| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Total Sales Food | 0% | £44,579 | £50,948 | £57,975 | £65,441 | £79,057 | £81,253 | £83,449 | £74,665 | £83,449 | £74,665 | £79,057 | £79,057 |
| Total Sales Bar/Beverages | 0% | £11,499 | £13,141 | £14,954 | £16,880 | £20,392 | £20,958 | £21,524 | £19,259 | £21,524 | £19,259 | £20,392 | £20,392 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Total Cost of Sales: Food | £15,603 | £17,832 | £20,291 | £22,904 | £27,670 | £28,439 | £29,207 | £26,133 | £29,207 | £26,133 | £27,670 | £27,670 | |
| Total Cost of Sales: Bar/Beverages | £3,795 | £4,337 | £4,935 | £5,570 | £6,729 | £6,916 | £7,103 | £6,355 | £7,103 | £6,355 | £6,729 | £6,729 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Direct Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| Gross Margin | £36,681 | £41,921 | £47,703 | £53,846 | £65,050 | £66,856 | £68,663 | £61,436 | £68,663 | £61,436 | £65,050 | £65,050 | |
| Gross Margin % | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | |
| Expenses | |||||||||||||
| Payroll | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |
| Marketing/Promotion | £1,457 | £1,457 | £1,457 | £6,457 | £0 | £1,457 | £2,457 | £1,457 | £0 | £0 | £0 | £2,457 | |
| Depreciation | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | |
| Leased Equipment | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Accounting/Payroll Processing | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | |
| Legal Retainer Fees | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Business Licenses & Permits | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Credit Card Expense | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | |
| Bank Fees | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Music & Entertainment | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | |
| Training / Employee Retention Programs | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Repairs & Maintenance | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utility Services (Gas/Electric/Water/Sewer) | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | |
| Telephone/Communication Expense | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance: Fire/Theft/Liability/Liquor/Product | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | |
| Restaurant Occupancy Cost (Lease) | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Payroll Taxes (FICA/FUTA/SUTA) & Employee Benefits | 17% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Exterminator/Trash Removal | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Dishware/Uniforms/Cleaning Supplies/Decor | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | |
| Printing/Paper/Postage/Subscriptions | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | |
| Facility (Exterior Cleaning/Grease Trap/Hood/Windows,etc.) | £0 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | |
| R&D Meals | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| General Business Comps | £0 | £0 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | |
| Owner Comps | 15% | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 |
| Other Expenses (ComAreaMaint, etc.) | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Total Operating Expenses | £53,111 | £53,614 | £54,854 | £59,854 | £53,397 | £54,854 | £55,854 | £54,854 | £53,397 | £53,397 | £53,397 | £55,854 | |
| Profit Before Interest and Taxes | (£16,430) | (£11,693) | (£7,151) | (£6,007) | £11,653 | £12,003 | £12,809 | £6,582 | £15,266 | £8,039 | £11,653 | £9,196 | |
| EBITDA | (£15,888) | (£11,151) | (£6,609) | (£5,466) | £12,195 | £12,544 | £13,351 | £7,124 | £15,808 | £8,581 | £12,195 | £9,738 | |
| Interest Expense | £1,727 | £1,704 | £1,680 | £1,657 | £1,634 | £1,611 | £1,587 | £1,564 | £1,541 | £1,518 | £1,495 | £1,471 | |
| Taxes Incurred | (£5,447) | (£4,019) | (£2,649) | (£2,299) | £3,006 | £3,118 | £3,367 | £1,505 | £4,118 | £1,956 | £3,048 | £2,317 | |
| Net Profit | (£12,710) | (£9,378) | (£6,182) | (£5,365) | £7,013 | £7,274 | £7,855 | £3,513 | £9,608 | £4,565 | £7,111 | £5,407 | |
| Net Profit/Sales | -22.66% | -14.63% | -8.48% | -6.52% | 7.05% | 7.12% | 7.48% | 3.74% | 9.15% | 4.86% | 7.15% | 5.44% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Subtotal Cash from Operations | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |
| Bill Payments | £959 | £29,247 | £42,873 | £48,926 | £57,675 | £65,013 | £62,220 | £63,929 | £52,812 | £65,248 | £51,624 | £60,586 | |
| Subtotal Spent on Operations | £34,258 | £62,546 | £76,172 | £82,225 | £90,974 | £98,312 | £95,519 | £97,228 | £86,111 | £98,547 | £84,923 | £93,885 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £38,239 | £66,527 | £80,153 | £86,206 | £94,955 | £102,293 | £99,500 | £101,209 | £90,092 | £102,528 | £88,904 | £97,866 | |
| Net Cash Flow | £17,839 | (£2,438) | (£7,224) | (£3,885) | £4,494 | (£82) | £5,473 | (£7,285) | £14,881 | (£8,604) | £10,545 | £1,583 | |
| Cash Balance | £164,819 | £162,381 | £155,157 | £151,272 | £155,765 | £155,683 | £161,157 | £153,871 | £168,752 | £160,148 | £170,693 | £172,276 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £146,980 | £164,819 | £162,381 | £155,157 | £151,272 | £155,765 | £155,683 | £161,157 | £153,871 | £168,752 | £160,148 | £170,693 | £172,276 |
| Inventory | £27,500 | £21,337 | £24,385 | £27,749 | £31,322 | £37,839 | £38,890 | £39,941 | £35,737 | £39,941 | £35,737 | £37,839 | £37,839 |
| Other Current Assets | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 |
| Total Current Assets | £247,791 | £259,467 | £260,077 | £256,217 | £255,905 | £266,915 | £267,884 | £274,409 | £262,919 | £282,004 | £269,196 | £281,843 | £283,426 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Accumulated Depreciation | £0 | £542 | £1,083 | £1,625 | £2,167 | £2,708 | £3,250 | £3,792 | £4,333 | £4,875 | £5,417 | £5,958 | £6,500 |
| Total Long-term Assets | £65,000 | £64,458 | £63,917 | £63,375 | £62,833 | £62,292 | £61,750 | £61,208 | £60,667 | £60,125 | £59,583 | £59,042 | £58,500 |
| Total Assets | £312,791 | £323,925 | £323,994 | £319,592 | £318,738 | £329,207 | £329,634 | £335,617 | £323,586 | £342,129 | £328,779 | £340,885 | £341,926 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £27,825 | £41,252 | £47,012 | £55,505 | £62,942 | £60,075 | £62,184 | £50,621 | £63,538 | £49,604 | £58,580 | £58,194 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £27,825 | £41,252 | £47,012 | £55,505 | £62,942 | £60,075 | £62,184 | £50,621 | £63,538 | £49,604 | £58,580 | £58,194 |
| Long-term Liabilities | £300,000 | £296,019 | £292,038 | £288,057 | £284,076 | £280,095 | £276,114 | £272,133 | £268,152 | £264,171 | £260,190 | £256,209 | £252,228 |
| Total Liabilities | £300,000 | £323,844 | £333,290 | £335,069 | £339,581 | £343,037 | £336,189 | £334,317 | £318,773 | £327,709 | £309,794 | £314,789 | £310,422 |
| Paid-in Capital | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 |
| Retained Earnings | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) |
| Earnings | £0 | (£12,710) | (£22,087) | (£28,269) | (£33,634) | (£26,621) | (£19,346) | (£11,491) | (£7,979) | £1,629 | £6,194 | £13,305 | £18,712 |
| Total Capital | £12,791 | £82 | (£9,296) | (£15,478) | (£20,843) | (£13,829) | (£6,555) | £1,300 | £4,813 | £14,420 | £18,985 | £26,096 | £31,504 |
| Total Liabilities and Capital | £312,791 | £323,925 | £323,994 | £319,592 | £318,738 | £329,207 | £329,634 | £335,617 | £323,586 | £342,129 | £328,779 | £340,885 | £341,926 |
| Net Worth | £12,791 | £82 | (£9,296) | (£15,478) | (£20,843) | (£13,829) | (£6,555) | £1,300 | £4,813 | £14,420 | £18,985 | £26,096 | £31,504 |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| General Manager (Year 2+) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Partner/Manager | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Partner/Asst. Manager/Exec. Chef | 0% | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 |
| Hostess (Full Time) | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Hostess (Part Time) | 0% | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Waitperson 1 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 2 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 3 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 4 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 5 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 6 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 7 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 8 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 9 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Wait/Barperson | 0% | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 |
| Bartender 1 | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Bartender 2 | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Busboy 1 | 0% | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 |
| Busboy 2 | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
| Busboy 3 | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Assistant Chef | 0% | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 |
| Sous Chef | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
| Cook 1 | 0% | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 |
| Cook 2 | 0% | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 |
| Prep Cook/Dishwasher | 0% | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 |
| Prep Cook/Dishwasher/Cleaning | 0% | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 |
| Dishwasher 1 | 0% | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 |
| Dishwasher 2 | 0% | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 |
| Cleaning/Dishwasher | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
| Open | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | |
| Total Payroll | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Total Sales Food | 0% | £44,579 | £50,948 | £57,975 | £65,441 | £79,057 | £81,253 | £83,449 | £74,665 | £83,449 | £74,665 | £79,057 | £79,057 |
| Total Sales Bar/Beverages | 0% | £11,499 | £13,141 | £14,954 | £16,880 | £20,392 | £20,958 | £21,524 | £19,259 | £21,524 | £19,259 | £20,392 | £20,392 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Total Cost of Sales: Food | £15,603 | £17,832 | £20,291 | £22,904 | £27,670 | £28,439 | £29,207 | £26,133 | £29,207 | £26,133 | £27,670 | £27,670 | |
| Total Cost of Sales: Bar/Beverages | £3,795 | £4,337 | £4,935 | £5,570 | £6,729 | £6,916 | £7,103 | £6,355 | £7,103 | £6,355 | £6,729 | £6,729 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Direct Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £19,397 | £22,168 | £25,226 | £28,475 | £34,399 | £35,355 | £36,310 | £32,488 | £36,310 | £32,488 | £34,399 | £34,399 | |
| Gross Margin | £36,681 | £41,921 | £47,703 | £53,846 | £65,050 | £66,856 | £68,663 | £61,436 | £68,663 | £61,436 | £65,050 | £65,050 | |
| Gross Margin % | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | 65.41% | |
| Expenses | |||||||||||||
| Payroll | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |
| Marketing/Promotion | £1,457 | £1,457 | £1,457 | £6,457 | £0 | £1,457 | £2,457 | £1,457 | £0 | £0 | £0 | £2,457 | |
| Depreciation | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | £542 | |
| Leased Equipment | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Accounting/Payroll Processing | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | |
| Legal Retainer Fees | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Business Licenses & Permits | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Credit Card Expense | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | £1,548 | |
| Bank Fees | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Music & Entertainment | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | £312 | |
| Training / Employee Retention Programs | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Repairs & Maintenance | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utility Services (Gas/Electric/Water/Sewer) | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | £2,083 | |
| Telephone/Communication Expense | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance: Fire/Theft/Liability/Liquor/Product | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | |
| Restaurant Occupancy Cost (Lease) | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Payroll Taxes (FICA/FUTA/SUTA) & Employee Benefits | 17% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Exterminator/Trash Removal | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Dishware/Uniforms/Cleaning Supplies/Decor | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | |
| Printing/Paper/Postage/Subscriptions | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | £763 | |
| Facility (Exterior Cleaning/Grease Trap/Hood/Windows,etc.) | £0 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | £303 | |
| R&D Meals | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| General Business Comps | £0 | £0 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | £1,240 | |
| Owner Comps | 15% | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 | £177 |
| Other Expenses (ComAreaMaint, etc.) | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Total Operating Expenses | £53,111 | £53,614 | £54,854 | £59,854 | £53,397 | £54,854 | £55,854 | £54,854 | £53,397 | £53,397 | £53,397 | £55,854 | |
| Profit Before Interest and Taxes | (£16,430) | (£11,693) | (£7,151) | (£6,007) | £11,653 | £12,003 | £12,809 | £6,582 | £15,266 | £8,039 | £11,653 | £9,196 | |
| EBITDA | (£15,888) | (£11,151) | (£6,609) | (£5,466) | £12,195 | £12,544 | £13,351 | £7,124 | £15,808 | £8,581 | £12,195 | £9,738 | |
| Interest Expense | £1,727 | £1,704 | £1,680 | £1,657 | £1,634 | £1,611 | £1,587 | £1,564 | £1,541 | £1,518 | £1,495 | £1,471 | |
| Taxes Incurred | (£5,447) | (£4,019) | (£2,649) | (£2,299) | £3,006 | £3,118 | £3,367 | £1,505 | £4,118 | £1,956 | £3,048 | £2,317 | |
| Net Profit | (£12,710) | (£9,378) | (£6,182) | (£5,365) | £7,013 | £7,274 | £7,855 | £3,513 | £9,608 | £4,565 | £7,111 | £5,407 | |
| Net Profit/Sales | -22.66% | -14.63% | -8.48% | -6.52% | 7.05% | 7.12% | 7.48% | 3.74% | 9.15% | 4.86% | 7.15% | 5.44% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Subtotal Cash from Operations | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £56,078 | £64,089 | £72,929 | £82,321 | £99,449 | £102,211 | £104,973 | £93,924 | £104,973 | £93,924 | £99,449 | £99,449 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |
| Bill Payments | £959 | £29,247 | £42,873 | £48,926 | £57,675 | £65,013 | £62,220 | £63,929 | £52,812 | £65,248 | £51,624 | £60,586 | |
| Subtotal Spent on Operations | £34,258 | £62,546 | £76,172 | £82,225 | £90,974 | £98,312 | £95,519 | £97,228 | £86,111 | £98,547 | £84,923 | £93,885 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | £3,981 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £38,239 | £66,527 | £80,153 | £86,206 | £94,955 | £102,293 | £99,500 | £101,209 | £90,092 | £102,528 | £88,904 | £97,866 | |
| Net Cash Flow | £17,839 | (£2,438) | (£7,224) | (£3,885) | £4,494 | (£82) | £5,473 | (£7,285) | £14,881 | (£8,604) | £10,545 | £1,583 | |
| Cash Balance | £164,819 | £162,381 | £155,157 | £151,272 | £155,765 | £155,683 | £161,157 | £153,871 | £168,752 | £160,148 | £170,693 | £172,276 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £146,980 | £164,819 | £162,381 | £155,157 | £151,272 | £155,765 | £155,683 | £161,157 | £153,871 | £168,752 | £160,148 | £170,693 | £172,276 |
| Inventory | £27,500 | £21,337 | £24,385 | £27,749 | £31,322 | £37,839 | £38,890 | £39,941 | £35,737 | £39,941 | £35,737 | £37,839 | £37,839 |
| Other Current Assets | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 | £73,311 |
| Total Current Assets | £247,791 | £259,467 | £260,077 | £256,217 | £255,905 | £266,915 | £267,884 | £274,409 | £262,919 | £282,004 | £269,196 | £281,843 | £283,426 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Accumulated Depreciation | £0 | £542 | £1,083 | £1,625 | £2,167 | £2,708 | £3,250 | £3,792 | £4,333 | £4,875 | £5,417 | £5,958 | £6,500 |
| Total Long-term Assets | £65,000 | £64,458 | £63,917 | £63,375 | £62,833 | £62,292 | £61,750 | £61,208 | £60,667 | £60,125 | £59,583 | £59,042 | £58,500 |
| Total Assets | £312,791 | £323,925 | £323,994 | £319,592 | £318,738 | £329,207 | £329,634 | £335,617 | £323,586 | £342,129 | £328,779 | £340,885 | £341,926 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £27,825 | £41,252 | £47,012 | £55,505 | £62,942 | £60,075 | £62,184 | £50,621 | £63,538 | £49,604 | £58,580 | £58,194 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £27,825 | £41,252 | £47,012 | £55,505 | £62,942 | £60,075 | £62,184 | £50,621 | £63,538 | £49,604 | £58,580 | £58,194 |
| Long-term Liabilities | £300,000 | £296,019 | £292,038 | £288,057 | £284,076 | £280,095 | £276,114 | £272,133 | £268,152 | £264,171 | £260,190 | £256,209 | £252,228 |
| Total Liabilities | £300,000 | £323,844 | £333,290 | £335,069 | £339,581 | £343,037 | £336,189 | £334,317 | £318,773 | £327,709 | £309,794 | £314,789 | £310,422 |
| Paid-in Capital | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 | £440,000 |
| Retained Earnings | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) | (£427,209) |
| Earnings | £0 | (£12,710) | (£22,087) | (£28,269) | (£33,634) | (£26,621) | (£19,346) | (£11,491) | (£7,979) | £1,629 | £6,194 | £13,305 | £18,712 |
| Total Capital | £12,791 | £82 | (£9,296) | (£15,478) | (£20,843) | (£13,829) | (£6,555) | £1,300 | £4,813 | £14,420 | £18,985 | £26,096 | £31,504 |
| Total Liabilities and Capital | £312,791 | £323,925 | £323,994 | £319,592 | £318,738 | £329,207 | £329,634 | £335,617 | £323,586 | £342,129 | £328,779 | £340,885 | £341,926 |
| Net Worth | £12,791 | £82 | (£9,296) | (£15,478) | (£20,843) | (£13,829) | (£6,555) | £1,300 | £4,813 | £14,420 | £18,985 | £26,096 | £31,504 |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| General Manager (Year 2+) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Partner/Manager | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Partner/Asst. Manager/Exec. Chef | 0% | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 | £2,680 |
| Hostess (Full Time) | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Hostess (Part Time) | 0% | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Waitperson 1 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 2 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 3 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 4 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 5 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 6 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 7 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 8 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Waitperson 9 | 0% | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 | £470 |
| Wait/Barperson | 0% | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 | £870 |
| Bartender 1 | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Bartender 2 | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Busboy 1 | 0% | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 |
| Busboy 2 | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
| Busboy 3 | 0% | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Assistant Chef | 0% | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 |
| Sous Chef | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
| Cook 1 | 0% | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 | £2,020 |
| Cook 2 | 0% | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 | £1,580 |
| Prep Cook/Dishwasher | 0% | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 | £1,024 |
| Prep Cook/Dishwasher/Cleaning | 0% | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 |
| Dishwasher 1 | 0% | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 |
| Dishwasher 2 | 0% | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 | £475 |
| Cleaning/Dishwasher | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
| Open | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | |
| Total Payroll | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | £33,299 | |