Copy of 12 month Profit and Loss Projection.pdf

80 KB Posted

Attached to
Eugene T. Mahoney State Park Food and Beverage Service Management
Solicitation number
6790 Z1 REBID
Issued by
Cedar County, Nebraska

About this file

Written by GovTribe AI ·

This document is a 12-month Profit and Loss Projection for Carl's at Mahoney, a food and beverage service management contract opportunity for the State of Nebraska, Department of Administrative Services, Materiel Division, State Purchasing Bureau. The contract covers restaurant and beverage services at the Eugene T. Mahoney State Park. The projection estimates revenues of $949,800 and expenses of $698,957, resulting in a net operating loss of $176,377 over the 12-month period. Key revenue streams include food sales, alcohol sales, catering, and a canteen operation. Major expense categories include salaries, payroll, supplies, repairs, advertising, insurance, and loan interest.

The contract opportunity is seeking a qualified contractor to provide the specified food and beverage services. The contract term is not provided. The document does not mention any set-asides, incumbents, funding details, or other salient information beyond the financial projections.

View the file

Other files

File Type Posted
6790 Z1 Cost Proposal Final-CC.pdf PDF
Attachment A - Restaurant Kitchen Sketch.pdf PDF
6790 Z1 ETM Restaurant RFP-CC.pdf PDF
Diane_Kucera_Resume.pdf PDF
6790 Z1 ETM Restaurant RFP.pdf PDF
6790 Z1 RFP Respondents List.pdf PDF
6790 Z1 RFP Addendum for Questions and Answers Final.pdf PDF
RFP Intent to Award.pdf PDF
Final Evaluation Document.pdf PDF
Request for proposal form and form A.pdf PDF
CarlLee_Kucera_Resume_2.pdf PDF
Attachment B - Restaurant Sketch_22.pdf PDF
6790 Z1 Cost Proposal Final.pdf PDF
6790 Z1 ETM Restaurant RFP.doc DOC document
Hog Roast for Drew's Graduation.jpg JPG image
6790 Z1 Cost Proposal Final.docx DOCX document
W91243-23-A-0001_KO & KTR signed.pdf PDF
Stock ledger-Country Catering INC.pdf PDF
Attachment C - Restaurant Inventory.pdf PDF
Diane Kucera Education Cert's.pdf PDF
Business Plan (Autosaved).pdf PDF
Articles of incorporation-Country Catering.pdf PDF
Show all 22

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Profit and Loss Projection (12 Months) Carl's at Mahoney

Fiscal Year Begins Oct-23

O ct

-2

N ov

-2

D ec

-2

Ja n-

Fe b-

M ar

-2

A pr

-2

M ay

-2

Ju n-

Ju l-2

A ug

-2

S ep

-2

Y E

A R

LY

Revenue (Sales) FOOD SALES- buffet -estimating 300 guests x $15 average x 12 days per month 54,000 50,000 45,000 40,000 45,000 45,000 54,000 54,000 54,000 54,000 54,000 54,000 603,000

Carl's Canteen - Take & bake items, Morning breakfast grab & go, carry out beer/liquor 12,000 8,000 8,000 8,000 8,000 8,000 9,000 10,000 12,000 12,000 12,000 12,000 119,000 ALCOHOL- 10% of food sales 5,400 5,000 4,500 4,000 4,500 4,500 5,400 5,400 5,400 5,400 5,400 5,400 60,300

CATERING -inside lodge to conference rooms 5,000 2,500 5,000 5,000 5,000 22,500 Catering - Off Lodge premise & within park 10,000 20,000 20,000 20,000 10,000 80,000 CATERING-Military 5,000 10,000 15,000 15,000 20,000

Total Revenue (Sales) 71,400 63,000 67,500 62,000 75,000 72,500 88,400 84,400 96,400 96,400 91,400 81,400 949,800

Cost of Sales Food -30% 19,800 17,400 15,900 14,400 15,900 15,900 18,900 23,700 27,300 27,300 26,000 22,800 245,300

POS -TOAST -credit card processing, terminals and hand held devices 1,500 1,500 1,500 1,500 1,500 1,800 2,710 2,710 2,710 2,710 2,710 2,710 25,560 Sales Tax 4,055 4,055 4,055 4,055 4,055 4,055 4,055 4,055 4,055 4,055 4,055 4,055 48,660 Alcohol 10,000 3,000 2,700 1,200 1,200 1,200 5,000 2,000 2,500 2,700 3,000 3,600 38,100 Category 5 0 Category 6 0 Category 7 0 Total Cost of Sales 35,355 25,955 24,155 21,155 22,655 22,955 30,665 32,465 36,565 36,765 35,765 33,165 357,620

Gross Profit 36,045 37,045 43,345 40,845 52,345 49,545 57,735 51,935 59,835 59,635 55,635 48,235 592,180

Expenses Salary expenses 24,520 24,520 24,520 24,520 24,520 24,520 40,000 40,000 40,000 40,000 40,000 24,520 371,640 Payroll expenses 8,550 10,075 8,550 7,050 8,550 8,550 13,050 15,000 15,000 15,000 15,000 13,050 137,425 Outside services 0 Supplies (office and operating) 1,110 1,110 1,110 1,110 1,110 1,110 1,110 1,110 1,110 1,110 1,110 1,110 13,320 Repairs and maintenance 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 Advertising 3,000 1,500 500 500 500 1,500 1,500 1,500 1,500 500 500 500 13,500

Car, delivery and travel 500 500 500 500 500 500 500 500 500 500 500 500 6,000 Accounting and legal 1,000 350 350 350 350 350 350 350 350 350 350 350 4,850 Rent & Related Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 Telephone 600 600 600 600 600 600 600 600 600 600 600 600 7,200 Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 INSURANCE-Work comp, liability, Renter's insurance 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000

Taxes (real estate, etc.)

Interest 0 Depreciation 0 loan + interest 1,890 1,890 1,890 1,890 1,890 1,890 1,890 1,890 1,890 1,890 1,890 1,890 22,680 Donations 200 200 200 200 200 200 200 200 200 200 200 200 2,400 permits 500 500 500 500 500 500 500 500 500 500 500 500 6,000

Website hosting fee 200 200 200 200 200 200 200 200 200 200 200 200 2,400 Sub-total Expenses 46,070 45,445 42,920 41,420 42,920 43,920 63,900 65,850 65,850 64,850 64,850 47,420 635,415 Reserve for Contingencies 4607 4545 4292 4142 4292 4392 6390 6585 6585 6485 6485 4742 63,542 Total Expenses 50,677 49,990 47,212 45,562 47,212 48,312 70,290 72,435 72,435 71,335 71,335 52,162 698,957

Net Profit Before Taxes -14,632 -12,945 -3,867 -4,717 5,133 1,233 -12,555 -20,500 -12,600 -11,700 -15,700 -3,927 -106,777

Federal Income Taxes 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000 State Income Taxes 800 800 800 800 800 800 800 800 800 800 800 800 9,600 Local Income Taxes

Net Operating Income -20,432 -18,745 -9,667 -10,517 -667 -4,567 -18,355 -26,300 -18,400 -17,500 -21,500 -9,727 -176,377

File details come from the government source that posted it. Updated .