View the step-by-step solution to:

Operational Forecast "THE HIVE" Scenario 1 Ratio Food Beverage Sales (Beer, Liquor & Wine) Private Area Liquor Sales...

What would determine the lowest and highest scenarios of performance?
Copy of Sample_ pro_ forma.xls

Operational Forecast "THE HIVE"
Scenario 1 Ratio Food
Beverage Sales (Beer, Liquor & Wine)
Private Area Liquor Sales
Merchandise Sales
Cover Charge
Sponsorships $624,000
$1,820,000
$1,040,000
$78,000
$960,000
$60,000 13.62%
39.72%
22.70%
1.70%
20.95%
1.31% Total Sales $4,582,000 100.00% Scenario 2 $755,040
$2,202,200
$1,258,400
$94,380
$1,161,600
$72,600 Ratio
13.62%
39.72%
22.70%
1.70%
20.95%
1.31% $5,544,220 100.00% Scenario 3
$913,598
$2,664,662
$1,522,664
$114,200
$1,405,536
$87,846 Ratio
13.62%
39.72%
22.70%
1.70%
20.95%
1.31% $6,708,506 100.00% Food
Beverage Cost (Beer, Liquor & Wine)
Merchandise Cost
Other COGS $156,000
$543,400
$19,500
$102,000 25.00%
19.00%
25.00%
10.00% $188,760
$657,514
$23,595
$123,420 25.00%
19.00%
25.00%
10.00% $228,400
$795,592
$28,550
$149,338 25.00%
19.00%
25.00%
10.00% Total Cost of Sales $820,900 17.92% $993,289 17.92% $1,201,880 17.92% $3,761,100 82.08% $4,550,931 82.08% $5,506,627 82.08% $778,940
$180,000
$580,000
$29,240
$6,000
$24,000
$240,000
$5,000
$5,000
$3,000
$6,000
$2,000
$55,000
$4,582
$6,000
$3,600
$48,000
$24,000
$36,656 17.00%
3.93%
12.66%
0.64%
0.13%
0.52%
5.24%
0.11%
0.11%
0.07%
0.13%
0.04%
1.20%
0.10%
0.13%
0.08%
1.05%
0.52%
0.80% $942,517
$180,000
$701,800
$35,380
$7,260
$29,040
$240,000
$6,050
$6,050
$3,630
$7,260
$2,420
$66,550
$5,544
$7,260
$4,356
$50,430
$25,215
$38,512 17.00%
3.25%
12.66%
0.64%
0.13%
0.52%
4.33%
0.11%
0.11%
0.07%
0.13%
0.04%
1.20%
0.10%
0.13%
0.08%
0.91%
0.45%
0.69% $1,006,275.93
$180,000
$849,178
$42,810
$8,785
$35,138
$290,400
$7,321
$7,321
$4,392
$8,785
$2,928
$80,526
$6,709
$8,785
$5,271
$52,983
$26,492
$40,461 15.00%
2.68%
12.66%
0.64%
0.13%
0.52%
4.33%
0.11%
0.11%
0.07%
0.13%
0.04%
1.20%
0.10%
0.13%
0.08%
0.79%
0.39%
0.60% Total Controllable Expense $2,037,018 44.46% $2,359,275 42.55% $2,664,558 39.72% Contollable Profit $1,724,082 37.63% $2,191,656 39.53% $2,842,068 42.37% Fixed Expenses:
Insurance
Workman's Compensation
Licenses
Professional Fees
Equipment Rental
Property Lease
CAM & Property Taxes
Credit Card Cost $47,000
$36,656
$13,746
$36,000
$65,000
$239,694
$17,121
$12,000 1.03%
0.80%
0.30%
0.79%
1.42%
5.23%
0.37%
0.26% $56,870
$44,354
$13,746
$23,040
$78,650
$239,694
$17,121
$14,520 1.03%
0.80%
0.25%
0.42%
1.42%
4.32%
0.31%
0.26% $68,813
$53,668
$13,746
$27,878
$95,167
$239,694
$17,121
$17,569 1.03%
0.80%
0.20%
0.42%
1.42%
3.57%
0.26%
0.26% Total Fixed Expense $467,217 10.20% $487,995 8.80% $533,656 7.95% Total Operating Expenses $2,504,235 54.65% $2,847,269 51.36% $3,198,214 47.67% Net / Before Bonus and Federal
Income Tax $1,256,865 27.43% $1,703,662 30.73% $2,308,412 34.41% $9,426 0.21% $12,777 0.23% $17,313 0.26% $1,247,439 27.22% $1,690,884 30.50% $2,291,099 34.15% Gross Profit
Controllable Expenses:
Payroll
Management
Talent/Talent Buyer
Payroll Taxes
Uniforms
In-Store Advertizing/Promotion
Promotion, Advertizing & Media
Comp & Manager Meals
Laundry
Maintenance
Office Supplies
Repairs
Supplies
Cash Over & Short
Miscellaneous Expense
Gas
Electricity
Water & Sewer
Telephone/Cable/ASCAP/BMI Employee's Bonus (.75% Net Profit)
Net Before Federal Income Tax

This question was asked on Oct 04, 2010.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards