Your task is to design a spreadsheet that provides detailed information on monthly production, inventory, lost sales, and the different cost categories and solve a linear optimization model for minimizing the total cost of meeting demand over the next year. Compare your solution with the level production strategy of producing 9,100 units each month. Interpret the Sensitivity report, and conduct an appropriate study of how the solution will be affected by changing the assumption of the lost sales costs. Summarize all your results in a report to Ms. Burke.

Juanita and sam attend a beach party and notice that the local beach appears to have a great deal more trash washed up on shore than it did when they were young. the water doesn't appear nearly as clear, and there seems to be less evidence of small water creatures living in the shallows. an afternoon at the local library convinces them that one major cause is the new factory nearby. after some discussion, they decide their next step should be identifying the cause of the changes identifying the problem picketing the guilty factory lobbying their elected representatives to complain about the problem talking to a local environmental group about solutions