Moose Mountain 0
Moose Mountain 0
Moose Mountain 0
The Business
Moose Mountain Caf has selected the sole proprietorship as its formal legal entity. This structure was chosen because of its operational simplicity. Although this structure exposes the owner to unlimited liability, risk management and insurance protection will be established to offset this risk. Moose Mountain Caf will be an independent, start-up venture. The proposed starting date for the venture will be 07/04/2010. This business plan documents the precise strategies and activities that will be taken in order to commence operations of the business. The Moose Mountain Caf will be located at 200 Main Street, Moose Mountain, NH, with seating for 20 patrons. The rent is $600 a month, with a five-year lease available. The site consists of a 20 x 20 square-foot dining room, a 15 x 15 square-foot kitchen, two bathrooms, and a storage room in back. To be used as a restaurant, this storefront needs to be plumbed and wired appropriately. Painting, new floors, and countertops are also needed. With materials bought on sale and volunteer labor, the cost to renovate will be $5,000. The kitchen will be equipped with a commercial stove, refrigerator, freezer, walk-incooler, oven, microwave, and small commercial dishwasher. With bargain (but quality) equipment, the cost will be $20,000. The walk-in cooler will be custom-built. Other startup expenses will be dishes, furniture, food inventory, rent deposit, and marketing. The Moose Mountain Caf will serve a basic American-style breakfast and lunch, with an emphasis on healthy, tasty food. Low-fat recipes will be used whenever possible in such a way as not to sacrifice taste or appeal. Menu items for breakfast will range from $1.99 4.99. Lunch items will range from $2.50 - 5.99. Daily soups and specials will be offered. See the attached menu for details. Hours of operation will be 6:30 a.m. - 2:30 p.m., 6 days a week, and 8:00 a.m. - 3:00 p.m., Sundays. Rosie Jenkins will be head cook, and additional staff will consist of a part-time back-up cook and two waitresses. During slow times, only one waitress will be used. Experienced staff members have already been located.
Marketing
The Industry
Eating out is a growing trend, since people are increasingly pressed for time and enjoy this convenience. Breakfast and lunch are popular, as workers and business owners often choose not to brown bag meals. Choosing healthy, low-fat food is a concern, but studies have shown that people are ambivalent about it and continue to choose high-fat foods. The menu will address this by preparing favorites in such a way that people wont realize that much of the unhealthy fat has been removed.
Target Market
Business Owners & Workers - During the week, 2000 people work in Moose Mountain. Most of them work early in the morning, so the Caf will open at 6:30. This group includes managers, factory employees, retail clerks, professionals, tradesmen, laborers, and other food service workers. This group will form the base clientele, as many will be repeat customers. A number of tradesmen have promised to patronize the caf every day. Fast, accurate service will be provided, as these customers often have limited time to eat. Local Residents & Workers - Small ads will be placed weekly in the dining section of the local newspaper. Specials will be promoted with an A-frame sign and, during slow periods, coupons and 2-for-1 deals will be offered. Menus will be distributed to local businesses and faxing in orders will be encouraged. Take-out will be attractively boxed and given equal priority to sit-down services. Tourists - Menus will be distributed to the local lodging establishments to encourage their guests to come to the Caf. Advertisements and listings will be placed in statewide and regional tourist guides and publications. Menus will also be placed at information booths and other spots likely to have tourist traffic. Other Moose Mountain Community College is nearby. Students there are likely to visit Moose Mountain Caf on the weekends, on very nice days and during their holiday periods. Flyers will be distributed on campus during those times, offering the students a percentage discount on certain meals and during certain times.
Competitive Analysis
The Competition - The Competitor Matrix below shows the Moose Mountain Caf in comparison to its competitors: Seats Meals Pricing Hours Other Moose Mountain Caf Dunkin Donuts Local Donuts Auntie Ems 20 Breakfast/Lunch * 6:30a.m.2:30p.m 24 hours 7:00a.m.3:00p.m. 7:00a.m.9:00p.m 7:00a.m.9:00p.m 24 hours no full meals no full breakfast Outdated menu/high priced/ other end of Main Street owners ready to retire/old building/ no parking/slow service no seating or full meals
20 10 30
Donuts/Soups
50
3 meals/day
**
none pastries/coffee
Marketing Strategy
In addition to an overall strategy, different actions and methods will be used for each of the target markets.
Marketing Actions
Local Residents & Workers - Small ads will be placed weekly in the dining section of the local newspaper. Specials will be promoted with an A-frame sign and during slow periods coupons and 2-for-1 deals will be offered. Menus will be distributed to local businesses and the faxing-in of orders will be encouraged. Take-out will be attractively boxed and given equal priority to sit-down services. Tourists - Menus will be distributed to the local lodging establishments to encourage their guests to come to the Caf. Advertisements and listings will be placed in state wide and regional tourist guides and publications. Menus will also be placed at information booths and other spots likely to have tourist traffic. Other - Pricing will be competitive and customer service excellent. If anyone is not satisfied, the item will be replaced or taken off the bill. The Caf will leverage the internet as part of its marketing presence. Its website is http://www.moosecoffee.com.
Welcome:
This spreadsheet walks you through the process of developing an integrated set of financial projections. To use this model, simply complete any information asked for found in the color blue. A number found in the color red, is information that has been provided but can be modified. Otherwise any information found in black type is automatically calculated for you. Also, many cells have comments provided to clarify certain types of information. These comments can be viewed by finding the red arrow as shown below:
By placing your cursor over the cell as shown above, you should be able to see the cell's comments. Before we begin, we need some information about your business to best customize your financial statements. Please enter the name of your business in the box below: Moose Mountain Cafe
The first seven worksheets in this workbook are steps you will need to complete. They are titled: 1. Required Funds 2. Sources of Capital 3. Monthly Budget 4. Gross Margins 5. Sales Forecast 6. Cash Receipts The seventh step titled, "Current Balance Sheet" is for existing businesses only. The last four worksheets are your prepared financial statements based upon the information you have entered. They are as follows: Income Statement Cash Flow Statement Balance Sheet Break-Even To begin, click on the first worksheet tab below titled, "Required Funds."
How much initial money do you require and what will it be used for? Item Fixed Assets -Real Estate -Buildings -Leasehold Improvements -Equipment -Furniture and Fixtures -Vehicles -Other Fixed Operating Capital -Salaries and Wages -Insurance Premiums -Beginning Inventory -Legal and Accounting Fees -Rent Deposits -Utility Deposits -Supplies -Advertising and Promotions -Licenses -Other Initial Costs -Working Capital (Cash On Hand) Amount Totals Depreciation
5,000 20,500 1,000 26,500 2,400 5,000 600 500 1,000 2,000 2,000 13,500
20 7 7 5 5 5
Amortization years
40,000
Funds Required: (from previous statement) -Operating Capital -Buildings and Real Estate Mortgage Total Funds Required
40,000 40,000
Owner's Injection: -How much will the owner(s) put into the business? -Recommended Minimum Level -Owner's injection as a percent of the total
$ $
30,000
Recommended Financing Structure: -Commercial Loan -Interest Rate -Term in Months -Monthly Loan Payment Amount -Commercial Mortgage -Interest Rate -Term in Months -Monthly Loan Payment Amount Total Monthly Loan Payments
Number of Fixed Salary Employees Salaries and Wages Owner's Compensation Salaries Social Security Medicare Federal Unemployment Tax State Unemployment Tax Worker's Compensation Employee Benefit Programs Total Salaries and Wages Business Expenses Advertising Car and Truck Expenses Credit Card Charges Insurance Legal and Accounting Fees Office Expenses Postage and Shipping Rent on Business Property Rent on Equipment Repairs Supplies Telephone Travel Utilities Miscellaneous Expenses Total Business Expenses Total Operating Expenses
0 Monthly 3,000 3,574 408 95 16 117 7,209 Annual 36,000 42,888 4,891 1,144 189 1,400 86,512 Wage Base Limit
$ $ $
2,400 3,000 200 7,200 600 2,000 1,200 4,800 21,400 107,913
Year Two Salary and Wages Percent Change Business Expenses Percent Change Year Three Salary and Wages Percent Change Business Expenses Percent Change
0% 0%
0% 0%
What are the direct costs for producing your products and services and what margins will you achieve? Products -Type of Units -Average Price per Unit -Average Material Costs per Unit -Average Labor Costs per Unit -Total Product Costs per Unit -Gross Margin per Unit -Year Two Price per Unit -Year Two Total Costs per Unit -Year Three Price per Unit -Year Three Total Costs per Unit Dollars Food/Beverage $ 0.40 $ $ $ $ $ $ 0.40 0.60 1.00 0.40 1.00 0.40 40.00% 60.00% 1.00 100.00% Percent
Product / Service 2 -Type of Units -Average Price per Unit -Average Material Costs per Unit -Average Labor Costs per Unit -Total Product Costs per Unit -Gross Margin per Unit -Year Two Price per Unit -Year Two Total Costs per Unit -Year Three Price per Unit -Year Three Total Costs per Unit
Dollars Services $ $ $ $ $ $ $ -
Percent 100.00%
0.00% 0.00%
Product / Service 3 -Type of Units -Average Price per Unit -Average Material Costs per Unit -Average Labor Costs per Unit -Total Product Costs per Unit -Gross Margin per Unit -Year Two Price per Unit -Year Two Total Costs per Unit -Year Three Price per Unit -Year Three Total Costs per Unit
Dollars Hours $ $ $ $ $ $ $ -
Percent 100.00%
0.00% 0.00%
Thinking about seasonality and business growth what are the forecasted unit sales for each category?
Product / Service: Type of Units: 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 Unit Sales
Products Food/Beverage 12,600 25,200 25,200 25,200 12,600 8,400 12,600 12,600 12,600 8,400 12,600 12,600 180,600
Year Two
Products
Product / Service 2
Product / Service 3
ENTER A: Year Two Percent Change or ENTER B: 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 Unit Sales
20% 30,240 30,240 30,240 30,240 15,120 10,080 15,120 15,120 15,120 10,080 15,120 15,120 231,840
0% -
0% -
Year Three ENTER A: Year Three Percent Change or ENTER B: 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 Unit Sales
Products 35% 40,824 40,824 40,824 40,824 20,412 13,608 20,412 20,412 20,412 13,608 20,412 20,412 312,984
Product / Service 2 0% -
Product / Service 3 0% -
Once a sale is made, what percent of the money do you collect during the following time periods? 0 to 30 days 31 to 60 days More than 60 days 100.00% 0.00% 0.00% 100.00%
Line of Credit Preferences: Desired Minimum Cash Balance: Line of Credit Interest Rate:
10.00%
0.00%
Moose Mountain Cafe Current Balance Sheet (Existing Business Only) 12/31/2004 For the period ending on
Please list the value of your business assets in dollars: Assets (Stuff you have) -Cash -Accounts Receivable -Inventory -Prepaid Expenses -Other Current Assets -Improvements -Furniture and Fixtures -Equipment -Real Estate -Buildings -Other Fixed -Accumulated Depreciation Total Assets $
Please list the value of your business liabilities: Liabilities (What you owe) -Accounts Payable -Notes Payable -Mortgage Payable -Other Liabilities Total Liabilities
Please list the Owner's Equity (What you own) -Common Stock -Retained Earnings Total Owner's Equity Total Liabilities and Equity $
must be zero
Moose Mountain Cafe PROJECTED INCOME STATEMENT Month 1 Income: Products Product / Service 2 Product / Service 3 Total Income Cost of Sales: Products Product / Service 2 Product / Service 3 Total Cost of Sales Gross Margin Salaries and Wages: Owner's Compensation Salaries Payroll Taxes Worker's Compensation Employee Benefit Programs Total Salaries and Wages Business Expenses: Advertising Car and Truck Expenses Credit Card Charges Insurance Legal and Accounting Fees Office Expenses Postage and Shipping Rent on Business Property Rent on Equipment Repairs Supplies Telephone Travel Utilities Miscellaneous Expenses Amortized Start-up Expenses Depreciation Total Business Expenses Less Interest Expense: Commercial Loan Commercial Mortgage Line of Credit Total Interest Expense Net Operating Profit Less: Income Taxes Net Profit (Loss) Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Totals %
12,600 12,600
25,200 25,200
25,200 25,200
25,200 25,200
12,600 12,600
8,400 8,400
12,600 12,600
12,600 12,600
12,600 12,600
8,400 8,400
12,600 12,600
12,600 12,600
12,600
250 17 600 -
2,200 3,000 200 7,200 550 1,837 1,200 4,800 3,843 24,830 13.75%
Moose Mountain Cafe PROJECTED CASH FLOW STATEMENT Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Totals
2,000
8,659
14,133
19,608
25,083
22,997
18,392
16,307
14,221
12,136
7,531
5,445
12,600 12,600
25,200 25,200
25,200 25,200
25,200 25,200
12,600 12,600
8,400 8,400
12,600 12,600
12,600 12,600
12,600 12,600
8,400 8,400
12,600 12,600
12,600 12,600
180,600 180,600
Cash Outflows Capital Purchases Cost of Sales Salaries and Wages Business Expenses Income Taxes Loan Payments Line of Credit Interest Line of Credit Repayments Total Cash Outflows
8,659
14,133
19,608
25,083
22,997
18,392
16,307
14,221
12,136
7,531
5,445
3,360
8,659
14,133
19,608
25,083
22,997
18,392
16,307
14,221
12,136
7,531
5,445
3,360
Moose Mountain Cafe Pro Forma Balance Sheet Base Period Assets Current Assets Cash Accounts Receivable Inventory Prepaid Expenses Other Current Total Current Assets Fixed Assets Improvements Furniture and Fixtures Equipment Real Estate Buildings Other Fixed Total Fixed Assets Less: Accumulated Depreciation Total Assets End of Year One
Liabilities and Owner's Equity Liabilities Accounts Payable Notes Payable Mortgage Payable Line of Credit Balance Total Liabilities Owner's Equity Common Stock Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity
25,237 25,237
Statement Balances
Annual Fixed Costs: Cost of Sales as a Percent of Sales: Contribution Margin as a Percent of Sales:
111,120 62.79%
176,969
Financial Diagnostics This sheet performs a few tests on your numbers to see if they seem within certain reasonable ranges. Remember, no computer can tell whether your projections are truly well-constructed, only a human can do that. But these tests can at least look for values that are critically out of range.
Test Condition General Financing Assumptions: Owner's Injection into the Business Cash Request as Percent of Total Required Funds
Value
Findings:
10,000.00 5.00%
Owner's Injection is adequate Cash request seems reasonable with total request
Loan Assumptions: Commercial Loan Interest Rate Commercial Loan Term in Months Commercial Mortgage Interest Rate Commercial Mortgage Term in Months Loan Payments as a Percent of Projected Sales
Interest rate seems reasonable Loan term seems within range for this type of loan Interest rate seems reasonable Loan term seems within range for this type of loan Calculated loan payments as a percent of sales seem resonable
Income Statement: Gross Margin as a Percent of Sales Owner's Compensation Lower Limit Check Owner's Compensation Upper Limit Check Advertising Expense Levels as a Percent of Sales Profitability Levels Profitability as a Percent of Sales
Gross margin percentage seems reasonable An owner's compensation amount has been established Owner's compensation may be too high relative to profitability of business Advertising as a percent of sales may be too low The business is showing a profit The projection does not seem highly unreasonable
Cash Flow Statement Desired Operating Cash Flow Levels Line of Credit Drawdowns Accounts Receivable Ratio to Sales
$ $
0.00%
The financial projection provides the desired level of cash flow The business doesn't seem to require a line of credit Accounts receivable amount as a percent of sales seems reasonable
Balance Sheet Statement Does the Base Period Balance Sheet Balance? Does the Final Balance Sheet Balance? Debt to Equity Ratios
2.06
The balance sheet does balance The balance sheet does balance The debt to equity ratio seems reasonable
3,631
Income: Products Product / Service 2 Product / Service 3 Total Income Cost of Sales: Products Product / Service 2 Product / Service 3 Total Cost of Sales Gross Margin Salaries and Wages: Owner's Compensation Salaries Payroll Taxes Worker's Compensation Employee Benefit Programs Total Salaries and Wages Business Expenses: Advertising Car and Truck Expenses Credit Card Charges Insurance Legal and Accounting Fees Office Expenses Postage and Shipping Rent on Business Property Rent on Equipment Repairs Supplies Telephone Travel Utilities Miscellaneous Expenses Amortized Start-up Expenses Depreciation Total Business Expenses Less Interest Expense: Commercial Loan Commercial Mortgage Line of Credit Total Interest Expense Net Opertating Profit Less: Income Taxes Net Operating Profit
37.21% 62.79%
40.00% 60.00%
40.00% 60.00%
46.08%
37.32%
27.64%
2,200 3,000 200 7,200 550 1,837 1,200 4,800 3,843 24,830
13.75%
2,400 3,000 200 7,200 600 2,000 1,200 4,800 3,843 25,243
10.89%
2,400 3,000 200 7,200 600 2,000 1,200 4,800 3,843 25,243
8.07%
1.70%
1.08%
0.61%
1.26%
24,835
10.71%
74,136
23.69%
2.06 0.24
0.54 1.44
0.13 5.57
Profitability Sales Growth COGS to Sales Gross Profit Margin SG&A to Sales Net Profit Margin Return on Equity Return on Assets Owners Compensation to Sales
Efficiency Days in Receivables Accounts Receivable Turnover Days in Inventory Inventory Turnover Sales to Total Assets
Moose Mountain Cafe YEAR 2 PROJECTED INCOME STATEMENT Month 1 Income: Products Product / Service 2 Product / Service 3 Total Income Cost of Sales: Products Product / Service 2 Product / Service 3 Total Cost of Sales Gross Margin Salaries and Wages: Owner's Compensation Salaries Payroll Taxes Worker's Compensation Employee Benefit Programs Total Salaries and Wages Business Expenses: Advertising Car and Truck Expenses Credit Card Charges Insurance Legal and Accounting Fees Office Expenses Postage and Shipping Rent on Business Property Rent on Equipment Repairs Supplies Telephone Travel Utilities Miscellaneous Expenses Amortized Start-up Expenses Depreciation Total Business Expenses Less Interest Expense: Commercial Loan Commercial Mortgage Line of Credit Total Interest Expense Net Operating Profit Less: Income Taxes Net Profit (Loss)
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Totals
30,240 30,240
30,240 30,240
30,240 30,240
30,240 30,240
15,120 15,120
10,080 10,080
15,120 15,120
15,120 15,120
15,120 15,120
10,080 10,080
15,120 15,120
15,120 15,120
2,400 3,000 200 7,200 600 2,000 1,200 4,800 3,843 25,243 10.89%
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Totals
3,360
11,859
20,358
28,857
37,356
36,783
33,186
32,613
32,040
31,467
27,870
27,297
30,240 30,240
30,240 30,240
30,240 30,240
30,240 30,240
15,120 15,120
10,080 10,080
15,120 15,120
15,120 15,120
15,120 15,120
10,080 10,080
15,120 15,120
15,120 15,120
231,840 231,840
Cash Outflows Capital Purchases Cost of Sales Salaries and Wages Business Expenses Income Taxes Loan Payments Line of Credit Interest Line of Credit Repayments Total Cash Outflows
11,859
20,358
28,857
37,356
36,783
33,186
32,613
32,040
31,467
27,870
27,297
26,724
11,859
20,358
28,857
37,356
36,783
33,186
32,613
32,040
31,467
27,870
27,297
26,724
Moose Mountain Cafe Year 2 Pro Forma Balance Sheet End of Year One Assets Current Assets Cash Accounts Receivable Inventory Prepaid Expenses Other Current Total Current Assets Fixed Assets Improvements Furniture and Fixtures Equipment Real Estate Buildings Other Fixed Total Fixed Assets Less: Accumulated Depreciation Total Assets End of Year Two
Liabilities and Owner's Equity Liabilities Accounts Payable Notes Payable Mortgage Payable Line of Credit Balance Total Liabilities Owner's Equity Common Stock Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity
25,237 25,237
19,924 19,924
Statement Balances
Moose Mountain Cafe YEAR 3 PROJECTED INCOME STATEMENT Month 1 Income: Products Product / Service 2 Product / Service 3 Total Income Cost of Sales: Products Product / Service 2 Product / Service 3 Total Cost of Sales Gross Margin Salaries and Wages: Owner's Compensation Salaries Payroll Taxes Worker's Compensation Employee Benefit Programs Total Salaries and Wages Business Expenses: Advertising Car and Truck Expenses Credit Card Charges Insurance Legal and Accounting Fees Office Expenses Postage and Shipping Rent on Business Property Rent on Equipment Repairs Supplies Telephone Travel Utilities Miscellaneous Expenses Amortized Start-up Expenses Depreciation Total Business Expenses Less Interest Expense: Commercial Loan Commercial Mortgage Line of Credit Total Interest Expense Net Operating Profit Less: Income Taxes Net Profit (Loss)
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Totals
40,824 40,824
40,824 40,824
40,824 40,824
40,824 40,824
20,412 20,412
13,608 13,608
20,412 20,412
20,412 20,412
20,412 20,412
13,608 13,608
20,412 20,412
20,412 20,412
312,984 312,984
100.00%
2,400 3,000 200 7,200 600 2,000 1,200 4,800 3,843 25,243 8.07%
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Totals
26,724
41,573
56,423
71,272
86,122
88,724
87,244
89,846
92,448
95,050
93,570
96,172
40,824 40,824
40,824 40,824
40,824 40,824
40,824 40,824
20,412 20,412
13,608 13,608
20,412 20,412
20,412 20,412
20,412 20,412
13,608 13,608
20,412 20,412
20,412 20,412
231,840 312,984
Cash Outflows Capital Purchases Cost of Sales Salaries and Wages Business Expenses Income Taxes Loan Payments Line of Credit Interest Line of Credit Repayments Total Cash Outflows
41,573
56,423
71,272
86,122
88,724
87,244
89,846
92,448
95,050
93,570
96,172
98,775
41,573
56,423
71,272
86,122
88,724
87,244
89,846
92,448
95,050
93,570
96,172
98,775
Moose Mountain Cafe Year 3 Pro Forma Balance Sheet End of Year Two Assets Current Assets Cash Accounts Receivable Inventory Prepaid Expenses Other Current Total Current Assets Fixed Assets Improvements Furniture and Fixtures Equipment Real Estate Buildings Other Fixed Total Fixed Assets Less: Accumulated Depreciation Total Assets End of Year Three
Liabilities and Owner's Equity Liabilities Accounts Payable Notes Payable Mortgage Payable Line of Credit Balance Total Liabilities Owner's Equity Common Stock Retained Earnings Total Owner's Equity Total Liabilities and Owner's Equity
19,924 19,924
13,995 13,995
Statement Balances