View the step-by-step solution to: What would determine the lowest and highest scenarios of

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

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
  • 890,990,898

    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
  • 890,990,898

    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