The budget director of Gold Medal Athletic Co., 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 March:
Batting helmet |
1,200 units at $40 per unit |
Football helmet |
6,500 units at $160 per unit |
Direct materials: |
Finished products: |
||||
Plastic |
90 |
lbs. |
Batting helmet |
40 |
units at $25 per unit |
Foam lining |
80 |
lbs. |
Football helmet |
240 |
units at $77 per unit |
Direct materials: |
|
Finished products: |
|||
Plastic |
50 |
lbs. |
Batting helmet |
50 |
units at $25 per unit |
Foam lining |
65 |
lbs. |
Football helmet |
220 |
units at $78 per unit |
In manufacture of batting helmet: |
|
Plastic |
1.2 lbs. per unit of product |
Foam lining |
0.5 lb. per unit of product |
In manufacture of football helmet: |
|
Plastic |
3.5 lbs. per unit of product |
Foam lining |
1.5 lbs. per unit of product |
Plastic |
$6 per lb. |
Foam lining |
$4 per lb. |
Batting helmet: |
|
Molding Department |
0.2 hr. at $20 per hr. |
Assembly Department |
0.5 hr. at $14 per hr. |
Football helmet: |
|
Molding Department |
0.5 hr. at $20 per hr. |
Assembly Department |
1.8 hrs. at $14 per hr. |
Indirect factory wages |
$86,000 |
Power and light |
$4,000 |
|
Depreciation of plant and equipment |
12,000 |
Insurance and property tax |
2,300 |
Sales salaries expense |
$184,300 |
Advertising expense |
87,200 |
Office salaries expense |
32,400 |
Depreciation expense—office equipment |
3,800 |
Telephone expense—selling |
5,800 |
Telephone expense—administrative |
1,200 |
Travel expense—selling |
9,000 |
Office supplies expense |
1,100 |
Miscellaneous administrative expense |
1,000 |
Interest revenue |
$940 |
Interest expense |
872 |
Instructions
Ans. 1 | Gold Medal Athletic Co. | ||||
Sales Budget | |||||
For the Month Ending March 31 | |||||
Unit Sales Volume (a) | Unit Selling Price (b) | Total Sales (a*b) | |||
Batting helmet | 1200 | $40 | $48,000 | ||
Football helmet | 6500 | $160 | $1,040,000 | ||
Total revenue from sales | $1,088,000 | ||||
Ans. 2 | Gold Medal Athletic Co. | ||||
Production Budget | |||||
For the Month Ending March 31 | |||||
Particulars | Batting helmet | Football helmet | |||
Expected units to be sold | 1200 | 6500 | |||
Add: Desired ending finished inventory | 50 | 220 | |||
Total required units | 1250 | 6720 | |||
Less: Beginning finished inventory units | -40 | -240 | |||
Units to be produced | 1210 | 6480 | |||
Ans. 3 | Gold Medal Athletic Co. | ||||
Direct Materials Purchases Budget | |||||
For the Month Ending March 31 | |||||
Plastic | Foam lining | Total | |||
Required units for production: | |||||
Batting helmet | 1452 | 605 | |||
Football helmet | 22680 | 9720 | |||
Add: Desired units of ending materials inventory | 50 | 65 | |||
Total units available | 24182 | 10390 | |||
Less: Estimated beginning materials inventory | -90 | -80 | |||
Total units to be purchased | 24092 | 10310 | |||
(*) Unit price | $6.00 | $4.00 | |||
Total direct materials to be purchased | $144,552 | $41,240 | $185,792 | ||
*Calculations: | |||||
Required units for production = Units produced * Materials required per unit | |||||
Plastic | Foam lining | ||||
Required units for production: | |||||
Batting helmet | 1,210 * 1.20 lb | 1,210 * 0.50 lb | |||
Football helmet | 6,480 * 3.50 lb | 6,480 * 1.50 lb | |||
Ans. 4 | Gold Medal Athletic Co. | ||||
Direct Labor Cost Budget | |||||
For the Month Ending March 31 | |||||
Molding Department | Assembly Department | Total | |||
Hours required for production: | |||||
Batting helmet | 242 | 605 | |||
Football helmet | 3240 | 11664 | |||
Total | 3482 | 12269 | |||
(*) Hourly rate | $20.00 | $14.00 | |||
Total direct labor cost | $69,640 | $171,766 | $241,406 | ||
*Calculations: | |||||
Hours required for production = Units produced * Direct labor hours per unit | |||||
Molding Department | Assembly Department | ||||
Hours required for production: | |||||
Batting helmet | 1,210 * 0.20 hr. | 1,210 * 0.50 hr. | |||
Football helmet | 6,480 * 0.50 hr. | 6,480 * 1.80 hr. |
The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production...
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., 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 March: Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit Estimated inventories at March 1: Direct materials: Plastic 90 lbs. Foam lining 80 lbs. Finished products: Batting helmet 40...
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., 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 March 2016: Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit Estimated inventories at March 1: Direct materials: Plastic 90 lbs. Foam lining 80 lbs. Finished products: Batting helmet...
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., 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 March: Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit Estimated inventories at March 1: Direct materials: Plastic 90 lb. Foam lining 80 lb. Finished products: Batting helmet 40...
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., 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 March: Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit Estimated inventories at March 1: Direct materials: Plastic 90 lb. Foam lining 80 lb. Finished products: Batting helmet 40...
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co, 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 March a. Estimated sales for March: Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unit b. Estimated inventories at March 1: Direct materials Plastic 90 lb Foam lining 80 lb Finished pducts Batting...
PR 21-3B Budgeted income statement and supporting budgets Obj. 4 4. Total direct labor cost in Assembly Dept. The budget director of Gold Medal Athletic Co., 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 March: A. Estimated sales for March: $171,766 Batting helmet.... 1,200 units at $40 per unit 6,500 units at $160 per unit EXCEL TEMPLATE Football helmet B. Estimated inventories...
Budgeted Income Statement and Supporting Budgets The budget director of Jupiter Helmets 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 May: a. Estimated sales for May: Bicycle helmet 8,500 units at $24 per unit Motorcycle helmet 5,500 units at $180 per unit b. Estimated inventories at May 1: Direct materials: Finished products: Plastic 1,480 lbs. Bicycle helmet 200 units at $15...
do not answer otal direct cost in nbly Dept., 766 PR 22-3B Budgeted Income statement and supporting budgets OBJ.4 The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following datit for use in developing the budgeted income statement for March: a. Estimated sales for March: Batting helmet...... 1,200 units at $40 per unit Football helmet... 6,500 units at S160 per unit (Continued b. Estimated inventories at...
Budgeted Income Statement and Supporting Budgets The budget director of Jupiter Helmets 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 May: a. Estimated sales for May: Bicycle helmet 9,250 units at $24 per unit Motorcycle helmet 6,250 units at $180 per unit b. Estimated inventories at May 1: Direct materials: Finished products: Plastic 1,480 lbs. Bicycle helmet 200 units at $15...
Budgeted Income Statement and Supporting Budgets The budget director of Jupiter Helmets 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 May a. Estimated sales for May: Bicycle helmet 7,500 units at $24 per unit Motorcycle helmet 7,000 units at $185 per unit b. Estimated Inventories at May 1: Direct materials: Plastic Foam lining 1,480 lbs. 520 lbs. Finished products: Bicycle helmet...