Question
A company produces a certain product and has the capacity to produce 100 units per month in regular time, and an additional 15 units per
A company produces a certain product and has the capacity to produce 100 units per month in regular time, and an additional 15 units per month in overtime. The production cost of the product varies by month due to changes in the material costs over time. The quantities of the product to be delivered over the next six months have already been set. The delivery requirements and production costs are given in the following table
Month 1 2 3 4 5 6
Quantities to be delivered (units) 95 85 110 115 90 100
Production cost per unit in regular time (rands) 180 180 192 192 186 192
Production cost per unit in overtime (rands) 210 210 222 222 216 222
It is possible that the units produced in a month exceeds the delivery requirement.
In such a case, the unsold units are then carried in stock to the following month. The cost of carrying an unsold unit in stock is R12 per unit per month. At the beginning of month 1 there are no units in stock and the company does not want to have any unsold units at the end of month 6. The company must determine the number of units of the product to produce in regular time and in overtime each month to meet the delivery requirement at minimum cost.
(a) Define the decision variables that will be needed to formulate a linear programming (LP) model for this problem. (10 marks)
(b) Formulate the Linear Programming (LP) model that represents this problem. (30 marks)
(c) Solve the LP model using SOLVER. (20 marks)
(d) Interpret your SOLVER solution within the context of the original business problem (20 marks)
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