just in seafood market

22
January 2002 This sample business plan has been made available to users of Business Plan Pro™, business planning software published by Palo Alto Software. Names, locations and numbers may have been changed, and substantial portions of text may have been omitted from the original plan to preserve confidentiality and proprietary information. You are welcome to use this plan as a starting point to create your own, but you do not have permission to reproduce, publish, distribute or even copy this plan as it exists here. Requests for reprints, academic use, and other dissemination of this sample plan should be emailed to the marketing department of Palo Alto Software at [email protected]. For product information visit our Website: www.paloalto.com or call: 1-800-229-7526. Copyright Palo Alto Software, Inc., 1995-2002

Upload: sakibk2008

Post on 17-Nov-2014

117 views

Category:

Documents


1 download

DESCRIPTION

Seafood Market

TRANSCRIPT

Page 1: Just in Seafood Market

January 2002

This sample business plan has been made available to users of Business Plan Pro™, business planning software published by Palo Alto Software. Names, locations and numbers may have been changed, and substantial portions of text may have been omitted from the original plan to preserve confidentiality and proprietary information.

You are welcome to use this plan as a starting point to create your own, but you do not have permission to reproduce, publish, distribute or even copy this plan as it exists here.

Requests for reprints, academic use, and other dissemination of this sample plan should be emailed to the marketing department of Palo Alto Software at [email protected]. For product information visit our Website: www.paloalto.com or call: 1-800-229-7526.

Copyright Palo Alto Software, Inc., 1995-2002

Page 2: Just in Seafood Market

Confidentiality Agreement

The undersigned reader acknowledges that the information provided by _________________________ in this business plan is confidential; therefore, reader agrees not to disclose it without the express written permission of _________________________.

It is acknowledged by reader that information to be furnished in this business plan is in all respects confidential in nature, other than information which is in the public domain through other means and that any disclosure or use of same by reader, may cause serious harm or damage to _________________________.

Upon request, this document is to be immediately returned to _________________________.

___________________ Signature

___________________Name (typed or printed)

___________________Date

This is a business plan. It does not imply an offering of securities.

Page 3: Just in Seafood Market

1.0 Executive Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11.1 Objectives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11.2 Mission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21.3 Keys to Success . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

2.0 Company Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22.1 Company Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22.2 Company History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22.3 Company Locations and Facilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

3.0 Products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

4.0 Market Analysis Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44.1 Market Segmentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

5.0 Strategy and Implementation Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55.1 Competitive Edge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65.2 Sales Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

5.2.1 Sales Forecast . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

6.0 Management Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86.1 Personnel Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

7.0 Financial Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97.1 Break-even Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97.2 Projected Profit and Loss . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107.3 Projected Cash Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117.4 Projected Balance Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137.5 Business Ratios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Table of Contents

Page 4: Just in Seafood Market

1.0 Executive Summary

Justin Seafood Market has been providing customers with the finest quality seafood for five years. The business is primarily wholesale to area restaurants. We purchase seafood directly from local fishermen and contacts all along the Florida panhandle. This allows us to pick from the finest selection of seafood available anywhere. Currently, we sell to over sixty restaurants. This a 10% increase over last year and we estimate that we will have additional restaurants as customers next year.

Justin Seafood Market plans to expand our storefront and sell direct to the public. In our expanded market, we will bring our commitment of quality, freshness and great prices to the public. By purchasing in large quantities we are able to pass the savings on to our customer.

The planned renovation will cost $150,000. Additional service staff will be hired to assist customers. Bill Justin, owner of Justin Seafood Market, will invest $50,000 in the expansion and also secure a $100,000 short-term loan.

$0

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

$1,400,000

$1,600,000

2002 2003 2004

Sales

Gross Margin

Net Profit

Highlights (Planned)

1.1 Objectives

• Establish Justin Seafood Market as the leader in selling fresh seafood to the public. • Increase the number of customers buying from Justin Seafood Market by 10% over the

next two years.• Establish a Seafood Discount Club for customers that will build customer loyalty.

Justin Seafood Market

Page 1

Page 5: Just in Seafood Market

1.2 Mission

The mission of Justin Seafood Market is to offer customers the best seafood prices on the highest quality seafood.

1.3 Keys to Success

• Superior products will promote customer loyalty.• A location that will assure walk-in traffic.• A program that will create customer loyalty.

2.0 Company Summary

Justin Seafood Market is primarily a wholesaler to area restaurants. Bill Justin, owner of Justin Seafood Market, has utilized his wholesale background, his experience in the restaurant industry, and his contacts with the area's fishermen to build a loyal customer base.

Bill wants to open a seafood market to the public by renovating the building's storefront to accommodate the public.

2.1 Company Ownership

Bill Justin is the owner of Justin Seafood Market.

2.2 Company History

Bill Justin started Justin Seafood Market in 1996 in response to the dramatic growth of the Florida panhandle. Over the past five years, the population has increased by 30% in communities along the panhandle. But most importantly, tourists have returned to the area. In 2000, tourists spent over 400 million dollars with panhandle businesses. A significant portion of those sales were with the area's loyalty. Currently, there are over 1,350 restaurants but that number grows by 15% annually.

Against this backdrop of growth, Bill Justin launched his market. Starting with ten customers in 1996, Justin Seafood Market now serves sixty restaurants.

Justin Seafood Market

Page 2

Page 6: Just in Seafood Market

Table: Past Performance

Past Performance1999 2000 2001

Sales $560,000 $644,000 $710,600Gross Margin $270,000 $320,000 $350,000Gross Margin % 48.21% 49.69% 49.25%Operating Expenses $150,000 $170,000 $190,000Collection Period (Days) 0 0 0Inventory Turnover 0.00 0.00 0.00

Balance SheetShort-term Assets 1999 2000 2001Cash $40,000 $50,000 $50,000Accounts Receivable $0 $0 $0Inventory $0 $0 $0Other Short-term Assets $20,000 $30,000 $50,000Total Short-term Assets $60,000 $80,000 $100,000Long-term AssetsCapital Assets $80,000 $80,000 $80,000Accumulated Depreciation $5,000 $10,000 $15,000Total Long-term Assets $75,000 $70,000 $65,000Total Assets $135,000 $150,000 $165,000

Capital and Liabilities1999 2000 2001

Accounts Payable $10,000 $12,000 $20,000Current Borrowing $0 $0 $0Other Short-term Liabilities $0 $0 $0Subtotal Short-term Liabilities $10,000 $12,000 $20,000

Long-term Liabilities $30,000 $20,000 $20,000Total Liabilities $40,000 $32,000 $40,000Paid-in Capital $0 $0 $50,000Retained Earnings $95,000 $118,000 $75,000Earnings $0 $0 $0Total Capital $95,000 $118,000 $125,000Total Capital and Liabilities $135,000 $150,000 $165,000

Other Inputs 1999 2000 2001Payment Days 0 0 0Sales on Credit $0 $0 $0Receivables Turnover 0.00 0.00 0.00

$0

$100,000

$200,000

$300,000

$400,000

$500,000

$600,000

$700,000

$800,000

1999 2000 2001

Sales

Gross

Net

Past Performance

Justin Seafood Market

Page 3

Page 7: Just in Seafood Market

2.3 Company Locations and Facilities

Justin Seafood Market is located at 3456 Main Street, Tallahassee, Florida. After renovation, the market will have an additional 5,000 ft. of floor space that will be used for the new retail operation.

3.0 Products

Justin Seafood Market currently provides numerous seafood products to restaurants in the Florida panhandle. The market's new public retail outlet will focus on popular seafood selections that will bring customers into the store.

Justin Seafood Market will have the following retail products:

• Jumbo Fresh Gulf Shrimp;• Alaskan King Crab;• Florida Lobster;• Sea Scallops;• Fresh Gulf Fish Filets;• Yellowfin Tuna;• Grouper;• Snapper;• Amberjack.

4.0 Market Analysis Summary

Tallahassee has a population of over 160,000 residents but the area receives thousands of day tourists each year. Justin Seafood Market is located in the busiest commercial section of Tallahassee with excellent foot traffic. Expanding the market's storefront by 5,000 ft. will create an inviting environment for the public. The market's interior design will focus on the motif of an open air fish market. We will advertise the market as a place where the public can get quality seafood at wholesale prices.

Justin Seafood Market

Page 4

Page 8: Just in Seafood Market

4.1 Market Segmentation

Justin Seafood Market is focused on two customer groups:

• Urban professional working downtown.• Day tourists.

Table: Market Analysis

Market AnalysisPotential Customers Growth 2002 2003 2004 2005 2006 CAGRUrban Professionals 10% 30,000 33,000 36,300 39,930 43,923 10.00%Day Tourists 0% 60,000 60,000 60,000 60,000 60,000 0.00%Total 3.66% 90,000 93,000 96,300 99,930 103,923 3.66%

Urban Professionals

Day Tourists

Market Analysis (Pie)

5.0 Strategy and Implementation Summary

Justin Seafood Market will expand its storefront and sell direct to the public. The market is known as a wholesale operation and we will use that identity to advertise the new service to the public. We will ask the public "Why pay retail when you can get better quality at wholesale prices!" Additional staff will be hired to serve the public.

Justin Seafood Market

Page 5

Page 9: Just in Seafood Market

5.1 Competitive Edge

The competitive edge of Justin Seafood Market is the market's commitment of quality, freshness and great prices. The market's location also assures excellent tourist and resident foot traffic.

5.2 Sales Strategy

Justin Seafood Market will employ two sales approaches for its target customers.

• For Urban Professional: The market will promote membership in its Seafood Discount Club. Residents will be encouraged to join for $20 a year. As a member, all purchases will be discounted $1 per pound. This will result in considerable saving for members who shop regularly at the market.

• For the Day Tourist: The market will offer free 24-hour shipping of purchases in excess of $100. The customer will be able to select the day the seafood will be shipped. The customers will then receive a regular newsletter that will include an invitation to purchase seafood again with same free shipping option.

5.2.1 Sales Forecast

The following is the sales forecast for three years.

Table: Sales Forecast (Planned)

Sales ForecastSales 2002 2003 2004Over-counter $334,000 $350,000 $380,000Shipped $122,000 $140,000 $155,000Restaurant Deliveries $720,000 $800,000 $900,000Total Sales $1,176,000 $1,290,000 $1,435,000

Direct Cost of Sales 2002 2003 2004Over-counter $166,500 $173,000 $188,000Shipped $64,100 $74,000 $81,000Restaurant Deliveries $359,000 $409,000 $459,000Subtotal Direct Cost of Sales $589,600 $656,000 $728,000

Justin Seafood Market

Page 6

Page 10: Just in Seafood Market

$0

$20,000

$40,000

$60,000

$80,000

$100,000

$120,000

$140,000

$160,000

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Over-counter

Shipped

Restaurant Deliveries

Sales Monthly (Planned)

$0

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

$1,400,000

$1,600,000

2002 2003 2004

Over-counter

Shipped

Restaurant Deliveries

Sales by Year (Planned)

Justin Seafood Market

Page 7

Page 11: Just in Seafood Market

6.0 Management Summary

Prior to beginning Justin Seafood Market, Bill Justin worked as an account manager for William's Wholesale Foods and Wilson Seafood for ten years. In his last position with Wilson Seafood, Bill developed an excellent network of fishing contacts in the Florida panhandle, generating sales in excess of $2 million annually. His strength has always been his customer relation skills.

Bill Justin has a BA in marketing from Florida State University. His first position after graduation was as a shift manager with Johnson Seafood Restaurant. In three years, he was promoted to the manager position. During that time, Bill demonstrated the ability to effectively manage a large staff.

6.1 Personnel Plan

The personnel for Justin Seafood Market is as follows:

• Manager;• Market staff (4);• Delivery crew (4);• Sales staff (4);• Cleanup crew (2);

Table: Personnel (Planned)

Personnel Plan2002 2003 2004

Manager $36,000 $38,000 $40,000Market Staff (4) $84,000 $90,000 $96,000Clean-up Crew (2) $45,600 $47,000 $49,000Delivery Staff (4) $96,000 $102,000 $108,000Sales Staff (4) $120,000 $130,000 $140,000Total Payroll $381,600 $407,000 $433,000

Total People 15 15 15Payroll Burden $57,240 $61,050 $64,950Total Payroll Expenditures $438,840 $468,050 $497,950

Justin Seafood Market

Page 8

Page 12: Just in Seafood Market

7.0 Financial Plan

The following is the financial plan for expansion of Justin Seafood Market to include a new retail market space.

7.1 Break-even Analysis

The monthly break-even point is $85,740.

Table: Break-even Analysis

Break-even Analysis:Monthly Units Break-even 429Monthly Sales Break-even $85,740

Assumptions:Average Per-Unit Revenue 200Average Per-Unit Variable Cost 100Estimated Monthly Fixed Cost 42,870

($60,000)

($40,000)

($20,000)

$0

$20,000

$40,000

$0 $28,000 $56,000 $84,000 $112,000 $140,000

Monthly break-even point

Break-even point = where line intersects with 0

Break-even Analysis

Justin Seafood Market

Page 9

Page 13: Just in Seafood Market

7.2 Projected Profit and Loss

The following table and charts highlight the projected profit and loss for three years.

Table: Profit and Loss (Planned)

Pro Forma Profit and Loss2002 2003 2004

Sales $1,176,000 $1,290,000 $1,435,000Direct Cost of Sales $589,600 $656,000 $728,000Other Production Expenses $0 $0 $0

------------ ------------ ------------Total Cost of Sales $589,600 $656,000 $728,000Gross Margin $586,400 $634,000 $707,000Gross Margin % 49.86% 49.15% 49.27%Operating Expenses: Advertising/Promotion $12,000 $15,000 $20,000Travel $12,000 $15,000 $20,000Miscellaneous $0 $0 $0Payroll Expense $381,600 $407,000 $433,000Payroll Burden $57,240 $61,050 $64,950Depreciation $9,600 $9,600 $9,600Leased Equipment $0 $0 $0Utilities $6,000 $6,000 $6,000Insurance $0 $0 $0Rent $36,000 $36,000 $36,000Contract/Consultants $0 $0 $0

------------ ------------ ------------Total Operating Expenses $514,440 $549,650 $589,550Profit Before Interest and Taxes $71,960 $84,350 $117,450Interest Expense Short-term $8,830 $7,840 $7,840Interest Expense Long-term $2,000 $920 ($1,240)Taxes Incurred $18,339 $22,677 $33,255Extraordinary Items $0 $0 $0Net Profit $42,791 $52,913 $77,595Net Profit/Sales 3.64% 4.10% 5.41%

($20,000)

($15,000)

($10,000)

($5,000)

$0

$5,000

$10,000

$15,000

$20,000

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Profit Monthly (Planned)

Justin Seafood Market

Page 10

Page 14: Just in Seafood Market

$0

$10,000

$20,000

$30,000

$40,000

$50,000

$60,000

$70,000

$80,000

2002 2003 2004

Profit Yearly (Planned)

7.3 Projected Cash Flow

The following table and chart highlight the projected cash flow for three years.

Justin Seafood Market

Page 11

Page 15: Just in Seafood Market

Table: Cash Flow (Planned)

Pro Forma Cash Flow 2002 2003 2004

Cash ReceivedCash from Operations: Cash Sales $705,600 $774,000 $861,000From Receivables $397,600 $508,943 $565,024 Subtotal Cash from Operations $1,103,200 $1,282,943 $1,426,024

Additional Cash ReceivedExtraordinary Items $0 $0 $0Sales Tax, VAT, HST/GST Received $0 $0 $0New Current Borrowing $100,000 $0 $0New Other Liabilities (interest-free) $0 $0 $0New Long-term Liabilities $0 $0 $0Sales of other Short-term Assets $0 $0 $0Sales of Long-term Assets $0 $0 $0New Investment Received $0 $0 $0 Subtotal Cash Received $1,203,200 $1,282,943 $1,426,024

Expenditures 2002 2003 2004Expenditures from Operations:Cash Spent on Costs and Expenses $69,838 $76,097 $85,152Wages, Salaries, Payroll Taxes, etc. $438,840 $468,050 $497,950Payment of Accounts Payable $582,420 $678,946 $757,792 Subtotal Spent on Operations $1,091,097 $1,223,093 $1,340,894

Additional Cash SpentSales Tax, VAT, HST/GST Paid Out $0 $0 $0Principal Repayment of Current Borrowing $21,600 $0 $0Other Liabilities Principal Repayment $0 $0 $0Long-term Liabilities Principal Repayment $0 $21,600 $21,600Purchase Other Short-term Assets $0 $0 $0Purchase Long-term Assets $0 $0 $0Dividends $0 $0 $0 Adjustment for Assets Purchased on Credit $0 $0 $0 Subtotal Cash Spent $1,112,697 $1,244,693 $1,362,494

Net Cash Flow $90,503 $38,249 $63,530Cash Balance $140,503 $178,752 $242,282

($40,000)

($20,000)

$0

$20,000

$40,000

$60,000

$80,000

$100,000

$120,000

$140,000

$160,000

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Net Cash Flow

Cash Balance

Cash (Planned)

Justin Seafood Market

Page 12

Page 16: Just in Seafood Market

7.4 Projected Balance Sheet

The following table highlights the projected balance sheet for three years.

Table: Balance Sheet (Planned)

Pro Forma Balance Sheet

AssetsShort-term Assets 2002 2003 2004Cash $140,503 $178,752 $242,282Accounts Receivable $72,800 $79,857 $88,833Inventory $13,607 $15,140 $16,801Other Short-term Assets $50,000 $50,000 $50,000Total Short-term Assets $276,910 $323,749 $397,916Long-term AssetsLong-term Assets $80,000 $80,000 $80,000Accumulated Depreciation $24,600 $34,200 $43,800Total Long-term Assets $55,400 $45,800 $36,200Total Assets $332,310 $369,549 $434,116

Liabilities and Capital2002 2003 2004

Accounts Payable $66,119 $72,045 $80,617Current Borrowing $78,400 $78,400 $78,400Other Short-term Liabilities $0 $0 $0Subtotal Short-term Liabilities $144,519 $150,445 $159,017

Long-term Liabilities $20,000 ($1,600) ($23,200)Total Liabilities $164,519 $148,845 $135,817

Paid-in Capital $50,000 $50,000 $50,000Retained Earnings $75,000 $117,791 $170,704Earnings $42,791 $52,913 $77,595Total Capital $167,791 $220,704 $298,299Total Liabilities and Capital $332,310 $369,549 $434,116Net Worth $167,791 $220,704 $298,299

7.5 Business Ratios

Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 5146, Fish and Seafood, are shown for comparison.

Justin Seafood Market

Page 13

Page 17: Just in Seafood Market

Table: Ratios (Planned)

Ratio Analysis2002 2003 2004 Industry Profile

Sales Growth 65.49% 9.69% 11.24% 4.60%

Percent of Total AssetsAccounts Receivable 21.91% 21.61% 20.46% 33.30%Inventory 4.09% 4.10% 3.87% 25.40%Other Short-term Assets 15.05% 13.53% 11.52% 24.00%Total Short-term Assets 83.33% 87.61% 91.66% 82.70%Long-term Assets 16.67% 12.39% 8.34% 17.30%Total Assets 100.00% 100.00% 100.00% 100.00%

Short-term Liabilities 43.49% 40.71% 36.63% 47.70%Long-term Liabilities 6.02% -0.43% -5.34% 10.10%Total Liabilities 49.51% 40.28% 31.29% 57.80%Net Worth 50.49% 59.72% 68.71% 42.20%

Percent of SalesSales 100.00% 100.00% 100.00% 100.00%Gross Margin 49.86% 49.15% 49.27% 14.20%Selling, General & Administrative Expenses 46.23% 45.05% 43.86% 9.00%Advertising Expenses 1.02% 1.16% 1.39% 0.30%Profit Before Interest and Taxes 6.12% 6.54% 8.18% 0.80%

Main RatiosCurrent 1.92 2.15 2.50 1.64Quick 1.82 2.05 2.40 0.97Total Debt to Total Assets 49.51% 40.28% 31.29% 57.80%Pre-tax Return on Assets 24.91% 25.20% 28.58% 3.60%Pre-tax Return on Net Worth 49.34% 42.19% 41.59% 8.40%

Business Vitality Profile 2002 2003 2004 IndustrySales per Employee $78,400 $86,000 $95,667 $0Survival Rate 0.00%

Additional Ratios 2002 2003 2004Net Profit Margin 3.64% 4.10% 5.41% n.aReturn on Equity 25.50% 23.97% 26.01% n.a

Activity RatiosAccounts Receivable Turnover 6.46 6.46 6.46 n.aCollection Days 28 54 54 n.aInventory Turnover 86.66 45.64 45.58 n.aAccounts Payable Turnover 9.51 9.51 9.51 n.aTotal Asset Turnover 3.54 3.49 3.31 n.a

Debt RatiosDebt to Net Worth 0.98 0.67 0.46 n.aShort-term Liab. to Liab. 0.88 1.01 1.17 n.a

Liquidity RatiosNet Working Capital $132,391 $173,304 $238,899 n.aInterest Coverage 6.64 9.63 17.80 n.a

Additional RatiosAssets to Sales 0.28 0.29 0.30 n.aCurrent Debt/Total Assets 43% 41% 37% n.aAcid Test 1.32 1.52 1.84 n.aSales/Net Worth 7.01 5.84 4.81 n.aDividend Payout $0 0.00 0.00 n.a

Justin Seafood Market

Page 14

Page 18: Just in Seafood Market

Appendix Table: Sales Forecast (Planned)

Sales ForecastSales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecOver-counter $10,000 $10,000 $16,000 $16,000 $21,000 $26,000 $30,000 $40,000 $45,000 $40,000 $40,000 $40,000Shipped $2,000 $3,000 $5,000 $7,000 $9,000 $11,000 $14,000 $15,000 $17,000 $13,000 $10,000 $16,000Restaurant Deliveries $30,000 $30,000 $50,000 $55,000 $55,000 $60,000 $70,000 $80,000 $80,000 $70,000 $70,000 $70,000Total Sales $42,000 $43,000 $71,000 $78,000 $85,000 $97,000 $114,000 $135,000 $142,000 $123,000 $120,000 $126,000

Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecOver-counter $5,000 $5,000 $8,000 $8,000 $10,000 $13,000 $15,000 $20,000 $22,500 $20,000 $20,000 $20,000Shipped $1,100 $1,600 $2,600 $3,800 $4,500 $5,500 $7,500 $8,000 $8,500 $6,500 $6,000 $8,500Restaurant Deliveries $15,000 $15,000 $25,000 $27,000 $27,000 $30,000 $35,000 $40,000 $40,000 $35,000 $35,000 $35,000Subtotal Direct Cost of Sales $21,100 $21,600 $35,600 $38,800 $41,500 $48,500 $57,500 $68,000 $71,000 $61,500 $61,000 $63,500

Appendix

Page 1

Page 19: Just in Seafood Market

Appendix Table: Personnel (Planned)

Personnel PlanJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Manager $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000Market Staff (4) $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000Clean-up Crew (2) $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800Delivery Staff (4) $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000Sales Staff (4) $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000Total Payroll $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800

Total People 15 15 15 15 15 15 15 15 15 15 15 15Payroll Burden $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770Total Payroll Expenditures $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570

Appendix

Page 2

Page 20: Just in Seafood Market

Appendix Table: Profit and Loss (Planned)

Pro Forma Profit and LossJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Sales $42,000 $43,000 $71,000 $78,000 $85,000 $97,000 $114,000 $135,000 $142,000 $123,000 $120,000 $126,000Direct Cost of Sales $21,100 $21,600 $35,600 $38,800 $41,500 $48,500 $57,500 $68,000 $71,000 $61,500 $61,000 $63,500Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------Total Cost of Sales $21,100 $21,600 $35,600 $38,800 $41,500 $48,500 $57,500 $68,000 $71,000 $61,500 $61,000 $63,500Gross Margin $20,900 $21,400 $35,400 $39,200 $43,500 $48,500 $56,500 $67,000 $71,000 $61,500 $59,000 $62,500Gross Margin % 49.76% 49.77% 49.86% 50.26% 51.18% 50.00% 49.56% 49.63% 50.00% 50.00% 49.17% 49.60%Operating Expenses: Advertising/Promotion $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000Travel $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Payroll Expense $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800 $31,800Payroll Burden $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770 $4,770Depreciation $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------Total Operating Expenses $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870 $42,870Profit Before Interest and Taxes ($21,970) ($21,470) ($7,470) ($3,670) $630 $5,630 $13,630 $24,130 $28,130 $18,630 $16,130 $19,630Interest Expense Short-term $818 $803 $788 $773 $758 $743 $728 $713 $698 $683 $668 $653Interest Expense Long-term $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167Taxes Incurred ($6,887) ($6,732) ($2,528) ($1,383) ($89) $1,416 $3,821 $6,975 $8,180 $5,334 $4,589 $5,643Extraordinary Items $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Net Profit ($16,069) ($15,708) ($5,898) ($3,227) ($207) $3,304 $8,915 $16,275 $19,086 $12,446 $10,707 $13,167Net Profit/Sales -38.26% -36.53% -8.31% -4.14% -0.24% 3.41% 7.82% 12.06% 13.44% 10.12% 8.92% 10.45%

Appendix

Page 3

Page 21: Just in Seafood Market

Appendix Table: Cash Flow (Planned)

Pro Forma Cash Flow Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Cash ReceivedCash from Operations: Cash Sales $25,200 $25,800 $42,600 $46,800 $51,000 $58,200 $68,400 $81,000 $85,200 $73,800 $72,000 $75,600From Receivables $0 $8,960 $17,013 $23,173 $29,893 $32,693 $36,560 $42,427 $50,080 $55,493 $52,747 $48,560 Subtotal Cash from Operations $25,200 $34,760 $59,613 $69,973 $80,893 $90,893 $104,960 $123,427 $135,280 $129,293 $124,747 $124,160

Additional Cash ReceivedExtraordinary Items $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0New Current Borrowing $100,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Sales of other Short-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Cash Received $125,200 $34,760 $59,613 $69,973 $80,893 $90,893 $104,960 $123,427 $135,280 $129,293 $124,747 $124,160

Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecExpenditures from Operations:Cash Spent on Costs and Expenses $2,522 $2,145 $4,253 $4,454 $4,842 $5,783 $6,964 $8,361 $8,619 $7,115 $7,182 $7,600Wages, Salaries, Payroll Taxes, etc. $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570 $36,570Payment of Accounts Payable $20,757 $22,585 $19,933 $38,335 $40,205 $43,856 $52,398 $63,098 $75,322 $77,117 $64,053 $64,760 Subtotal Spent on Operations $59,849 $61,299 $60,756 $79,359 $81,616 $86,208 $95,932 $108,029 $120,511 $120,802 $107,805 $108,930

Additional Cash SpentSales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Principal Repayment of Current Borrowing $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Purchase Other Short-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Adjustment for Assets Purchased on Credit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Cash Spent $61,649 $63,099 $62,556 $81,159 $83,416 $88,008 $97,732 $109,829 $122,311 $122,602 $109,605 $110,730

Net Cash Flow $63,551 ($28,339) ($2,943) ($11,186) ($2,523) $2,885 $7,228 $13,598 $12,969 $6,691 $15,142 $13,430Cash Balance $113,551 $85,212 $82,270 $71,084 $68,561 $71,446 $78,673 $92,271 $105,240 $111,931 $127,073 $140,503

Appendix

Page 4

Page 22: Just in Seafood Market

Appendix Table: Balance Sheet (Planned)

Pro Forma Balance Sheet

AssetsShort-term Assets Starting Balances Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecCash $50,000 $113,551 $85,212 $82,270 $71,084 $68,561 $71,446 $78,673 $92,271 $105,240 $111,931 $127,073 $140,503Accounts Receivable $0 $16,800 $25,040 $36,427 $44,453 $48,560 $54,667 $63,707 $75,280 $82,000 $75,707 $70,960 $72,800Inventory $0 $4,521 $4,629 $7,629 $8,314 $8,893 $10,393 $12,321 $14,571 $15,214 $13,179 $13,071 $13,607Other Short-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000Total Short-term Assets $100,000 $184,873 $164,881 $176,325 $173,851 $176,014 $186,505 $204,701 $232,122 $252,455 $250,817 $261,104 $276,910Long-term AssetsLong-term Assets $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000Accumulated Depreciation $15,000 $15,800 $16,600 $17,400 $18,200 $19,000 $19,800 $20,600 $21,400 $22,200 $23,000 $23,800 $24,600Total Long-term Assets $65,000 $64,200 $63,400 $62,600 $61,800 $61,000 $60,200 $59,400 $58,600 $57,800 $57,000 $56,200 $55,400Total Assets $165,000 $249,073 $228,281 $238,925 $235,651 $237,014 $246,705 $264,101 $290,722 $310,255 $307,817 $317,304 $332,310

Liabilities and CapitalJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Accounts Payable $20,000 $21,941 $18,657 $36,999 $38,752 $42,121 $50,309 $60,590 $72,736 $74,983 $61,899 $62,480 $66,119Current Borrowing $0 $98,200 $96,400 $94,600 $92,800 $91,000 $89,200 $87,400 $85,600 $83,800 $82,000 $80,200 $78,400Other Short-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0Subtotal Short-term Liabilities $20,000 $120,141 $115,057 $131,599 $131,552 $133,121 $139,509 $147,990 $158,336 $158,783 $143,899 $142,680 $144,519

Long-term Liabilities $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000Total Liabilities $40,000 $140,141 $135,057 $151,599 $151,552 $153,121 $159,509 $167,990 $178,336 $178,783 $163,899 $162,680 $164,519

Paid-in Capital $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000Retained Earnings $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000Earnings $0 ($16,069) ($31,777) ($37,674) ($40,901) ($41,108) ($37,804) ($28,889) ($12,614) $6,472 $18,918 $29,624 $42,791Total Capital $125,000 $108,932 $93,224 $87,326 $84,099 $83,893 $87,197 $96,111 $112,386 $131,472 $143,918 $154,624 $167,791Total Liabilities and Capital $165,000 $249,073 $228,281 $238,925 $235,651 $237,014 $246,705 $264,101 $290,722 $310,255 $307,817 $317,304 $332,310Net Worth $125,000 $108,932 $93,224 $87,326 $84,099 $83,893 $87,197 $96,111 $112,386 $131,472 $143,918 $154,624 $167,791

Appendix

Page 5