Multiperiod production model \begin{tabular}{lr} Input data \\ Initial inventory \\ Holding cost as % of prod cost & 5000 \\ \end{tabular} \begin{tabular}{|l|c|c|c|c|c|c|} \hline Month & Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month 6 \\ \hline Production cost/unit & $12.50 & $12.55 & $12.70 & $12.80 & $12.85 & $12.95 \\ \hline \end{tabular} \begin{tabular}{l} Production plan \\ Month \\ \hline \end{tabular} Units produced Production capacity 6 On hand after production 8 Demand Ending inventory Storage capacity 4 Summary of costs 5 Month Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Totals 6 Production costs 7 Holding costs 8 Totals Using the given data file P13-22 xdsx, modity the Pigskin spreadsheet model so that except for month 6 , demand does not have to be met on time. The only requirement i that aft demand must be met eventually by the end of month 6 , How does this change the optimal production schedule? Round your answers to nearest whole number, How does it change the optimal rotal cost? Round your answers to two decimal places. The total cost is elinghth thon for the onginat model, with totat savings of $ 8, because of the flexibulity to have a shortage for month Multiperiod production model Input data Initial inventory Holding cost as % of prod cost 5000 Month Production cost/unit. \begin{tabular}{|c|c|c|c|c|c|} \hline Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month 6 \\ \hline$12.50 & $12.55 & $12.70 & $12.80 & $12.85 & $12.95 \\ \hline \end{tabular} Production plan Month 1 2 4 5 6 Units produced Production capacity 30000 30000 30000 30000 30000 30000 6 On hand after production Demand 10000 15000 3000035000 2500010000 Ending inventory Storage capacity 10000 10000 10000 10000 10000 10000 Summary of costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Totals Month Production costs Holding costs Totals Model