Premier Paints supplies to major contractors. One of their contracts for specialty paint requires them to supply 750, 500, 400, and 950 gallons over the next 4 months. To produce this paint requires a shutdown and cleaning of one of their manufacturing departments at a cost of SI.000. The entire contract requirement can he produced during the first month in one production run; however, the inventory that must be held until delivery costs S0.75 per gallon per month. If the paint is produced in other months, then the cleaning costs are incurred during each month of production.
How would I solve an integer optimization model using excel to determine the best monthly production schedule to meet delivery contracts and minimize total costs.