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
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 | ||
| Notice_Request for Information_RFI_TVC.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,856 | 100.0% |
| Food Cost | $ 26,508 | 36.4% |
| Gross Margin | $ 46,348 | 63.6% |
| Labor Costs | |||
| Salaries | $ 32,141 | 44.1% | * Requires to be supported by Staff Hours report that includes: labor category; rate, number of hours, total amount. |
| Employee Benefits | $ 4,256 | 5.8% | |
| Total Labor Costs | $ 36,397 | 50.0% |
| Controllable Expenses | ||
| Supplies | $ 1,366 | 1.9% |
| Services Purchased | $ 242 | 0.3% |
| Communications | $ 60 | 0.1% |
| Miscellaneous | $ 5,450 | 7.5% |
| Total Controllable Expenses | $ 7,118 | 9.8% |
| Non Controllable Expenses | ||
| Insurance | $ 218 | 0.3% |
| Professional Services | $ 339 | 0.5% |
| Total Non Controllables Expenses | $ 557 | 0.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,392 | 7.4% |
| BANK FEES | $ 31 | 0.0% |
| Permints and Licenses | $ - 0 | 0.0% |
| CASH SHORT/OVER | $ 27 | 0.0% |
| Total Other Costs | $ 5,450 | 7.5% |
File details come from the government source that posted it. Updated .