Question: table [ [ table [ [ Period ] , [ ( Month ) ] ] , table [ [ Demand ] ,

\table[[\table[[Period],[(Month)]],\table[[Demand],[(in units)]],\table[[Setup Cost],[(in $/batch)]],\table[[Production cost],[(in $? unit)]],(in $/unit/month)],[1,10,60,2.5,0.6],[2,5,70,3,0.8],[3,15,50,2.6,0.7],[4,15,80,3.0,0.9]]
a. Use dynamic programming to find the optimal policy and minimum total cost (use backward recursion).(pdf file)
b. Find the optimal policy by using dynamic programming in EXCEL (Hint: It is very similar to the shortest path DP Excel solution. But you need to find a way to adid costs).
Q3) Consider that in the previous question, the company's production and storage capacity is at most 6 and 4 batches, respectively.
a. Use dynamic programming to find the optimal policy and minimum total cost (use forward recursion).(pdf file)
b. Find the optimal policy by using dynamic programming in EXCEL.
can u please solve question 3?
 \table[[\table[[Period],[(Month)]],\table[[Demand],[(in units)]],\table[[Setup Cost],[(in $/batch)]],\table[[Production cost],[(in $? unit)]],(in $/unit/month)],[1,10,60,2.5,0.6],[2,5,70,3,0.8],[3,15,50,2.6,0.7],[4,15,80,3.0,0.9]] a. Use dynamic

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!