Preview

Summer Sports Camp

Good Essays
Open Document
Open Document
1315 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Summer Sports Camp
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 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 local laundry has indicated that it will clean a set of sheets for $4. Also, a couple of Mary’s 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, Mary’s friends can only deliver cleaned sheets in two 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 that have registered during each of the eight weeks the camp will operate. Based on discussions with camp administrators from previous summers and on some old camp records and receipts, 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 stain will

You May Also Find These Documents Helpful

  • Good Essays

    We recommend purchasing at least 0.95 beds; since we cannot have a 0.95 bed, we conclude 1 bed is required at a cost of 26,000*1=26,000. A graph of the probability follows, on Graph II.…

    • 651 Words
    • 3 Pages
    Good Essays
  • Good Essays

    ECO 550 FINAL EXAM

    • 1177 Words
    • 4 Pages

    4. The production manager for Beer etc. produces 2 kinds of beer: light (L) and dark (D). Two resources used to produce beer are malt and wheat. He can obtain at most 4800 oz of malt per week and at most 3200 oz of wheat per week respectively. Each bottle of light beer requires 12 oz of malt and 4 oz of wheat, while a bottle of dark beer uses 8 oz of malt and 8 oz of wheat. Profits for light beer are $2 per bottle, and profits for dark beer are $1 per bottle. If the production manager decides to produce of 0 bottles of light beer and 400 bottles of dark beer, it will result in slack of…

    • 1177 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Mat540 Assignment 3

    • 418 Words
    • 2 Pages

    Do an analysis of the profit solution and what impact it has on Julia’s ability to have sufficient funds for the next home game to purchase and prepare the food. What would you recommend to Julia?…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A bakery buys sugar in 15-pound bags. The bakery uses 5000 bags of sugar each year. Carrying costs are $20 per bag per year. Ordering costs are estimated at $5 per order. Assume that the bakery is open 250 days a year and its daily demand is estimated at 20 bags. It takes 5 days for each order of sugar to be filled.…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays
  • Good Essays

    Sport Trends in the Ymca

    • 934 Words
    • 4 Pages

    There are multiple ways that recent trends in the sport industry are affecting the YMCA. A majority of them would be revolving around the economy and how the YMCA is considered a luxury to the people. Others would be the increase of fitness in the world and sport curiosity and also the elderly still maintaining their healthy lifestyles. The increased popularity of celebrity athletes in the world are leading to an increased popularity in the sport world (Balmer, 2009). The battle against obesity is increasing the number of people who join a fitness club or health organization. Also, many people are beginning to try to find both healthier lifestyles and seeking a balance between work and leisure (Sports, 2007). Lastly, the way that kids are being taught is changing; practices are becoming known as best practices and the kids are learning more of the sport and becoming better (Stephens, 2009).…

    • 934 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Bootcamp for Boys

    • 1077 Words
    • 5 Pages

    Preview: Most of us probably have not heard much about this program just like I didn’t. But after I did some research on the place I found that I was a lot more comfortable that my son would be going there.…

    • 1077 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Summer Assighnment

    • 986 Words
    • 4 Pages

    "He don’t have to go," Miss Emma said for about the hundredth time. – page 17…

    • 986 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Given the information in Problem 25-3, calculate the dry cleaner’s marginal revenue and marginal cost at each output level. Based on marginal analysis, what is the profit-maximizing level of output?…

    • 1004 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Green Mountain Camp

    • 531 Words
    • 3 Pages

    Nick and Carol Randall had a dream for themselves and their two sons: to live at summer camp, re-creating their own memories of swimming in a lake, hiking the mountains, and laughing around the campfire every evening. So, when Green Mountain Camp in Vermont went up for sale, they scraped together their savings and bought the property and the business. Soon they learned why the camp was for sale: the cabins were run down, the kitchen was below health standards, and the dock was falling into the lake. But as they assessed the situation, adding up the repairs necessary to open for a summer session of school-age boys, they realized they had an even more serious problem: a lack of employees. When they bought the camp, the previous owners were vague about the commitment of camp staff from year to year; when the Randalls tried to contact both the camp chef and head counselor, neither answered phone calls or e-mails.…

    • 531 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Youth Sports

    • 1757 Words
    • 8 Pages

    D1. Discuss how social and economic conditions have affected the emergence, growth, and current state of youth and college sports in the United States.…

    • 1757 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    Middle School Recess

    • 208 Words
    • 1 Page

    Do you think that middle schoolers should have time for recess? I don’t think that middle schools should have a set time for recess. Recess is for little kids not almost adults.…

    • 208 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    High School Sports

    • 614 Words
    • 3 Pages

    When in high school, one of the most memorable things to do is go to the games, attend homecoming, or the pep rallies every semester. One thing they all have in common is that they are tied to sports. High school sports are an important part of children's lives whether they are the ones attending the game or the one playing in it. A few years ago, Solano County tried to cut sports programs because there was no room in the budget for it. The community reacted by spending their whole summer raising money in any way they could by selling things to standing outside of the mall collecting donations with the fire department. High school sports programs are important and should not be on the list of school cuts.…

    • 614 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Training Camp

    • 295 Words
    • 2 Pages

    The team that held a news conference with more than 80 media-credentialed reporters for the arrival of their backup quarterback in March? The one that green-lit ESPN coming down for an entire week of training camp in August?…

    • 295 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    1415983562

    • 647 Words
    • 2 Pages

    1-14 : Gina Fox has started her own company, Foxy Shirts, which manufactures imprinted shirts for special occasions. Since she has just begun this operation, she rents the equipment from a local printing shop when necessary. The cost of using the equipment is $350. The materials used in one shirt cost $8, and Gina can sell these for $15 each. (a) If Gina sells 20 shirts, what will her total revenue be? What will her total variable cost be? (b) How many shirts must Gina sell to break even? What is the total revenue for this? 1-15 : Ray Bond sells handcrafted yard decorations at county fairs. The variable cost to make these is $20 each, and he sells them for $50. The cost to rent a booth at the fair is $150. How many of these must Ray sell to break even? 1-16 : Ray Bond, from Problem 1-15, is trying to find a new supplier that will reduce his variable cost of production to $15 per unit. If he was able to succeed in reducing this cost, what would the break-even point be? 1-17 : Katherine D’Ann is planning to finance her college education by selling programs at the football games for State University. There is a fixed cost of $400 for printing these programs, and the variable cost is $3. There is also a $1,000 fee that is paid to the university for the right to sell these programs. IF Katherine was able to sell programs for $5 each, how many would she have to sell in order to break even? 1-18 : Katherine D’Ann, from Problem 1-17, has become concerned that sales may fall, as the team is on a terrible losing streak, and attendance has fallen off. In fact, Katherine believes that she will sell only 500 programs for the next game. If it was possible to raise the selling price of the program and still sell 500, what would the price have to be for Katherine to break even by selling 500? 1-19 : Farris Billiard Supply sells all types of billiard equipment, and is considering manufacturing their own brand of pool cues. Mysti Farris, the production…

    • 647 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Katherine D’ Ann is planning to finance her college education by selling programs at the football games for State University. There is a fixed cost of $400 for printing these programs, and the variable cost is $3. There is also a $1,000 fee that is paid to the university for the right to sell these programs. If Katherine was able to sell programs for $5 each, how many would she have to sell in order to break even?…

    • 702 Words
    • 5 Pages
    Satisfactory Essays

Related Topics