Attachment 2_Sample PL Statement.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
RFI_TVC__ Treasury Vault Cafe Food Services
Solicitation number
Not on record
Issued by

About this file

This is a sample Profit and Loss (P&L) Statement template provided as an attachment to the Department of the Treasury's Request for Information (RFI) for Treasury Vault Cafe Food Services. The document presents a financial statement format for a food service operation dated 7/30, showing actual figures and percentages of sales across multiple expense categories. The statement demonstrates the required structure for financial reporting, with Sales of $72,856 generating a Gross Margin of 63.6% after Food Costs of $26,508. Labor Costs comprise the largest operating expense category at 50.0% of sales ($36,397), inclusive of Salaries of $32,141—which requires supporting documentation via a Staff Hours report detailing labor categories, rates, hours, and total amounts—and Employee Benefits of $4,256. Additional expense categories include Controllable Expenses ($7,118 or 9.8%), Non-Controllable Expenses ($557 or 0.8%), and an Administrative Fee/G&A allocation of 3.0%. The statement concludes with a Profit/Loss figure of $90 against a Guaranteed Profit of $7,000, resulting in an Invoice amount of $6,910. Miscellaneous expenses totaling $5,450 are itemized separately, primarily comprising Credit Card Fees at 7.4% of sales. This template serves as guidance for prospective vendors responding to the RFI to understand the financial reporting format and expense categorization expected for the Treasury Vault Cafe Food Services operation.

View the file

Other files

File Type Posted
Attachment 1_PWS_RFI_TVC.pdf PDF
Notice_Request for Information_RFI_TVC.pdf PDF

On GovTribe

Work with this file

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

Text version

Table 1

EXAMPLE

DEPARTMENT OF THE TREASURY

Income Statement 7/30/XXXX

Actual%
Sales$ 72,856100.0%
Food Cost$ 26,50836.4%
Gross Margin$ 46,34863.6%
Labor Costs
Salaries$ 32,14144.1%* Requires to be supported by Staff Hours report that includes: labor category; rate, number of hours, total amount.
Employee Benefits$ 4,2565.8%
Total Labor Costs$ 36,39750.0%
Controllable Expenses
Supplies$ 1,3661.9%
Services Purchased$ 2420.3%
Communications$ 600.1%
Miscellaneous$ 5,4507.5%
Total Controllable Expenses$ 7,1189.8%
Non Controllable Expenses
Insurance$ 2180.3%
Professional Services$ 3390.5%
Total Non Controllables Expenses$ 5570.8%

Administrative Fee/ G&A $ 2,186 3.0%

Total Operating expenses$ 72,766
Profit/Loss$ 90
Guaranteed Profit$ 7,000
Invoice amount$ 6,910
Miscellaneous (Detail):
CREDIT CARD FEES$ 5,3927.4%
BANK FEES$ 310.0%
Permints and Licenses$ - 00.0%
CASH SHORT/OVER$ 270.0%
Total Other Costs$ 5,4507.5%

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