# The Entrepreneur of the Year Assignment by yca71986

VIEWS: 13 PAGES: 1

• pg 1
```									The Entrepreneur of the Year Assignment
Scenario
You and your best friend decide to go into business together. You create a
company called New Balloons that offers Hot Air Balloon rides to people. You
and your friend decide that you will need to create a spreadsheet to keep track
of your expenses, revenue (money brought in) and profit.

For each customer you will enter the length (duration) of their trip in hours.
Once that is complete your spreadsheet will calculate the price that will be
charged to the customer (this will be your Revenue). You and your friend
decide to charge \$56 per hour for a flight. You will need to also calculate your
total revenue and your average revenue per trip.

As mentioned above, you need to also use this spreadsheet to calculate your expenses. This is the
amount of money your company pays in order to stay in business. You and your friend determine that
it costs \$20.43 per hour to run the hot air balloon. Your spreadsheet will need to calculate the
expenses per trip, your total expenses, and your average expenses per trip.

Now, for the profit! This is the amount of money you and your friend make after all of the expenses
are paid from the revenue generated. You would like the spreadsheet to show the profit per trip, the
total profit and the average profit.

Use the information below for your customers:

Customer Name                  Duration of Trip (in hrs)
Grouch, Oscar                  5
Bird, Big                      3.5
Evaluation:
Muppet, Elmo                   2.5
Clown, Nemo                    5.25
Mermaid, Ariel                 1.25
Plan
Trash, Wall-e                  3                             Thinking & Inquiry – 10 marks
Vegetation, Eve                4.25
Dwarf, Sneezy                  3.75                          Performing of Tasks
Mutt, Tramp                    4                             Application - 20 marks
Lion, Simba                    2
Lion, Mufasa                   3.5
Overall Design, Data Entry, etc.
Pan, Peter                     0.5
Darling, Wendy                 1.5
Communication – 10 marks
Happy-Feet, Mumble             4.75
Curious, George                7.5

Tips:
   Use everything that has been shown to you in this unit. (sorting, graphs, both reference types,
etc.)
    Format appropriate numbers to currency (\$.00)
    Make it attractive, add colour, an image, word art … however, remember we only have a black
and white printer (maintain professionalism and aesthetics).
    Try using the header and footer as well.
    Printouts must fit on one page (landscape, margins)

Due Date: Thursday, May 21st (end of day)
Submit three printouts – one regular, one with formulas, one full page of chart

```
To top