Working | ||||
Particulars | Scooter Parts | Lawn Mower Parts | Hand Tools Parts | Total |
Machine Hours | 9,050 | 1,750 | 1,700 | 12,500 |
Share of M/C Hrs | 72.40% | 14.00% | 13.60% | |
Weight of parts shipped to distributors-Kg | 40,000 | 470,000 | 190,000 | 700,000 |
Share of Weights | 5.71% | 67.14% | 27.14% | |
Sales Commission per unit | $ 4.20 | $ 0.80 | $ 0.15 | |
Units assembled and sold | 13,000 | 20,000 | 52,000 | 85,000 |
Sales Price per unit | $ 85.00 | $ 16.00 | $ 6.00 |
Boston Tools |
Statement of Operating Income |
Particulars | Scooter Parts | Lawn Mower Parts | Hand Tools Parts | Total |
Sales Revenue | 1,105,000 | 320,000 | 312,000 | 1,737,000 |
Cost of Goods Sold | ||||
Direct Materials | 165,000 | 115,000 | 160,000 | 440,000 |
Indirect Production (allocated based on m/c hrs) | 63,350 | 12,250 | 11,900 | 87,500 |
Total Cost of Goods Sold | 228,350 | 127,250 | 171,900 | 527,500 |
Gross Profit | 876,650 | 192,750 | 140,100 | 1,209,500 |
Selling & Administrative Expenses | ||||
Commissions | 54,600 | 16,000 | 7,800 | 78,400 |
Distribution to warehouses(allocated based on wt in Kg) | 4,000 | 47,000 | 19,000 | 70,000 |
Income before unallocated Expenses | 818,050 | 129,750 | 113,300 | 1,061,100 |
Operating Income/(Loss) % by Product line before unallocated Expenses | 74.03% | 40.55% | 36.31% | 61.09% |
Unallocated Expenses | ||||
Corporate Salaries | 12,000 | |||
Other General expenses | 16,000 | |||
Total Unallocated Expenses | 28,000 | |||
Net Operating Income /(Loss) at overall Level: | 1,033,100 | |||
Net Operating Income /(Loss) % at overall Level: | 59.48% |
Requirement 4. You have been asked to determine operating income (loss) for each product line. (Round...
Atlanta Tool Co. is a supplier that assembles purchased parts into components for three distinct markets-scooter parts, lawn mower parts, and hand tool parts. Following is the statement of operating income for the most recent period: E (Click the icon to view the statement of operating income.) Atlanta Tool uses a traditional cost accounting system. Operating data used in the cost accounting system are as follows: Data Table x (Click the icon to view the operating data.) Requirement 1. You...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows: Current Year Previous Year Sales $624,000 $480,000 Cost of goods sold 512,000 400,000 Gross profit $112,000 $80,000 Selling expenses $33,600 $28,000 Administrative expenses 30,720 24,000 Total operating expenses $64,320 $52,000 Income before income tax $47,680 $28,000 Income tax expenses 19,100 11,200 Net income $28,580 $16,800 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
The condensed product-line income statement for Rhinebeck Company for the month of October is as follows: A product-line income statement is shown. The statement title is Rhinebeck Company, Product-Line Income Statement, For the Month Ended October 31. There are columns for Hats, Gloves, and Mufflers. In the Hats column, Sales is $71,000, Cost of goods sold is (32,600) (set in parentheses and single-ruled), Gross profit is $38,400, Selling and administrative expenses is (27,400) (set in parentheses and single-ruled), and Operating...
How to calculate the net operating income for both and shipping expense? Milden Company is a merchandiser that plans to sell 35,000 units during the next quarter at a selling price of $56 per unit. The company also gathered the following cost estimates for the next quarter: 20 points Cost Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense Cost Formula $26 per unit sold $183,000 per quarter 6% of sales $57,000 per...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these...
Homework Chapter zu Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 2017 as at the beginning of the year. The total of all productior costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads werd asked to submit estimates of the costs for their departments during the year. A summary...
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Graph, and Operating Leverage Organic Health Care Products Inc. expects to maintain the same inventories at the end of 2048 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during 2018. A summary report of these estimates...
Differential Analysis Report for a Discontinued Product The condensed product-line income statement for Dinner Ware Company is as follows: DINNER WARE COMPANY Product-Line Income Statement Bowls Plates Cups Sales $1,500,000 $2,350,000 $975,000 (900,000) Cost of goods sold Gross profit (1,400,000) $950,000 (700,000) $250,000 $600,000 (270,000) $330,000 (780,000) $195,000 (300,000) $(105,000) Selling and administrative expenses Operating income (loss) Fixed costs are 40% of the cost of goods sold and 18% of the selling and administrative expenses. Dinner Ware assumes that fixed...
Members of the board of directors of Security System have received the following operating income data for the year ended May 31, 2018: E(Click the icon to view the operating income data.) Members of the board are surprised that the industrial systems product line is not profitable. They commission a study to determine whether the company should drop the line. Company accountants estimate that dropping industrial systems will decrease fixed cost of goods sold by $81,000 and decrease fixed selling...
Members of the board of directors of Safety Point have received the following operating income data for the year ended May 31, 2018: (Click the icon to view the operating income data.) Members of the board are surprised that the industrial systems product line is not profitable. They commission a study to determine whether the company should drop the line. Company accountants estimate that dropping industrial systems will de fixed cost of goods sold by $80,000 and decrease fixed selling...