Modify the Pigskin model so that there are 8 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?

AutoSave On . Kyndel Babin Assignment 5 (Product Mi... - Saved Search Kyndel Babin KB X File Home Insert Page Layout Formulas Data Review View Help Share Comments Queries & Connections Data Analysis Le la Refresh Properties ? Solver Get Stocks Currencies Sort Filter Reapply Text to CV What-If Forecast Outline Data All Edit Links Advanced Columns COBB Analysis Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Analyze P28 X V B D E F G H M N P Q R S U V W X Multiperiod production model IN 3 Input data 4 Initial inventory 5000 Holding cost as % of prod cost 5% 6 7 Month Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Production cost/unit 12.50 $12.55 $12.70 $12.80 $12.85 $12.95 9 10 Production plan 11 Month 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 31 Question 2 (Product mix 1) Question 11 (Product mix 2) Question 19 (Production plan) + + Type here to search O N W P X 1:51 PM 4/17/2021 13