Computer Engineering Business Plan - Ridzuan


Executive Summary

Todd, West, and Associates specialize in modifications to inventory management systems of all types. The company's connectivity and network engineering expertise assures a complete wireless solution to warehouse management issues. Todd, West, and Associates has over fifteen years of experience within the ADC (Automated Data Collection) marketplace.
Prior to starting this new company, the staff of Todd, West, and Associates worked within the industry's major companies performing special wireless modification for customers. Their unique perspective has already led to two of the industry leaders, Symbol and CDS, outsourcing special modification orders to Todd, West, and Associates.



1.1 Objectives

The objectives of Todd, West, and Associates are as follows:
  • Establish the company as a leader in warehouse wireless connectivity.
  • Increase client base by 20% each year.
  • Develop packaged solutions for warehouse management systems.

1.2 Mission

The mission of Todd, West, and Associates is to work directly with customers to improve their warehouse management systems. The development, modification, and/or improvement of warehouse data infrastructure will assure that the business will function efficiently and successfully.

Company Summary

Todd, West, and Associates is a new start-up engineering contracting firm. Co-owners, Mary Todd and John West have over fifteen years of experience in connectivity and network engineering. The country's economic growth over the last several years has resulted in increased opportunity for the installation of high-end warehouse management systems. Todd, West, and Associates is positioned to capitalize on the growing need of companies to better manage their inventory.

From 1996 to 2001, Mary Todd was senior engineer for the Special Modification Services unit of CDS, one of the country's leading producers of Automatic Data Collection (ADC) products. Her primary responsibility was to travel to the customer's warehouse site and perform custom wireless network modifications using CDS products.

John West has been a senior engineer for Symbol's system installation services unit for the past five years. John's responsibilities included custom wireless installation of Symbol networking equipment and ADC products at the customer's warehouse site.

Todd, West, and Associates has signed outsourcing agreements with both CDS and Symbol to provide custom network installation services to their customers. Currently, these agreements represent $100,000 in scheduled assignments.

2.1 Company Ownership

Mary Todd and John West are co-owners of Todd, West, and Associates.

2.2 Start-up Summary

Mary Todd and John West will each equally invest in Todd, West, and Associates. In addition, they will secure a long-term loan. The following table and chart show projected initial start-up costs for Todd, West, and Associates.




Start-up Funding
Start-up Expenses to Fund
$9,000
Start-up Assets to Fund
$61,000
Total Funding Required
$70,000
Assets
Non-cash Assets from Start-up
$0
Cash Requirements from Start-up
$61,000
Additional Cash Raised
$0
Cash Balance on Starting Date
$61,000
Total Assets
$61,000
Liabilities and Capital
Liabilities
Current Borrowing
$0
Long-term Liabilities
$50,000
Accounts Payable (Outstanding Bills)
$0
Other Current Liabilities (interest-free)
$0
Total Liabilities
$50,000
Capital
Planned Investment
Mary Todd
$10,000
John West
$10,000
Additional Investment Requirement
$0
Total Planned Investment
$20,000
Loss at Start-up (Start-up Expenses)
($9,000)
Total Capital
$11,000
Total Capital and Liabilities
$61,000
Total Funding
$70,000

Start-up
Requirements
Start-up Expenses
Legal
$1,000
Stationery etc.
$1,000
Rent
$1,000
Expensed Equipment
$6,000
Total Start-up Expenses
$9,000
Start-up Assets
Cash Required
$61,000
Other Current Assets
$0
Long-term Assets
$0
Total Assets
$61,000
Total Requirements
$70,000

Services

Todd, West, and Associates' services include the following:

  • Automated data collection installation
  • Database engineering/conversions (MS Access/SQL/Oracle)
  • Data imports/exports
  • Database links to accounting system (MAS-90/Solomon/Peachtree)
  • Wireless networking
  • Portable data terminal programming
  • LAN/WAN infrastructure
  • System consulting

The prices for services are as follows:
  • On-site System Requirements Study: $1,000 a day plus travel and expenses.
  • On-site Database/Network Engineering/Training: $1,000 a day plus travel and expenses.
  • Phone Training/Assistance: $120 an hour.
  • Database Modifications: Quoted based on job specifics.
  • General Data Imports/Exports: $120 an hour.

Market Segmentation

Automated Data Collection (ADC) products and services is a $3 billion industry. The products are used in numerous companies with significant inventory and warehouse space. Approximately, 30% of the market is in wireless products and services but the demand is growing. It is estimated that wireless ADC products will dominate the market by 2005. Two of the industry leaders, Symbol and CDS, exceeded $600 million in sales for FY 2000. Wireless products represented 28% of their total sales.

Typically, with the installation of wireless products, there are associated costs for networking and connectivity issues. Most companies in the industry offer these additional services to their customers or outsource the service to engineering firms with expertise in their product line.

Todd, West, and Associates has extensive experience with both Symbol and CDS products. The company's focus is to first meet the demands of the Symbol and CDS referred customers. Todd, West, and Associates will establish relationships with these companies and will work to receive referral business from them over time. The company estimates that 80% of revenues will come from outsourced clientele and 20% from new business. Over the next three years, Todd, West, and Associates estimates that new business will constitute 40% of revenue.




Market Analysis
Year 1
Year 2
Year 3
Year 4
Year 5
Potential Customers
Growth
CAGR
Outsourced Customers
10%
2,000
2,200
2,420
2,662
2,928
10.00%
New Customers
5%
10,000
10,500
11,025
11,576
12,155
5.00%
Total
5.88%
12,000
12,700
13,445
14,238
15,083
5.88%

Strategy and Implementation Summary

Todd, West, and Associates will focus on companies utilizing Symbol and CDS wireless ADC products to manage their inventories. The targeted customer will have ten or more warehouse staff members using ADC wireless systems.

Initially, the company will receive 80% of its clients through Symbol and CDS outsource referrals. The remaining 20% will come from direct marketing.

Over the past five years, both Mary and John have built an extensive network of contacts with companies utilizing wireless ADC products. Todd, West, and Associates will market its services directly to these companies.

After its first three months of operation, the company expects to begin to receive installation contracts from new customers.

5.1 Competitive Edge

Todd, West, and Associates will sustain its competitive advantages to steadily gain market share. The first advantage is based on extensive knowledge of Symbol and CDS wireless ADC products. The second advantage is an established network of contacts among numerous companies that utilize wireless ADC products.

Todd, West, and Associates' competitive edge is the five years Mary and John have spent installing Symbol and CDS wireless ADC systems. Both have excellent reputations with customers for quality work and effective communication skills. These established relationships create a trust bond that is significant when it comes to generating new referrals.

5.2 Sales Strategy

Todd, West, and Associates estimates that about 80% of revenues will come from outsourced clientele and 20% from new business. Over the next three years, Todd, West, and Associates estimates that new business will grow to eventually constitute 40% of revenue.

5.2.1 Sales Forecast

The following is the sales forecast for the next three years.





Sales Forecast
Year 1
Year 2
Year 3
Sales
Symbol and CDS Customers
$283,377
$310,000
$330,000
New Customers
$57,200
$78,000
$100,000
Total Sales
$340,577
$388,000
$430,000
Direct Cost of Sales
Year 1
Year 2
Year 3
Symbol and CDS Customers
$0
$0
$0
New Customers
$0
$0
$0
Subtotal Direct Cost of Sales
$0
$0
$0

Management Summary

Todd, West, and Associates will be managed jointly by Mary Todd and John West. Initially, the company will have only three additional employees.

6.1 Personnel Plan

The personal plan for Todd, West, and Associates is as follows:
  • Mary Todd
  • John West
  • Installation consultants (wireless installations)
  • Office manager

Personnel Plan
Year 1
Year 2
Year 3
Mary Todd
$60,000
$63,000
$66,000
John West
$60,000
$63,000
$66,000
Installation Consultants
$96,000
$100,000
$104,000
Office Manager
$36,000
$38,000
$40,000
Total People
4
4
4
Total Payroll
$252,000
$264,000
$276,000

Financial Plan

The following is the financial plan for Todd, West, and Associates.

7.1 Break-even Analysis

The monthly break-even point is shown in the table and chart below.



Break-even Analysis
Monthly Revenue Break-even
$25,450
Assumptions:
Average Percent Variable Cost
0%
Estimated Monthly Fixed Cost
$25,450

7.2 Projected Profit and Loss

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







Pro Forma Profit and Loss
Year 1
Year 2
Year 3
Sales
$340,577
$388,000
$430,000
Direct Cost of Sales
$0
$0
$0
Other Production Expenses
$0
$0
$0
Total Cost of Sales
$0
$0
$0
Gross Margin
$340,577
$388,000
$430,000
Gross Margin %
100.00%
100.00%
100.00%
Expenses
Payroll
$252,000
$264,000
$276,000
Sales and Marketing and Other Expenses
$0
$0
$0
Depreciation
$0
$0
$0
Leased Equipment
$0
$0
$0
Utilities
$3,600
$3,600
$3,600
Insurance
$0
$0
$0
Rent
$12,000
$12,000
$12,000
Payroll Taxes
$37,800
$39,600
$41,400
Other
$0
$0
$0
Total Operating Expenses
$305,400
$319,200
$333,000
Profit Before Interest and Taxes
$35,177
$68,800
$97,000
EBITDA
$35,177
$68,800
$97,000
Interest Expense
$2,883
$2,676
$2,460
Taxes Incurred
$9,688
$19,837
$28,362
Net Profit
$22,606
$46,287
$66,178
Net Profit/Sales
6.64%
11.93%
15.39%

7.3 Projected Cash Flow
The following table and chart highlight the projected cash flow for the next three years.

cash
Pro Forma Cash Flow
Year 1
Year 2
Year 3
Cash Received
Cash from Operations
Cash Sales
$85,144
$97,000
$107,500
Cash from Receivables
$209,420
$284,593
$316,826
Subtotal Cash from Operations
$294,565
$381,593
$424,326
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$0
$0
$0
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$0
$0
$0
Sales of Other Current Assets
$0
$0
$0
Sales of Long-term Assets
$0
$0
$0
New Investment Received
$0
$0
$0
Subtotal Cash Received
$294,565
$381,593
$424,326
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$252,000
$264,000
$276,000
Bill Payments
$60,773
$76,524
$86,991
Subtotal Spent on Operations
$312,773
$340,524
$362,991
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out
$0
$0
$0
Principal Repayment of Current Borrowing
$0
$0
$0
Other Liabilities Principal Repayment
$0
$0
$0
Long-term Liabilities Principal Repayment
$3,600
$3,600
$3,600
Purchase Other Current Assets
$0
$0
$0
Purchase Long-term Assets
$0
$0
$0
Dividends
$0
$0
$0
Subtotal Cash Spent
$316,373
$344,124
$366,591
Net Cash Flow
($21,809)
$37,469
$57,735
Cash Balance
$39,191
$76,661
$134,395

7.4 Projected Balance Sheet

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

Pro Forma Balance Sheet
Year 1
Year 2
Year 3
Assets
Current Assets
Cash
$39,191
$76,661
$134,395
Accounts Receivable
$46,013
$52,419
$58,094
Other Current Assets
$0
$0
$0
Total Current Assets
$85,204
$129,080
$192,489
Long-term Assets
Long-term Assets
$0
$0
$0
Accumulated Depreciation
$0
$0
$0
Total Long-term Assets
$0
$0
$0
Total Assets
$85,204
$129,080
$192,489
Liabilities and Capital
Year 1
Year 2
Year 3
Current Liabilities
Accounts Payable
$5,198
$6,387
$7,218
Current Borrowing
$0
$0
$0
Other Current Liabilities
$0
$0
$0
Subtotal Current Liabilities
$5,198
$6,387
$7,218
Long-term Liabilities
$46,400
$42,800
$39,200
Total Liabilities
$51,598
$49,187
$46,418
Paid-in Capital
$20,000
$20,000
$20,000
Retained Earnings
($9,000)
$13,606
$59,893
Earnings
$22,606
$46,287
$66,178
Total Capital
$33,606
$79,893
$146,071
Total Liabilities and Capital
$85,204
$129,080
$192,489
Net Worth
$33,606
$79,893
$146,071

7.5 Business Ratios

Business ratios for the years of this plan are shown below. Industry profile ratios based on the NAISC code 541614, Process, Physical Distribution, and Logistics Consulting, are shown for comparison.

Ratio Analysis
Year 1
Year 2
Year 3
Industry Profile
Sales Growth
0.00%
13.92%
10.82%
7.23%
Percent of Total Assets
Accounts Receivable
54.00%
40.61%
30.18%
19.37%
Other Current Assets
0.00%
0.00%
0.00%
50.13%
Total Current Assets
100.00%
100.00%
100.00%
70.99%
Long-term Assets
0.00%
0.00%
0.00%
29.01%
Total Assets
100.00%
100.00%
100.00%
100.00%
Current Liabilities
6.10%
4.95%
3.75%
34.21%
Long-term Liabilities
54.46%
33.16%
20.36%
15.24%
Total Liabilities
60.56%
38.11%
24.11%
49.45%
Net Worth
39.44%
61.89%
75.89%
50.55%
Percent of Sales
Sales
100.00%
100.00%
100.00%
100.00%
Gross Margin
100.00%
100.00%
100.00%
23.92%
Selling, General & Administrative Expenses
93.80%
88.49%
85.02%
11.77%
Advertising Expenses
0.00%
0.00%
0.00%
0.57%
Profit Before Interest and Taxes
10.33%
17.73%
22.56%
0.85%
Main Ratios
Current
16.39
20.21
26.67
1.60
Quick
16.39
20.21
26.67
1.31
Total Debt to Total Assets
60.56%
38.11%
24.11%
56.90%
Pre-tax Return on Net Worth
96.10%
82.77%
64.72%
2.82%
Pre-tax Return on Assets
37.90%
51.23%
49.11%
6.54%
Additional Ratios
Year 1
Year 2
Year 3
Net Profit Margin
6.64%
11.93%
15.39%
n.a
Return on Equity
67.27%
57.94%
45.31%
n.a
Activity Ratios
Accounts Receivable Turnover
5.55
5.55
5.55
n.a
Collection Days
57
62
63
n.a
Accounts Payable Turnover
12.69
12.17
12.17
n.a
Payment Days
27
27
28
n.a
Total Asset Turnover
4.00
3.01
2.23
n.a
Debt Ratios
Debt to Net Worth
1.54
0.62
0.32
n.a
Current Liab. to Liab.
0.10
0.13
0.16
n.a
Liquidity Ratios
Net Working Capital
$80,006
$122,693
$185,271
n.a
Interest Coverage
12.20
25.71
39.43
n.a
Additional Ratios
Assets to Sales
0.25
0.33
0.45
n.a
Current Debt/Total Assets
6%
5%
4%
n.a
Acid Test
7.54
12.00
18.62
n.a
Sales/Net Worth
10.13
4.86
2.94
n.a
Dividend Payout
0.00
0.00
0.00
n.a