In: Accounting
I ONLY need requirements 9&10 on the first set of requirements and then 1 &2 on the second set of requirements 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:
The company’s CFO has asked you to prepare the 2019 master budget. To fulfill this request, prepare the following budget schedules and financial statements.
1. Quarterly sales budget including a schedule of expected cash collections.
2. Quarterly production budget.
3. Quarterly direct materials budget including a schedule of expected cash disbursements for purchases of materials.
4. Quarterly direct labor budget.
5. Quarterly manufacturing overhead budget.
6. Ending finished goods inventory budget at December 31, 2019.
7. Quarterly selling and administrative expense budget.
8. Quarterly cash budget.
9. Income statement for the year ended December 31, 2019.
10. Balance sheet at December 31, 2019.
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-9 | Income Statement | |
Sales | 2,848,000 | |
Cost of Goods sold | 1,998,724 | |
Gross profit | 849,276 | |
Selling and admin Expense | 579,250 | |
Interest Expense | 9,642 | |
Net Profit | 260,384 | |
Less: Dividend Paid | 60,000 | |
Net Income | 200,384 | |
Req 10 | Balance Sheet | |
Assets | ||
Cash | 319,243 | |
Accounts Receivable | 200,000 | |
Raw Material Inventory | 12,750 | |
Finished Goods Inventory | 42,363 | |
Total Current Assets | 574,356 | |
Equipment | 900,000 | |
Accumulated Depreciation | (404,000) | |
Equipment, Net | 496,000 | |
Total Assets | 1,070,356 | |
Liabilities and Equity | ||
Accounts Payable | 70,272 | |
Total Current Liabilities | 70,272 | |
Total Liabilities | 70,272 | |
Common Stock | 419,800 | |
Retained Earnings | 580,284 | |
Total Stockholder's Equity | 1,000,084 | |
Total Liability and Equity | 1,070,356 | |
Req 1-a | Total Fixed Cost | 1,068,000 | |||
Working Note : 1 | |||||
Per Qtr | Per Year | ||||
Budgdted Fixed Overhead | 150,000 | 600,000 | |||
Advertisement | 25,000 | 100,000 | |||
Executive Salaries | 64,000 | 256,000 | |||
Insurance | 12,000 | 48,000 | |||
Property TAXES | 8,000 | 32,000 | |||
Depreciation Expense | 8,000 | 32,000 | |||
Total | 1,068,000 | ||||
Req 1-b | Variable Cost per Unit | 17.00 | |||
Working Note : 2 | |||||
Req per Unit | Rate | Cost per Unit | |||
Direct Material | 3.5 | 3 | 10.50 | ||
Direct Labor | 0.25 | 18 | 4.50 | ||
Varible Overhead | 0.25 | 3 | 0.75 | ||
Variable selling and Admin | 1.25 | ||||
Total | 17.00 | ||||