If you are serious about making more money in your restaurant, you have got to know your business running costs and not just once a month, but at the end of every week. By having done so you will win yourself a huge amount of valuable time to act on arising problems. Calculating Profit and Loss is a must for any restaurant serious about making profit. The Restaurant Monthly Profit and Loss Template contains five P&L worksheets for every week of the month. I have also included a Budget Tool that helps to allocate your Prime Cost amounts. What is a Prime Cost? Prime cost is cost of sales (food & beverages) plus all payroll related costs, including gross payroll of all management and hourly personnel and payroll taxes, benefits, worker's compensation, etc. Prime cost usually runs 60% to 65% of total sales in a full service restaurant and 55% to 60% of sales in a quick service restaurant. Restaurant Monthly Profit and Loss Statement Template for Excel that contains five weekly P&L Workbooks can be a real help when calculating your weekly and monthly profit and costs. The Profit and Loss Worksheet also has an integrated budget tool that allocates estimated revenue, profit and costs per set margin and also helps to compare to the actual cost of sales for every week of the month. Instructions are simple, just enter the amounts from you POS in to the blue cells and this is really all you have to do. The P&L Template can be customised to suit your business requirements. You can download and use or free restaurant monthly profit and loss statement template only for your personal use.
Requirements:
Excel 2002(XP)/2003/2007
Limitations:
Limited customization option
Comments not found