Docstoc

lemonade (Excel)

Document Sample
lemonade (Excel) Powered By Docstoc
					Lemonade stand revenue at corner of Post and Oak

Inputs                                       Avg      Min     Max    Format

Number of cars that drive by                 1000       0     5000   Amount
Cars that stop to ask about lemonade         50%      0.00%   100%   Percent
Visitors that purchase                       50%      0.00%   100%   Percent
Time lemonade stand is open                    4        1      12     Hours
Price of Lemonade                           $1.50     $0.10    $5    Currency

Outputs

Total Sales                                  1000                    Amount
Total Lemonade Revenue                    $1,500.00                  Currency
How Often

 Hourly


  Daily




  Daily
  Daily
Savings Associated with Installation of Super Savertron

Category                                Inputs

Current process                         Number of employees needed
Current process                         Activities employees are required to perform
Current process                         Time Required per Activity
Current process                         Avg Salary per Employee

New process w/ Super Savertron          Number of employees needed
Current process                         Activities employees are required to perform
New process w/ Super Savertron          Time Required per Activity

Cost of Super Savertron                 Initial Cost
Cost of Super Savertron                 Annual Cost

                                        Outputs

                                        Year 1 Savings
                                        Savings over 3 Years

Calculation Variables Hidden from the User
Current Process                         Total Hours needed per month
                                        hours needed per year
                                        Dollars per hour per employee
                                        Cost per year

New process                             Total Hours needed per month
                                        hours needed per year
                                        Dollars per hour per employee
                                        Cost per year

new process                             year 1 cost
new process                             total annual cost
                                        3 year cost
   Avg          Min         Max        Format     How Often

    10          1        5000          Amount
     5          1         100          Amount      Monthly
     2        0.25         10           Hours
$50,000.00 $20,000.00 $100,000.00      Currency     Yearly

    5           1           5000       Amount
    2           1            100       Amount      Monthly
   0.5         0.25          10         Hours

$10,000.00    $500.00    $100,000.00   Currency
$2,500.00    $1,500.00   $50,000.00    Currency     Yearly




$10,300.00                             Currency     Daily
$50,900.00                             Currency     Daily


    100
   1200
  $20.00                 3 year cost
$24,000.00               $72,000.00

    5
    60
 $20.00
$1,200.00

$13,700.00
$3,700.00
$21,100.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:10/27/2011
language:English
pages:4