Mary’s major at State is operations management, and she wants to develop a plan for purchasing and cleaning sheets using linear programming. Help Mary formulate a linear programming model for this problem, and solve it using Excel.

Mary Kelly is a scholarship soccer player at State University. During the summer she works at a youth all-sports camp that several of the university’s coaches operate. The sports camp runs for eight weeks during July and August. Campers come for a one-week period, during which time they live in the State dormitories and use the State athletic fields and facilities. At the end of a week a new group of kids comes in. Mary serves primarily as one of the camp soccer instructors. However, she has also been placed in charge of arranging for sheets for the beds the campers will sleep on in the dormitories. Mary has been instructed to develop a plan for purchasing and cleaning sheets each week of camp at the lowest possible cost.