19. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don't forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optimal production quantity in month 1? A B C D E F G H I Multiperiod production model 2 3 Input data 4 Initial inventory 5000 5 Holding cost as %% of prod cost 5% 7 Month Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 8 Production cost/unit $12.50 $12.55 $12.70 $12.80 $12.85 $12.95 9 10 Production plan 11 Month 2 3 5 6 12 Units produced 13 14 Production capacity 30000 30000 30000 30000 30000 30000 15 16 On hand after production 17 18 Demand 10000 15000 30000 35000 25000 10000 19 20 Ending inventory 21 22 Storage capacity 10000 10000 10000 10000 10000 10000 23 24 Summary of costs 25 Month Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Totals 26 Production costs 27 Holding costs 28 Totals 29 30