Business 1B - Managerial Accounting - Master Budget Comprehensive Project Radical Boards, Inc. manufactures and sells a
Fantastic news! We've Found the answer you've been seeking!
Question:
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 11 - Budgeted Income Statement | |||||||
Sales Revenue | |||||||
Less: Cost of Goods Sold | |||||||
= Gross Profit | $ - | ||||||
Less: Operating Expenses | |||||||
Variable marketing costs | |||||||
Fixed non-manufacturing costs | $ - | ||||||
=Operating Income | $ - | ||||||
Part 12 - Budgeted Balance Sheet | |||||||
Cash | Current Liabilities | ||||||
Inventory | Long-Term Liabilities | ||||||
PPE | Capital Stock | ||||||
Retained Earnings | |||||||
Total Assets | $ - | Total Liabilities & Equity |
Related Book For
Horngrens Cost Accounting A Managerial Emphasis
ISBN: 978-0134475585
16th edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date: