Question: Please write down constrains and solve it by excel solver Sanders Fishing Supply of Naples, Florida, Manufactures a variety of fishing equipment, which it sells

Please write down constrains and solve it by excel solver
Sanders Fishing Supply of Naples, Florida, Manufactures a variety of fishing equipment, which it sells throughout the United States, For the next three months, Sanders estimate demand for a particular product at 115.125, and 155 units, respectively. Sunders can supply this demand by products on regular time or overtime Because of other commitments and anticipated cost increase in month3, the production capacities in units and the production costs per unit are as follows: Production Monthl-regular Month1 - Overtime Month2-regular month2-overtime month3-regular month3-overtime Capacity Cost/unit 115 40 135 45 65 145 90 105 90 60 95 105 Inventory may be carried from one month to the next, but the holding cost is $30 per unit month What is the minimal cost of meeting demands in the next three monthsStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
