Case 1: Linear ProgrammingCase: Summer Sports Camp at State University (p. 179) o Help Mary formulate a linear programming model for this problem and solve the formulated linear programming model. Summer Sports Camp at State University Mary Kelly is a scholarship soccer player at State Univer- sity. During the summer, she works at a youth all-sports camp that several of the universitys coaches operate. The sports camp runs for 8 weeks during July and August. Campers come for a 1-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 primarily serves 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. Clean sheets are needed at the beginning of each week, and the campers use the sheets all week. At the end of the week, the campers strip their beds and place the sheets in large bins. Mary must arrange either to purchase new sheets or to clean old sheets. A set of new sheets costs $10. A lo- cal laundry has indicated that it will clean a set of sheets for $4. Also, a couple of Marys friends have asked her to let them clean some of the sheets. They have told her they will charge only $2 for each set of sheets they clean. However, while the laundry will provide cleaned sheets in a week, Marys friends can deliver cleaned sheets only in 2 weeks. They are going to summer school and plan to launder the sheets at night at a neighborhood Laundromat. The accompanying table lists the number of campers who have registered during each of the 8 weeks the camp will op- erate. Based on discussions with camp administrators from previous summers and on some old camp records and re- ceipts, Mary estimates that each week about 20% of the cleaned sheets that are returned will have to be discarded and replaced. The campers spill food and drinks on the sheets,and sometimes the stains do not come out during cleaning. Also, the campers occasionally tear the sheets,or the sheets get torn at the cleaners. In either case, when the sheets come back from the cleaners and are put on the beds,20% are taken off and thrown away. At the beginning of the summer,the camp has no sheets available, so initially sheets must be purchased. Sheets are thrown away at the end of the summer.

Week Registered Campers

1 115

2 210

3 250

4 230

5 260

6 300

7 250

8 190

Marys major at State is management science, and she wants to develop a plan for purchasing and cleaning sheets by using linear programming. Help Mary formulate a lin- ear programming model for this problem and solve it by using the computer. ? Submit your response in a Microsoft Excel workbook if you choose Case 1 or 2. If you choose Case 3 or 4, submit your response in a Microsoft Word document of the following specifications: ? Font: Arial; Point 12 ? Spacing: Double ? Length: 400 words ? Provide an explanation for each problem that represents a thorough and critically analyzed response? ? Show all your calculations to justify your answer. ? Cite references, if any, in proper APA format. For help, refer to the ITT Tech Virtual Library>School of Study>General Education Information> Recommended links>Grammar, Writing, and Style> APA Formatting and Style