Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Unit Sales Unit Selling Total
Product Volume Price Sales
Batting Football
Helmet Helmet
Expected units to be sold
Total units available
Total units to be produced
Plastic Foam Lining
(lbs.) (lbs.) Total
Required units for production:
Batting helmet
Football helmet
Total units available
For the Month Ending March 31
Direct Materials Purchases Budget
For the Month Ending March 31
For the Month Ending March 31
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Total units to be purchased
Unit price
Total direct materials to be purchased
Molding Assembly
Department Department Total
Hours required for production:
Batting helmet
Football helmet
Total
Hourly rate
Total direct labor cost
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total
Direct materials:
Direct materials purchases
Cost of direct materials available for use
Cost of direct materials placed in production
Direct labor
Factory overhead
Total manufacturing costs
Total work in process during period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of Goods Sold Budget
For the Month Ending March 31
Factory Overhead Cost Budget
For the Month Ending March 31
For the Month Ending March 31
Finished goods inventory, March 1:
Batting helmet
Football helmet
Total
Finished goods inventory, March 31:
Batting helmet
Football helmet
Total
Direct materials inventory, March 1
Plastic
Foam lining
Total
Direct materials inventory, March 31
Plastic
Foam lining
Total
Total selling expenses
Administrative expenses:
Total administrative expenses
Total operating expenses
Budgeted Income Statement
For the Month Ending March 31
Selling and Administrative Expenses Budget
For the Month Ending March 31
Gross profit
Operating expenses:
Selling expenses
Administrative expenses
Total operating expenses
Operating income
Other revenue and expense:
Interest revenue
Interest expense
Income before income tax
Income tax expense
Net income
An asterisk (*) will appear to the right of an incorrect entry.
Unit Sales Unit Selling Total
Product Volume Price Sales
Plastic Foam Lining
(lbs.) (lbs.) Total
For the Month Ending March 31
Direct Materials Purchases Budget
For the Month Ending March 31
For the Month Ending March 31
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Molding Assembly
Department Department Total
Hours required for production:
Cost of Goods Sold Budget
For the Month Ending March 31
For the Month Ending March 31
For the Month Ending March 31
Factory Overhead Cost Budget
Supporting calculations:
Units Cost Total
Direct materials inventory, March 1
For the Month Ending March 31
Budgeted Income Statement
Selling and Administrative Expenses Budget
For the Month Ending March 31