a | Division | ||
Uno | Dos | ||
Revenues | $ 6,00,000 | $ 19,00,000 | |
Less: Cost of Sale | $ 3,84,750 | $ 9,50,000 | |
Gross Profit | $ 2,15,250 | $ 9,50,000 | |
Operating Expenses: | |||
Allocated Corporate overhead | $ 36,000 | $ 1,14,000 | |
Other general and administration | $ 79,250 | $ 5,50,000 | |
Total | $ 1,15,250 | $ 6,64,000 | |
Operating Profit | $ 1,00,000 | $ 2,86,000 | |
Tax (30%) | $ 30,000 | $ 85,800 | |
Net Profit | $ 70,000 | $ 2,00,200 | |
b | Gross Margin ratio (Gross profit/Revenues) in % | 35.88% | 50.00% |
or | 0.36 | 0.50 | |
c | Operating Margin ratio (Operating profit/Revenues) in % | 16.67% | 15.05% |
or | 0.17 | 0.15 | |
d | Profit Margin ratio (Net profit/Revenues) in % | 11.67% | 10.54% |
or | 0.12 | 0.11 | |
--
Formula
---
Hope you Understood.
If you have any doubt please leave a comment. Thank you.
02. Award: 1.00 point La Mesa Foods has the following data for its two divisions for...
La Mesa Foods has the following data for its two divisions for the year: Dos Revenues Cost of sales Allocated corporate overhead Other general & administration Uno $600,000 384,750 36,000 79,250 $1,900,000 950,000 114,000 550,000 Required: a. Compute divisional operating income for each of the divisions. Assume taxes are 30%. b. Calculate the gross margin ratio for each division. c. Calculate the operating margin ratio for each division. d. Calculate the profit margin ratio for each division.
Becky’s Bikes Inc. has two divisions: Retail and Service. The following information is for each division at Becky’s Bikes for the most recent fiscal year. Retail Division Service Division Income Statement Sales $1,200,000 $1,000,000 Cost of sales 550,000 400,000 Gross margin 650,000 600,000 Allocated overhead (from corporate) 210,000 180,000 Marketing expense 130,000 120,000 Administrative expense 60,000 55,000 Operating income 250,000 245,000 Income tax expense (40% rate) 100,000 98,000 Net income 150,000 147,000 Balance...
Becky’s Bikes Inc. has two divisions: Retail and Service. The following information is for each division at Becky’s Bikes for the most recent fiscal year. Retail Division Service Division Income Statement Sales $1,200,000 $1,000,000 Cost of sales 550,000 400,000 Gross margin 650,000 600,000 Allocated overhead (from corporate) 210,000 180,000 Marketing expense 130,000 120,000 Administrative expense 60,000 55,000 Operating income 250,000 245,000 Income tax expense (40% rate) 100,000 98,000 Net income 150,000 147,000 Balance Sheet Information Average operating assets $600,000 $375,000...
The Kelsh Company has two divisions North and South. The divisions have the following revenues and expenses: North South Sales $700,000 $600,000 Less Operating Expenses: Variable Expenses 350,000 250,000 Traceable Fixed Expenses 200,000 160,000 Allocated Common Corporate Expenses 180,000 730,000 120,000 530,000 Net Operating Income (Loss) $( 30,000) $ 70,000 Management at Kelsh is pondering the elimination of North Division. If North Division were eliminated, its traceable fixed expenses could be avoided. The total common corporate expenses would be unaffected....
Okoboji Company manufactures wooden canoes, and has four operating divisions: East, West, North, and South. Each division manufactures a unique model of canoe. During the first quarter of 2017, total net operating income was $70,000. A breakdown by division was as follows: East West North South Sales $ 550,000 $750,000 $950,000 $450,000 COGS 460,000 480,000 575,000 400,000 S & A expenses 120,000 220,000 250,000 125,000 Net Op. Income $ ( 30,000) $ 50,000 $125,000 $ (75,000) An...
Office Supplies Ltd has a geographical structure with two divisions aligned with its two markets: Sydney and Brisbane. Sales The following data is provided for the two divisions for the year 2019: Sydney Brisbane $600,000 $400,000 Contribution margin ratio 52% 58% Fixed costs $280,000 $190,000 Divisional investments $200,000 $280,000 Common costs for the year totalled $70,000 and were allocated based on sales. The management of Office Supplies Ltd faced an investment opportunity, which would require an investment of $50,000 in...
Situation: Office Supplies Ltd has a geographical structure with two divisions aligned with its two markets: Sydney and Brisbane The following data is provided for the two divisions for the year 2019: Sydney Brisbane Sales $600,000 $400,000 Contribution margin ratio 5296 5896 Fixed costs $280,000 $190,000 Divisional investments $200,000 $280,000 Common costs for the year totalled $70,000 and were allocated based on sales The management of Office Supplies Ltd faced an investment opportunity, which would require an investment of $50,000...
1. The Bash Company has two divisions—Office and Home . The divisions have the following revenues and expenses: Office Home Sales 800,000 900,000 Variable costs (280,000) (200,000) Direct fixed costs (430,000) (320,000) Allocated corporate costs (120,000) (250.000) Net income (loss) (30,000) 130,000 The management at Bash is pondering the elimination of the Office Division. If the Office Division were eliminated, its direct fixed costs could be avoided, but its total corporate costs would not be affected. Given these data, the...
1. The Bash Company has two divisions—Office and Home . The divisions have the following revenues and expenses: Office Home Sales 800,000 900,000 Variable costs (280,000) (200,000) Direct fixed costs (430,000) (320,000) Allocated corporate costs (120,000) (250.000) Net income (loss) (30,000) 130,000 The management at Bash is pondering the elimination of the Office Division. If the Office Division were eliminated, its direct fixed costs could be avoided, but its total corporate costs would not be affected. Given these data, the...
1. The Bash Company has two divisions—Office and Home . The divisions have the following revenues and expenses: Office Home Sales 800,000 900,000 Variable costs (280,000) (200,000) Direct fixed costs (430,000) (320,000) Allocated corporate costs (120,000) (250.000) Net income (loss) (30,000) 130,000 The management at Bash is pondering the elimination of the Office Division. If the Office Division were eliminated, its direct fixed costs could be avoided, but its total corporate costs would not be affected. Given these data, the...