please use Excel and answer the questions as well please

Case Study-2: Wichita State University (WSU) Summer Sports Camp Harriet is a scholarship soccer player at WSU. During the summer, she works at a youth all-sports camp that several of the university's coaches operate. The sports camp runs for 8 weeks during July and August. Campers come for a l-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. Harriet 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. Harriet 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. Harriet must arrange either to purchase new sheets or to clean old sheets. A set of new sheets costs $15. A local laundry has indicated that it will clean a set of sheets for $5. Also, a couple of Harriet's friends have asked her to let them clean some of the sheets. They have told her they will charge only S3 for each set of sheets they clean. However, while the laundry will provide cleaned sheets in a week, Harriet's 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 operate. Based on discussions with camp administrators from previous summers and on some old camp records and receipts, Harriet estimates that each week about 25% of the cleaned sheets that are retumed 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, 25% are taken off immediately, thrown away, and replaced 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 # Campers 1 2 3 4 5 6 7 8 liv 122 205 230 245 260 280 250 210 Table: Campers Each Week Page 2 of 2 Harriet's major at State is management science, and she wants to develop a plan for purchasing and cleaning sheets by using linear programming. Assume continuous decision variables. a. Formulate a linear programming model for this problem and solve it by using the computer. b. What is the total number sheets that were bought? c. How many sheets were sent out to the laundry and how many to her friends? How do these vary over the 8 weeks? d. Identify the sensitivity range for the right-hand constraint of week 8. What is the cost in linen for each additional camper in week 8? Evaluate e, f, and g individually and compare to the original solution in part a. Which of the three changes has the most impact on the decision variables and total cost? e. What will be the optimal solution if the set of new sheets cost $20? f. What will be the optimal solution if the local laundry will clean a set of sheets for $10? g. What will be the optimal solution if the Harriet's friends clean the sheets for $5? h. What would be the optimal solution if all of the above (c., f., and g.) financial changes were made? How does it compare to the original solution found in part a? i. Due to some delay in game schedule, the sports committee is considering adding one more week to the sports camp schedule i.e., week 9. The number of registered campers in that week is estimated to be 300. How much will this add to the total cost of purchasing and laundering linens? For each the following questions revert back to the original formulation in part a. j. The local Motel 6-Ten is willing to buy left over sheets at the end of the season for $5 apiece. What impact, if any, will this have on the optimal values of the decision variables? How many sheets were bought in total over the 8 weeks? What is the total number of sheets that were sold to Motel 6-10? k What is the minimum amount that Motel 6-Ten would have to pay in order for some of the optimal decision values to change from the solution values in part a? Case Study-2: Wichita State University (WSU) Summer Sports Camp Harriet is a scholarship soccer player at WSU. During the summer, she works at a youth all-sports camp that several of the university's coaches operate. The sports camp runs for 8 weeks during July and August. Campers come for a l-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. Harriet 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. Harriet 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. Harriet must arrange either to purchase new sheets or to clean old sheets. A set of new sheets costs $15. A local laundry has indicated that it will clean a set of sheets for $5. Also, a couple of Harriet's friends have asked her to let them clean some of the sheets. They have told her they will charge only S3 for each set of sheets they clean. However, while the laundry will provide cleaned sheets in a week, Harriet's 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 operate. Based on discussions with camp administrators from previous summers and on some old camp records and receipts, Harriet estimates that each week about 25% of the cleaned sheets that are retumed 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, 25% are taken off immediately, thrown away, and replaced 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 # Campers 1 2 3 4 5 6 7 8 liv 122 205 230 245 260 280 250 210 Table: Campers Each Week Page 2 of 2 Harriet's major at State is management science, and she wants to develop a plan for purchasing and cleaning sheets by using linear programming. Assume continuous decision variables. a. Formulate a linear programming model for this problem and solve it by using the computer. b. What is the total number sheets that were bought? c. How many sheets were sent out to the laundry and how many to her friends? How do these vary over the 8 weeks? d. Identify the sensitivity range for the right-hand constraint of week 8. What is the cost in linen for each additional camper in week 8? Evaluate e, f, and g individually and compare to the original solution in part a. Which of the three changes has the most impact on the decision variables and total cost? e. What will be the optimal solution if the set of new sheets cost $20? f. What will be the optimal solution if the local laundry will clean a set of sheets for $10? g. What will be the optimal solution if the Harriet's friends clean the sheets for $5? h. What would be the optimal solution if all of the above (c., f., and g.) financial changes were made? How does it compare to the original solution found in part a? i. Due to some delay in game schedule, the sports committee is considering adding one more week to the sports camp schedule i.e., week 9. The number of registered campers in that week is estimated to be 300. How much will this add to the total cost of purchasing and laundering linens? For each the following questions revert back to the original formulation in part a. j. The local Motel 6-Ten is willing to buy left over sheets at the end of the season for $5 apiece. What impact, if any, will this have on the optimal values of the decision variables? How many sheets were bought in total over the 8 weeks? What is the total number of sheets that were sold to Motel 6-10? k What is the minimum amount that Motel 6-Ten would have to pay in order for some of the optimal decision values to change from the solution values in part a