You are starting a fresh, made to order, lemonade stand at the mall. Your stand is set to open on April 1st. The mall is open from 10:00 a.m. to 9:00 p.m. on Monday through Saturday and noon to 6:00 p.m. on Sunday. Assume the mall is closed on Thanksgiving, Christmas, and New Year's Day. The weekly mall traffic is 100,000 patrons, including children. The market research analysis concludes the stand location can sell 15 to 25 cups of lemonade per hour. Initially you estimate your stand can sell an average of 20 cups per hour. Each cup holds 12 fluid ounces and will be filled with 10 ounces of lemonade. All sales will be for cash. The monthly rent for the space at the mall is $4200 plus 3.0% of the total sales. The rent includes all utilities (water, gas, electric), garbage collection, custodial services, mall security, and liability insurance. The rental agreement is month-to-month and must be personally guaranteed. A one-month deposit of $4200 is required. All material purchases will be paid for in cash; no trade credit will be used. - The current cost of lemons is $0.30 per lemon. A cup of lemonade requires two to three lemons. Maximum lemon storage is one week, refrigerated. - The sugar cost is $0.19 per pound for 50 pounds. One cup requires one tablespoon of sugar or 5 grams of sugar per cup. One-pound equals 454 grams. - Cups with lids cost $0.10 each for a quantity of 1000 cups. - Straws cost $0.01 each for a quantity of 5000 straws. - Napkins cost $0.003 each for a quantity of 10,000 napkins. It is anticipated that each customer will utilize at least two napkins. - Bottled water is $1.00 per gallon delivered on site to the lemonade stand. Water must be purchased in a minimum of 50 -gallon increments. There will be two attendants at the stand from 9:30 am to 10:30pm Monday through Saturday. There will be one additional attendant after 3:00 p.m. There will be three attendants on Sunday from 11:30 a.m. to 7:30p.m. One of the attendants will be a supervisor. The supervisor will be present at all hours. You may elect to be the supervisor on site at all hours or part of the hours. You may also elect to have a family member or partner be the supervisor. As the owner of the business, you would like to take a salary of $80,000 per year (including benefits). The hourly rate for each regular attendant is the minimum wage in Ohio plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs). The supervisor rate is $21.00 per hour (this already includes benefits). The supervisor's salary is for an employee other than yourself. - The current cost of lemons is $0.30 per lemon. A cup of lemonade requires two to three lemons. Maximum lemon storage is one week, refrigerated. - The sugar cost is $0.19 per pound for 50 pounds. One cup requires one tablespoon of sugar or 5 grams of sugar per cup. One-pound equals 454 grams. - Cups with lids cost $0.10 each for a quantity of 1000 cups. - Straws cost $0.01 each for a quantity of 5000 straws. - Napkins cost $0.003 each for a quantity of 10,000 napkins. It is anticipated that each customer will utilize at least two napkins. - Bottled water is $1.00 per gallon delivered on site to the lemonade stand. Water must be purchased in a minimum of 50 -gallon increments. There will be two attendants at the stand from 9:30 am to 10:30 pm Monday through Saturday. There will be one additional attendant after 3:00 p.m. There will be three attendants on Sunday from 11:30 a.m. to 7:30 p.m. One of the attendants will be a supervisor. The supervisor will be present at all hours. You may elect to be the supervisor on site at all hours or part of the hours. You may also elect to have a family member or partner be the supervisor. As the owner of the business, you would like to take a salary of $80,000 per year (including benefits). The hourly rate for each regular attendant is the minimum wage in Ohio plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs). The supervisor rate is $21.00 per hour (this already includes benefits). The supervisor's salary is for an employee other than yourself. The cost of the capital equipment for setting up the stand is $250,000 which includes all equipment, counters, signage, refrigerators, ice-machine, and cash register. This equipment can be purchased with $50,000 cash and a bank loan for the remainder. You will need to determine the bank loan terms for the remainder amount- the annual interest and monthly payments for 5 years. You are to assume that the monthly loan payment will be $XXXX amount, broken down as $X interest each month and $X on the loan principal balance. The equipment is to be depreciated on a straight-line basis (no salvage value) over the 7 years of its estimated life. Note: "free" loans where you do not have to make payments for X-years on the loan are not to be used. C. Cash Flow Analysis Calculate cash flows at start-up and then for each month. Cash flow is the most important financial data in a business, especially a start-up. Business happiness is positive cash flow. Note: You must document, report, and explain all of your decisions/calculations. You will submit the Excel sheets along with a written report containing your decisions, how you arrived at the decisions, the input information, and your justification for each of your decisions. Any change or adjustment to the business model must be justified in your write up. There will be separate drop boxes for the Excel sheets and the qualitative write-up. You are starting a fresh, made to order, lemonade stand at the mall. Your stand is set to open on April 1st. The mall is open from 10:00 a.m. to 9:00 p.m. on Monday through Saturday and noon to 6:00 p.m. on Sunday. Assume the mall is closed on Thanksgiving, Christmas, and New Year's Day. The weekly mall traffic is 100,000 patrons, including children. The market research analysis concludes the stand location can sell 15 to 25 cups of lemonade per hour. Initially you estimate your stand can sell an average of 20 cups per hour. Each cup holds 12 fluid ounces and will be filled with 10 ounces of lemonade. All sales will be for cash. The monthly rent for the space at the mall is $4200 plus 3.0% of the total sales. The rent includes all utilities (water, gas, electric), garbage collection, custodial services, mall security, and liability insurance. The rental agreement is month-to-month and must be personally guaranteed. A one-month deposit of $4200 is required. All material purchases will be paid for in cash; no trade credit will be used. - The current cost of lemons is $0.30 per lemon. A cup of lemonade requires two to three lemons. Maximum lemon storage is one week, refrigerated. - The sugar cost is $0.19 per pound for 50 pounds. One cup requires one tablespoon of sugar or 5 grams of sugar per cup. One-pound equals 454 grams. - Cups with lids cost $0.10 each for a quantity of 1000 cups. - Straws cost $0.01 each for a quantity of 5000 straws. - Napkins cost $0.003 each for a quantity of 10,000 napkins. It is anticipated that each customer will utilize at least two napkins. - Bottled water is $1.00 per gallon delivered on site to the lemonade stand. Water must be purchased in a minimum of 50 -gallon increments. There will be two attendants at the stand from 9:30 am to 10:30pm Monday through Saturday. There will be one additional attendant after 3:00 p.m. There will be three attendants on Sunday from 11:30 a.m. to 7:30p.m. One of the attendants will be a supervisor. The supervisor will be present at all hours. You may elect to be the supervisor on site at all hours or part of the hours. You may also elect to have a family member or partner be the supervisor. As the owner of the business, you would like to take a salary of $80,000 per year (including benefits). The hourly rate for each regular attendant is the minimum wage in Ohio plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs). The supervisor rate is $21.00 per hour (this already includes benefits). The supervisor's salary is for an employee other than yourself. - The current cost of lemons is $0.30 per lemon. A cup of lemonade requires two to three lemons. Maximum lemon storage is one week, refrigerated. - The sugar cost is $0.19 per pound for 50 pounds. One cup requires one tablespoon of sugar or 5 grams of sugar per cup. One-pound equals 454 grams. - Cups with lids cost $0.10 each for a quantity of 1000 cups. - Straws cost $0.01 each for a quantity of 5000 straws. - Napkins cost $0.003 each for a quantity of 10,000 napkins. It is anticipated that each customer will utilize at least two napkins. - Bottled water is $1.00 per gallon delivered on site to the lemonade stand. Water must be purchased in a minimum of 50 -gallon increments. There will be two attendants at the stand from 9:30 am to 10:30 pm Monday through Saturday. There will be one additional attendant after 3:00 p.m. There will be three attendants on Sunday from 11:30 a.m. to 7:30 p.m. One of the attendants will be a supervisor. The supervisor will be present at all hours. You may elect to be the supervisor on site at all hours or part of the hours. You may also elect to have a family member or partner be the supervisor. As the owner of the business, you would like to take a salary of $80,000 per year (including benefits). The hourly rate for each regular attendant is the minimum wage in Ohio plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs). The supervisor rate is $21.00 per hour (this already includes benefits). The supervisor's salary is for an employee other than yourself. The cost of the capital equipment for setting up the stand is $250,000 which includes all equipment, counters, signage, refrigerators, ice-machine, and cash register. This equipment can be purchased with $50,000 cash and a bank loan for the remainder. You will need to determine the bank loan terms for the remainder amount- the annual interest and monthly payments for 5 years. You are to assume that the monthly loan payment will be $XXXX amount, broken down as $X interest each month and $X on the loan principal balance. The equipment is to be depreciated on a straight-line basis (no salvage value) over the 7 years of its estimated life. Note: "free" loans where you do not have to make payments for X-years on the loan are not to be used. C. Cash Flow Analysis Calculate cash flows at start-up and then for each month. Cash flow is the most important financial data in a business, especially a start-up. Business happiness is positive cash flow. Note: You must document, report, and explain all of your decisions/calculations. You will submit the Excel sheets along with a written report containing your decisions, how you arrived at the decisions, the input information, and your justification for each of your decisions. Any change or adjustment to the business model must be justified in your write up. There will be separate drop boxes for the Excel sheets and the qualitative write-up
