Summer Sports Camp

1304 WordsJan 27, 20136 Pages
Using Excel, please help with the following: 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 field and facilities. At the end of the 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…show more content…
This number must be equal to or greater than the number of sheets that will be used during this week. Let’s define a variable that represents the number of clean sheets at the beginning of any week (call it “Clean”). Clearly, the number of clean sheets at the beginning of week 1 is the number of sheets purchased on week 1:[pic]. The number of clean sheets at the beginning of week 2 will simply be the number sheets purchased on week 1 minus the amount used on week 1, plus the number of sheets just purchased (on week 2): [pic] The number of clean sheets at the beginning of week 3 will be equal to the number of clean sheets on week 2, minus the ones that were used during week 2, plus the number that were just purchased (on week 3), plus 80% of the sheets sent to the laundry at the beginning of week 2 (since they took a week to clean them): [pic] Similarly, for week 4: [pic] (Notice that we now also receive 80% of the sheets we sent to Mary’s friends on week 2). The following variables are defined analogously to the one in week 4. These are shown in the “Clean sheets available” column in the Excel file. The constraint on these variables is that the number of clean sheets must be equal to or greater than the number of sheets that will be needed. For
Open Document