Spreadsheet: a98cd881-812f-4f80-b708-c8a6fdcca686
Sheet: Estimated Budget

CHAPTER: |  |  |  |  |  |  |  |  |  | Account #: |  |  |  |  |  |  | The chapter name is mapped from the OA Budget Planning-Report worksheet cell "OA Budget Planning-Report Sheet'!B5"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The chapter account # is mapped from the OA Budget Planning-Report worksheet cell "OA Budget Planning-Report Sheet'!B7"
CALCULATING EXPENSES:
Food |  |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total
 | Ordeal Candidates |  |  |  |  |  |  | x | $ |  | = | $
 | Elangomats |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The estimated number of attendees by category is entered
 | Members |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | in column "H" in the gray shaded cells "H7" to "H13"
 | Members (Day Only) |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The estimated food cost per person by category is entered
 | Feast Only |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | in column "K" in the gray shaded cells "K7" to "K13"
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The Estimated Food Cost per attendee category is automatically calculated
 |  |  |  |  |  |  |  | x | $ |  | = | $
 | TOTAL ESTIMATED FOOD COSTS |  |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Estimated Food Cost is automatically calculated
Operating
 | Postage |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total |  |  |  | The current first class postage rate is entered into cell "K18" and is mapped to cell "K19"
 |  | Ordeal Candidates |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The number of elected ordeal candidates elected during the current elections season is entered into cell "H18"
 |  | Members |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The number of members in the chapter is entered into cell "H19"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional printing cost description is entered in cell "C20and the cost in cell 'N20"
 |  | TOTAL ESTIMATED POSTAGE COSTS |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Postage Cost is automatically calculated
 | Printing & Printing Supplies |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total
 |  | Ordeal Candidates |  |  |  |  |  | x | $ |  | = | $
 |  | Members |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The per person printing cost is entered into cell "K23 and is mapped to cell "K24"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The quantities are mapped from cells "H18 and "H19"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional printing cost description is entered in cell "C25" to "C27" and the cost in cell "N25" to "N27"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Total Printing Cost is automatically calculated
 |  | TOTAL ESTIMATED PRINTING COSTS |  |  |  |  |  |  |  |  |  | $
 | Awards |  |  |  |  |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Awards cost descriptions are entered in cells "C30" to "C33"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and the costs are entered in cells "N30 to "N33"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Total Awards Cost is automatically calculated
 |  | TOTAL ESTIMATED AWARDS COSTS |  |  |  |  |  |  |  |  |  | $
 | Ceremonies |  |  |  |  |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ceremonies cost descriptions are entered in cells "C36" to "C39"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and the costs are entered in cells "N36" to "N39"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Total Ceremonies Cost is automatically calculated
 |  | TOTAL ESTIMATED CEREMONIES COSTS |  |  |  |  |  |  |  |  |  | $
 | Health & Safety |  |  |  |  |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Health & Saftey cost descriptions are entered in cells "C42" to "C45"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and the costs are entered in cells "N42" to "N45"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Total Ceremonies Cost is automatically calculated
 |  | TOTAL ESTIMATED HEATLH & SAFTEY COSTS |  |  |  |  |  |  |  |  |  | $
 | Facility/Site Infrastructure |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total
 |  | Facility usage Fee (per attendee) |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | Facilities usage per person is entered in cell "K48" and the quantity is mapped as the sum of cells "H7 to [NAME]"
 |  | Port-a-John(s) |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The number of Port-a-John(s) is entered in cell "H49" and the cost for each in cell "K49"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional Facility/Site Infrastructure cost description is entered in cell "C50" and the cost in cell "N50"
 |  | TOTAL ESTIMATED FACILITY/SITE INFRASTRUCTURE  COSTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Total Facility/Site Infrastructure cost is automatically calculated
 | Contingency Fee
 |  | Estimated Foods Costs |  |  |  | $ |  | x |  | 0.1 |  | $ |  |  |  |  | The Estimated Contingency Fee is automatically calculated as 10% of the Estimated Food Cost in cell "N54"
 | TOTAL OPERATING ESTIMATED COSTS |  |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total of the Estimated Operating Costs is automatically total in cell "N55
 |  |  |  |  |  |  | Operating Unit Costs |  |  |  |  | $ |  |  |  |  | The per person Operating Cost is automatically calculated by dividing cell "N55" by the total of cells "H7 to [NAME]"
CALCULATING FEES:
Ordeal Candidate |  |  |  |  |  |  | Cost |  |  | Total |  |  | Fee to be Charged |  |  |  | The cost for the Ordeal Induction materials is set by LEC policy
 | [NAME], O/A Handbook, Amangamek-Wipit Flap Patch |  |  |  |  | $ | 25 |  |  |  |  |  |  |  |  |  | These include ordeal Sash, O/A Handbook and Standard Lodge Flap
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The current amount of the O/A dues is entered in cell "H64"
 | O/A Dues |  |  |  |  | $ | 12 |  |  |  |  |  |  |  |  |  | The Liability Insurance Recovery for the event is entered in cell "H65"
 | Liability Insurance Recovery |  |  |  |  | $ | 2 |  |  |  |  |  |  |  |  |  | The food cost is mapped from cell "K7"
 | Food |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The per person operating cost is mapped from cell "N56"
 | Operating Cost |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | Additional Ordeal fee cost description is entered in cell "B68" and the cost in cell 'H68"
 |  |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The Estimated fee for Ordeal Candidate is automatically calculated
 | Ordeal Candidate Fee |  |  |  |  |  |  |  | $ |  |  | $ |  |  |  |  | Use Cell "N69 to establish actual fee to be charged
Elangomat |  |  |  |  |  |  | Cost |  |  | Total |  |  |  |  |  |  | The cost for the Elangomat Patch is mapped from the Consignment worksheet "Consignment!D18"
 | Elangomat Patch |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The Liability Insurance Recovery is mapped from cell "H65"
 | Liability Insurance Recovery |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The food cost is mapped from cell "K8"
 | Food |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The per person operating cost is mapped from cell "N56"
 | Operating Cost |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | Additional Elangomat fee cost description is entered in cell "B75" and the cost in cell 'H75"
 |  |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The Estimated fee for Elangomat is automatically calculated
 | Elangomat Fee |  |  |  |  |  |  |  | $ |  |  | $ |  |  |  |  | Use Cell "N77" to establish actual fee to be charged
Member Fee |  |  |  |  |  |  | Cost |  |  | Total |  |  |  |  | Day Only |  | The Liability Insurance Recovery is mapped from cell "H65" ([NAME] only is automatically reduced to one day in cell "P78")
 | Liability Insurance recovery |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The food cost is mapped from cell "K9" ("K10" for Day Participant Only)
 | Food |  |  |  |  | $ |  |  |  |  |  | $ |  |  |  |  | The per person operating cost is mapped from cell "N56"
 | Operating Cost |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | Additional Member fee cost description is entered in cell "B81" and the cost in cell 'H81"
 |  |  |  |  |  | $ |  |  |  |  |  |  |  |  | Day Only |  | The Estimated fee for Member is automatically calculated
 | Member Fee |  |  |  |  |  |  |  | $ |  |  | $ |  |  |  |  | Use Cell "N82"and "P82" to establish actual fee to be charged for Member and Day Participant
Member Fee (Feast Only) |  |  |  |  |  |  | Cost |  |  | Total |  |  |  |  |  |  | The Liability Insurance Recovery is mapped from cell "H65" and is automatically reduced to one day
 | Liability Insurance recovery |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The food cost is mapped from cell "K11"
 | Food |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | Additional Member (Feast Only) fee cost description is entered in cell "B86" and the cost in cell 'H86"
 |  |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  | The Estimated fee for Member (Feast Only) is automatically calculated
 | Member Fee |  |  |  |  |  |  |  | $ |  |  | $ |  |  |  |  | Use Cell "N87" to establish actual fee to be charged
CALCULATING ESTIMATED BUDGET REVENUE:
Registration Fees |  |  |  |  | Quantity |  | Fee |  |  | Total |  |  |  |  |  |  | The estimated attendees and registration fees are mapped from
 | Ordeal Candidates |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cells "H7 and "N69"
 | Elangomats |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cells "H8" and "N76"
 | Members |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cells "H9" and "N82"
 | Members (Day Only) |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cells "H10" and "P82"
 | Feast Only |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cell's "H11" and "N87"
 |  |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cell's "H12" and the appropriate fee is entered in cell "H98"
 |  |  |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | cells "H13" and  the appropriate fee is entered in cell "H99"
 |  | TOTAL Fee Based Revenue |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The total fees by attendee is automatically calculated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The total fee based revenue is automatically calculated
Other Revenue Sources |  |  |  |  |  |  |  |  |  | Total
 | Chapter Contribution  (Current Account Balance Reduction) |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | If existing chapter funds are to be treated as "revenue" the amount is entered in cell "K112"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Additional revenue description is entered in cell "B104 to B105" and the dollar amount in cell 'K104 to K105"
 |  |  |  |  |  |  |  |  | $
 |  | Total Other Revenue Sources |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Other Revenue is automatically calculated
 | TOTAL ESTIMATED REVENUE |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Estimated Revenue is automatically calculated
BALANCING THE ESTIMATED BUDGET: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Estimated Food Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Food Cost is mapped from cell "N14"
 | Estimated Postage Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Postage Cost is mapped from cell "N21"
 | Estimate Printing cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Printing Cost is mapped from cell "N28"
 | Estimated Awards Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Awards Cost is mapped from cell "N34"
 | Estimated Ceremonies Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Ceremonies Cost is mapped from cell "N40"
 | Estimated Health & Safety Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Health & Safety Cost is mapped from cell "N46"
 | Estimated Facility/Site Infrastructure Cost |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Facilities/Site Infrastructure Cost is mapped from cell "N51"
 |  |  |  |  |  |  | Quantity |  |  | Cost
 | Ordeal Sashes, O/A Handbooks, Amangamek-Wipit Flap Patches |  |  |  |  |  |  | x | $ | 18 |  |  |  | $ |  |  | The number of Ordeal Sashes, Handbooks, and Lodge Flaps is mapped from cells "F193"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The cost in cell "K127" is set by the LEC
 |  |  |  |  |  |  | Quantity |  |  | Cost
 | O/A Dues |  |  |  |  |  |  | x | $ |  |  |  |  | $ |  |  | The number of O/A Dues is mapped from cells "F102" and "H70
 |  |  |  |  |  |  | Quantity |  |  | Cost
 | Brotherhood Sashes |  |  |  |  |  |  | x | $ | 14 |  |  |  | $ |  |  | The number of [NAME] is entered into cell "H132", the cost in cell K132" is set by the LEC
 |  |  |  |  |  |  | Quantity |  |  | Cost
 | Elangomat Patches |  |  |  |  |  |  | x | $ |  |  |  |  | $ |  |  | The number and cost of Elangomat Patches is mapped from cells "F94" and "Consignment!D18"
 | Liability Insurance Recovery |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total |  |  |  | The quantity and cost of Liability Insurance Recovery is mapped from
 |  | Ordeal Candidates |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H7" and "H65"
 |  | Elangomats |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H8" and "H72"
 |  | Members |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H9" and "H78"
 |  | Members (Day Only) |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H10" and "P78"
 |  | Members (Feast Only) |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H11" and "H84"
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cell "H12"  and the cost is set based upon a 1-day or 2-day attendance
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  | $ |  |  | cell "H13"  and the cost is set based upon a 1-day or 2-day attendance
 | Contingency Fee |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The [NAME] fee is mapped from cell "N54"
 |  | TOTAL ESTIMATED EXPENSES |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Estimated Expense is the sum of cells "P113 to P146"
 |  | TOTAL ESTIMATED REVENUE |  |  |  |  |  |  |  |  |  |  |  | $ |  |  | The Total Estimated Revenue is mapped  from "K108"
 |  | DIFFERENCE |  |  |  |  |  |  |  |  |  |  | +/- | $ |  |  | The Difference between Estimated Expenses and Revenue is applied as an adjustment
Adjust the Contingency Fee [increase for "+" or decrease for "-"] to balance budget on the Budget Planning and Report Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to the [NAME] fee (increase for a positive difference and decrease for a negative difference
TOTAL EXPENSES BUDGETED ALWAYS EQUALS TOTAL REVENUE BUDGETED
TRANSFER FIGURES TO THE ORDER of the ARROW "ACTIVITY BUDGET PLANNING/REPORT SHEET"