Structural Engineering Consulting Firm
Structural Engineering Consulting Firm
BUSINESS PLAN STRUCTUREALL LTD.
306 Pine Trail Way
Yellowknife, Northwest Territories, Canada
StructureAll's mission is to provide clients across Canada's Northwest Territories with structural engineering services for all types of buildings, from concept planning through completion, with a highly skilled professional team working together, using common sense and practical experience. This business plan was compiled using Business Plan Pro, © 1999, Palo Alto Software, www.paloaltosoftware.com, 800-229-7526.
- executive summary
- company summary
- services
- market analysis summary
- strategy & implementation summary
- management summary
- financial plan
EXECUTIVE SUMMARY
StructureAll Ltd. will be formed as a consulting firm specializing in structural engineering services. A home office in Yellowknife, Northwest Territories, will be established the first year of operations to reduce start-up costs. The founder of the firm is a professional engineer with eighteen years of progressive and responsible experience.
Initial start-up costs amount to $20,000. Of this total, $13,000 is required for start-up expenses while the balance is to to be placed in the company accounts as working capital. We have secured an investor (Russ Renneberg, P. Eng.) who will contribute $10,000 toward start-up costs. This investment has been indicated in Long-Term Loans in the Projected Cash Flow chart. The loan will be repaid over a three-year period.
Projected sales and profits for the first three years of operation are summarized below:
Year | Sales ($) | Profits ($) | Sales/Profit (%) |
1 | $118,000 | $9,150 | 7.80% |
2 | $130,000 | $12,650 | 9.80% |
3 | $138,000 | $15,100 | 11.00% |
The firm will specialize in providing three-dimensional modeling and visualization to our clients. State-of-the-art analysis and design tools will be an integral part of the business plan. Implementation of a quality control and assurance program will provide a focus for production work.
Objectives
- Revenues of $118,000 the first year, approaching $138,000 at the end of three years.
- Achieve 20 percent of market value at the end of the third year of operation.
- Increase gross margin to 80 percent by the third year of operations.
Mission
Our mission is to provide clients across Canada's North with structural engineering services for all types of buildings, from concept planning through completion, with a highly skilled professional team working together, using common sense and practical experience.
Keys to Success
- Provide professional quality services on time and on budget.
- Develop a follow-up strategy to gauge performance with all clients.
- Implement and maintain a quality control and assurance policy.
COMPANY SUMMARY
StructureAll Ltd. is a new company which provides professional engineering design services for clients which manage, maintain, and plan for residential, commercial, and industrial type buildings. Our focus will be the public sector market in remote communities across Canada's North.
Company Ownership
StructureAll Ltd. will be created as a limited liability company. The company will be privately owned by Philip D. Nolan. Leslie C. Goit will also be listed as a Director.
Start-up Summary
Our start-up expenses amount to $13,000, which allows for initial legal expenses, licenses, permits, stationery, specialty software, office equipment, and furniture. In addition to these start-up costs, an initial balance of $7,000 will be placed in the company accounts. The software purchases include an allowance of $5,000 for AutoCADD® 2000, $1,800 for National Master Specifications, and $200 for Quickbooks® (accounting package).
Philip Nolan will contribute $10,000 toward the overall start-up costs. The balance of the startup costs ($10,000) will be provided through a colleague and friend who operates W&R Foundations Ltd. This investment has been indicated as a three-year loan in the Projected Cash Flow table.
Start-up Plan | |
Start-up Expenses | |
Professional Liability Insurance | $1,200 |
Website Development | $600 |
Legal Services | $500 |
Business Licenses | $1,000 |
Permit Holder (NAPEGG) | $500 |
Software Purchases | $7,000 |
Stationery | $600 |
Office Furniture | $600 |
Office Equipment | $500 |
Other | $500 |
Total Start-up Expenses | $13,000 |
Start-up Assets Needed | |
Cash Requirements | $7,000 |
Start-up inventory | $0 |
Other Short-term Assets | $0 |
Total Short-term Assets | $7,000 |
Long-term Assets | $0 |
Total Assets | $7,000 |
Total Start-up Requirements: | $20,000 |
Left to finance: | $0 |
Start-up Funding Plan | |
Investment | |
Philip D. Nolan | $10,000 |
Russ Renneberg, P. Eng. | $10,000 |
Other | $0 |
Total investment | $20,000 |
Short-term Liabilities | |
Unpaid Expenses | $0 |
Short-term Loans | $0 |
Interest-free Short-term Loans | $0 |
Subtotal Short-term Liabilities | $0 |
Long-term Liabilities | $0 |
Total Liabilities | $0 |
Loss at Start-up | ($13,000) |
Total Capital | $7,000 |
Total Capital and Liabilities | $7,000 |
Checkline | $0 |
Company Locations and Facilities
We will establish a home office in Yellowknife, Northwest Territories, in order to reduce startup costs. The office space is estimated to be 150 square feet. We will be installing a dedicated fax line as well as a high-speed Internet connection. An interactive website will also be developed which will serve as a marketing tool. The domain name of "structureall.com" has already been reserved.
SERVICES
StructureAll Ltd. offers complete structural engineering services. We will focus on buildings with the following "Use and Occupancies":
- residential
- commercial
- industrial
The company is "project" oriented where each project involves:
- renovations
- rehabilitation
- additions
- new construction
We offer innovative and economical design services, maintaining state-of-the-art design technology. We meet client needs on projects of all sizes and smaller, special design projects.
Service Description
Project Consulting: Proposed and billed on a per-project and per-milestone basis, project consulting offers a client company a way to harness our specific qualities and use our expertise to develop and/or implement plans, from conceptual planning to turnover. Proposal costs will be associated with each project.
Forensic Investigations: Proposed and billed on a per-project and per-milestone basis, our investigations will serve the public and private sector markets. We will focus on troubleshooting buildings where damage and or failure has occurred. Our reports will outline the description of the problem, the nature of the mechanism which has caused damage or failure, and a list of options for remedial action including estimated budget costs for implementation.
Project Management: Our project management services include defining client needs, preparing bid documents, tendering, bid analysis, construction review, payment certification, contract administration, and warranty inspections. Projects include new facilities, renovations, repairs, and remodeling.
Dispute Resolution: We draw upon our broad range of construction and contract administration experience to provide dispute resolution services, including arbitration, mediation and expert reports for litigation. This work is supported by forensic engineering services to identify the cause of failures.
Restoration Engineering: We provide condition survey, design, and construction review services for the repair of building structures.
Home Inspections: We will provide prospective homeowners with an assessment of the various systems in a residential home, including foundations, framing, building envelope and efficiency, mechanical systems, electrical systems, and general safety issues. We provide a photographic record along with a thorough written report.
Competitive Comparison
StructureAll Ltd. offers their clients superior service accompanied with state-of-the-art analysis and design capabilities. We will offer three-dimensional visualization services to reduce the possibility of spatial conflicts with architectural elements and other engineering disciplines. In comparison, our competitors rely mostly on two-dimensional models.
We will implement a quality assurance and control program for all projects undertaken. This document will serve to focus on the standards which will be achieved and a means of measuring performance.
A systematic manner of sorting and retrieving a library of structural elements and assemblies will be implemented. Slide libraries will be available from a tool bar within AutoCADD for quick access. We will adopt the layering standards of the American Institute of Architects (AIA). In comparison, our competitors do not have an integrated database.
StructureAll Ltd. will adopt the filing systems developed by the AIA. All project information will be tracked using an integrated database management system.
Sales Literature
A brochure system, which covers a broad spectrum of the target market segment, will be developed during the initial year of operations. This system will be modular in nature and include many "boiler plate" sections which may be edited to suit specific needs. Brochure inserts will be maintained as individual sheets to facilitate their assembly in any custom situation.
Our website will be developed the first year of operations and will include a description of our services, the areas which we plan to serve, contact information, a list of representative projects, and a brief biography of Philip D. Nolan. An Internet domain name has already been reserved for this purpose http://www.structureall.com.
A series of templates will be developed for project proposals. The format for all proposals will include:
- Cover letter
- Scope of services for each project
- Fee (if requested)
- Firm's qualifications to provide services (overview)
- Project Team (describes each person's tasks and qualifications)
- Philosophy of design approach
- Relevant experience
- Schedule to provide services
Fulfillment
We will turn to qualified professionals to supplement computer-aided design and drafting (CADD) services, specialty connection designs, and analysis support services which are areas that we can afford to contract out without risking the core values provided to the clients.
We have fostered several alliances with suppliers of structural elements, including glued laminated lumber, pre-engineered dimension lumber trusses, engineered lumber, and steel to facilitate this strategy.
In the second year of operations, we intend to secure a storefront presence in Yellowknife. At this stage, we will seek qualified northern engineering students to provide them with work experience in a structural engineering office environment.
Technology
StructureAll Ltd. will maintain complete and comprehensive Windows®-based analysis tools for structural design. An integrated computer-aided design and drafting tool permits several evaluations to be made on a structure at minimal cost.
StructureAll Ltd. will maintain an Internet website complete with file transfer protocol (ftp) capabilities.
Future Services
Quality Control and Assurance: Serving the needs of the welding industry, we will ensure that certified firms and their employee welders are qualified to perform specific welds in accordance with the requirements of the Canadian Welding Bureau (CWB) as a certified welding inspector. We are currently in the process of completing a comprehensive home study program offered through the CWB for this purpose.
There are four firms presently in the Northwest Territories which require these services in order to maintain their certification with the CWB. On-site inspections are required four times per year.
Fabrication and Detailing Drawings: Serving the special needs of steel and concrete construction, StructureAll Ltd. will be working toward offering these services to contractors in the future.
Accident Reconstruction Services: We will act as a storefront for a well respected engineering firm in Edmonton (Renneberg and Wallace Ltd.) who have the knowledge and expertise to conduct this type of work. We will learn how to gather basic information from an accident site and act as a local representative to facilitate and expedite these services.
Toll-Free Communications: We will provide our clients a toll-free number to access 24 hours a day in the second year of operations.
MARKET ANALYSIS SUMMARY
StructureAll Ltd. will focus on traditional architect/engineering (A/E) contracts. The owner will usually contract the A/E to perform planning and design services. These design services include preparation of plans, specifications, and estimates.
Construction services may be limited to occasional field visits and certain contract administration requirements. Typically, these types of projects distribute total design fees among the professionals involved in accordance with the following guideline:
- Architecture Design (65%)
- Structural Design (10%)
- Mechanical Design (15%)
- Electrical Design (10%)
Our most important clients will be established architectural/engineering firms who require structural engineering services.
Market Segmentation
The market for engineering services may be summarized with the following groups:
- Established Architectural and Engineering firms: Typically, the structural portions of any building project involve a prime consultant who pre-selects their team members and promotes their strengths in a proposal call to prospective clients. Our strategy is to offer these established firms a viable resource from which to draw upon. We can undertake the entire structural engineering process or provide assistance to their own in-house staff.
- Territorial and Federal Governmental Departments: The Government of the Northwest Territories (GNWT) and the newly created Nunavut Territory retain consultants for a variety of purposes. We intend to position ourselves as a local firm offering expertise in consulting, project management, forensic, and restoration engineering. The Federal Government also retains consultants for similar purposes
- Law Firms: We will market our services to the legal community to provide dispute resolution services, including arbitration, mediation and expert reports for litigation. This work is supported by forensic engineering services to identify the cause of failures.
- Contractors: We will offer design/build services to contractors for the multitude of potential projects which the Territorial Government and Nunavut Territory have recently undertaken. Contractors occasionally require structural engineers to submit sealed alternatives for equivalents to construction details.
- Municipal Governments: Remote Municipal Governments in the Territories can expect to have more autonomy with respect to infrastructure growth and development in the years to come. This initiative is part of the GNWT mandate. We will promote our services to the local municipal governments for this purpose. To attract this market potential, we will offer to train those students in each community who are interested in engineering as a career choice. On the local front, the city of Yellowknife often provides recommendations to builders and homeowners for structural engineering services related to renovations, additions, and new construction.
- Private Individuals: We will focus attention on homeowners in Yellowknife who are renovating or contemplating an addition to their residence. We will also promote home inspections to those parties contemplating the purchase of a home.
- Realtors: In conjunction with home inspections, we will make all the Realtors aware of this service.
The Potential Market Chart and the Market Analysis Table are based on percentages which each of these groups could contribute to the services offered. This manner of describing the potential market is more appropriate for this type of business. As can be seen, the established architectural/engineering firms account for 65 percent of the potential market with the other participants claiming the balance in smaller proportions.
Market Analysis | |||||||
Potential Customers | Growth | 1999 | 2000 | 2001 | 2002 | 2003 | CAGR |
Architectural/Engineering firms | 0% | 65 | 65 | 65 | 65 | 65 | 0.00% |
Territorial/Federal Governments | 0% | 10 | 10 | 10 | 10 | 10 | 0.00% |
Law firms | 0% | 5 | 5 | 5 | 5 5 | 0.00% | |
Contractors | 0% | 5 | 5 | 5 | 5 5 | 0.00% | |
Municipal Governments | 0% | 5 | 5 | 5 | 5 5 | 0.00% | |
Private Individuals | 0% | 5 | 5 | 5 | 5 5 | 0.00% | |
Realtors | 0% | 5 | 5 | 5 | 5 5 | 0.00% | |
Other | 0% | 0 | 0 | 0 | 0 0 | 0.00% | |
Total | 0.00% | 100 | 100 | 100 | 100 | 100 | 0.00% |
Service Business Analysis
The following sections describe in more detail these aspects of the service business environment:
- Business Participants
- Competition and Buying Patterns
- Main Competitors
Business Participants
The majority of consulting services cater to the needs of the Territorial Governments. The Territorial Governments operate on a budget of approximately $1,170 million per year, based on the 1998/1999 Main Estimates. Of this total, approximately $1,028 million is spent on Operating and Maintenance Expenditures while $142 million is allocated to Capital Expenditures.
Within the Capital Expenditures, Buildings and Works is a sub-category. This is the area of the annual operating budget from which all building design consultants must draw upon. Our analysis of the 1998/1999 Main Estimates indicates a total expenditure of $59,339,000. A typical A/E contract derives fee estimates from total budgets. For this analysis, we will apply 9 percent as a guideline for design fees. This yields a figure of about $5,340,000 in design fees available for distribution to the consulting industry.
The major clients within the Territorial Governments include:
- Department of Education
- Department of Transportation
- Department of Municipal and Community Affairs
Our competition matrix indicates a total of 102 persons within the consulting field in the Territories. This total has been subdivided into the types of positions these people hold. Based on reasonable estimates of salary expectations including 30 percent burdens for administration yields a value of about $7,800,000. This figure represents an estimate of the revenues required to sustain engineering consultants in the Territories.
From this evaluation, the Territorial Governments account for close to 70 percent of design fees while other participants in the building marketplace account for the balance. The Territorial Governments retain consultants for the following types of buildings:
- Schools
- Health Centers
- Community Halls
- Arenas
- Warehouses
- Firehalls
These types of buildings are constructed on a rotating basis across several communities in the Northwest Territories. In addition to new construction, rehabilitation, renovations, and additions are also in demand.
Typically, the Territorial Governments issue a proposal call to consultants to service these needs. StructureAll will position itself as a Structural Sub-Consultant or resource to the Prime Consultant.
StructureAll Ltd. will also promote its services as structural specialists and project managers to the Territorial Governments.
Competition and Buying Patterns
Pricing of projects and billing rates are surprisingly variable. In consulting at this level, it is easier to be priced too low than too high. Clients and potential clients expect to pay substantial fees for the best quality professional advice. The nature of the billing, however, is sensitive. Clients are much more likely to be offended when a job starts at $20K and ends up at $30K because of overruns, than if the same job started at $30K or even $35K.
Clients rarely compare consultants directly, looking for two, or more, possible providers of a proposed project or job. Usually they follow word-of-mouth recommendations and either go for the job or not, rather than selecting from a menu of possible providers.
The most important element of general competition, by far, is what it takes to keep clients for repeat business. It is worth making huge concessions in any single project to maintain a client relationship that brings the client back for future projects.
Main Competitors
- Ferguson Simek Clark (FSC Group): This well-established architectural and multi-discipline engineering firm would be our main competitor. This firm has branch offices in Iqaluit, Northwest Territories, and Whitehorse, Yukon, besides a head office located in Yellowknife. Their principal strength is undertaking a project from inception through to completion under one roof. Their weakness stems from an understaffed structural engineering group. At present, there is only one structural engineer who services the needs of all their in-house architects and outside clients. The drafting aspects of any project rely upon recollection and modification of past projects typically. There is no systematic manner in which standard block libraries are maintained or updated. They underutilize the programs at their disposal for structural analysis and design.
- A. D. Williams Engineering Ltd. (ADWEL): This multi-discipline engineering firm is well established in Yellowknife. Their head office is located in Edmonton, Alberta. They can draw on additional resources from the core group as required to meet the demands of project schedules. At present, there is no resident structural engineer on staff in Yellowknife.
- Girvan and Associates: This is a small one-person architectural and engineering firm which specializes in providing services for residential construction projects. Ian Girvan services the private sector mostly. It is our hope that we can form a strategic alliance to carry out consulting work jointly as needs and occasions arise.
- B. Nelson Engineer: Mr. Nelson is a former partner with FSC Group who has resurfaced in the Territories to provide structural engineering services. His strength is his working relationship with existing architectural firms. His weakness stems from not having an established presence in the Territories. At present, he is working out of the offices of a mechanical engineering firm (Thorn Engineering Ltd.).
STRATEGY & IMPLEMENTATION SUMMARY
StructureAll Ltd. will focus on the Western Arctic area initially. We believe the creation of Nunavut will still provide opportunities for structural engineering services; however, a separate Association of Professional Engineers for Nunavut is anticipated.
We are also licensed to practice in the Yukon Territories, although we have not planned for any aggressive marketing in this area.
The target client is usually an architect manager.
Competitive Edge
StructureAll Ltd. offers the following competitive edge:
- State-of-the-art modeling, design, analysis, and drafting capabilities
- Quality control and assurance program
- An Internet website (http://www.structureall.com and e-mail, info@structureall.com)
Marketing Strategy
The sections which follow describe in more detail our positioning statement, pricing, and promotion strategy.
Positioning Statement
For established engineering and architectural firms in Yellowknife who require structural engineering sub-consultant services, StructureAll Ltd. offers a competitive and economical option. Projects may be delegated to StructureAll Ltd. directly or arrangements can be made to supplement and assist their own in-house staff.
Pricing Strategy
Most consulting work is billed on an hourly basis to pre-determined levels dictated by project schedule milestones. We have assigned a rate of $80/hour for basic consulting services and $40/hour for drafting services. These are conservative values for the consulting market. We have used conservative unit rates to remain more competitive.
Promotion Strategy
We will be using the Internet extensively in our sales promotion. Together with a well targeted direct mail and e-mail campaign, we will make all the major players in the marketplace aware of our presence.
We will focus our limited advertising budgets to promote community sponsored events. We will also offer technical services at discount rates to nonprofit organizations.
When traveling to remote communities, we will contact the local principals in elementary, middle, and high schools offering them a speaker on structural engineering as a career choice.
StructureAll Ltd. will apply for the Northwest Territories Business Incentive Policy. This policy is directed at those firms resident in the Northwest Territories and provides incentives with respect to evaluation of services.
Sales Strategy
Success in a consulting market is focused on client service and typically translates into repeat business. We will avoid the pitfall of buying a project, only to find that the scope of work far exceeds renumeration.
When a potential client questions the cost of a project, we explain the benefits and refer to our proposal which clearly outlines the tasks to be performed. If the budget is for less money, then we must offer less service.
Billing rates are not negotiated. One exception to this rule would be for not-for-profit organizations where marketing can be traded for services in kind.
Sales Forecast
The following table and chart summarizes forecasted sales. We expect sales to remain at a constant level after three months of operation. We predict the first two months of operations will be slow. Revenues will be limited while a generic quality management plan is formulated and basic office administration tasks are completed.
Direct unit costs for the first year have been set at 30 percent of unit revenues, which yields a 70 percent gross margin. In the third year of operations, we plan to increase gross margin to 80 percent as a result of providing a more efficient service to our clients.
Our unit rate for basic consulting services has been set at $80/hour. This is a conservative assumption based on published salary guideline levels for engineering professionals. Our unit rate for CADD services is $40/hour.
Sales Forecast | |||
Unit Sales | FY2000 | FY2001 | FY2002 |
Project Consulting | 690 | 750 | 800 |
Project Management | 240 | 260 | 280 |
Home Inspections | 96 | 110 | 120 |
Computer-aided Drafting Services | 890 | 1,000 | 1,050 |
Other | 0 | 0 | 0 |
Total Unit Sales | 1,916 | 2,120 | 2,250 |
Unit Prices | |||
Project Consulting | $80.00 | $80.00 | $80.00 |
Project Management | $80.00 | $80.00 | $80.00 |
Home Inspections | $80.00 | $80.00 | $80.00 |
Computer-aided Drafting Services | $40.00 | $40.00 | $40.00 |
Other | $0.00 | $0.00 | $0.00 |
Sales | |||
Project Consulting | $55,200 | $60,000 | $64,000 |
Project Management | $19,200 | $20,800 | $22,400 |
Home Inspections | $7,680 | $8,800 | $9,600 |
Computer-aided Drafting Services | $35,600 | $40,000 | $42,000 |
Other | $0 | $0 | $0 |
Total Sales | $117,680 | $129,600 | $138,000 |
Direct Unit Costs | |||
Project Consulting | $24.00 | $20.00 | $16.00 |
Project Management | $24.00 | $20.00 | $16.00 |
Home Inspections | $24.00 | $20.00 | $16.00 |
Computer-aided Drafting Services | $12.00 | $10.00 | $8.00 |
Other | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||
Project Consulting | $16,560 | $15,000 | $12,800 |
Project Management | $5,760 | $5,200 | $4,480 |
Home Inspections | $2,304 | $2,200 | $1,920 |
Computer-aided Drafting Services | $10,680 | $10,000 | $8,400 |
Other | $0 | $0 | $0 |
Subtotal Direct Cost of Sales | $35,304 | $32,400 | $27,600 |
Milestones
The accompanying table lists important program milestones, with dates and managers in charge, and budgets for each. The milestone schedule indicates our emphasis on planning for implementation.
What the table doesn't show is the commitment behind it. Our business plan includes complete provisions for plan vs. actual analysis, which will be updated monthly to compare the variance and plan for course corrections.
Milestones | |||||
Start Date | End Date | Budget | Manager | Department | |
Complete incorporation | 04/01/99 | 04/15/99 | $500 | PN | Administrative |
Acquire Tradename for Internet site | 03/06/99 | 03/06/99 | $400 | PN | Administrative |
Submit Business License Application | |||||
to City | 04/01/98 | 04/16/98 | $250 | PN | Administrative |
Aquire WCB Coverage | 04/01/98 | 04/16/98 | $50 | PN | Administrative |
Apply for Staad-Pro Core financing | 04/01/99 | 04/16/99 | n/a | PN | Administrative |
Aquire E&O Insurance | 04/01/98 | 04/16/98 | $1,200 | PN | Administrative |
Other | n/a | n/a | n/a | PN | n/a |
Totals | $2,400 |
MANAGEMENT SUMMARY
StructureAll Ltd. will initially have one employee who is also acting as general manager. Phil Nolan will be responsible for all daily operations in the firm.
Management Team
Philip Nolan, P. Eng. has eighteen years of progressive and responsible engineering experience. Phil will be responsible for soliciting clients, marketing, promotion, and all daily aspects of running the business. He graduated from McGill University in Montreal, Quebec, in 1981 with a Bachelor of Engineering degree.
Following graduation in 1981, Phil worked for consulting engineers in Toronto, Ontario, on a variety of transportation planning projects.
In 1982, Phil moved to Yellowknife where he worked for the GNWT as a project engineer. Phil gained experience working on a host of community development and transportation related projects, including Little Buffalo River Bridge, Bridge Inspections, and Bridge Rehabilitations. Phil was with the GNWT for six years.
From 1988 to 1991, Phil worked for Foundation Company of Canada Ltd., a large multi-national contracting firm as a project engineer where he gained experience in the use of explosives at the Magpie River Hydro Development and continued gaining experience on several bridge projects.
In 1992, Phil worked for Reid Crowther & Partners Ltd. out of Edmonton, Alberta, on a host of bridge design and rehabilitation projects, including the Whitemud Ravine Pedestrian Bridges.
From 1993 to 1995, Phil was self-employed as a private consultant offering services in quality control and assurance for building construction where he gained considerable experience in Preserved Wood Foundations and their use in residential and commercial applications.
In May of 1995, Phil joined the Ferguson Simek Clark (FSC) team of professionals and was responsible for all structural design, including quality control and assurance services for schools, arenas, health centers, and other buildings.
Phil will be the principal designer of all projects at StructureAll Ltd. Phil is currently working on a contract basis for Ferguson Simek Clark.
Management Team Gaps
StructureAll Ltd. will require administrative support to ensure clients are billed on a timely basis. We will be looking to an outside source for ensuring the books are kept in order and up to date.
Self sufficiency in computer-aided drafting capabilities will require Phil to become more familiar with AutoCADD 2000 as a drafting tool. We will invest in continuing education to fulfill this need. We have accounted for this in the business plan.
Personnel Plan
The following table summarizes our personnel expenditures for the first three years, with compensation increasing from $50K the first year to $70K in the third. The detailed monthly personnel plan for the first year is included in the appendices.
Personnel Plan | FY2000 | FY2001 | FY2002 |
Payroll | $50,000 | $60,000 | $70,000 |
FINANCIAL PLAN
Important Assumptions
The financial plan depends on important assumptions, most of which are shown in the following table as annual assumptions. The monthly assumptions are included in the appendices.
Some of the more important underlying assumptions are:
- We assume a strong economy, without major recession.
- We assume the creation of Nunavut will not dramatically change the delivery of engineering services.
- Interest rates, tax rates, and personnel burdens are based on conservative assumptions.
General Assumptions | FY2000 | FY2001 | FY2002 |
Short-term Interest Rate % | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate % | 10.00% | 10.00% | 10.00% |
Payment Days Estimator | 30 | 30 | 30 |
Collection Days Estimator | 45 | 45 | 45 |
Inventory Turnover Estimator | 6 | 6 | 6 |
Tax Rate % | 15.00% | 15.00% | 15.00% |
Expenses in Cash % | 10.00% | 10.00% | 10.00% |
Sales on Credit % | 100.00% | 100.00% | 100.00% |
Personnel Burden % | 15.00% | 15.00% | 15.00% |
Key Financial Indicators
We foresee modest growth in sales and a marginal reduction in operating expenses for the first three years.
Break-even Analysis
The following table and chart summarize our break-even analysis. With estimated monthly fixed costs of $6,500, billing targets of $10,000 per month will cover our costs. We don't really expect to reach break-even until a few months into the business operation.
The break-even assumes unit variable costs at 30 percent of unit revenue. The unit revenue value of $60/hour is an aggregate measure for all the types of services which will be offered.
Break-even Analysis: | |
Monthly Units Break-even | 238 |
Monthly Sales Break-even | $14,286 |
Assumptions: | |
Average Per-Unit Revenue | $60 |
Average Per-Unit Variable Cost | $18 |
Estimated Monthly Fixed Cost | $10,000 |
Projected Profit and Loss
The gross margin for a service-based business is a reflection of the efficiency at which those services are offered. In the initial year of operations, we have targeted a gross margin of 70 percent. This is not an unreasonable figure for a consulting business. For the second and third year of operations, we have targeted gross margins of 75 percent and 80 percent to indicate overall improved efficiency at service delivery.
In order to fulfill the requirements of the mission statement and simultaneously reduce startup costs, we have made arrangements to purchase software on quarterly repayment options:
- Staad-Pro Core is a structural engineering design and drafting suite offered through Research Engineers Ltd. This program fulfills the need to carry out three-dimensional analysis and design requirements and is a key feature of the business plan. This program supports Canadian codes and standards. We have contacted the authorized Canadian reseller (Detech Corporation Ltd.) and will made arrangements to purchase this tool on four payments of $1,550 over the first year of operations.
- Errors and Omissions Insurance is required for all consultants working on behalf of the Territorial Governments. Through Falconair Insurance, we have received a quotation of $1,200/year for this coverage. The first year's premium payments are included in the start-up costs, with subsequent years indicated at the same annual premium.
- Website hosting fees are included as quarterly payments to Internic.com, the web host. This service provides the company with a valuable marketing tool. As part of this service, we will have at our disposal file transfer protocol capabilities. This feature permits us to place electronic media on the Internet for our clients and strategic allies.
- Rent for storefront office space has been included in the profit and loss table for the second and third years of operations. An allowance of $500 per month has been indicated for Contracts and Sub-Consultants.
Net Profit/Sales is determined to be 7.8 percent the first year, increasing to 9.8 percent the second year and 11 percent the third year.
Profit and Loss (Income Statement) | |||
FY2000 | FY2001 | FY2002 | |
Sales | $117,680 | $129,600 | $138,000 |
Direct Cost of Sales | $35,304 | $32,400 | $27,600 |
Production Payroll | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Total Cost of Sales | $35,304 | $32,400 | $27,600 |
Gross Margin | $82,376 | $97,200 | $110,400 |
Gross Margin % | 70.00% | 75.00% | 80.00% |
Advertising/Promotion | $850 | $1,000 | $1,000 |
Engineering Association Annual Fees | $600 | $750 | $750 |
Continuing Education | $900 | $900 | $900 |
Yellow Pages/White Pages | $500 | $500 | $500 |
Miscellaneous | $600 | $600 | $600 |
Payroll Expense | $50,000 | $60,000 | $70,000 |
Payroll Burden | $0 | $0 | $0 |
Depreciation | $1,800 | $1,800 | $1,800 |
Website Hosting Fees | $380 | $380 | $380 |
Telephone/Fax | $2,400 | $2,400 | $2,400 |
Software Purchases (Staad-Pro Core) | $6,200 | $300 | $300 |
Utilities | $1,200 | $1,200 | $1,200 |
Errors and Omissions Insurance | $0 | $1,200 | $1,200 |
Rent | $0 | $4,800 | $4,800 |
Contract/Consultants | $6,000 | $6,000 | $6,000 |
Total Operating Expenses | $71,430 | $81,830 | $91,830 |
Profit Before Interest and Taxes | $10,946 | $15,370 | $18,570 |
Interest Expense Short-term | $0 | $0 | $0 |
Interest Expense Long-term | $179 | $495 | $830 |
Taxes Incurred | $1,615 | $2,231 | $2,661 |
Extraordinary Items | $0 | $0 | $0 |
Net Profit | $9,152 | $12,644 | $15,079 |
Net Profit/Sales | 7.78% | 9.76% | 10.93% |
Projected Cash Flow
Cash flow projections are critical to our success. The monthly cash flow is shown in the illustration, with one bar representing the cash flow per month, and the other the monthly balance. The first few months are critical. It may be necessary to inject additional capital in this time-frame if the need arises. The annual cash flow figures are included here and the more important detailed monthly numbers are included in the appendices.
Projected Cash Flow | |||
FY2000 | FY2001 | FY2002 | |
Net Profit | $9,152 | $12,644 | $15,079 |
Plus: | |||
Depreciation | $1,800 | $1,800 | $1,800 |
Change in Accounts Payable | $3,677 | $513 | ($401) |
Current Borrowing (repayment) | $0 | $0 | $0 |
Increase (decrease) Other Liabilities | $0 | $0 | $0 |
Long-term Borrowing (repayment) | $3,300 | $3,300 | $3,400 |
Capital Input | $0 | $0 | $0 |
Subtotal | $17,930 | $18,257 | $19,878 |
Less: | |||
Change in Accounts Receivable | $15,360 | $1,556 | $1,096 |
Change in Inventory | $0 | $0 | $0 |
Change in Other Short-term Assets | $0 | $0 | $0 |
Capital Expenditure | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal | $15,360 | $1,556 | $1,096 |
Net Cash Flow | $2,570 | $16,701 | $18,781 |
Cash Balance | $9,570 | $26,271 | $45,052 |
Projected Balance Sheet
The balance sheet in the following table shows managed but sufficient growth of net worth and a sufficiently healthy financial position. The monthly estimates are included in the appendices.
Projected Balance Sheet | |||
Assets | |||
Short-term Assets | FY2000 | FY2001 | FY2002 |
Cash | $9,570 | $26,271 | $45,052 |
Accounts Receivable | $15,360 | $16,916 | $18,012 |
Inventory | $0 | $0 | $0 |
Other Short-term Assets | $0 | $0 | $0 |
Total Short-term Assets | $24,930 | $43,186 | $63,064 |
Long-term Assets | |||
Capital Assets | $0 | $0 | $0 |
Accumulated Depreciation | $1,800 | $3,600 | $5,400 |
Total Long-term Assets | ($1,800) | ($3,600) | ($5,400) |
Total Assets | $23,130 | $39,586 | $57,664 |
Liabilities and Capital | |||
Accounts Payable | $3,677 | $4,190 | $3,789 |
Short-term Notes | $0 | $0 | $0 |
Other Short-term Liabilities | $0 | $0 | $0 |
Subtotal Short-term Liabilities | $3,677 | $4,190 | $3,789 |
Long-term Liabilities | $3,300 | $6,600 | $10,000 |
Total Liabilities | $6,977 | $10,790 | $13,789 |
FY2000 | FY2001 | FY2002 | |
Paid in Capital | $20,000 | $20,000 | $20,000 |
Retained Earnings | ($13,000) | ($3,848) | $8,796 |
Earnings | $9,152 | $12,644 | $15,079 |
Total Capital | $16,152 | $28,796 | $43,875 |
Total Liabilities and Capital | $23,130 | $39,586 | $57,664 |
Net Worth | $16,152 | $28,796 | $43,875 |
Business Ratios
The following table shows the projected business ratios. We expect to maintain healthy ratios for profitability, risk, and return.
Ratio Analysis | ||||
Profitability Ratios: | FY2000 | FY2001 | FY2002 | RMA |
Gross Margin | 70.00% | 75.00% | 80.00% | 0 |
Net Profit Margin | 7.78% | 9.76% | 10.93% | 0 |
Return on Assets | 39.57% | 31.94% | 26.15% | 0 |
Return on Equity | 56.66% | 43.91% | 34.37% | 0 |
Activity Ratios | ||||
AR Turnover | 7.66 | 7.66 | 7.66 | 0 |
Collection Days | 24 | 45 | 46 | 0 |
Inventory Turnover | 0.00 | 0.00 | 0.00 | 0 |
Accounts Payable Turnover | 13.88 | 12.17 | 12.17 | 0 |
Total Asset Turnover | 5.09 | 3.27 | 2.39 | 0 |
Debt Ratios | ||||
Debt to Net Worth | 0.43 | 0.37 | 0.31 | 0 |
Short-term Liability to Liability | 0.53 | 0.39 | 0.27 | 0 |
Liquidity Ratios | ||||
Current Ratio | 6.78 | 10.31 | 16.64 | 0 |
Quick Ratio | 6.78 | 10.31 | 16.64 | 0 |
Net Working Capital | $21,252 | $38,996 | $59,275 | 0 |
Interest Coverage | 61.24 | 31.05 | 22.37 | 0 |
Additional Ratios | ||||
Assets to Sales | 0.20 | 0.31 | 0.42 | 0 |
Debt/Assets | 30% | 27% | 24% | 0 |
Current Debt/Total Assets | 16% | 11% | 7% | 0 |
Acid Test | 2.60 | 6.27 | 11.89 | 0 |
Asset Turnover | 5.09 | 3.27 | 2.39 | 0 |
Sales/Net Worth | 7.29 | 4.50 | 3.15 | 0 |
Dividend Payout | $0 | $0 | $0 | 0 |
Projected Balance Sheet
Assets | |||||||
Short-term Assets | Starting Balances | Apr | May | Jun | Jul | Aug | |
Cash | $7,000 | $4,108 | $596 | $2,337 | $3,217 | $3,554 | |
Accounts Receivable | $0 | $7,840 | $12,782 | $13,374 | $14,760 | $15,360 | |
Inventory | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Short-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Short-term Assets | $7,000 | $11,948 | $13,379 | $15,711 | $17,977 | $18,914 | |
Long-term Assets | |||||||
Capital Assets | $0 | $0 | $0 | $0 | $0 | $0 | |
Accumulated Depreciation | $0 | $150 | $300 | $450 | $600 | $750 | |
Total Long-term Assets | $0 | ($150) | ($300) | ($450) | ($600) | ($750) | |
Total Assets | $7,000 | $11,798 | $13,079 | $15,261 | $17,377 | $18,164 | |
Liabilities and Capital | |||||||
Accounts Payable | $0 | $4,467 | $3,460 | $3,500 | $5,011 | $3,796 | |
Short-term Notes | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Short-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Short-term Liabilities | $0 | $4,467 | $3,460 | $3,500 | $5,011 | $3,796 | |
Long-term Liabilities | $0 | $275 | $550 | $825 | $1,100 | $1,375 | |
Total Liabilities | $0 | $4,742 | $4,010 | $4,325 | $6,111 | $5,171 | |
Paid in Capital | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | |
Retained Earnings | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | |
Earnings | $0 | $56 | $2,069 | $3,936 | $4,266 | $5,993 | |
Total Capital | $7,000 | $7,056 | $9,069 | $10,936 | $11,266 | $12,993 | |
Total Liabilities and Capital | $7,000 | $11,798 | $13,079 | $15,261 | $17,377 | $18,164 | |
Net Worth | $7,000 | $7,056 | $9,069 | $10,936 | $11,266 | $12,993 |
Sep | Oct | Nov | Dec | Jan | Feb | Mar |
$5,706 | $6,687 | $6,665 | $7,517 | $8,629 | $8,649 | $9,570 |
$15,360 | $15,360 | $15,360 | $15,360 | $15,360 | $15,360 | $15,360 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$21,066 | $22,047 | $22,025 | $22,877 | $23,989 | $24,009 | $24,930 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$900 | $1,050 | $1,200 | $1,350 | $1,500 | $1,650 | $1,800 |
($900) | ($1,050) | ($1,200) | ($1,350) | ($1,500) | ($1,650) | ($1,800) |
$20,166 | $20,997 | $20,825 | $21,527 | $22,489 | $22,359 | $23,130 |
$3,798 | $4,922 | $4,114 | $3,672 | $4,890 | $4,045 | $3,677 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$3,798 | $4,922 | $4,114 | $3,672 | $4,890 | $4,045 | $3,677 |
$1,650 | $1,925 | $2,200 | $2,475 | $2,750 | $3,025 | $3,300 |
$5,448 | $6,847 | $6,314 | $6,147 | $7,640 | $7,070 | $6,977 |
$20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) |
$7,718 | $7,150 | $7,511 | $8,380 | $7,849 | $8,289 | $9,152 |
$14,718 | $14,150 | $14,511 | $15,380 | $14,849 | $15,289 | $16,152 |
$20,166 | $20,997 | $20,825 | $21,527 | $22,489 | $22,359 | $23,130 |
$14,718 | $14,150 | $14,511 | $15,380 | $14,849 | $15,289 | $16,152 |
Projected Cash Flow
Apr | May | Jun | Jul | Aug | Sep | ||
Net Profit | $56 | $2,013 | $1,867 | $331 | $1,727 | $1,725 | |
Plus: | |||||||
Depreciation | $150 | $150 | $150 | $150 | $150 | $150 | |
Change in Accounts Payable | $4,467 | ($1,007) | $40 | $1,510 | ($1,215) | $2 | |
Current Borrowing (repayment) | $0 | $0 | $0 | $0 | $0 | $0 | |
Increase (decrease) Other Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Borrowing (repayment) | $275 | $275 | $275 | $275 | $275 | $275 | |
Capital Input | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $4,948 | $1,431 | $2,332 | $2,266 | $937 | $2,152 | |
Less: | |||||||
Change in Accounts Receivable | $7,840 | $4,942 | $592 | $1,386 | $600 | $0 | |
Change in Inventory | $0 | $0 | $0 | $0 | $0 | $0 | |
Change in Other Short-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | |
Capital Expenditure | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $7,840 | $4,942 | $592 | $1,386 | $600 | $0 | |
Net Cash Flow | ($2,892) | ($3,511) | $1,740 | $880 | $337 | $2,152 | |
Cash Balance | $4,108 | $596 | $2,337 | $3,217 | $3,554 | $5,706 |
General Assumptions
Apr | May | Jun | Jul | Aug | Sep | |
Short-term Interest Rate % | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate % | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
Payment Days Estimator | 30 | 30 | 30 | 30 | 30 | 30 |
Collection Days Estimator | 45 | 45 | 45 | 45 | 45 | 45 |
Inventory Turnover Estimator | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 |
Tax Rate % | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
Expenses in Cash % | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
Sales on Credit % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
Personnel Burden % | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
Personnel Plan
Apr | May | Jun | Jul | Aug | Sep | |
Payroll | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 |
Oct | Nov | Dec | Jan | Feb | Mar |
($568) | $361 | $869 | ($531) | $440 | $863 |
$150 | $150 | $150 | $150 | $150 | $150 |
$1,125 | ($808) | ($442) | $1,218 | ($845) | ($368) |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$275 | $275 | $275 | $275 | $275 | $275 |
$0 | $0 | $0 | $0 | $0 | $0 |
$982 | ($22) | $852 | $1,112 | $20 | $920 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$982 | ($22) | $852 | $1,112 | $20 | $920 |
$6,687 | $6,665 | $7,517 | $8,629 | $8,649 | $9,570 |
Oct | Nov | Dec | Jan | Feb | Mar |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
30 | 30 | 30 | 30 | 30 | 30 |
45 | 45 | 45 | 45 | 45 | 45 |
6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 |
15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
Oct | Nov | Dec | Jan | Feb | Mar |
$5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Profit and Loss (Income Statement)
Apr | May | Jun | Jul | Aug | Sep | |
Sales | $7,840 | $8,640 | $9,040 | $10,240 | $10,240 | $10,240 |
Direct Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 |
Production Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Total Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 |
Gross Margin | $5,488 | $6,048 | $6,328 | $7,168 | $7,168 | $7,168 |
Gross Margin % | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% |
Advertising/Promotion | $200 | $100 | $50 | $50 | $50 | $50 |
Engineering Association Annual Fees | $0 | $0 | $0 | $0 | $0 | $0 |
Continuing Education | $75 | $75 | $75 | $75 | $75 | $75 |
Yellow Pages/White Pages | $0 | $0 | $0 | $0 | $0 | $0 |
Miscellaneous | $50 | $50 | $50 | $50 | $50 | $50 |
Payroll Expenses | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 |
Payroll Burden | $0 | $0 | $0 | $0 | $0 | $0 |
Depreciation | $150 | $150 | $150 | $150 | $150 | $150 |
Website Hosting Fees | $95 | $0 | $0 | $95 | $0 | $0 |
Telephone/Fax | $200 | $200 | $200 | $200 | $200 | $200 |
Software Purchases (Staad-Pro Core) | $1,550 | $0 | $0 | $1,550 | $0 | $0 |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 |
Errors and Omissions Insurance | $0 | $0 | $0 | $0 | $0 | $0 |
Rent | $0 | $0 | $0 | $0 | $0 | $0 |
Contract/Consultants | $500 | $500 | $500 | $500 | $500 | $500 |
Total Operating Expenses | $5,420 | $3,675 | $4,125 | $6,770 | $5,125 | $5,125 |
Profit Before Interest and Taxes | $68 | $2,373 | $2,203 | $398 | $2,043 | $2,043 |
Interest Expense Short-term | $0 | $0 | $0 | $0 | $0 | $0 |
Interest Expense Long-term | $2 | $5 | $7 | $9 | $11 | $14 |
Taxes Incurred | $10 | $355 | $329 | $58 | $305 | $304 |
Extraordinary Items | $0 | $0 | $0 | $0 | $0 | $0 |
Net Profit | $56 | $2,013 | $1,867 | $331 | $1,727 | $1,725 |
Net Profit/Sales | 0.71% | 23.30% | 20.65% | 3.23% | 16.86% | 16.84% |
Oct | Nov | Dec | Jan | Feb | Mar |
$10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 |
$3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 |
$7,168 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 |
70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% |
$100 | $50 | $50 | $50 | $50 | $50 |
$0 | $600 | $0 | $0 | $0 | $0 |
$75 | $75 | $75 | $75 | $75 | $75 |
$0 | $0 | $0 | $0 | $500 | $0 |
$50 | $50 | $50 | $50 | $50 | $50 |
$5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
$0 | $0 | $0 | $0 | $0 | $0 |
$150 | $150 | $150 | $150 | $150 | $150 |
$95 | $0 | $0 | $95 | $0 | $0 |
$200 | $200 | $200 | $200 | $200 | $200 |
$1,550 | $0 | $0 | $1,550 | $0 | $0 |
$100 | $100 | $100 | $100 | $100 | $100 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$500 | $500 | $500 | $500 | $500 | $500 |
$7,820 | $6,725 | $6,125 | $7,770 | $6,625 | $6,125 |
($652) | $443 | $1,043 | ($602) | $543 | $1,043 |
$0 | $0 | $0 | $0 | $0 | $0 |
$16 | $18 | $21 | $23 | $25 | $28 |
($100) | $64 | $153 | ($94) | $78 | $152 |
$0 | $0 | $0 | $0 | $0 | $0 |
($568) | $361 | $869 | ($531) | $440 | $863 |
-5.55% | 3.53% | 8.49% | -5.19% | 4.30% | 8.43% |
Sales Forecast
Unit Sales | Apr | May | Jun | Jul | Aug | Sep | |
Project Consulting | 50 | 50 | 50 | 60 | 60 | 60 | |
Project Management | 20 | 20 | 20 | 20 | 20 | 20 | |
Home Inspections | 8 | 8 | 8 | 8 | 8 | 8 | |
Computer-aided Drafting Services | 40 | 60 | 70 | 80 | 80 | 80 | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Unit Sales | 118 | 138 | 148 | 168 | 168 | 168 | |
Unit Prices | |||||||
Project Consulting | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Project Management | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Home Inspections | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Computer-aided Drafting Services | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||
Project Consulting | $4,000 | $4,000 | $4,000 | $4,800 | $4,800 | $4,800 | |
Project Management | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
Home Inspections | $640 | $640 | $640 | $640 | $640 | $640 | |
Computer-aided Drafting Services | $1,600 | $2,400 | $2,800 | $3,200 | $3,200 | $3,200 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $7,840 | $8,640 | $9,040 | $10,240 | $10,240 | $10,240 | |
Direct Unit Costs | |||||||
Project Consulting | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | |
Project Management | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | |
Home Inspections | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | |
Computer-aided Drafting Services | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Direct Cost of Sales | |||||||
Project Consulting | $1,200 | $1,200 | $1,200 | $1,440 | $1,440 | $1,440 | |
Project Management | $480 | $480 | $480 | $480 | $480 | $480 | |
Home Inspections | $192 | $192 | $192 | $192 | $192 | $192 | |
Computer-aided Drafting Services | $480 | $720 | $840 | $960 | $960 | $960 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 |
Oct | Nov | Dec | Jan | Feb | Mar |
60 | 60 | 60 | 60 | 60 | 60 |
20 | 20 | 20 | 20 | 20 | 20 |
8 | 8 | 8 | 8 | 8 | 8 |
80 | 80 | 80 | 80 | 80 | 80 |
0 | 0 | 0 | 0 | 0 | 0 |
168 | 168 | 168 | 168 | 168 | 168 |
$80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 |
$80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 |
$80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 |
$40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 |
$0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
$4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 |
$1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
$640 | $640 | $640 | $640 | $640 | $640 |
$3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 |
$0 | $0 | $0 | $0 | $0 | $0 |
$10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 |
$24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
$24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
$24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
$12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 |
$0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
$1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
$480 | $480 | $480 | $480 | $480 | $480 |
$192 | $192 | $192 | $192 | $192 | $192 |
$960 | $960 | $960 | $960 | $960 | $960 |
$0 | $0 | $0 | $0 | $0 | $0 |
$3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 |