Visit our US site at: www.bplans.comhide this bar
 
Edit This Plan

Coffee Distribution Business Plan

The Coffee Warehouse

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Appendix

Sales Forecast
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Sales
Espresso Syrups 0% £14,322 £16,470 £18,941 £21,782 £25,049 £28,807 £33,128 £38,097 £43,811 £50,383 £57,940 £66,632
Chocolate & Caramel Sauces 0% £10,465 £12,034 £13,839 £15,915 £18,303 £21,048 £21,048 £24,205 £27,836 £32,011 £36,813 £42,335
Specialty Beverage Mixes 0% £8,626 £6,363 £3,759 £4,006 £4,242 £4,732 £7,887 £10,498 £21,167 £30,347 £34,899 £40,134
Energy Drinks 0% £1,530 £1,760 £2,023 £2,327 £2,676 £3,077 £3,539 £4,070 £4,680 £5,382 £6,190 £7,118
Concentrated Milk 0% £1,530 £2,924 £3,520 £4,245 £5,128 £6,360 £7,914 £9,882 £12,379 £15,556 £19,604 £24,774
Paper Supplies 0% £51,400 £47,414 £43,114 £45,849 £51,378 £58,075 £68,506 £85,766 £123,777 £177,815 £202,120 £230,071
Marketing 0% £700 £805 £910 £1,015 £1,155 £1,295 £1,470 £1,680 £1,890 £2,170 £2,450 £2,765
Total Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Espresso Syrups £11,908 £13,694 £15,748 £18,110 £20,827 £23,951 £27,544 £31,675 £36,426 £41,890 £48,174 £55,400
Chocolate & Caramel Sauces £8,441 £9,707 £11,163 £12,837 £14,763 £16,977 £19,524 £22,453 £25,821 £29,694 £34,148 £39,270
Specialty Beverage Mixes £6,496 £4,866 £2,981 £3,192 £3,401 £3,802 £6,168 £8,145 £16,035 £22,852 £26,280 £30,222
Energy Drinks £1,260 £1,449 £1,666 £1,916 £2,204 £2,534 £2,914 £3,352 £3,854 £4,433 £5,097 £5,862
Concentrated Milk £1,308 £2,509 £3,022 £3,646 £4,405 £5,465 £6,804 £8,499 £10,651 £13,389 £16,880 £21,339
Paper Supplies £38,550 £35,560 £32,335 £34,387 £38,534 £43,556 £51,379 £64,325 £92,833 £133,361 £151,590 £172,554
Marketing £250 £288 £325 £363 £413 £463 £525 £600 £675 £775 £875 £988
Subtotal Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Personnel Plan
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Jennifer Smith 0% £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500
Sales/Delivery (Salary) 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Sales/Delivery (Commission) 0% £170 £192 £216 £240 £268 £300 £336 £379 £429 £493 £565 £649
Delivery/Warehouse Personnel 0% £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Administration 0% £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560 £1,560
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
General Assumptions
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Direct Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Hidden Row £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £68,213 £68,073 £67,240 £74,451 £84,546 £96,749 £114,858 £139,049 £186,297 £246,395 £283,045 £325,635
Gross Margin £20,360 £19,697 £18,866 £20,688 £23,385 £26,645 £28,634 £35,149 £49,243 £67,269 £76,971 £88,194
Gross Margin % 22.99% 22.44% 21.91% 21.74% 21.67% 21.59% 19.96% 20.18% 20.91% 21.45% 21.38% 21.31%
Expenses
Payroll £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Rent £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758 £2,758
Utilities and Phone £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Insurance £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Payroll Burden 15% £1,145 £1,148 £1,151 £1,155 £1,159 £1,164 £1,169 £1,176 £1,183 £1,193 £1,204 £1,216
Leased Equipment (Delivery Vehicles) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Leased Equipment (Warehouse) £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250 £250
Leased Equipment (Other) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Fuel (delivery) £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Advertising / Promotion £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Professional Services 15% £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Miscellaneous (office supplies, etc) £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Total Operating Expenses £15,783 £15,808 £15,835 £15,863 £15,895 £15,932 £15,973 £16,023 £16,080 £16,154 £16,237 £16,333
Profit Before Interest and Taxes £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
EBITDA £4,578 £3,889 £3,030 £4,825 £7,490 £10,713 £12,661 £19,126 £33,163 £51,116 £60,735 £71,861
Interest Expense £620 £607 £593 £580 £567 £553 £540 £527 £513 £500 £487 £473
Taxes Incurred £1,187 £821 £609 £1,061 £1,731 £2,540 £3,030 £4,650 £8,162 £12,654 £15,062 £17,847
Other Income
Interest Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Income Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense
Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other Expense Account Name £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Other Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Other Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Net Profit £2,770 £2,462 £1,828 £3,184 £5,192 £7,620 £9,090 £13,950 £24,487 £37,962 £45,186 £53,541
Net Profit/Sales 3.13% 2.80% 2.12% 3.35% 4.81% 6.18% 6.34% 8.01% 10.40% 12.10% 12.55% 12.94%
Pro Forma Cash Flow
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Cash Received
Cash from Operations
Cash Sales £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Subtotal Cash from Operations £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Additional Cash Received
Non Operating (Other) Income £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
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 £88,573 £87,770 £86,106 £95,139 £107,931 £123,394 £143,492 £174,198 £235,540 £313,664 £360,016 £413,829
Expenditures Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Expenditures from Operations
Cash Spending £7,630 £7,652 £7,676 £7,700 £7,728 £7,760 £7,796 £7,839 £7,889 £7,953 £8,025 £8,109
Bill Payments £2,607 £78,184 £77,442 £76,236 £92,651 £106,626 £122,274 £147,608 £181,556 £257,760 £334,299 £348,850
Subtotal Spent on Operations £10,237 £85,836 £85,118 £83,936 £100,379 £114,386 £130,070 £155,447 £189,445 £265,713 £342,324 £356,959
Additional Cash Spent
Non Operating (Other) Expense £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Sales Tax, VAT, HST/GST Paid Out £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Principal Repayment of Current Borrowing £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Other Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Long-term Liabilities Principal Repayment £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
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 £12,237 £87,836 £87,118 £85,936 £102,379 £116,386 £132,070 £157,447 £191,445 £267,713 £344,324 £358,959
Net Cash Flow £76,336 (£66) (£1,012) £9,203 £5,552 £7,008 £11,422 £16,751 £44,095 £45,951 £15,692 £54,870
Cash Balance £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Pro Forma Balance Sheet
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Assets Starting Balances
Current Assets
Cash £9,800 £86,136 £86,071 £85,059 £94,262 £99,813 £106,821 £118,243 £134,994 £179,089 £225,039 £240,731 £295,601
Inventory £75,000 £75,034 £74,880 £73,964 £81,896 £93,001 £106,424 £126,344 £152,954 £204,926 £271,034 £311,349 £358,198
Other Current Assets £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750 £18,750
Total Current Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,765 £514,823 £570,830 £672,549
Long-term Assets
Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Accumulated Depreciation £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Long-term Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Assets £103,550 £179,920 £179,701 £177,773 £194,908 £211,564 £231,995 £263,337 £306,698 £402,76