In: Accounting
I ONLY need requirements 1c-1f and 2 please. Thank you!
Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2019 and reports a balance sheet at December 31, 2018 as follows:
Endless Mountain Company | ||||||
Balance Sheet | ||||||
December 31, 2018 | ||||||
Assets | ||||||
Current assets: | ||||||
Cash | $ | 46,200 | ||||
Accounts receivable (net) | 260,000 | |||||
Raw materials inventory (4,500 yards) | 11,250 | |||||
Finished goods inventory (1,500 units) | 32,250 | |||||
Total current assets | $ | 349,700 | ||||
Plant and equipment: | ||||||
Buildings and equipment | 900,000 | |||||
Accumulated depreciation | (292,000 | ) | ||||
Plant and equipment, net | 608,000 | |||||
Total assets | $ | 957,700 | ||||
Liabilities and Stockholders’ Equity | ||||||
Current liabilities: | ||||||
Accounts payable | $ | 158,000 | ||||
Stockholders’ equity: | ||||||
Common stock | $ | 419,800 | ||||
Retained earnings | 379,900 | |||||
Total stockholders’ equity | 799,700 | |||||
Total liabilities and stockholders’ equity | $ | 957,700 | ||||
The company’s chief financial officer (CFO), in consultation with various managers across the organization has developed the following set of assumptions to help create the 2019 budget:
Required:
1. Calculate the following budgeted figures for 2019:
a. The total fixed cost.
b. The variable cost per unit sold.
c. The contribution margin per unit sold.
d. The break-even point in unit sales and dollar sales.
e. The margin of safety.
f. The degree of operating leverage
2. Prepare a budgeted variable costing income statement for 2019. Stop your computations at net operating income.
Req 1-c | Contribution margin per unit | 15.00 | ||
Working Note : 3 | ||||
Selling Price Per Unit | 32.00 | |||
Less: Variable cost per unit | 17.00 | |||
Contribution margin per unit | 15.00 | |||
Req 1-d | Break even (Units) | 71,200 | Units | |
Break even (Dollars) | 2,278,400 | |||
Working Note : 4 | ||||
Total Fixed Cost | 1,068,000 | |||
Divided by : Contribution margin per unit | 15.00 | |||
Break even (Units) | 71200 | Units | ||
Total Fixed Cost | 1,068,000 | |||
Divided by :Contribution margin ratio | 46.88% | (Contribution/selling price) | ||
Break even (Dollars) | 2,278,400 | |||
Req 1-e | Margin of Safety | 569,600 | ||
Working Note : 5 | ||||
Total Sales | 2,848,000 | (Total units * selling price) | ||
Less: Break Even sales | 2,278,400 | |||
Margin of Safety(MOS) | 569,600 | |||
Margin of Safety(%ge) | 20% | (MOS/Total sale) | ||
Req 1-f | Degree of Operating Leverage | 5.0 | ||
Working Note : 6 | ||||
Total Contribution margin | 1,335,000 | |||
Less: Fixed cost | 1,068,000 | |||
Net Income | 267,000 | |||
Degree of Operating Leverage | 5.0 | |||
(Contribution Margin/Net Income) | ||||
Req 2: | Variable Costing Income Statement | |||
Sales | 2,848,000 | |||
Variable Expenses: | ||||
Variable Cost of Goods sold | 1,401,750 | |||
Variable selling and admin exp | 111,250 | |||
Total Variable Expense | 1,513,000 | |||
Contribution Margin | 1,335,000 | |||
Fixed Expesnes: | ||||
Fixed Manufacturing OH | 600,000 | |||
Fixed Selling Admin Expense | 468,000 | |||
Total Fixed Expenses | 1,068,000 | |||
Net Income | 267,000 |