Module 5 Assignment Caloalator eBook Sales, Production, Direct Materials Purchas

Question

Module 5 Assignment Caloalator eBook Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative 1. TMM.7-1 2. PR.07-02A 3. TMM8-2 4. EX08-07 ALGO units every month. Selected information concerning sales and production for July is summarized as follows: a. Estimated sales for July by sales territory Maine: 310 units at $700 per unit 150 units at 1,200 per unit Backyard Ch EX 08-08 ALGO Master Che Vermont 240 units at $750 per unit 110 units at 1,300 per unit Backyard Chef Master Che New Hampshe 360 units at $750 per unit 180 units at $1,400 per unt ackyard Che Master Chet b. Estimated inventories at July 1

Explanation / Answer

1 Sales Budget Product and Area Unit Sales Volume Unit Selling Price Total Sales Backyard chef: Maine 310 700 217000 Vermont 240 750 180000 New Hampshire 360 750 270000 Total 910 667000 Master chef: Maine 150 1200 180000 Vermont 110 1300 143000 New Hampshire 180 1400 252000 Total 440 575000 Total revenue from sales 1242000 2 Production Budget Backyard Chef Master Chef Units to be sold 910 440 Add: Ending Finished products 40 22 950 462 Less: beginning Finished products 30 32 Units to be produced 920 430 3 Direct material Purchase budget Grates Stainless Steel Burner Sub Assemblies Shelves Total Required units for production: (Note:1) Backyard chef 2760 22080 1840 3680 Master chef 5520 38640 3680 4600 Desired inventory,July 31 340 1800 155 315 Total 8620 62520 5675 8595 Estimated inventory,July 1 290 1500 170 340 Total units to be purchased 8330 61020 5505 8255 Unit price 15 6 110 10 Total direct materials to be purchased 124950 366120 605550 82550 1179170 Note:1. Raw material required Backyard chef: Units to be produced 920 Grates 3 units per unit (920*3) 2760 Units Stainless steel 24 lbs per unit (920*24) 22080 lbs Burner Sub Assemblies . 2 units per unit (920*2) 1840 Units Shelves 4 units per unit (920*4) 3680 Units Master chef: Units to be produced 430 Grates 6 units per unit (920*6) 5520 Units Stainless steel 42 lbs per unit (920*42) 38640 lbs Burner Sub Assemblies . 4 units per unit (920*4) 3680 Units Shelves 5 units per unit (920*5) 4600 Units 4 Direct labor cost Budget Stamping Department Forming Department Assembly Department Total Hours required for production: (Note:2) Backyard chef 460 552 920 Master chef 552 736 1380 Total 1012 1288 2300 Hourly rate 17 15 14 Total direct labor cost 17204 19320 32200 68724 Note:2-Hours required for production Backyard chef Units to be produced 920 Stamping Department 0.50 hrs per unit (920*0.50) 460 hrs Forming Department 0.60 hrs per unit (920*0.60) 552 hrs Assembly Department 1 hr per unit (920*1) 920 hrs Master chef: Units to be produced 430 Stamping Department 0.60 hrs per unit (920*0.60) 552 hrs Forming Department 0.80 hrs per unit (920*0.80) 736 hrs Assembly Department 1.50 hrs per unit (920*1.5) 1380 hrs

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.