Required information
[The following information applies to the questions displayed below.]
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 2017 and reports a balance sheet at December 31, 2016 as follows:
Endless Mountain Company | ||||||
Balance Sheet | ||||||
December 31, 2016 | ||||||
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 2017 budget:
Required:
The company’s CFO has asked you to prepare the 2017 master budget. To fulfill this request, prepare the following budget schedules and financial statements.
1. Quarterly manufacturing overhead budget.
1 | 2 | 3 | 4 | Year | |
Budgeted Direct Labor Hours | 4013.0 | 8425.0 | 4125.0 | 5800.0 | 22362.5 |
Variable MO per DL Hour | 3 | 3 | 3 | 3 | 3 |
Variable MO | 12039 | 25275 | 12375 | 17400 | 67088 |
Fixed MO | 130000 | 130000 | 130000 | 130000 | 130000 |
Total MO | 142039 | 155275 | 142375 | 147400 | 587088 |
Less depreciation | ? | ? | ? | ? | ? |
Cash Disbursements for MO | ? | ? | ? | ? | ? |
Total MO | ? | ? | ? | ? | ? |
Budgeted DLH | ? | ? | ? | ? | ? |
Predetermined overhead rate | ? | ? | ? | ? | ? |
I don't know the the cells with ? in them for the rest I believe I am right but if I am wrong please let me know. Showing work would be pretty cool.
2. Ending finished goods inventory budget at December 31, 2017. (Absorption Basis)
Item | Quantity | Cost | Total |
Production Cost Per unit | |||
Direct Materials | 3.5 Yards | $3 Per Yard | ? |
Direct Labor | 0.25 Hours | $18 Per Hour | ? |
Manufacturing Overhead | ? | ? | ? |
Unit Product Cost | ? | ||
Budgeted Finished goods Inventory | |||
Units from Prior year Production | ? | ||
Unit Product Cost | ? | ||
Cost from Prior Years production | |||
Units from current years production | ? | ||
Unit product cost | ? | ||
Cost from current years production | |||
Cost of ending finished goods inventory |
I am having a lot of issues with this question for some reason...Thank you for your help.
1. Quarterly manufacturing overhead budget
Particulars | Q1 | Q2 | Q3 | Q4 | Year |
Budgeted direct labour hours | 4012.5 | 8425 | 4125 | 5800 | 22362.5 |
Variable manufacturing per DL | 3 | 3 | 3 | 3 | 3 |
Total Variable manufacturing OH | 12037.5 | 25275 | 12375 | 17400 | 67087.5 |
Fixed MO | 150000 | 150000 | 150000 | 150000 | 600000 |
Total MO | 162037.5 | 175275 | 162375 | 167400 | 667087.5 |
Less depreciation | 20000 | 20000 | 20000 | 20000 | 80000 |
Cash disbursement for MO | 142037.5 | 155275 | 142375 | 147400 | 587087.5 |
Total MO | 162037.5 | 175275 | 162375 | 167400 | 667087.5 |
Budget DLH | 4012.5 | 8425 | 4125 | 5800 | 22362.5 |
Predetermined overhead rate | 40.38 | 20.80 | 39.36 | 28.86 | 29.83 |
2. Finished goods inventory budget
Item | Quantity | cost | Total |
Production cost per unit | |||
Direct materials | 3.5 yards | $3 per yard | $10.5 |
Direct labour | 0.25 hours | $18 per hour | $4.5 |
Manufacturing overhead | 0.25 hours | $29.83 per hour | $7.4575 |
Unit product cost | $22.4575 | ||
Budgeted Finished goods Inventory | |||
Units from Prior year Production | 1500 | ||
Unit Product Cost(32250÷1500) | 21.5 | ||
Cost from Prior Years production | 32250 | ||
Units from current years production | 450 | ||
Unit Product Cost | $22.4575 | ||
Cost from current years production | $10,105.875 | ||
Cost of ending finished goods inventory | $42,355.875 |
Required information [The following information applies to the questions displayed below.] Endless Mountain Company manufactures a...
Required information (The following information applies to the questions displayed below.] 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 2017 and reports a balance sheet at December 31, 2016 as follows: $ 46,200 260,000 11,250 32,250 $349,700 Endless Mountain Company Balance Sheet December 31, 2016 Assets Current assets:...
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 2017 and reports a balance sheet at December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current assets: Cash $ 46,200 Accounts receivable (net) 260,000 Raw materials inventory (4,500 yards) 11,250 Finished goods inventory (1,500...
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 2017 and reports a balance sheet at December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current assets: Cash $ 46,200 Accounts receivable (net) 260,000 Raw materials inventory (4,500 yards) 11,250 Finished goods inventory (1,500...
Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout Northern England. It is in the process of creating a master budget for 2017 and reports a balance sheet at December 31, 2016 as follows:Endless Mountain Company Balance SheetDecember 31, 2016AssetsCurrent assets:Cash$ 46,200Accounts receivable (net)260,000Raw materials inventory (4,500 yards)11,250Finished goods inventory (1,500 units) 32,250 Total current assets$ 349,700Plant and equipment:Buildings and equipment900,000Accumulated depreciation (292,000) Plant and equipment, net 608,000 Total...
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 2022 and reports a balance sheet at December 31, 2021 as follows: Endless Mountain Company Balance Sheet December 31, 2021 Assets Current assets: Cash $ 46,200 Accounts receivable (net) 260,000 Raw materials inventory (4,500 yards) 11,250 Finished goods inventory (1,500...
Please solve for required in image 1-2. Required information [The following information applies to the questions displayed below.) 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 2017 and reports a balance sheet at December 31, 2016 as follows: $ 46,200 260,000 11,250 32,250 $349,700 Endless Mountain Company Balance...
Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget a. The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 9,400, 25,000, 27,000, and 28,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c....
Required Information The following information applies to the questions displayed below.) Morganton Company makes one product and it provided the following Information to help prepare the master budget: a. The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 9,200, 23,000, 25,000, and 26,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. C....
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 2022 and reports a balance sheet at December 31, 2021 as follows:Endless Mountain CompanyBalance SheetDecember 31, 2021AssetsCurrent assets:Cash$46,200Accounts receivable (net)260,000Raw materials inventory (4,500 yards)11,250Finished goods inventory (1,500 units)32,250Total current assets$349,700Plant and equipment:Buildings and equipment900,000Accumulated depreciation(292,000)Plant and equipment, net608,000Total assets$957,700Liabilities and...
Required Information [The following information applies to the questions displayed below.) Morganton Company makes one product and it provided the following Information to help prepare the master budget. a. The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 9,200, 23,000, 25,000, and 26,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% In the following month c....