Pricing Formula Examples and Variables : Pricing Formula Examples
  
Pricing Formula Examples
Common examples
This table provides examples of many of the most common pricing formulas. The variables are described in “Formula Variables”.
 
To create this pricing...
You’d enter this formula...
Base fee of $50, and $10/hour
50 + 10 * OccurrenceHours
$5 each
5 * Quantity
$10/hour/unit
10 * OccurrenceHours * Quantity
$100/day or part of
100 * OccurrenceDays
$20/hour, pro-rated
20 * OccurrenceDuration * 24
$25/game
25
$50/hour for overtime, defined as between midnight and 8 a.m
00:00-08:00 ? 50 * OccurrencePartHours
$25 for a Lecture (event type),
regardless of the number of
reservations
25 / NumberOfOccurrences
Note: Event types are priced for each occurrence, so this makes each occurrence charge a fraction of the total.
$10/day on weekdays,
$20/day on weekends
10 * OccurrenceDays +
(10 * OnSat) + (10 * OnSun)
Note: $10 per day. If the event occurs on a Saturday then charge an extra $10, and the same for Sunday. If there are several Saturdays in the occurrence, OnSat will be the total number of them.
$100 per 4 hours or any part of a 4-hour period
100 * (In01stHour + In05thHour + In09thHour + In13thHour + In17thHour + In21stHour)
A permit costing $50 must be filed for an event and will cover all occurrences in the event
FirstOccurerence * 50
or
OccurrenceNumber = 1 ? 50
Setup and Takedown labor costs of $25/hr
int((SetupDuration + TakeDownDuration) * 24) * 25
Christmas Day surcharge of $200
OccStartDate[M] = 12 & OccStartDate[D] = 25 ? 200
If a reservation ends after the normal building close time of 7 p.m., an extra $15 security fee is charged
RsrvEndTime > $clock("19:00") ? 15
Examples of limits/caps and price breaks
Some pricing schemes have limits or caps on the prices or price breaks after certain times or during certain hours. To accommodate this, each price sheet can have a range of durations or times and the formula that applies if the occurrence duration falls into that range. Note that the ranges of the durations or times could overlap, in which case only the most appropriate formula applies, or they could be consecutive where each formula applies.
Example 1:
Base fee of $20 per event, plus a cost of $20/hour between 10:00 a.m. and 6:00 p.m., $10/hour between 6:00 p.m. and 11:30 p.m.
10:00 - 17:59
20 + 20 * OccurrencePartHours
18:00 - 23:30
10 * OccurrencePartHours
Example 2:
$100/day, any portion of 4 hours is charged as a half day, any portion of 8 hours is charged as a full day.
0 - 4 hours
50
more than 4 hours
100 * OccurrenceNights
Example 3:
$395/hour, $25/hour after 3 hours (for example, arena lights).
0 - 3 hours
395 * OccurrencePartHours
after 3 hours
25 * OccurrencePartHours
Example 4:
$12/hour, 2 hour minimum
0 - 2 hours
24
after 2 hours
12 * OccurrencePartHours
To create this pricing...
You’d enter this formula...
$2000/day, overtime of $250/hour between midnight and 8 a.m.
unlimited 2000 * OccurrenceDays
00:00-08:00 250 * OccurrencePartHours
Note: $2000 per day. Add up the instances of hours that the event spans between midnight and 8 a.m. and multiply that by the overtime rate of $250.
 
$95/hour (peak), $40/hour (offpeak)
09:00-18:00 95 * OccurrencePartHours
00:00-09:00 40 * OccurrencePartHours
18:00-23:59 40 * OccurrencePartHours
Note: Peak hours are 9 a.m. to 6 p.m. Add up the instances of the peak hours and multiply by $95. Add up the instances of off-peak hours and multiply by $40.
 
To create this pricing...
You’d enter this formula...
1-400 people $33/hour,
401-800 people $156/hour,
801-2000 people $189/hour
unlimited:
ExpHeadCount <= 400 ?
33 * OccurrenceHours
unlimited:
(ExpHeadCount > 400) &
(ExpHeadCount < 800) ?
156 * OccurrenceHours
unlimited:
ExpHeadCount > 800 ?
189 * OccurrenceHours
Overtime staff: $20/overtime hour, regardless of how many.
Based on these hours of operation:
Mon-Thurs = 8 a.m. - Midnight
Friday = 8 a.m. - 10 p.m.
Saturday = 10 a.m. - 8 p.m.
Sunday = 10 a.m. - 11 p.m.
and
These defined overtime hours:
Sunday 11 p.m. - Monday 8 a.m.
Monday, Tuesday, Wednesday, Thursday 12 a.m. - 8 a.m.
Friday 10 p.m. - Saturday 10 a.m.
Saturday 8 p.m. - Sunday 10 a.m.
0 - unlimited :
20 * OccurrencePartHours
08:00-23:59:
20 * (OccPartMonHours +
OccPartTueHours +
OccPartWedHours +
OccPartThurHours)
8:00-22:00 :
20 * OccPartFriHours
10:00-20:00:
20 * OccPartSatHours
10:00-23:00 :
20 * OccPartSunHours
Note: The preceding formula charges all hours as if they were overtime, and then credits back those hours that are not overtime.
 
Maintenance Staff Fees: $18.00 per hour per crew, with a minimum of 2 crew and (if necessary) one supervisor at $25.00 per hour (for as long as the cleaning takes).
(This resource would have to be assigned to a separate reservation called "Cleanup" that occurs following the close of the event.)
18 * OccurrenceHours * 2
Quantity > 2 ? 18 * OccurrenceHours * (Quantity - 2)
Note: This evaluates to 0 if less than 1 or 2 crew are specified, or to 1 if 3 or more crew are specified.
 
To create this pricing...
You’d enter this formula...
Additional rate schedule for the Maintenance Supervisor: $25.00 per hour
25 * OccurrenceHours
Security Staff: $17.50 per hour per officer, with a minimum of 4 officers for the duration of the event plus .5 hours before and 1.5 hours after the event.
(This formula would be part of a rate schedule for Security Officers, and would be applied to the resource "Security Officer". That resource would be assigned to the duration of an event.)
Quantity < 4 ? 17.5 * (OccurrenceHours + 2) * 4
Quantity > 4 ? 17.5 * (OccurrenceHours + 2) * Quantity
The cost is 25% less than what the Corporate rate would be.
{Corporate} * .75