Production schedule to meet delivery contracts

Assignment Help Operation Management

Reference no: EM13840624

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.

Reference no: EM13840624

Questions Cloud

Supporting the supply chains performance : What is role of supply chain decisions on the success of a your firm or the firm that you are familiar with? Elaborate your response? Explain how the major drivers of supply chain performance (facilities, inventory, transport, information, sourcing a..

Contrast lamarck and darwins views of evolutionary change : Contrast Lamarck and Darwin's views of evolutionary change

Optimally between orthopedic and rheumatology departments : A practice would like to allocate their resources optimally between the orthopedic and rheumatology departments. The revenues per case generated by orthopedics and by rheumatology are $2,000 and $1,000, respectively.

Performance to change in response to new control systems : Suppose a company at which executives were rewarded for meeting targets based only on profits and stock prices switches to a balanced scorecard that adds measures for customer satisfaction, employee engagement, employee diversity, and ethical conduct..

Production schedule to meet delivery contracts : 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 manufacturi..

Difference between organizational risk and project risk : What is the difference between organizational risk and project risk? Also, give an example of both.

Role modeling in establishing culture of preparedness : How important is role modeling in establishing a culture of preparedness and safety in health organizations? How can we ensure that employees “walk the walk” (follow guidelines) as well as “talk the talk” (advise others to follow guidelines)?

Define critical thinking : Define 'critical thinking. Identify and describe one way in which critical thinking differs from any other way of thinking? That is, identify one specific feature of critical thinking? Also, research Bloom's taxonomy. How does this enhance your knowl..

Enhanced communication-order to produce better results : Why have some organizations not improved their structures, for example, enhanced communication, in order to produce better results?

User Account

All Pages