An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product Volume Price Sales
Total revenue from sales
2.
Bird Bird
House Feeder
Expected units to be sold
Total units available
3.
Wood Plastic
(feet) (lbs.) Total
Required units for production:
Bird house
Bird feeder
Birding Homes and Feeders Inc.
Production Budget
For the Month Ending January 31
Units
0%
Birding Homes and Feeders Inc.
Sales Budget
For the Month Ending January 31
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Score:
Key Code:
Name:
Section:
For the Month Ending January 31
Birding Homes and Feeders Inc.
Direct Materials Purchases Budget
Total units to be purchased
× Unit price
Total direct materials to be purchased
4.
Fabrication Assembly
Department Department Total
Hours required for production:
Bird house
Bird feeder
Total
× Hourly rate
Total direct labor cost
5.
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total
6.
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
Birding Homes and Feeders Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Direct Labor Cost Budget
For the Month Ending January 31
Birding Homes and Feeders Inc.
Birding Homes and Feeders Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Cost of finished goods available for sale
Cost of goods sold
Supporting calculations:
Units Cost Total
Finished goods inventory, January 1:
Bird house
Bird feeder
Total
Finished goods inventory, January 31:
Bird house
Bird feeder
Total
Direct materials inventory, January 1:
Wood
Plastic
Total
Direct materials inventory, January 31
Wood
Plastic
Total
7.
Selling expenses:
Total selling expenses
Administrative expenses:
Total administrative expenses
Total operating expenses
8.
Revenue from sales
Cost of goods sold
Birding Homes and Feeders Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Birding Homes and Feeders Inc.
Budgeted Income Statement
For the Month Ending January 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.
1.
Unit Sales Unit Selling Total
Product Volume Price Sales
2.
Bird Bird
House Feeder
3.
Wood Plastic
(feet) (lbs.) Total
Required units for production:
Birding Homes and Feeders Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
For the Month Ending January 31
Units
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Birding Homes and Feeders Inc.
Sales Budget
For the Month Ending January 31
Score:
Instructions
Name:
Solution
Section:
ON
Birding Homes and Feeders Inc.
Production Budget
4.
Fabrication Assembly
Department Department Total
5.
6.
Birding Homes and Feeders Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Birding Homes and Feeders Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Birding Homes and Feeders Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Direct materials inventory, January 1:
Wood 600 $2.50 1,500$
Plastic 1,000 $0.80 800
Total 2,300$
7.
8.
Budgeted Income Statement
For the Month Ending January 31
Birding Homes and Feeders Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Birding Homes and Feeders Inc.