Problem #7 that refers back to #4

Problem 4 Problem 5 Standard Corkscrew Forecast Proi. Available 2.000 MPS Lot size: 2,000 1 3,000 -1000 0 Week 2 3 4 3,500 5,000 4,000 4. SOG 9.500 13 500 - 0 0 0 0 Direct labor Standard corksore 0.10 Deluxe corkscrew 0.30 Machine time Standard corksore 0.20 Deluxe corkscrew 0.40 1 2 3 4 Totals 0 Week 2 3 4 1,500 1,000 3,000 1500-2500 -5.500 0 0 0 Direct labor Machine time 111 Deluxe Corkscrew Forecast Proj. Available 2,000 MPS Lot size: 1,000 1 2,000 0 0 0 WAI uses two resources for each product that it builds: direct labor and machine time. From historical records, WAI calculates the following planning factors: 5,000 corkscrews per week NO NO NO NO Use the spreadsheet to do some trial and error solutions for this problem. The company wants to produce exactly 5,000 corkscrews each week. When the "5,000 corkscrews per week?" row shows all green and there are no red colored cells, you've found an answer. You can use the dropdown arrow to select possible numerical values. There are multiple answers. Direct labor for standard corkscrew is 0.10 hour. Direct labor for deluxe corkscrew is 0.30 hour. Machine time for standard corkscrew is 0.20 hour Machine time for deluxe corkscrew is 0.40 hour. Calculate the capacity needed for the MPS developed in Problem 4. Problem 7 40% Wine Accessories Inc. (WA) produces two models of corkscrews, the standard model and a deluxe model. Wal follows a level aggregate plan, producing 20,000 corkscrews per month, or 5000 corkscrews per week. The MPS is developed in weekly time periods. The forecasts for each model and the projected available are shown in the next two tables. The replenishment order quantity is 2000 units for the standard model and 1000 units for the deluxe model. Note that you can place multiple orders if a single order is insufficient to cover the forecast (you can produce 4000 units of the standard model if necessary, or 2000 or 3000 units of the deluxe model). ) Remember that total weekly production is limited to 5000 corkscrews. Develop an MPs for each of the products. WAI knows from historical records that approximately 40 percent of its labor is used in Department 101 and 60 percent is used in Department 102. The reverse is true of machine time; 60 percent is used in Department 101 and 40 percent is used in Department 102. Direct labor Dept 101 Dept 102 Machine time Dept 101 Dept 102 60% 60% 40% 1 1 2 3 4 Department 1011 Direct labor Machine time Totals 0 0 Calculate the labor and machine hours needed in Department 101 for each period of the MPS developed in Problem 4. LLLLLLL TES 1 2 3 4 4 Department 102 Direct labor Machine time Totals 0 0 Calculate the labor and machine hours needed in Department 102 for each period of the MPS developed in Problem 4