Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 &

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance

Authors: Laurence S. Seidman

1st Edition

0073375748, 978-0073375748

More Books

Students also viewed these Finance questions