Problem 4 Standard Corkscrew Forecast Proj. Available MFS Lot size: Deluxe Corkscrew Forecast Proj. Available MPS 2,000 2,000 2,000 Lot size: 1,000 1 3,000 1,000 1 2,000 0 2 3,300 41300 0 2 1,500 Week Week Wine Accessories inc. (WAI) produces two mod standard medal and deluxa medal. Walfellow COMPANY. When the 3,000 corlacraws per week raw thaw are no red colored colla, you've dropdown arrow to Joinct patie 3 3,000 1:00 3 1,000 4,000 -13,300 5,000 corkscrews per week? INO NO NO Use the spreadsheet to do some trial and error solutions for this problem. 3,000 P31500) rkierows, th producing 20,000 corkscrews por month, or 9000 carkscrows par was The MPS is developed in woo! periods. The forecasts for each madal and the projec hown in the next two tablox. The Felanihmont order quantity 1 2000 units for the standard model and 1000 units for the deluxe modal. Note that you can place multiple arders id ingle order is insufficient to cover th units of the star deluxe model). Remembert corkscrews Develop an MPS forach of the products. Perozoit (you can preQUED 4000 br 2000 or 9000 units of the wookly production in limited to 3000

numlam A 9,000 corkscrews per week? Use the ap rendaheet to de aeme trial snd errer ablutiena for thix problem. The compeny wenta to produce erectly 2,000 cerkacrewa esch weok. When the "s,000 eorkacrewa per week?" rew shawa all green end there we ne red celered crella, yeu've feund on enawer, Yeu enn uat the drepdown errew to select possible numericel velues. There ere multiple entwers. The Mes is develaped in weeky bime perieda. The forecents for esch repleniahment arder quantity a 2000 unita fer the atondard reedol and 1000 unita fer the delure moed. Nete that you can gince multiale arderx it deluxe medell. Rememberthat total weekly groduction ix limited be 2000 cerkxerwwz. Develez an kers for wech efthe preduetr