1 Problem 4 Problem 5 5,000 4.000 0.10 3 Standard Corkscrew 4 Forecast 5 Proj Available 6 MPS Lot size: 2.000 3,000 1.000 2,000 3,500 1500 4.000 4,000 Direct lobor Standard corkscres Deluxe corkscrew Machine time Standard corkscres Deluxe corkscrew 2.000 0.20 Direct labor Machine time 10 Deluxe Corkscrew 11 Forecast 12 Proj Available 13 MPS Lot size: 2.000 500 3.000 3.000 2.500 1.000 2.500 1.000 1,000 165,000 corkscrews per week? YES YES YES YES 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 Tow to select possible numerical values. There are multiple awwers WAI uses two resources for each product that it builds direct labor and machine time from historical records, WAl calculates the following planning factors Direct labor for standard corkscrew is 0.10 hour Direct labor for deluxe Corkscrew is 0.5 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 NRWER Problem 7 Wine Accessories Inc. (WA) produces two models of cortecrews, the standard model and a deluxe model W ollows a level agregate 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 dele model Note that you can place multiple orders angle order is insufficient to cover the forecast you can produce 4000 units of the standard model 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 laboris 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 Direct lobor Dept 101 Dept 102 Machine time Dept 101 Dept 102 Calculate the labor and machine hours needed in Department 101 for each period of the MPS developed in Problem 4 Department 102 Calculate the labor and machine hours needed in Department 102 for each period of the MPS developed in Problem 1 Problem 4 Problem 5 5,000 4.000 0.10 3 Standard Corkscrew 4 Forecast 5 Proj Available 6 MPS Lot size: 2.000 3,000 1.000 2,000 3,500 1500 4.000 4,000 Direct lobor Standard corkscres Deluxe corkscrew Machine time Standard corkscres Deluxe corkscrew 2.000 0.20 Direct labor Machine time 10 Deluxe Corkscrew 11 Forecast 12 Proj Available 13 MPS Lot size: 2.000 500 3.000 3.000 2.500 1.000 2.500 1.000 1,000 165,000 corkscrews per week? YES YES YES YES 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 Tow to select possible numerical values. There are multiple awwers WAI uses two resources for each product that it builds direct labor and machine time from historical records, WAl calculates the following planning factors Direct labor for standard corkscrew is 0.10 hour Direct labor for deluxe Corkscrew is 0.5 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 NRWER Problem 7 Wine Accessories Inc. (WA) produces two models of cortecrews, the standard model and a deluxe model W ollows a level agregate 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 dele model Note that you can place multiple orders angle order is insufficient to cover the forecast you can produce 4000 units of the standard model 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 laboris 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 Direct lobor Dept 101 Dept 102 Machine time Dept 101 Dept 102 Calculate the labor and machine hours needed in Department 101 for each period of the MPS developed in Problem 4 Department 102 Calculate the labor and machine hours needed in Department 102 for each period of the MPS developed in