Question
Coop Mart has received the following demands for a product this year: Month 1 2 3 4 5 6 7 8 9 10 11 12
Coop Mart has received the following demands for a product this year:
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Demand | 300 | 700 | 800 | 900 | 3300 | 200 | 600 | 900 | 200 | 300 | 1000 | 800 |
Suppose ordering cost (OC) is $504 and holding cost (HC) of one unit of product in a year is $3. There is no shortage cost. Backordering is not allowed in this model.
Q1:
Given that the total demand of the whole year is 10,000 products, suppose the company is going to use the EOQ model for the accumulated demand of one year (10,000). In other words, ignore the monthly demand. Compute:
Optimal order quantity (Q*)
Total cost
Frequency of orders
Time between orders
Q2
Use mixed integer linear programming to solve the problem regarding the monthly demand. Suppose that holding cost is applied to the ending inventory.
Develop the mathematical model in the Word document.
Solve the problem in MS Excel
Develop a plan in the Word document and explain when and how many products should be ordered in order to minimise the total cost.
Recalculate the optimal value of objective function (total cost with the new assumption that the holding cost is applied to the average inventory (not ending inventory).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started