Questions
Windsor Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown,...

Windsor Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common stock, was one of the organizers of Windsor and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2021, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two $34,970 notes, which are due on June 30, 2021, and September 30, 2021. Another note of $5,970 is due on March 31, 2022, but he expects no difficulty in paying this note on its due date. Brown explained that Windsor’s cash flow problems are due primarily to the company’s desire to finance a $300,080 plant expansion over the next 2 fiscal years through internally generated funds.

The commercial loan officer of Topeka National Bank requested the following financial reports for the last 2 fiscal years.

Windsor Corporation
Balance Sheet
March 31

Assets

2021

2020

Cash

$18,120 $12,410

Notes receivable

147,220 132,930

Accounts receivable (net)

130,790 124,530

Inventories (at cost)

104,940 49,570

Plant & equipment (net of depreciation)

1,446,500 1,416,510

    Total assets

$1,847,570 $1,735,950
Liabilities and Owners’ Equity

Accounts payable

$79,360 $90,220

Notes payable

75,910 61,040

Accrued liabilities

8,250 2,550

Common stock (130,000 shares, $10 par)

1,296,650 1,312,800

Retained earningsa

387,400 269,340

    Total liabilities and stockholders’ equity

$1,847,570 $1,735,950
aCash dividends were paid at the rate of $1 per share in fiscal year 2020 and $2 per share in fiscal year 2021.

Windsor Corporation
Income Statement
For the Fiscal Years Ended March 31

2021

2020

Sales revenue

$2,994,540 $2,716,340

Cost of goods solda

1,536,450 1,415,660

Gross margin

1,458,090 1,300,680

Operating expenses

856,120 784,640

Income before income taxes

601,970 516,040

Income taxes (40%)

240,788 206,416

Net income

$361,182 $309,624
aDepreciation charges on the plant and equipment of $99,960 and $101,650 for fiscal years ended March 31, 2020 and 2021, respectively, are included in cost of goods sold.


(a)

Compute the following items for Windsor Corporation. (Round answers to 2 decimal places, e.g. 2.25 or 2.25%.)

1. Current ratio for fiscal years 2020 and 2021.
2. Acid-test (quick) ratio for fiscal years 2020 and 2021.
3. Inventory turnover for fiscal year 2021.
4. Return on assets for fiscal years 2020 and 2021. (Assume total assets were $1,705,230 at 3/31/19.)
5. Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year 2020 to 2021.

In: Accounting

Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income statement for a...

Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income statement for a recent month for the two games appears below:

Claimjumper Makeover Total
Sales $ 98,000 $ 49,000 $ 147,000
Variable expenses 24,520 4,880 29,400
Contribution margin $ 73,480 $ 44,120 117,600
Fixed expenses 91,680
Net operating income $ 25,920

Required:

1. What is the overall contribution margin (CM) ratio for the company?

2. What is the company's overall break-even point in dollar sales?

3. Prepare a contribution format income statement at the company's break-even point that shows the appropriate levels of sales for the two products.

In: Accounting

[The following information applies to the questions displayed below.] Laker Company reported the following January purchases...

[The following information applies to the questions displayed below.]

Laker Company reported the following January purchases and sales data for its only product.

Date Activities Units Acquired at Cost Units sold at Retail
Jan. 1 Beginning inventory 180 units @ $ 10.50 = $ 1,890
Jan. 10 Sales 140 units @ $ 19.50
Jan. 20 Purchase 110 units @ $ 9.50 = 1,045
Jan. 25 Sales 130 units @ $ 19.50
Jan. 30 Purchase 260 units @ $ 9.00 = 2,340
Totals 550 units $ 5,275 270 units


The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 280 units, where 260 are from the January 30 purchase, 5 are from the January 20 purchase, and 15 are from beginning inventory.

Required:
1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.
2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.

Specific Identification
Available for Sale Cost of Goods Sold Ending Inventory
Purchase Date Activity Units Unit Cost Units Sold Unit Cost COGS Ending Inventory- Units Cost Per Unit Ending Inventory- Cost
Jan. 1 Beginning inventory 180
Jan. 20 Purchase 110
Jan. 30 Purchase 260
550 0 $0 0 $0

In: Accounting

Han Products manufactures 27,000 units of part S-6 each year for use on its production line....

Han Products manufactures 27,000 units of part S-6 each year for use on its production line. At this level of activity, the cost per unit for part S-6 is: Direct materials $ 3.50 Direct labor 10.00 Variable manufacturing overhead 2.50 Fixed manufacturing overhead 12.00 Total cost per part $ 28.00 An outside supplier has offered to sell 27,000 units of part S-6 each year to Han Products for $22 per part. If Han Products accepts this offer, the facilities now being used to manufacture part S-6 could be rented to another company at an annual rental of $77,000. However, Han Products has determined that two-thirds of the fixed manufacturing overhead being applied to part S-6 would continue even if part S-6 were purchased from the outside supplier. Required: What is the financial advantage (disadvantage) of accepting the outside supplier’s offer?

In: Accounting

1. On December 1, Sage Hill accepted an order from a new customer, Buffalo Computers. Buffalo...

1. On December 1, Sage Hill accepted an order from a new customer, Buffalo Computers. Buffalo has a questionable credit history, so Sage Hill requires a $8,000 deposit from Buffalo in order to begin production on its order.
2. During December, cash sales at Sage Hill’s retail locations totaled $3,424,000, which includes the 7% sales tax Sage Hill must remit to the state by the fifteenth day of the following month.
3. During the year, Sage Hill was sued by a competitor for a patent violation. The competitor is claiming that Sage Hill’s liability is $2,050,000. Sage Hill’s attorneys have advised it that it is probable that the court will find for the company’s competitor. The attorneys estimate that the liability under the suit could be as little as $82,000 or as much as $410,000. The attorneys do not believe any amount within this range is a better estimate of Sage Hill’s liability than any other amount within the range.
4. Sage Hill provides one-year warranties on the laptops it sells. During the year, Sage Hill’s laptop sales totaled $82,000,000. Historically, Sage Hill’s warranty liability has been one percent of total sales. Sage Hill began the year with a warranty liability balance of $660,000. Warranty expenditures during the year were $635,000 for computers sold in prior years and $197,000 for computers sold during the year. These expenditures were recorded as credits to cash and debits to the warranty liability account. Any remaining warranty liability is expected to relate to computers sold during the current year.


Prepare all the journal entries necessary to record the transactions noted above as they occurred and any adjusting journal entries relative to the transactions that would be required to present fair financial statements at December 31. For simplicity, assume that adjusting entries are recorded only once a year on December 31

In: Accounting

Boron Chemical Company produces a synthetic resin that is used in the automotive industry. The company...

Boron Chemical Company produces a synthetic resin that is used in the automotive industry. The company uses a standard cost system. For each gallon of output, the following direct manufacturing costs are anticipated:

Direct labor: 2 hours at $25.00 per hour $ 50.00
Direct materials: 2 gallons at $10.00 per gallon $ 20.00

During December of the current year, Boron produced a total of 2,500 gallons of output and incurred the following direct manufacturing costs:

Direct labor: 4,900 hours worked at an average wage rate of $19.50 per hour
Direct materials:
Purchased: 6,000 gallons @ $10.45 per gallon
Used in production: 5,100 gallons

Boron records price variances for materials at the time of purchase.

Required:

Prepare journal entries for the following events and transactions.

1. Purchase, on credit, of direct materials.

2. Direct materials issued to production.

3. Direct labor cost of units completed this period.

4. Direct manufacturing cost (direct labor plus direct materials) of units completed and transferred to Finished Goods Inventory.

5. Sale (on credit), for $150.00 per gallon, of 2,000 gallons of output. (Hint: You will need two journal entries here.)

(For all requirements, if no entry is required for a transaction/event, select "No journal entry required" in the first account field. Round your answers to the nearest whole dollar amount.)

In: Accounting

Service Department Charges In divisional income statements prepared for LeFevre Company, the Payroll Department costs are...

Service Department Charges

In divisional income statements prepared for LeFevre Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $41,896, and the Purchasing Department had expenses of $15,370 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records:

Residential Commercial Government
Contract
Sales $321,000 $426,000 $978,000
Number of employees:
Weekly payroll (52 weeks per year) 245 65 70
Monthly payroll 30 41 28
Number of purchase
requisitions per year 2,200 1,600 1,500

a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division.

Residential Commercial Government Contract Total
Number of payroll checks:
Weekly payroll
Monthly payroll
Total
Number of purchase requisitions per year:

b. Using the activity base information in (a), determine the annual amount of payroll and purchasing costs charged back to the Residential, Commercial, and Government Contract divisions from payroll and purchasing services. If required, round your answers to two decimal places. Do not round your interim calculations, round your answers to two decimal places, if required.

Service department charge rates:
Payroll Department $ payroll distribution
Purchasing Department $ per requisition


Residential Commercial Government Contract Total
Service department charges:
Payroll Department $ $ $ $
Purchasing Department
Total $ $ $

c. Residential's service department charge is   than the other two divisions because Residential is a   user of service department services. Residential has many employees on a weekly payroll, which translates into a   number of check-issuing transactions.

In: Accounting

Gonzalez Tortilla Corporation produces tortillas in large batches and uses a process costing system. Three departments—Mixing,...

Gonzalez Tortilla Corporation produces tortillas in large batches and uses a process costing system. Three departments—Mixing, Rolling, and Packaging—are involved in the production process. Gonzalez Tortilla has the following transactions:

  1. Direct materials totaling $25,000—$7,500 for the Mixing department, $6,250 for the Rolling department, and $11,250 for the Packaging department—are requisitioned and placed in production.
  2. Each production department incurs the following direct labor costs (wages payable):

Mixing

$3,125

Rolling

$5,750

Packaging

$2,750

  1. Manufacturing overhead costs are applied to each department as follows:

Mixing

$12,500

Rolling

$8,750

Packaging

$9,375

  1. Products with a cost of $6,875 are transferred from the Mixing department to the Rolling department.
  2. Products with a cost of $8,000 are transferred from the Rolling department to the Packaging department.
  3. Products with a cost of $11,375 are completed and transferred from the Packaging department to the finished goods warehouse.
  4. Products with a cost of $10,375 are sold to customers.

Perform the following steps for each transaction:

  1. Prepare a journal entry to record the transaction.
  2. Summarize the flow of costs through T-accounts (no need to include T-accounts for raw materials inventory, wages payable, or manufacturing overhead). Assume that there are no beginning balances in the work-in-process inventory, finished goods inventory, and cost of goods sold accounts.

In: Accounting

The following are BAC Bhd.’s year end statement of financial position and statement of profit and...

The following are BAC Bhd.’s year end statement of financial position and statement of profit and loss for 2016 and 2017:

2017 ($)

2016 ($)

2017 ($)

2016 ($)

Non Current Assets:

total non current liabilities

410769

372931

Gross Non Current assets

317,503

232,179

current liabilities

Less accumulated depreciation

54,045

34,187

short term borrowings

288798

296149

Net Non Current assets  

263,458

197,992

A/P

636318

414611

Current Assets:  

accruals

106748

103362

cash and equivalents

208323

102024

total Current libilities

1031864

814122

A/R

690294

824979

total liabilities

1442633

1187053

inventories

942374

715414

shareholder equity

total Current assets

1840991

1642417

common stock(100000 sahres)

550000

550000

total assets

2104449

1840409

retaines earning

111816

103356

noncurrent liabilities

total shareholder equity

661816

653356

long term debt

410769

372931

total liabilities and share holder equity

2104449

1840409

2017 ($)

2016 ($)

Sales

2,325,967

2,220,607

(-) Cost of goods sold

1,869,326

1,655,827

Other expenses

287,663

273,870

Total operating costs excluding depreciation and amortization

2,156,989

1,929,697

Depreciation and amortization

25,363

26,341

Total operating costs

2,182,352

1,956,038

EBIT  

143,615

264,569

(-) Interest expense

31,422

13,802

EBT  

112,193

250,767

(-) Taxes (30%)

33,658

75,230

Net income

78,535

175,537

Related items:

2017 Total dividends paid $70,075 ,   Stock price per share $15.60

2016 Total dividends paid $15.60 ,   Stock price per share $21.80

Required:

  1. Calculate the after tax operating income (i.e. after-tax EBIT) for 2016 and 2017.   
  2. Calculate the net working capital (NWC) that is supported by non-free sources for 2016 and 2017, and the changes in NWC between these two years.                             
  3. What is free cash flow (FCF)? Calculate the FCF for 2017. Is a negative FCF always a bad sign?   
  4. Calculate the following for the company for 2017:
    1. Earnings per share   
    2. Dividends per share   
    3. Book value per share

In: Accounting

Contribution Format 2016 2017 2018 Sales $         135,987 $       177,866 $       232,887 Variable expenses Cost of...

Contribution Format
2016 2017 2018
Sales $         135,987 $       177,866 $       232,887
Variable expenses
Cost of sales                88,265            111,934            139,156
Fulfillment                14,095              20,199              27,222
Marketing                  7,233              10,069              13,814
Technology and content            8,042.50              11,310        14,418.50
     Total variable expenses             117,636            153,512            194,610
Contribution margin $           18,351 $          24,354 $          38,277
Fixed expenses
Fulfillment                  3,524                5,050                6,805
Technology and content            8,042.50              11,310        14,418.50
General and admin                  2,432                3,674                4,336
Other                      167                    214                    296
     Total fixed expenses                14,165              20,248              25,856
Operating income $              4,186 $            4,106 $          12,421

calculate the contribution margin ratio , break even dollar sales, margin of safety (dollars) safety margin % of sales

In: Accounting

Prepare the adjustment entry as of 30/06/2012 under the following E.            According to the balance sheet,...

Prepare the adjustment entry as of 30/06/2012 under the following

E.            According to the balance sheet, the inventory was $223,500. At the end of the financial year stock take, you have been advised that the inventory value is only $210,000.

F.           On 30/06/2012, the company aged receivables which have a total of $306,400. The company estimated       2% of 90 days receivable and 10% of over 90 days will not be able to be collected.

Aged Receivable Summary

30/6/2013

Total Due

0-30 days

31-60 days

61-90 days

91-120 days

$311,400

$220,000

$60,000

$18,000

$16,400

In: Accounting

The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the...

The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data:

Product Demand
Next year
(units)
Selling
Price
per Unit
Direct
Materials
Direct
Labor
Debbie 52,000 $ 17.00 $ 4.50 $ 2.80
Trish 44,000 $ 6.50 $ 1.30 $ 1.40
Sarah 37,000 $ 26.00 $ 6.74 $ 4.90
Mike 40,800 $ 12.00 $ 2.20 $ 3.50
Sewing kit 327,000 $ 8.20 $ 3.40 $ 1.05

The following additional information is available:  

  1. The company’s plant has a capacity of 114,750 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products.

  2. The direct labor rate of $7 per hour is expected to remain unchanged during the coming year.

  3. Fixed manufacturing costs total $540,000 per year. Variable overhead costs are $4 per direct labor-hour.

  4. All of the company’s nonmanufacturing costs are fixed.

  5. The company’s finished goods inventory is negligible and can be ignored.

Required:

1. How many direct labor hours are used to manufacture one unit of each of the company’s five products?

2. How much variable overhead cost is incurred to manufacture one unit of each of the company’s five products?

3. What is the contribution margin per direct labor-hour for each of the company’s five products?

4. Assuming that direct labor-hours is the company’s constraining resource, what is the highest total contribution margin that the company can earn if it makes optimal use of its constrained resource?

5. Assuming that the company has made optimal use of its 114,750 direct labor-hours, what is the highest direct labor rate per hour that Walton Toy Company would be willing to pay for additional capacity (that is, for added direct labor time)?

In: Accounting

Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who...

Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided for seniors—home nursing, Meals On Wheels, and housekeeping. Data on revenue and expenses for the past year follow:

Total Home Nursing Meals On Wheels House-
keeping
Revenues $ 924,000 $ 262,000 $ 405,000 $ 257,000
Variable expenses 470,000 120,000 195,000 155,000
Contribution margin 454,000 142,000 210,000 102,000
Fixed expenses:
Depreciation 70,000 8,800 40,500 20,700
Liability insurance 43,900 20,900 7,400 15,600
Program administrators’ salaries 115,000 40,200 38,500 36,300
General administrative overhead* 184,800 52,400 81,000 51,400
Total fixed expenses 413,700 122,300 167,400 124,000
Net operating income (loss) $ 40,300 $ 19,700 $ 42,600 $ (22,000)

*Allocated on the basis of program revenues.

The head administrator of Jackson County Senior Services, Judith Miyama, considers last year’s net operating income of $40,300 to be unsatisfactory; therefore, she is considering the possibility of discontinuing the housekeeping program.

The depreciation in housekeeping is for a small van that is used to carry the housekeepers and their equipment from job to job. If the program were discontinued, the van would be donated to a charitable organization. None of the general administrative overhead would be avoided if the housekeeping program were dropped, but the liability insurance and the salary of the program administrator would be avoided.

Required:

1-a. What is the financial advantage (disadvantage) of discontinuing the Housekeeping program?

1-b. Should the Housekeeping program be discontinued?

2-a. Prepare a properly formatted segmented income statement.

2-b. Would a segmented income statement format be more useful to management in assessing the long-run financial viability of the various services?

In: Accounting

Exercise Assume your Company sells to merchandisers in three different states—Oregon, Texas and Colorado The following...

Exercise

Assume your Company sells to merchandisers in three different states—Oregon, Texas and Colorado The following profit analysis by state was prepared by the company:

                                                                        Oregon                       Texas                        Colorado

Revenue                                                         4,500,000                    4,000,000                   4,000,000

Cost of Goods Sold                                        2,500,000                      2,000,000                  2,000,000

Gross profit                                                     2,000,000                      2,000,000                  2,000,000

Selling Expenses                                               500,000                         700,000                      700,000

Net profit                                                         1,500,000                      1,300,000                  1,300,000

Following are the fixed portion within the costs provided above:

Fixed manufacturing Costs                             300,000                         500,000                        1,000,000

Fixed Selling and Admin Costs                      300,000                         200,000                           400,000

Now, Management believes it could increase state sales by 20%, without increasing any of the fixed costs, by spending an additional $50,000 per state on advertising. No change in inventories.  

  1. Prepare a contribution margin statement by state to determine how much each state operating profit would be for the additional $50000 advertising.
  1. Which state will provide the greatest profit return for a $50000 increase in advertising?

  1. Why?

In: Accounting

Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has...

Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has been a long-simmering dispute between the company’s estimator and the work supervisors. The on-site supervisors claim that the estimators do not adequately distinguish between routine work such as removal of asbestos insulation around heating pipes in older homes and nonroutine work such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that nonroutine work is far more expensive than routine work and should bear higher customer charges. The estimator sums up his position in this way: “My job is to measure the area to be cleared of asbestos. As directed by top management, I simply multiply the square footage by $2.50 to determine the bid price. Since our average cost is only $2.46 per square foot, that leaves enough cushion to take care of the additional costs of nonroutine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tearing things apart.”

     To shed light on this controversy, the company initiated an activity-based costing study of all of its costs. Data from the activity-based costing system follow:

  Activity Cost Pool                Activity Measure Total Activity           
  Removing asbestos Thousands of square feet 1,000 thousand square  feet
  Estimating and job setup Number of jobs 500 jobs
  Working on nonroutine jobs Number of nonroutine jobs 100 nonroutine jobs
  Other (costs of idle capacity and
     organization-sustaining costs)
None    

Note: The 100 nonroutine jobs are included in the total of 500 jobs. Both nonroutine jobs and routine jobs require estimating and setup.

  Costs for the Year
  Wages and salaries $ 407,000
  Disposal fees 800,000
  Equipment depreciation 96,000
  On-site supplies 56,000
  Office expenses 300,000
  Licensing and insurance 490,000
  Total cost $ 2,149,000
  Distribution of Resource Consumption Across Activities
Removing Asbestos Estimating and Job Setup Working on Nonroutine Jobs Other Total
  Wages and salaries 50 % 10 % 30 % 10 % 100 %
  Disposal fees 70 % 0 % 30 % 0 % 100 %
  Equipment depreciation 40 % 5 % 20 % 35 % 100 %
  On-site supplies 60 % 25 % 15 % 0 % 100 %
  Office expenses 15 % 35 % 20 % 30 % 100 %
  Licensing and insurance 25 % 0 % 60 % 15 % 100 %
Required:

   

1.

Perform the first-stage allocation of costs to the activity cost pools.

     

2. Compute the activity rates for the activity cost pools.

      

3.

Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system. (Round the "Average cost" to 2 decimal places.)

   

a. A routine 1,000-square-foot asbestos removal job.

         

b. A routine 2,000-square-foot asbestos removal job.

         

c. A nonroutine 2,000-square-foot asbestos removal job.

          

In: Accounting