1.
Standard Product Cost
Sana Rosa Furniture Company manufactures designer home furniture. Sana Rosa uses a standard cost system. The direct labor, direct materials, and factory overhead standards for an unfinished dining room table are as follows:
| Direct labor: | standard rate | $24.00 per hr. |
| standard time per unit | 4.00 hrs. | |
| Direct materials (oak): | standard price | $11.50 per bd. ft. |
| standard quantity | 17 bd. ft. | |
| Variable factory overhead: | standard rate | $2.40 per direct labor hr. |
| Fixed factory overhead: | standard rate | $1.20 per direct labor hr. |
a. Determine the standard cost per dining room
table. If required, round your answer to two decimal places.
$ per dining room table
b. A standard cost system provides Rosa Furniture management a cost control tool using the principle of . Using this principle, cost deviations from standards can be investigated and corrected.
2.
Direct Materials and Direct Labor Variances
At the beginning of June, Kimber Toy Company budgeted 17,000 toy action figures to be manufactured in June at standard direct materials and direct labor costs as follows:
| Direct materials | $12,750 |
| Direct labor | 9,180 |
| Total | $21,930 |
The standard materials price is $0.50 per pound. The standard direct labor rate is $9.00 per hour. At the end of June, the actual direct materials and direct labor costs were as follows:
| Actual direct materials | $12,000 |
| Actual direct labor | 8,600 |
| Total | $20,600 |
There were no direct materials price or direct labor rate variances for June. In addition, assume no changes in the direct materials inventory balances in June. Kimber Toy Company actually produced 15,500 units during June.
Determine the direct materials quantity and direct labor time variances. Round your per unit computations to two decimal places, if required. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
| Direct materials quantity variance | $ | |
| Direct labor time variance | $ |
3.
Flexible Overhead Budget
Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 12,000 hours of productive capacity in the department:
| Variable overhead cost: | ||
| Indirect factory labor | $100,800 | |
| Power and light | 3,600 | |
| Indirect materials | 31,200 | |
| Total variable overhead cost | $135,600 | |
| Fixed overhead cost: | ||
| Supervisory salaries | $47,460 | |
| Depreciation of plant and equipment | 29,830 | |
| Insurance and property taxes | 18,980 | |
| Total fixed overhead cost | 96,270 | |
| Total factory overhead cost | $231,870 |
Assuming that the estimated costs for November are the same as for October, prepare a flexible factory overhead cost budget for the Press Department for November for 10,000, 12,000, and 14,000 hours of production. Round your interim computations to the nearest cent, if required. Enter all amounts as positive numbers.
| Leno Manufacturing Company | |||
| Factory Overhead Cost Budget-Press Department | |||
| For the Month Ended November 30 | |||
| Direct labor hours | 10,000 | 12,000 | 14,000 |
| Variable overhead cost: | |||
| Indirect factory labor | $ | $ | $ |
| Power and light | |||
| Indirect materials | |||
| Total variable factory overhead | $ | $ | $ |
| Fixed factory overhead cost: | |||
| Supervisory salaries | $ | $ | $ |
| Depreciation of plant and equipment | |||
| Insurance and property taxes | |||
| Total fixed factory overhead | $ | $ | $ |
| Total factory overhead cost | $ | $ | $ |
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
a. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
b. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
c. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
d. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
e. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
f. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
g. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
h. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Operating Budget, Comprehensive Analysis
Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below.
| January | 10,000 |
| February | 10,500 |
| March | 13,100 |
| April | 16,000 |
| May | 18,500 |
The following data pertain to production policies and manufacturing specifications followed by Ponderosa:
| Direct Material | Per-Unit Usage | Unit Cost |
| Part #K298 | 2 | $4 |
| Part #C30 | 3 | 7 |
Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the amount of material on hand on January 1.
| Fixed Cost Component |
Variable Cost Component |
|
| Supplies | $ — | $1.00 |
| Power | — | 0.20 |
| Maintenance | 12,600 | 1.10 |
| Supervision | 14,000 | — |
| Depreciation | 45,000 | — |
| Taxes | 4,300 | — |
| Other | 86,000 | 1.60 |
| Fixed Costs | Variable Costs | |
| Salaries | $ 88,600 | — |
| Commissions | — | $1.40 |
| Depreciation | 25,000 | — |
| Shipping | — | 3.60 |
| Other | 137,000 | 1.60 |
Required:
Prepare a monthly operating budget for the first quarter with the following schedules:
2. Production budget
| January | February | March | Total | |
|---|---|---|---|---|
| Unit sales | 10,000 | 10,500 | 13,100 | 33,600 |
| Desired ending inventory | 2,100 | 3,200 | ||
| Total needed | 12,100 | |||
| Less: Beginning inventory | 900 | 2,100 | ||
| Units produced | 11,200 |
3. Direct materials purchases budget
| January | February | March | Total | |||||
|---|---|---|---|---|---|---|---|---|
| Part K298 | Part C30 | Part K298 | Part C30 | Part K298 | Part C30 | Part K298 | Part C30 | |
| Units produced | 11200 | |||||||
| Dir. mat. per unit | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3 |
| Production needs | 22,400 | 33,600 | ||||||
| Desired EI | ||||||||
| Total needed | ||||||||
| Less: BI | ||||||||
| Dir. mat. to purchase | ||||||||
| Cost per unit | $ | $ | $ | $ | $ | $ | $ | $ |
| Total purchase cost | $ | $ | $ | $ | $ | $ | $ | $ |
4. Direct labor budget. Round your answers to two decimal places, if required.
| January | February | March | Total | |
|---|---|---|---|---|
| Units to be produced | ||||
| Direct labor time per unit (hrs.) | ||||
| Total hours needed | ||||
| Wages per hour | $ | $ | $ | $ |
| Total direct labor cost | $ | $ | $ | $ |
| January | February | March | Total | |
|---|---|---|---|---|
| Budgeted direct labor hours | ||||
| Variable overhead rate | ||||
| Budgeted var. overhead | $ | $ | $ | $ |
| Budgeted fixed overhead | ||||
| Total overhead cost | $ | $ | $ | $ |
6. Selling and administrative expense budget. Round your answers to the nearest cent, if required.
| January | February | March | Total | |
|---|---|---|---|---|
| Planned sales | ||||
| Variable selling & administrative expense per unit | $ | $ | $ | $ |
| Total variable expense | $ | $ | $ | $ |
| Fixed selling & administrative expense: | ||||
| Salaries | $ | $ | $ | $ |
| Depreciation | ||||
| Other | ||||
| Total fixed expenses | $ | $ | $ | $ |
| Total selling & administrative expenses | $ | $ | $ | $ |
7. Ending finished goods inventory budget. Round intermediate calculations to the nearest cent. Round your answers to the nearest cent, if required.
| Unit cost computation: | |
| Direct materials: | |
| Part K298 | $ |
| Part C30 | |
| Direct labor | |
| Overhead: | |
| Variable | |
| Fixed | |
| Total unit cost | $ |
| Number of units | |
| Finished goods | $ |
8. Cost of goods sold budget
| Direct materials used | ||
| Part K298 | $ | |
| Part C30 | $ | |
| Direct labor used | ||
| Overhead | ||
| Budgeted manufacturing costs | $ | |
| Add: Beginning finished goods | ||
| Goods available for sale | $ | |
| Less: Ending finished goods | ||
| Budgeted cost of goods sold | $ |
9. Budgeted income statement (ignore income taxes)
| Sales | $ |
| Less: Cost of goods sold | |
| Gross margin | $ |
| Less: Selling and administrative expense | |
| Income before income taxes | $ |
10. Cash budget
Enter a negative balance as a negative amount, and if an amount is
zero enter "0".
| January | February | March | Total | |
|---|---|---|---|---|
| Beginning balance | $ | $ | $ | $ |
| Cash receipts | ||||
| Total cash available | $ | $ | $ | $ |
| Disbursements: | ||||
| Purchases | $ | $ | $ | $ |
| DL payroll | ||||
| Overhead | ||||
| Marketing & admin | ||||
| Land | ||||
| Total disbursements | $ | $ | $ | $ |
| Ending balance | $ | $ | $ | $ |
| Financing: | ||||
| Borrowed/repaid | ||||
| Interest paid | ||||
| Ending cash balance | $ | $ | $ | $ |
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
Estimated sales for January:
| Bird house | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
Estimated inventories at January 1:
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lbs. |
| Finished products: | |
| Bird house | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
Desired inventories at January 31:
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lbs. |
| Finished products: | |
| Bird house | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
Direct materials used in production:
| In manufacture of Bird House: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
Anticipated cost of purchases and beginning and ending inventory of direct materials:
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
Direct labor requirements:
| Bird House: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
Estimated factory overhead costs for January:
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | $8,000 |
| Insurance and property tax | 2,000 |
Estimated operating expenses for January:
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
Estimated other income and expense for January:
| Interest revenue | $300 |
| Interest expense | 224 |
Estimated tax rate: 30%
Required:
1. Prepare a sales budget for January.
| Birds of a Feather
Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Bird house | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather
Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Bird House | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather
Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Bird house | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather
Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Bird house | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather
Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather
Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather
Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather
Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Operating expenses: | |||
| Total operating expenses | |||
| Other income: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting
Budgeted Income Statement and Supporting Budgets
The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:
| Birdhouse | 6,000 units at $55 per unit |
| Bird feeder | 4,500 units at $75 per unit |
| Direct materials: | |
| Wood | 220 ft. |
| Plastic | 250 lb. |
| Finished products: | |
| Birdhouse | 300 units at $23 per unit |
| Bird feeder | 240 units at $34 per unit |
| Direct materials: | |
| Wood | 180 ft. |
| Plastic | 210 lb. |
| Finished products: | |
| Birdhouse | 340 units at $23 per unit |
| Bird feeder | 200 units at $34 per unit |
| In manufacture of BirdHouse: | |
| Wood | 0.80 ft. per unit of product |
| Plastic | 0.50 lb. per unit of product |
| In manufacture of Bird Feeder: | |
| Wood | 1.20 ft. per unit of product |
| Plastic | 0.75 lb. per unit of product |
| Wood | $8.00 per ft. |
| Plastic | $1.20 per lb. |
| Birdhouse: | |
| Fabrication Department | 0.20 hr. at $15 per hr. |
| Assembly Department | 0.30 hr. at $12 per hr. |
| Bird Feeder: | |
| Fabrication Department | 0.40 hr. at $15 per hr. |
| Assembly Department | 0.35 hr. at $12 per hr. |
| Indirect factory wages | $80,000 |
| Depreciation of plant and equipment | 25,000 |
| Power and light | 8,000 |
| Insurance and property tax | 2,000 |
| Sales salaries expense | $90,000 |
| Advertising expense | 20,000 |
| Office salaries expense | 18,000 |
| Depreciation expense—office equipment | 800 |
| Telephone expense—selling | 500 |
| Telephone expense—administrative | 200 |
| Travel expense—selling | 5,000 |
| Office supplies expense | 250 |
| Miscellaneous administrative expense | 450 |
| Interest revenue | $300 |
| Interest expense | 224 |
Required:
1. Prepare a sales budget for January.
| Birds of a Feather Inc. Sales Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Birdhouse | |||
| Bird feeder | |||
| Total revenue from sales | $ | ||
2. Prepare a production budget for January.
| Birds of a Feather Inc. Production Budget For the Month Ending January 31 |
||||
|---|---|---|---|---|
| Units | ||||
| Birdhouse | Bird Feeder | |||
| Expected units to be sold | ||||
| Plus desired inventory, January 31 | ||||
| Total | ||||
| Less estimated inventory, January 1 | ||||
| Total units to be produced | ||||
3. Prepare a direct materials purchases budget for January.
| Birds of a Feather Inc. Direct Materials Purchases Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Wood | Plastic | Total | |
| Required units for production: | |||
| Birdhouse | |||
| Bird feeder | |||
| Plus desired units of inventory, January 31 | |||
| Total | |||
| Less estimated units of inventory, January 1 | |||
| Total units to be purchased | |||
| Unit price | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ |
4. Prepare a direct labor cost budget for January.
| Birds of a Feather Inc. Direct Labor Cost Budget For the Month Ending January 31 |
||||||
|---|---|---|---|---|---|---|
| Fabrication Department |
Assembly Department | Total | ||||
| Hours required for production: | ||||||
| Birdhouse | ||||||
| Bird feeder | ||||||
| Total | ||||||
| Hourly rate | $ | $ | ||||
| Total direct labor cost | $ | $ | $ | |||
5. Prepare a factory overhead cost budget for January.
| Birds of a Feather Inc. Factory Overhead Cost Budget For the Month Ending January 31 |
||
|---|---|---|
| Indirect factory wages | ||
| Depreciation of plant and equipment | ||
| Power and light | ||
| Insurance and property tax | ||
| Total | $ | |
6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.
| Birds of a Feather Inc. Cost of Goods Sold Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Direct materials: | |||
| Cost of direct materials available for use | |||
| Cost of direct materials placed in production | |||
| Total manufacturing costs | |||
| Total work in process during the period | |||
| Cost of goods manufactured | |||
| Cost of finished goods available for sale | |||
| Cost of goods sold | $ | ||
7. Prepare a selling and administrative expenses budget for January.
| Birds of a Feather Inc. Selling and Administrative Expenses Budget For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling expenses: | |||
| Sales salaries expense | |||
| Advertising expense | |||
| Telephone expense—selling | |||
| Travel expense—selling | |||
| Total selling expenses | |||
| Administrative expenses: | |||
| Office salaries expense | |||
| Depreciation expense—office equipment | |||
| Telephone expense—administrative | |||
| Office supplies expense | |||
| Miscellaneous administrative expense | |||
| Total administrative expenses | |||
| Total operating expenses | $ | ||
8. Prepare a budgeted income statement for January.
| Birds of a Feather Inc. Budgeted Income Statement For the Month Ending January 31 |
|||
|---|---|---|---|
| Selling and administrative expenses: | |||
| Total selling and administrative expenses | |||
| Other revenue: | |||
| Other expenses: | |||
| $ | |||
In: Accounting