My Proposal

Download as pdf or txt
Download as pdf or txt
You are on page 1of 24

BUSINESS PLAN: SAVE THE TIME AUTO WASH

Presented to:
Sir Qazi Waheed
Presented by:
Muhammad Afraz

Muhammad Junaid

Hamayun Khan

Sunniya Tariq

Tufail Shakir

Tufail Badshah

BBA (H) 2nd Semester


Group C
Dated: 19-11-2009

1|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH

Acknowledgement
• We owe our gratitude to Allah Almighty for His blessings and
kindness that we were able to accomplish the challenging task
successfully and enthusiastically.
• We acknowledge with deep gratitude the invaluable help extended
to us by our respected teacher: Sir Qazi Waheed whose
indispensable and detailed comments and untiring guidance on
various aspects combined with encouragement made us come forth
holding this article.

2|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
TABLE OF CONTENTS

Page No.

 Brief

Summary…………………………………………………………………………………………………4

 Mission and Vision Statement…………………………………………………..………………………

 Marketing Strategy…………………………………………………………………..

………………………4

 Products and Services………………………………………………………….

………………………….5

 Location………………………………………………………………………………….

…........................5

 Marketing Plan……………………………………………………………….

………………………………..6

 Situation Analysis………………………………………………..

……………………………………..6

 SWOT

Analysis……………………………………………………………………………………………7

 Market Segmentation…………………………………………………………………………………

 Market Targeting……………………………………………..

…………………………………………11

 Marketing Mix (4 P’s)………………………………….………………………………………………

11.

 Keys to

Success…………………………………………………………………………………………………..12
3|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
 Organizational

Plan……………………………………………………………………………………………..13

 Description about

Partners……………………………………………………………………………12

 Financial

Plan………………………………………………………………………………………………………..15

 Startup

Cost…………………………………………………………………………………………………….15

 Sources of

Capital…………………………………………………………………………………………………..1

 Break-Even

Analysis………………………………………………………………………………………………16

 Pro-Forma Income

Statement……………………………………………………………………………….17

 Pro-Forma Cash Flow

Statement………………………………………………………………………….18

4|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH

BRIEF SUMMARY
Save Time Auto Wash is a dynamic start-up company that will provide exceptional
car care services to the customers. Quality services that will exceed expectations will
establish Rinse Auto Wash as the premiere car wash service in the area. It will
provide the following services to the local community:

1. High pressure cleaning.


2. Shampoo wash.
3. Liquid wax spray.
4. Wheel brush washes.
5. Rinsing and drying.

Mission
Save Time Auto Wash is dedicated to providing its customers the ultimate car care
experience. Focusing all of its energy and resources on customer satisfaction and
value, while providing owners and employees an excellent reward.

Vision

To become so value oriented towards customers so that every vehicle should pass
through our bay.

Marketing Strategy
Marketing in our car wash business relies on the name recognition of the Laser wash
system as an industry leader and the "curbside" appeal of the site for first time
customers. Quality service will bring customers back time and time again. Also, use
of a local radio station and the "word of mouth" advertising of satisfied customers will
grow our customer base. We will offer a competitive price for all budgets. Our
average price per wash will be Rs. 400.

Competitive Edge
We start with a critical competitive edge: there is no competitor of Save Time Auto
Wash that offers a 2-bay, automatic and self-serve combination car wash. Currently,
Peshawar customers must plan significant time and/or effort to get a quality car
wash. Our positioning in these areas is very hard to match if we maintain our focus
on customer service, speed, quality and reliability.

5|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
Products and Services

• Rinse Auto Wash will develop an attractive, low maintenance, fully equipped
and customer friendly car wash designed to draw a wide customer base.
• The car wash will feature state-of-the-art equipment designed for quality,
reliability and easy usage.
• Conveniently located within each self serve bay will be a soft, but durable,
foaming brush for quick, easy and thorough cleaning.
• In addition, there will be a centrally located carpet shampoo machine, t`wo
fragrance machines and bill changers, along with a vending area that will
feature accessory items such as drying towels, tire cleaner.

Location

A car wash station would be of a novelty and only one of its kinds in Peshawar.
Having surveyed and keeping in mind the huge investment, I have chosen a very
posh area of Peshawar which I believe will provide a huge clientage. We prefer Tehkal
is the most suitable site.

The Surrounding vicinity of Tehkal is an area over flowing with vehicles of all
sorts off course much with branded cars. The civil society of this marked area is the
most elitist class at least in Peshawar. Every residence has minimum two vehicles
parked in the porch. Clean and tidy society, keeps their vehicles dazzling and shining
for any price they have to pay. Current society is busy, and in this era of fast
disposal, would prefer to utilize services of an automatic car wash because they are
always short of time.

Reason for going in this Business?

To start with a new business, is always asking the entrepreneur to deeply


ponder over all the dimensions of profit and loss (Profit being the first priority). The
canvass of business, its magnitude depends upon the scale of investment that is i.e.
the capital investment, nature of business, suitability and off courses countless other
areas. Priority with an entrepreneur will always be to have his investment back
through the selected business with the reasonable margin of profit.

A car wash enterprise is a profitable idea, and having thought over it with all
my human capacity, I have decided to go for an automatic car wash. I fully
understand, the project requires energy and energizer.

6|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
MARKETING PLAN
Situation Analysis (Where we have been?)
Since it’s a new venture so there is no such background of Automatic car wash in
Peshawar but if we see in Karachi the latest version of the value-added ‘automatic
car wash’ namely “Wash Express” has been introduced at a limited number of retail
outlets to provide a unique experience in terms of a highly automated, state-of-the-
art car wash facility at PSO stations with an added dimension of flexibility,
convenience and speed. Currently, there are three ‘Wash Express’ units at Karachi
offering a high-tech car wash facility with various value added features and special
packages, an experience truly worthwhile! The Auto Car Wash facility is being
currently offered at PSO Stations. The first Wash Express plant which was installed at
PSO commenced from September 3, 2007, the objective of this project being to
enhance the ‘customer-expectation’ level, set new benchmarks and of course, above
all, to make one’s experience even more rewarding, the initial feedback is
encouraging.

A car wash enterprise is a profitable idea, and having thought over


it, we’ve decided to go for an automatic car wash in order to satisfy consumer needs
and wants. We want to satisfy our customers by saving their time. Our venture name
is “Save Time Auto Wash”.

Market Needs:
Rinse Auto Wash is providing the market with a premium automatic car wash service
for the Peshawar community. SR seeks to fulfill the following benefits that are
important to the customers:

• Exemplary customer service- The target customers have money and are
used to having excellent customer service. They will not regularly use SR
unless they receive excellent service.
• High quality washes- The target market value a higher quality wash for their
upper-end cars.
• Convenience- The hours of operation as well as the time needed to provide
the service must be convenient and fast respectively, to gain market share

Market Trends:
The market trends for the car washing industry have been gravitation from hand
washing to automatic washing machine facilities. This trend has been fueled by the
progression of technology. The automatic washing machines have become less
expensive and more efficient over the last few years to the point that it is typically
cost effective to invest in these machines.

7|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
SWOT ANALYSIS
Now we consider some of the Strengths, Weaknesses, Opportunities, and Threats
that will come across our desired service venture.

1: Strengths
Strengths are the internal factors of a venture or a company. Following are some of
our strengths:

• Time saving: our main and biggest strength is the saved time. As everyone
knows that a manual car wash takes about 40-50 minutes per car, which bother
the car users and that’s why they like to wash their car at home rather than at
a wash station. While an automatic car wash system takes only 5 minutes to
wash a car and without any problem. In this way we can attract a large number
of customers.

• First mover advantage: there are lots of car wash stations in Peshawar but
all of them are hand car wash (manual). In this situation, we’ve got a first
mover advantage of providing car wash service by an automated station.

• Low labor cost: since it’s all about buttons and bays, we don’t have that
much labor forces or employees. It can be operated by a single person. In this
way we can reduce our cost. Though the cost of machinery is very high, but by
reduction of labor cost we mean that we can reduce our operating expenses.

• Safety: It’s another noticeable strength of our venture as there is a possibility


that a car may damage during manual car wash due to unbalanced lift beds or
some carelessness from the labors. But like we mentioned automatic car wash
can be operated by a single person because all the work is done by machinery.
And there are no lift beds as well. So the chances of damages are very rare.

2: Weaknesses:
Weaknesses are also internal factors of a venture. There is not even a single
business that doesn’t have any weaknesses. And our venture is not cent percent
strong as well. Here are some weaknesses that might cause problems to our plan.

• Lack of skilled employees: this might be a weakness of our venture. As this


idea is new in Peshawar and less people are aware of this opportunity. So it
is a possibility that the person we hire may not understand how to operate
the machinery. As a result we might lose our goodwill and so lose our
customers.

• Machinery Repair: like we said that the people in Peshawar are unaware of
this business. As there might be a lack of skilled labor, similarly there will be
8|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
shortage of repairers of the machinery. And if machinery stops its function
due to some problems so we have to bring the repairers from Karachi or
Islamabad. And in severe cases we might send the machinery outside the
city for repair. All these things will increase our cost too much.

• The need for reliance on outside investors: if we were unable to make


profits for more years, we have to be depending on outside investors for
more capital.

• Entering without prior experience: this can be a weakness for our


business. Starting a new venture without knowing the pros and cons is
always risky. It may happen that our venture flops.

3: Opportunities:
Opportunities are external factors of a business. Here are some opportunities for
our business.

• New location: if we were successful in our venture and gained enough


market share by satisfying our proposed customers, we might get the
opportunity to open the same service venture at new areas both in
Peshawar as well as in other cities.

• Enhancement in services: with our successful results in car wash, we


might start some other small services like, car spare parts shop, tires, petrol
pumps, CNG stations.

• Gold and Platinum Car Wash.

4: Threats:
Threats are also external factors that might stop one’s venture from growing. Our
venture has also got some threats:

• Competition: competitor is the biggest threat for a business whether it’s a


restaurant, a video retail store, garments, or an automatic car wash. We
have got the first mover advantage in Peshawar but it might happen that
some other person may open an automatic car wash as well. And then price
wars and quality wars may rise. So this can be the biggest threat.

• Slumps in Economy: includes inflation. Due to which prices will rise and
people will spend less money and therefore will switch to manual car wash.
This situation will also be problematic.

9|Page
BUSINESS PLAN: SAVE THE TIME AUTO WASH
• Govt. Regulations: govt. regulations can also cause some problems. If
they criticize us on our point of location, or impose other taxes on us then
our venture can flop.

• The perception that there is not a difference in quality between a


hand and machine wash.

10 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

GENERAL MARKET
Our general market will consist of Upper-Upper, Lower Upper, and Upper
Middle.

MARKET SEGMENTATION
Segmentation is the Process of dividing a market into definable and
measureable groups for purposes of targeting marketing strategy.

We’ve segmented the market into smaller groups based on characteristics of


the customer or buying situations.

A. Characteristics of the customer

• Geographic Segmentation

We can segment our market on the basis of location. In Peshawar, people are
most likely to come from these places:

• University Town
• Shami Road
• Hayatabad
• Defence
• Cantt (Saddar)
• Tehkal
• Ring Road

• Demographic Segmentation

Demographic segmentation includes:

a) Age

We can segment our market on the basis of age as a fixed percentage as


follows:

Age 19-25: 30% of this segment of age will be using our services. This range
includes youngsters who are seeking education.

Age 35-50: 50% of this segment of age will be using our services. This range
includes businessmen, executives and doctors.

Age above 50: 20% of this segment of age will be using our services. This age
includes retirees.

11 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
b) Gender

We can also segment our market on the basis of gender as a fixed percentage.
In Peshawar, males are more likely to be served by us than females due to
cultural factors. So we’ve estimated that:

75% Males will be using our services.

25% Females will be using our services.

c) Occupation

Similarly we can divide our market on the basis of occupation as well. Based on
occupation, these people are likely to use our services:

• Doctors
• Executives
• Professionals/Businessmen
• Dual family carriers
• Luxury car owners
• College and University students
• Racers

All these segments are the potential customers of our venture.

d) Income

All those people, whose income is greater than 35,000, are likely to be served
by us.

• Psychographic Segmentation

Psycho graphically, we can divide our market on the basis of:

• Lifestyles: consider cell phones, a decade ago only 2 out of 10 persons


had cell phones. But the trends are changed. Every single person has a
cell phone. Similarly, the trends for cars have also changed. Firstly, there
was only one car in a home, but now 2 or 3 are there. One for husband,
one for wife, and one for the son. Lifestyles have been changed. So
families of this kind of lifestyles are also more likely to be served by our
venture. Because they have more cars and they can’t wait for 40 minutes
for each one.

B. Buying Situations:

Segmentation can also be done on buying situations. It included:

12 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
• Usage rates: those people who travel a lot in cars, even for small
distances are also targeted by our venture. Because the more they
travel, the more their car gets dirty, and so more is the likelihood that
they will be served by us. Because if they want to wash their cars daily,
so they can’t wait for 40 minutes daily just for the car wash. They will try
to save their time and so does our venture.

MARKET TARGETING
Market Targeting is specific group of potential customers toward which venture
aims its marketing plan. Out of above listed segments, we’ll mainly target the
following:

• Doctors
• Executives
• Professionals/Businessmen
• Dual family carriers
• Luxury car owners

In addition to all these segments, all those segments based on characteristics


of customers or buying situations will also be targeted. The fact that the
remaining segments (University students, Racers) are not added in the
targeting list doesn’t mean that they are not allowed to our venture but it
means that the probability of the listed segments is much high as compared to
them.

MARKETING MIX (4 P’S)


The controllable variables that a venture puts together to satisfy a target
group.

Product:

As our venture is a service venture so it doesn’t have any tangible product. But
we can add these things into our product category:

 Brand Name:

Rinse Auto Wash

 Pricing policy

For 800-1000cc Cars: Rs. 300


13 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
For 1300-1800cc Cars: Rs. 400

For Luxury Cars (2000-3000cc): Rs. 50

 Allowances

• We shall issue membership cards and deliver discounts on those cards.


• A free car wash for every 4 washes.

 Quality service

We will provide the best quality as compared to manual car wash system and
so will make loyal customers by making a perception that auto car wash is
better than the other one.

Price:

Following will be our pricing strategies:


For 800-1000cc Cars: Rs. 300
For 1300-1800cc Cars: Rs. 400
For Luxury Cars (2000-3000cc): Rs. 500

Place:

Similarly, we don’t have any distribution channels for our service. Our location
of the service will be Tehkal. And if we gained success here we shall expand
our venture in new areas both inside and outside Peshawar.

Promotion:

Promotion is the main P of the Marketing Mix. Due to this pillar, we make
awareness among our potential customers. We define certain strategies in
order to attract customers. Without Promotion, a venture cannot succeed. We
will promote our venture services through:

• Pamphlets
• Newspapers
• Billboards
• Car Wash Stickers

KEYS TO SUCCESS
Rinse Auto Wash keys to success are:

• High quality services.


• Benchmarked customer service.

14 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
• Convenience.

15 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

ORGANIZATIONAL PLAN
The Hierarchy of Save Time Auto Wash is very simple. As it is a
Medium size Business so it doesn’t require large kind of management
Team.

Managing
Director

Junaid Rafiq

Operational Marketing Finance


Manager Manager Manager

Tufail Shakir Tufail Badshah M. Afraz

 Save Time Auto Wash is a Legal Partnership type of Business.


 There are six Partners who equally own this business.
 Each Partner contributes Rs. 700,000 into the Business.
 According to the Partnership deed all the members have unlimited liabilities.
 All the Members are Principal and Agents of each other.
 No member can withdraw or Transfer his/her share without the consent of other
Members.
 No Partner can start the same business for three years.

Managing Director (M. Junaid):

Due to his good leadership skills and academic abilities, all the members
have chosen him as the MD of the firm. He is good in Management and
handling of all business operations.

Operational Manager (M. Tufail Shakir)

He is a skillful Person and will check the operation of the car wash. He will
be responsible for the Repair & Maintenance of the Machinery & all other

16 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
Assets. He knows much about cars and other Machinery and also knows how
to look after these.

Marketing Manager (Tufail Badshah)

He has good Communication skills and hence he’ll be the Marketing


Manager of the firm so we believe that he will be sincere enough to deal
with Customer and Position the firm in consumers mind in a good way.

Finance Manager (Muhammad Afraz)

He is a finance expert and will be handling the finance section of the firm.
He always have shown good result in his Academic career. He is master of
numbers.

Other Partners

The two other partners namely Hamayun Khan and Sunniya Tariq are not
included in the Management Team doesn’t mean that they have nothing to
do with the operations of business. Their ideas and opinion will be equally
weighted and whenever required they will be called for Help and
participation in management. They will work as a fully employee and equally
involved in the Profit & loss of Business.

For the betterment of business no partner will be paid extra (salary) for their
management work for three years.

17 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

FINANCIAL PLAN
The financial plan is the most important plan in the whole business plan.
It tells us about how to use the funds and how to allocate them
systematically. It also tells that how to attract the investors and lenders
to generate funds.

Startup Cost

A startup cost pro-forma tells about the foremost main costs that are
incurred in starting the venture. So, the main costs that our business will
require are as follows.

Description Amount
Rs.

Machinery 4,000,00
0

Installation Charges 400,000

Office Supplies 5,000

Operating Supplies 60,000

Prepaid Insurance 45,600

Advertising 120,000

Land (Security) 1,000,00


0

Furniture 25,000

Computer 35,000

Legal Fee (Registration) 5,000

Offices Building 700,000

Cash Required 604,400

Total Cost 7,000,0


00

18 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

19 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
SOURCES OF CAPITAL
Equity Financing

 The Startup costs for the venture is Rs. 7,000,000 out of this amount
each partner will pay Rs. 700,000 (4,200,000)

Debt Financing

 The Remaining Rs. 2,800,000 will be borrowed from Khushali bank with
following rules:

• Total Maturity date is 8 years.

• The interest rate is 13%

As we’ll be making losses for the first few years of our operations, so
the bank has cushioned us that we’ll start to pay the debt after 3
years.

Break-Even Analysis

It’s a point where a firm or a venture neither incurs a loss nor a profit. We
calculated the amount of cars that we’ll be washing in order to break even as
follows:

 We calculate the fixed cost which amounted to 207000.

 Our average selling price per car wash is 400 and the variable cost per car
is 265.

 By using the formula of B.E, we got the number of cars (at break-even) as
follows:

20 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
TFC

Selling Price - Variable


B.E (Q) = Cost

207000

B.E (Q) = 400-265

207000

B.E (Q) = 135

B.E (Q) = 1534 Units

So, in order to break even, we should wash 1534 cars in a month. Any one
additional car wash will result in a profit. If we multiply these units (cars) with
our average selling price per car wash (i.e.400), we’ll get sales volume at break
even that amounts 613600. In other words we can define our break-even point
as when this much (613600) worth of sales are done, our venture will be in
break-even point.

21 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

Income Statement
This statement will tell us about the profit and losses that our venture will incur during its operations.

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year 1 Year 2 Year 3
Cars Per Day 25 30 35 40 42 45 50 55 60 65 70 75 17760 21600 24000
Sales

7,104,00 14,400,00
Sales Per Month
300,000 360,000 420,000 480,000 504,000 540,000 600,000 660,000 720,000 780,000 840,000 900,000 = 0 0 17,280,000
Operating Expenses:
Salaries 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 = 624,000 708,000 708,000
Office Supplies 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 = 60,000 72,000 90,000

Operating Supplies 60,000 72,000 84,000 96,000 100,800 108,000 120,000 132,000 144,000 156,000 168,000 180,000 = 1,420,800 1,620,000 1,680,000

Rent 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 = 1,800,000 1,800,000 1,800,000
Advertising 120,000 120,000 100,000 90,000 90,000 75,000 60,000 60,000 50,000 40,000 35,000 35,000 = 875,000 700,000 650,000
Utilities 56,250 67,500 78,750 90,000 94,500 101,250 112,500 123,750 135,000 146,250 157,500 168,750 = 1,332,000 1,620,000 1,800,000
GST ** 48,000 57,600 67,200 76,800 80,640 86,400 96,000 105,600 115,200 124,800 134,400 144,000 = 1,136,640 2,304,000 2,764,800
Depreciation * 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 = 200,004 200,004 200,004

Insurance Premium ┬ 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 = 45,600 45,600 45,600
Total Expenses 511,717 544,567 557,417 580,267 593,407 598,117 615,967 648,817 671,667 694,517 722,367 755,217 = 7,494,044 9,024,004 9,692,804
(211,717 (184,567 (137,417 (100,267 (15,967
Gross Profit ) ) ) ) (89,407) (58,117) ) 11,183 48,333 85,483 117,633 144,783 = -390,044 5,375,996 7,587,196
Less: Income Tax *** = 1,128,959 1,593,311
(211,717 (184,567 (137,417 (100,267 (15,967 (390,04
Net Profit ) ) ) ) (89,407) (58,117) ) 11,183 48,333 85,483 117,633 144,783 = 4) 4,247,037 5,993,885
(0.705 (0.512 (0.327 (0.208 (0.177 (0.107 (0.026 0.109 0.140 0.160 -
Net Profit Margin 7) 7) 2) 9) 4) 6) 6) 0.0169 0.0671 6 0 9 1.571536962 0.2949 0.3469
(70.572 (51.268 (32.718 (20.889 (17.739 (10.762 (2.661 10.959 14.003 16.087
NPM in % 3) 6) 3) 0) 5) 4) 2) 1.6944 6.7129 4 9 0 = 29% 35%
19.303 18.550 11.829 3.149 6.977 8.101 4.246 3.044 2.083
Average Increase 7 3 4 5 1 2 4.3556 5.0185 4 6 1 = 29.49% 5.19%
* The Machinery has an estimated Useful life of 20 years and the venture depreciates it by Straight Line Method.

** The Company will be paying General Sales Taxes according to Govt. Rules and Regulation which is 16%

*** The Company will pay No Tax untill it is in Profit

┬ Insurance Policy is taken from EFU Insurance Company on per month basis.

22 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH
As in the breakeven analysis we determined that when we will serve 1534 cars and our sales volume will be 613,600
Monthly so we will be at Breakeven and from income statement it is clear that our break even will be in August.

23 | P a g e
BUSINESS PLAN: SAVE THE TIME AUTO WASH

Statement of Cash Flow


A statement of cash flow tells about the cash receipts and disbursements (cash inflows and outflows). The
statement of cash flow of our venture is as follows. Every 2% of our sales will be comprised of receivables,
so we’ll not be recording them in this statement as mentioned that it only deals in cash inflow and outflows.

Receipts: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year 1 Year 2 Year 3
7,104,00 14,400,0 17,280,00
Sales 294,000 352,800 411,600 470,400 493,920 529,200 588,000 646,800 705,600 764,400 823,200 882,000 0 00 0
Disbursements:
4,000,00 4,000,00
Machinery 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
624,00 708,0 708,00
Salaries 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 = 0 00 0
60,00 72,0 90,00
Office Supplies 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 = 0 00 0
1,420,80 1,620,0 1,680,00
Operating Supplies 60,000 72,000 84,000 96,000 100,800 108,000 120,000 132,000 144,000 156,000 168,000 180,000 = 0 00 0
1,800,00 1,800,0 1,800,00
Rent 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 = 0 00 0
875,00 700,0 650,00
Advertising 120,000 120,000 100,000 90,000 90,000 75,000 60,000 60,000 50,000 40,000 35,000 35,000 = 0 00 0
1,332,00 1,620,0 1,800,00
Utilities 56,250 67,500 78,750 90,000 94,500 101,250 112,500 123,750 135,000 146,250 157,500 168,750 = 0 00 0
1,136,64 2,304,0 2,764,80
GST 48,000 57,600 67,200 76,800 80,640 86,400 96,000 105,600 115,200 124,800 134,400 144,000 = 0 00 0
45,60 45,6 45,60
Insurance Premium 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 = 0 00 0
Installation Charge 400,000 0 0 0 0 0 0 0 0 0 0 0 = 400,000 0 0
Land (Security) 1,000,000 0 0 0 0 0 0 0 0 0 0 0 = 1,000,000 0 0
Furniture 25,000 0 0 0 0 0 0 0 0 0 0 0 = 25,000 0 0
Computers 35,000 0 0 0 0 0 0 0 0 0 0 0 = 35,000 0 0
Legal Fee 5,000 0 0 0 0 0 0 0 0 0 0 0 = 5,000 0 0
Office Building 700,000 0 0 0 0 0 0 0 0 0 0 0 = 700,000 0 0
Total 6,660,05 527,90 540,75 563,60 576,74 581,45 599,30 632,15 655,00 677,85 705,70 738,55 13,459,04 8,869,6 9,538,40
Disbursements: 0 0 0 0 0 0 0 0 0 0 0 0 = 0 00 0
(6,366,05 (175,10 (129,15 (93,20 (82,82 (52,25 (11,30 14,65 50,60 86,55 117,50 143,45 (6,355,04 5,530,4 7,741,60
Cash Flow 0) 0) 0) 0) 0) 0) 0) 0 0 0 0 0 = 0) 00 0
7,000,00 633,95 458,85 329,70 236,50 153,68 101,43 90,13 104,78 155,38 241,93 359,43 7,000,00 644,9 6,175,36
Beginning Balance 0 0 0 0 0 0 0 0 0 0 0 0 = 0 60 0
633,95 458,85 329,70 236,50 153,68 101,43 90,13 104,78 155,38 241,93 359,43 502,88 644,96 6,175,3 13,916,96
Ending Balance 0 0 0 0 0 0 0 0 0 0 0 0 = 0 60 0

As our breakeven is in august so we will be having positive cash flows in August as well.

24 | P a g e

You might also like