Pro Forma Worksheet.pdf
PDF 70 KB Posted
- Attached to
- 300 Glendale FWA 2-year Concession CampgroundBid Documents State and local contract opportunity
- Solicitation number
- 003000000088287
- Issued by
- Dubois County, Indiana
About this file
This is a Pro Forma Worksheet document based on a calendar year financial projection model for fiscal years 2027 through 2030, prepared in conjunction with a state or local contract opportunity involving the Department of Natural Resources (DNR). The worksheet is designed to project financial performance across a four-year period and appears to support a proposal or bid submission that requires demonstrating the bidder's financial capability and operational planning.
The Pro Forma Worksheet provides a comprehensive financial template organized into three main sections: Cost of Sales, Operating Expenses, and Net Income calculations. The Cost of Sales section itemizes revenue sources including merchandise, food, and other categories, with corresponding cost calculations to determine gross profit. The Operating Expenses section details labor costs (salaries, wages, insurance, and employee benefits), utilities (electricity, gas, water, sewer, telephone, trash, internet), and other operating costs including maintenance, vehicles, equipment, advertising, processing fees, professional services, and miscellaneous expenses. The worksheet culminates in a Net Income Before Taxes calculation and identifies a line item for "Proposed Payment to DNR," indicating that the financial model must account for contract-related payments or revenue sharing with the state agency. This financial projection tool enables bidders to demonstrate fiscal responsibility, operational viability, and the sustainability of their proposed contract performance across the four-year term.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| RFQ_Solicitation Event 003000000088287.docx | DOCX document | |
| Concession Opportunity Glendale FWA Campground.docx | DOCX document | |
| Event 003000000088287.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
REVENUE
List each revenue source / category
Gross Revenue -$ -$ -$ -$
Merchandise
Food
Other
Total Cost of Sales -$ -$ -$ -$
Gross Profit (Gross Revenue minus Total Cost of Sales) -$ -$ -$ -$
Salaries and Wages
Insurance - Workers Comp
Unemployment Taxes
FICA & Medicare Taxes
Health Insurance - Employees
Other Employee/Labor Expenses
Labor Cost Subtotal -$ -$ -$ -$
Electricity
Gas
Water
Sewer
Telephone
Trash Removal
Internet
Other Utilities
COST OF SALES
OPERATING EXPENSES
Pro Forma Worksheet Based on Calendar Year
2027 2028 2029 2030
Pro Forma Worksheet Based on Calendar Year
2027 2028 2029 2030
Utilities Cost Subtotal -$ -$ -$ -$
Postage
Linen
Uniforms
Maintenance
Vehicles
Equipment
Advertising
Electronic Processing Fees
Accountant Fees
Contract Services
Publications and Dues
Insurance
Miscellaneous Expenses
Other Expenses
Operating Other Costs Subtotal -$ -$ -$ -$
Total Operating Expenses -$ -$ -$ -$
Net Income Before Taxes -$ -$ -$ -$
Taxes on Income
NET INCOME -$ -$ -$ -$
PROPOSED PAYMENT TO DNR
File details come from the government source that posted it. Updated .