Docstoc

Picnic - Excel

Document Sample
Picnic - Excel Powered By Docstoc
					             A                  B        C          D             E                F            G
 1   Company Picnic
 2
 3   Fixed Cost Expenses                                                 Attendance
 4   Item                   Unit Cost Quantity Total Cost                # Employees             250
 5   Park Rental            $ 50.00           1 $    50.00               Avg. Family Size          2
 6   Entertainment-clowns   $ 50.00           2 $ 100.00                 Potential Attendance    500
 7   Administration         $ 43.00           1 $    43.00               % attending            60%
 8   Total                                      $ 193.00                 Est. Attendance         300
 9
10   Variable Cost Exp.
11   Item                   Unit Cost Quantity Total Cost
12   Food                   $    3.05      300 $ 915.00




C:\Docstoc\Working\pdf\2cebbb2f-ade2-4c85-b985-997b8b64de20.xls       Picnic                           8/18/2012
             A                  B        C            D           E                 F               G         H             I
 1   Company Picnic
 2
 3   Fixed Cost Expenses                                                  Attendance
 4   Item                   Unit Cost Quantity Total Cost                 # Employees                  250
 5   Park Rental            $ 50.00           1 $    50.00                Avg. Family Size               2
 6   Entertainment-clowns   $ 50.00           2 $ 100.00                  Potential Attendance         500
 7   Administration         $ 43.00           1 $    43.00                % attending                 60%
 8   Total                                      $ 193.00                  Est. Attendance              300
 9
10   Variable Cost Exp.                                                   Revenues               Unit Rev. Quantity Total Revenue
11   Item                   Unit Cost Quantity   Total Cost               Tickets                $    6.00      300 $      1,800.00
12   Food                   $    3.05      300    $ 915.00
13   Beveridges             $    2.00      300    $ 600.00                Profit (Loss)          $ 17.00
14   Cutlery                $    0.25      300    $    75.00
15   Total                                        $ 1,590.00
16
17   Expenses Grand Total                        $ 1,783.00
18   Avg. Exp. Per Person                        $     5.94




C:\Docstoc\Working\pdf\2cebbb2f-ade2-4c85-b985-997b8b64de20.xls       Picnic2                                                         8/18/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:20
posted:8/17/2012
language:
pages:2