Catering Function Worksheet - Excel by emj68678

VIEWS: 0 PAGES: 10

More Info
									       Catering Event Profitability Worksheet

       Instructions:

           1) Open a the workbook and from the "File" menu select the "Save As" option,
              renaming the workbook with the current catering/banquet function you're
              working on.

           2) Fill in all the cells, as appropriate, on each of the worksheet tabs (note: this
              workbook has a total of six different tabs). The "Summary" tab will show the
              total revenue, expense and profitability you can expect to derive from the
              event.




783cd313-28b5-4862-b8cc-acf46e428c55.xls
                                           Catering / Event Worksheet
                                                Profitability Analysis


PREPARED BY:
DATE:
EVENT NAME:                                                      EVENT DATE:
EVENT TIME:                                                       SETUP TIME:
                                                                                 If exempt, letter
CLIENT NAME:                                                     TAX STATUS:         received?

PHONE NUMBER:                                                        # GUESTS:
BILLING ADDRESS:
CONTACT NAME:
ALT. CONTACT:
TYPE OF EVENT:
(Describe Event Details)




    783cd313-28b5-4862-b8cc-acf46e428c55.xls
** PRODUCT COST **
** HORS D'OEURVES/COLD DISPLAYS/STATIONS **
                       # PER               EST.    SERVING
       DESCRIPTION             # GUESTS                        EST. COST
                      PERSON             SERVINGS    COST
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
                             0         0         0     $0.00   $     -
ESTIMATED HORS D'OEURVES/COLD DISPLAYS/STATIONS COST           $     -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
783cd313-28b5-4862-b8cc-acf46e428c55.xls
** DESSERTS **
                       # PER               EST.      SERVING
       DESCRIPTION             # GUESTS                          EST. COST
                      PERSON             SERVINGS     COST
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
                             0         0         0       $0.00   $     -
ESTIMATED DESSERTS COST                                          $     -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
** NON-ALCOHOLIC BEVERAGES **
                       # PER               EST.                      SERVING
       DESCRIPTION             # GUESTS                                          EST. COST
                     PERSON              SERVINGS                     COST
Drinks                       0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
                             0         0         0                       $0.00   $     -
ESTIMATED NON-ALCOHOLIC BEVERAGE COST                                            $     -

** ALCOHOLIC BEVERAGES **
                                       # PER               EST.      SERVING
       DESCRIPTION                             # GUESTS                          EST. COST
                                      PERSON             SERVINGS     COST
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
                                             0         0         0       $0.00   $     -
ESTIMATED ALCOHOLIC BEVERAGE COST                                                $     -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
** MISCELLANEOUS ** (Include Bread Service Cost)
                      # PER               EST.      SERVING
       DESCRIPTION            # GUESTS                          EST. COST
                     PERSON             SERVINGS     COST
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
                            0         0         0       $0.00   $     -
ESTIMATED MISCELLANEOUS COST                                    $     -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
** EQUIPMENT **
                                               IN     RENT OR   UNIT
   DESCRIPTION                QUANTITY                                        COST
                                             STOCK   PURCHASE   COST
Tables                                                            $0.00   $          -
Chairs                                                            $0.00   $          -
Beverage Dispensers                                               $0.00   $          -
Punch Bowls                                                       $0.00   $          -
Coffee Maker                                                      $0.00   $          -
Carving Knives                                                    $0.00   $          -
Serving Utensils                                                  $0.00   $          -
Serving Trays                                                     $0.00   $          -
Linen                                                             $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
                                                                  $0.00   $          -
ESTIMATED EQUIPMENT COST                                                  $          -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
** STAFFING **
                                             POSITION /    EST.            DIRECT
   EMPLOYEE NAME                                                  RATE
                                             FUNCTION     HOURS          LABOR COST
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
                                                                                $0.00
ESTIMATED STAFFING COST                                                         $0.00




  783cd313-28b5-4862-b8cc-acf46e428c55.xls
        CATEGORY/ DESCRIPTION                SUB-TOTAL COST    TOTAL COST
            DIRECT COSTS
Food & Add-Ons                                                 $      -
Alcoholic Beverages                                            $      -
Equipment                                                      $      -
                    STAFFING
 Gross Wages                                           $0.00
 Taxes & Benefits (% of Gross Wages)                   $0.00
 Gratuity (% of Gross Wages)                           $0.00
                       Total Staffing Cost                     $      -
            TOTAL DIRECT COST                                  $      -
  OVERHEAD (25% of Total Direct Cost)                          $      -
           TOTAL COST                                          $      -
Number of Guests                                          0
Per Person Ticket Charge                               $0.00
               TOTAL REVENUE                                   $      -
                 EVENT PROFIT                                  $      -




  783cd313-28b5-4862-b8cc-acf46e428c55.xls

								
To top