Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Business Start Up Project Business Type Lemonade Stand Location Mall Business Opening Date April 1 st Hours of Operation 10am 9pm Monday through Saturday, 12pm

Business Start Up Project

Business Type

Lemonade Stand

Location

Mall

Business Opening Date

April 1st

Hours of Operation

  • 10am 9pm Monday through Saturday, 12pm 6pm on Sundays.
  • Closed on Thanksgiving, Christmas, and New Years Day.

Weekly Mall Traffic

100,00 patrons, including children

Market Analysis

  • Stand location can sell 15 -25 cups of lemonade per hour, initially you estimate your stand can sell 20 cups per hour.
  • Each cup holds 12 fluid ounces and will be filled with 10 ounces of lemonade

Accepted Form of Payment

ALL SALES WILL BE CASH

Monthly Rent

  • $4500 plus 3.5% of total sales
  • Rent includes all utilities (water, gas, electric), garbage collection, custodial services, mall security, and liability insurance.
  • Rental agreement is month-to-month, must be personally guaranteed.
  • One-month deposit of $4,500 is required

Material Purchases

All material purchases will be paid for in cash; no trade credit will be used.

  • Current cost of lemons is $0.28 per lemon. A cup of lemonade requires 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.

Employees

  • 2 attendants at the stand from 9:30 am 10:30 pm Monday through Saturday. 1 additional attendant after 3 pm
  • 3 attendants on Sundays from 11:30 am 7:30 pm
  • One of the attendants will be a supervisor, a supervisor must 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, you would like to take a salary of $80,000 per year (including benefits)

Hourly Rate (attendants)

minimum wage in Ohio ($8.70 per hour) plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs)

Hourly Rate (supervisor)

$21.00 per hour (this already includes benefits). The supervisors salary is for an employee other than yourself.

Capital Equipment Cost

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.

  1. Starting (opening) Balance Sheet (time zero)
    1. Create a Balance Sheet showing starting Assets, Liabilities, and Shareholder's Equity. The assets will include cash, equipment, inventory, etc. The long-term liabilities will include the bank loan.
    2. The shareholder's equity will include starting capital which must be sufficient to purchase starting inventory, pay employees and rent for the first 2 months, pay the $4500 rental deposit, pay $50,000 for the equipment, and make payments on the equipment loan for the first year.
    3. The equity is your cash investment in the business and may come from your personal savings, personal investments, from your family and friends, a second mortgage on your home, or your kids' piggy banks. It may also partially come from a partner or partners. The cash investment will be shown as Shareholder's Equity on the Balance Sheet. Some of this cash will be spent on equipment ($50,000), starting inventory, rent deposit ($4500), et The remainder will appear as cash on hand on the Balance Sheet to help cover the monthly expenses going forward.
  2. Projected Income Statement for First Month and End of Year 1
    1. Based on your sales estimates, calculate the cost of operating the business for the first month and then for the first 12 months of operation including materials costs, labor, accessories (straws and napkins), rent payments, interest payments, and depreciation. Note: Estimated sales are cyclical. For example, you will need to estimate a higher sales volume (greater than 20 cups per hour) during the summer season, etc. You must provide your monthly sales estimates.
    2. You will need to calculate the direct materials costs to make one cup of lemonade. Make sure to include the costs for the cup, lid, straw, and napkins.
    3. Based on the above calculated cost and the initial sales estimates, establish a projected selling price per cup with a minimum 20% profit.
    4. Prepare a Projected Income Statement for the first month of operations. Then, prepare a Pro Forma Income Statement as of the close of year 1.
  3. Cash Flow Analysis
    1. 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.
  4. Projected Balance Sheet for First Month of Operations and End of Year 1
    1. Calculate a projected Balance Sheet at the close of month 1 using the starting Balance Sheet, the Projected Income Statement data, and the Cash Flow Analysis. Then prepare a projected Balance Sheet as of the close of year 1.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Cost Accounting

Authors: J.K. Mitra

1st Edition

8122425941, 978-8122425949

More Books

Students also viewed these Accounting questions