B D E TI C A Problem 4 4 Standard Corkscrew Forecast - Proj. Available 2,000 . MPS Lot size: 2,000 1 3,000 1,000 0 Week 2 3 3,500 5,000 4 500 9 500 0 0 4,000 13.500 0 - . NO Week Deluxe Corkscrew 1 2 3 4 1 Forecast 2,000 1,500 1,000 3,000 2 Proj. Available 2,000 0 1 500 2.500 5,500 3 MPS 0 0 0 0 4 Lot size: 1,000 5 5 5,000 corkscrews per week? NO NO NO 3 Use the spreadsheet to do some trial and error solutions for this 3 problem. The company wants to produce exactly 5,000 corkscrews 2 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. 1. You can use the dropdown arrow to select possible numerical 2 values. There are multiple answers. 3 4 Wine Accessories Inc. (WAI) produces two models of corkscrews, the 5 standard model and a deluxe model. Wal follows a level aggregate 5 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 1 cover the forecast (you can produce 4000 units of the standard 2 model if necessary, or 2000 or 3000 units of the deluxe model). 3 Remember that total weekly production is limited to 5000 corkscrews. Develop an MPS for each of the products. 5 7 3 2 2 3 7