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 |
||||
---|---|---|---|---|
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 |
||||
---|---|---|---|---|
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 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 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.
|
In: Accounting
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 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 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 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, Rolling, and Packaging—are involved in the production process. Gonzalez Tortilla has the following transactions:
Mixing |
$3,125 |
Rolling |
$5,750 |
Packaging |
$2,750 |
Mixing |
$12,500 |
Rolling |
$8,750 |
Packaging |
$9,375 |
Perform the following steps for each transaction:
In: Accounting
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:
In: Accounting
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, 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 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:
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.
The direct labor rate of $7 per hour is expected to remain unchanged during the coming year.
Fixed manufacturing costs total $540,000 per year. Variable overhead costs are $4 per direct labor-hour.
All of the company’s nonmanufacturing costs are fixed.
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 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 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.
In: Accounting
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