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:
Batting helmet | 1,200 units at $40 per unit |
Football helmet | 6,500 units at $160 per unit |
Direct materials: | |
Plastic | 90 lbs. |
Foam lining | 80 lbs. |
Finished products: | |
Batting helmet | 40 units at $25 per unit |
Football helmet | 240 units at $77 per unit |
Direct materials: | |
Plastic | 50 lbs. |
Foam lining | 65 lbs. |
Finished products: | |
Batting helmet | 50 units at $25 per unit |
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 |
Depreciation of plant and equipment | 12,000 |
Power and light | 4,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 |
Gold Medal Athletic Co. | ||
Production Budget | ||
For the month ending March 31 | ||
Units | ||
Batting Helmet | Football helmet | |
Expected units to be sold | 1,200 | 6,500 |
Desired Inventory, March 31 | 50 | 220 |
Total units available | 1,250 | 6,720 |
Estimated inventory, March 1 | -40 | -240 |
Total units to be produced | 1,210 | 6,480 |
Cost of goods sold:
Gold Medal Athletic Co. | |||
Cost of Goods Sold Budget | |||
For the month ending March 31 | |||
Finished goods inventory, March 1 (40*25+240*77) | $ 19,480 | ||
Work in progress inventory, March 1 | $ 15,300 | ||
Direct materials: | |||
Direct materials inventory, March 1 (90*6+80*4) | $ 860 | ||
Direct materials purchases | $ 1,85,792 | ||
Cost of direct materials available for use | $ 1,86,652 | ||
Direct materials inventory, March 31 (-50*6-65*4) | $ (560.00) | ||
Cost of direct materials placed in production | $ 1,86,092 | ||
Direct labor | $ 2,41,406 | ||
Factory overhead | $ 1,04,300 | ||
Total manufacturing costs | $ 5,31,798 | ||
Total work in progress during the period | $ 5,47,098 | ||
Work in progress inventory, March 31 | $ (14,800) | ||
Cost of goods manufactured | $ 5,32,298 | ||
Cost of finished goods available for sale | $ 5,51,778 | ||
Finished goods inventory, March 31 | $ (18,410) | ||
Cost of Goods Sold | $ 5,33,368 |
Workings:
Direct labor | |||
Batting Helmet | Football helmet | Total | |
Molding department |
$ 4,840 (1210*0.2*20) |
$ 64,800 (6480*0.5*20) |
$ 69,640 |
Assembly department |
$ 8,470 (1210*0.5*14) |
$ 1,63,296 (6480*1.8*14) |
$ 1,71,766 |
Total | $ 13,310 | $ 2,28,096 | $ 2,41,406 |
Ending inventory | |||
Batting Helmet | Football helmet | Total | |
Units | 50 | 220 | |
Rate | $ 25 | $ 78 | |
Cost | $ 1,250 | $ 17,160 | $ 18,410 |
Factory overheads | |
Indirect factor wages | $ 86,000 |
Depreication of plant and equipment | $ 12,000 |
Power and light | $ 4,000 |
Insurance and property taxes | $ 2,300 |
Total | $ 1,04,300 |
Budgeted Income Statement and Supporting Budgets The budget director of Gold Medal Athletic Co., with the assistance of...
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...
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: Finished products: Plastic 90 lbs. Batting helmet 40 units at $25 per unit Foam lining 80 lbs. Football...
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...
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...
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...