Business 1B - Managerial Accounting - Master Budget Comprehensive Project | ||||||||||||
Radical Boards, Inc. manufactures and sells a single model | The unit cost for ending FG inventory at 12/31/11 was $374.80. | |||||||||||
of snowboard, the Vortex. In the summer of 2011, | Ignore Work In Process | |||||||||||
Iggy Sawdust, CPA, provided data for the 2012 budget: | ||||||||||||
Direct Material Requirements (per snowboard) | The December 2012 Budget Includes the following selected balances: | |||||||||||
Wood | 5 board feet (b.f.) | Cash | $ 10,000.00 | |||||||||
Fiberglass | 6 yards | Property, Plant, and Equipment | $ 850,000.00 | |||||||||
Direct Labor Requirements | 5 hours | Current Liabilities | $ 17,000.00 | |||||||||
Long Term Liabilities | $ 178,000.00 | |||||||||||
Expected sales during 2012 - 1000 units at $450 per unit | Capital Stock | $ 600,000.00 | ||||||||||
Expected inventory balances: | ||||||||||||
1/1/12 | 12/31/12 | |||||||||||
Finished Goods | 100 | 200 | Retained Earnings at balance at 12/31/11 | $ 184,980.00 | ||||||||
Wood Raw Material | 2000 b.f. | 1500 b.f. | ||||||||||
Fiberglass Raw Material | 1000 yards | 2000 yards | ||||||||||
Required: Prepare the following reports for the year 2012 | ||||||||||||
Other data: | Unit Prices | 1 | Sales Budget in dollars | |||||||||
Wood | $30.00 per b.f. | 2 | Production Budget in units | |||||||||
Fiberglass | $5.00 per yard | 3 | Direct Materials Budget | |||||||||
Direct labor | $25.00 per hour | 4 | Direct Labor Budget | |||||||||
5 | Manufacturing Overhead Budget | |||||||||||
Variable Overhead | $7.00 per dlh | 6 | Predetermined Overhead Rate | |||||||||
Fixed Overhead | $66,000 | 7 | Estimated Overhead to be Applied to One Snowboard | |||||||||
Overhead Driver | DL Hours | 8 | Calculate the cost to manufacture a snowboard | |||||||||
9 | Budgeted Ending Inventory for Materials and Finished Goods | |||||||||||
Variable marketing costs | $250 per sales visits | 10 | Cost of Goods Sold Budget | |||||||||
Expected sales visits in 2012 | 30 | 11 | Budgeted Income Statement | |||||||||
Fixed non-overhead costs | $30,000 | 12 | Budgeted Balance Sheet | |||||||||
1) I advise doing all of the calculations by hand before you input numbers in the work sheets. | ||||||||||||
2) Fill in the hatched boxes ONLY. Some inputs are just numbers. Some require calculations. The rest of the cells calculate automatically. | ||||||||||||
3) Clarification: The balance sheet numbers above are as of the end of year, i.e. all you have to do is determine year-end retained earnings. |
Part 4 - Direct Labor Budget | Part 6 - POHR | |||||||||||
Units to Produce | Total Overhead | $ - | ||||||||||
x Direct Labor Hours Per Unit | / Expected Units in Activity Base | |||||||||||
= Total Direct Labor Hours | = POHR (per Direct Labor Hour) | #DIV/0! | ||||||||||
x Direct Labor Rate | ||||||||||||
= Direct Labor Cost | ||||||||||||
Part 5 - Overhead Budget | Part 7 - Overhead Cost Applied to One Snowboard | |||||||||||
Variable Manufacturing Overhead | # of DL Hours to Produce One Snowboard | |||||||||||
Fixed Manufacturing Overhead | x POHR | #DIV/0! | ||||||||||
Total Overhead | $ - | = Overhead Cost in One Snowboard | #DIV/0! | |||||||||
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
4. Direct Manufacturing Labor Budget: | |||
Finished Goods | |||
Budgeted Production | 1100 | ||
Labor Hour per unit of Production | 5 | ||
Total budgeted Hours needed | 5500 | ||
Labor cost per hour | $ 25 | ||
Total Direct Labor | $ 137,500 | ||
5. Manufacturing Overhead Budget: | |||
Finished Goods | |||
Budgeted Labor Hours | 5500 | ||
Per Hour Cost | $ 7.00 | ||
Variable Manufacturing Overhead | $ 7*5500 | $ 38,500 | |
Fixed Manufacturing Overhead | $ 66,000 | ||
Total Budgeted Manufacturing Overhead | $ 104,500 | ||
6. Predetermined Overhead Rate | |||
Total Budgeted Manufacturing Overhead | $ 104,500 | ||
Total budgeted Hours needed | 5,500 | ||
Budgeted Overhead Rate | 104500/5500 | $ 19.00 | |
7. Budgeted Manufacturing overhead cost per unit | |||
Labor hours for one snowboard | 5.00 | ||
Budgeted Overhead Rate | $ 19.00 | ||
Budgeted Manufacturing overhead cost per unit | $ 95 |
Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells...
Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells a single model The unit cost for ending FG inventory at 12/31/11 was $374.80. of snowboard, the Vortex. In the summer of 2011, Ignore Work In Process Iggy Sawdust, CPA, provided data for the 2012 budget: Direct Material Requirements (per snowboard) The December 2012 Budget Includes the following selected balances: Wood 5 board feet (b.f.) Cash $ 10,000.00 Fiberglass 6 yards Property, Plant, and Equipment...
Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells a single model The unit cost for ending FG inventory at 12/31/11 was $374.80. of snowboard, the Vortex. In the summer of 2011, Ignore Work In Process Iggy Sawdust, CPA, provided data for the 2012 budget: Direct Material Requirements (per snowboard) The December 2012 Budget Includes the following selected balances: Wood 5 board feet (b.f.) Cash $ 10,000.00 Fiberglass 6 yards Property, Plant, and Equipment...
Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells a single model The unit cost for ending FG inventory at 12/31/11 was $374.80. of snowboard, the Vortex. In the summer of 2011, Ignore Work In Process Iggy Sawdust, CPA, provided data for the 2012 budget: Direct Material Requirements (per snowboard) The December 2012 Budget Includes the following selected balances: Wood 5 board feet (b.f.) Cash $ 10,000.00 Fiberglass 6 yards Property, Plant, and Equipment...
,Inc., manufactures and sells snowboards. Skis manufactures a single model, the Pipex. In late 2017 Ski management accountant gathered the following data to prepare budgets for January 2018 The inventoriable unit cost for ending finished goods inventory on December 31, 2017, is $230.00 Assume Skis uses a FIFO inventory method for both direct materials and finished goods. Ignore work in process in your calculations. Materials and Labor Requirements Direct materials Wood 17 board feet (b.f.) per snowboard Fiberglass 15 yards...
Skulas, Inc., manufactures and sells Skulas manufactures a single model, the Pipex. In late 2017, Skulas's management accountant gathered the following data to prepare budgets for January 2018: Data Table Materials and Labor Requirements Direct materials Wood 9 board feet (b.f.) per snowboard Fiberglass 7 yards per snowboard Direct manufacturing labor 8 hours per snowboard Skulas's CEO expects to sell 1 comma 300 snowboards during January 2018 at an estimated retail price of $ 650 per board.Further, the CEO expects...
Q5 Q6 Q7 Q8 thx Sloane, Inc., manufactures and sells snowboards. Sloane manufactures a single model, the Pipex. In the summer of 2017, Sloane's management accountant gathered the following data to prepare budgets for 2018: Materials and Labour Requirements Direct materials Wood Fiberglass Direct manufacturing labour 9 board feet (b.f.) per snowboard 10 yards per snowboard 5 hours per snowboard Sloane's CEO expects to sell 2,900 snowboards during 2018 at an estimated retail price of $650 per board. Further, the...
Q8 Q9 Q10 Q11 thx Sloane, Inc., manufactures and sells snowboards. Sloane manufactures a single model, the Pipex. In the summer of 2017, Sloane's management accountant gathered the following data to prepare budgets for 2018: Materials and Labour Requirements Direct materials Wood Fiberglass Direct manufacturing labour 9 board feet (b.f.) per snowboard 10 yards per snowboard 5 hours per snowboard Sloane's CEO expects to sell 2,900 snowboards during 2018 at an estimated retail price of $650 per board. Further, the...
Materials and Labor Requirements Direct materials Wood Fiberglass Direct manufacturing labor 13 board feet (b.f.) per snowboard 11 yards per snowboard 7 hours per snowboard Skubas's CEO expects to sell 3,400 snowboards during January 2018 at an estimated retail price of $1,000 per board. Further, the CEO expects 2018 beginning inventory of 700 snowboards and would like to end January 2018 with 800 snowboards in stock. Direct Materials Inventories Ending Inventory 1/31/2018 Wood Beginning Inventory 1/1/2018 2,060 b.f. 1,060 yards...
ACNT-2309: Master Budgeting - Class Project: • Premium Furniture sells two models of granite-top coffee tables: Casual and Deluxe. Assume that FIFO is used for costing inventory There are two types of direct materials: red oak (RO) and granite slabs (GS). Direct material costs are variable with respect to units of output-coffee tables. Direct manufacturing labor workers are hired on an hourly basis; no overtime is worked There are two cost drivers for manufacturing overhead costs-direct manufacturing labor-hours and setup...
Problem 2. Preparing Master budgets UBS Company, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March). The managers of the different departments have provided the following information: The Sales Manager has projected the following sales: - January 6,000 units - February 5,000 units - March 6,000 units - Projected selling price is $40.00/unit Your Production Manager gave the following information: - Ending Inventory is to be...