Hi. If I could please get help.
a. Estimated sales for July by sales territory: Maine: 310 units at $700 Backyard Chef per unit 150 units at Master Chef $1,200 per unit Vermont: 240 units at $750 Backyard Chef per unit 110 units at Master Chef $1,300 per unit New Hampshire: 360 units at $750 Backyard Chef per unit 180 units at Master Chef $1,400 per unit b. Estimated inventories at July 1: Direct materials: Grates 290 units 1,500 Stainless steel Ibs.b. Estimated inventories at July 1: Direct materials: Grates 290 units 1,500 Stainless steel Ibs. Burner subassemblies 170 units Shelves 340 units Finished products: Backyard Chef 30 units Master Chef 32 units c. Desired inventories at July 31: Direct materials: Grates 340 units 1,800 Stainless steel Ibs Burner subassemblies 155 units Shelves 315 units Finished products: Backyard Chef 40 units Master Chef 22 unitsd. Direct materials used in production: In manufacture of Backyard Chef: Gram Stainless steel Burner subassemblies Shelves In manufacture of Master I:Ihef: ) Gram Stainless steel Burner subassemblies Shelves e. Anticipated purchase price for direct materials: Greta Stainless steel 3 units per unit of product 24 lbs. per unit of product 2 units per unit of product 4 units per unit of product 6 units per unit of product 42 lbs. per unit of product 4 units per unit of product 5 units per unit of product $15 per unit t6 ner Ih. e. Anticipated purchase price for direct materials: Grates $15 per unit Stainless steel $6 per lb. Burner subassemblies $110 per unit Shelves $10 per unit f. Direct labor requirements: Backyard Chef: 0.50 hr. at $17 Stamping Department per hr. 0.60 hr. at $15 Forming Department per hr. 1.00 hr. at $14 Assembly Department per hr. Master Chef: 0.60 hr. at $17 Stamping Department per hr. 0.80 hr. at $15 Forming Department per hr. 1.50 hrs. at $14 Assembly Department per hr. Required:Required: 1. Prepare a sales budget for July. Gourmet Grill Company Sales Budget For the Month Ending July 31 Unit Sales Unit Selling Product and Area Total Sales Volume Price Backyard Chef: Maine Vermont New Hampshire Total Master Chef: Maine Vermont New Hampshire Total Total revenue from sales2. Prepare a production budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Gourmet Grill Company Production Budget For the Month Ending July 31 Units Backyard Master Chef Chef Expected units to be sold v Desired inventory, July 31 v Total units available v Estimated inventory, July 1 v Total units to be produced v 3. Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July 313. Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July 31 Burner Sub- Grates Stainless Steel Shelves assemblies (units) (Ibs.) (units) (units) Required units for production: Backyard Chef Master Chef Desired inventory, July 31 Total Estimated inventory, July 1 Total units to be purchased Unit price Total direct materials to be purchasedUnit price Total direct materials to be purchased 4. Prepare a direct labor cost budget for July. Gourmet Grill Company Direct Labor Cost Budget For the Month Ending July 31 Stamping Forming Assembly Total Department Department Department Hours required for production: Backyard Chef Master Chef Total Hourly rate +A Total direct labor cost