entrepreneurship

part 2 is very important please help with answers

Your Task

Using the information provided below, answer the series of questions presented in Part I and Part II, below. When preparing your written submission, include both your calculations and your written analysis of the financial information. which youll need to complete this assignment.

1. Open Claire's income statement. I have included the file separately above as

well. Enable editing. Wherever there is a dash (cell without a numerical value) you can type into that cell and the rest of the document will auto-populate. You will need to fill in these cells with information to complete the income statement.

2. Using the information below, fill in the cells that have dashes in the income statement.

3. In a Word document, use the following headers to answer the questions below, based on the numbers you populated in the income statement. Explain how you reached your conclusions and what results you found. You do not need to also turn in the excel sheet, just turn in one Word document (Word format only) and explain what numbers and conclusions you came up with, and explain what it means in your own words.

Claires Cuttery

Claire has always loved working with hair and beauty products and has decided that she will quit her day job and use the money her grandfather left her to start a salon. All of her friends think its a great idea, but her brother cautions her about leaping before she looks. She decides that, before she begins, she will project her sales for the first year to prove to her family that she has a winning idea.

She sits down with paper and pencil and completes the expense part of the Income Statement shown in the file Claires Income Statement. But she needs help projecting her sales, so using the following assumptions and information, complete the Income section of the Income Statement for her.

PART 1: Year 1 Projections

Her Business

Claire will have 3 stylists available. For planning purposes, she assumes the following:

Each stylist can accommodate 6 customers per day. The stylists each work 20 days per month.

Claire also acts as a stylist, but she can only accommodate 4 customers per day since she also serves as receptionist. However, since it is her business, she works 6 days per week (24 days per month).

She has estimated, on average, that each customer will generate $12.00 in revenue.

She estimates that based on her research, it will cost her about $2.50 in supplies per customer/per cut.

She will operate January through December and close the month of February for a vacation at her favorite ski resort.

Market Share

There are 8 other salons in the area that will compete for business. Claire has talked to the local Chamber, and they estimate that about 15,000 people now live in her town. She assumes that she can capture about 24% of the market.

Sales Projections for Year 1

She assumes that the sales volume will be distributed as follows:

January: 5% of annual sales

February: CLOSED

March: 10% of annual sales

April: 10% of annual sales

May: 10% of annual sales

June: 20% of annual sales

July: 5% of annual sales

August: 5% of annual sales

September: 10% of annual sales

October: 10% of annual sales

November: 5% of annual sales

December: 10% of annual sales

Part I: Questions

1.

2. 3.

What is the maximum number of customers Claire can take in any one month based on her assumptions, and assuming a 30-day month? Is this enough to meet her market and sales projections, or does she have to reduce the sales projections because she runs out of capacity?

Can Claire accommodate 20% of her annual sales in one month (June), given that she has only 3 stylists available? How should she address this?

Will she show a profit or a loss for the business if she achieves her sales figures as projected?

Part II: REVISED Year 1 Projections

Good news for Claire! Four local competitors dont reopen in December, and Claire gets 34% (rather than the projected 24%) of the market. She believes that she will be able to reach her goals if she makes the following changes:

hours.

Each stylist will accommodate 1 additional customer per day if she extends her salon Claire now serves 5 customers per day, instead of 4.

With this increased market share, she has adjusted her operating expenses to include the following changes:

The landlord levies a new common area maintenance fee of that will increase her rent by $75.00 per month.

She hires a receptionist for $400 per month to free up her time. Her utilities costs increase because of the extended hours.

She needs you to adjust her sales projections and produce a new income statement for the year. (Use the REVISED Year 1 worksheet that has been provided in the file you downloaded above.)

Part II: Questions

1. 2. 3.

Will Claire be able to meet the revised sales projections? If not, what do you think she should do?

Under her current structure, will Claire be able to meet the demand for her services? If not, how can she address this?

Will she show a profit or a loss for the business if she achieves her sales figures as projected?

Part 1 Projections Part 1 Notes REVISED Year 1 Part II Notes # of People 3 1 Days Clients per Month per day 20 7 24 5 Stylists Claire Total Clients Served per Month 420 120 540 Part 1 Projections Part 1 Notes REVISED Year 1 Part II Notes Month day Served per Month People 3 1 Stylists Claire 360 20 24 6 4 96 456 12:13 X Claires+Income+Stateme... REVISED Year 1 Part Notes March M Part 1 Projections Part 1 Notes INCOME STATEMENT Calum Mary INCOME 3. TOTAL INCOME COST OF GOCESSED Total.com GROS PROVIT OPERATING EXPENSES Rowe 4.13 13 mit I ... Tag 175 *** WAS M Rent af 89 50 : 5:53:25 tai Bet 89 1 1. 16 TOTAL EXPENSES NET INCOME 1. Number of He TOTAL CUSTOMERS OF THE MARKET 12:13 X Claires+Income+Stateme... REVISED Year 1 Part II Notes Apa th TO 130 12 12.10 TE 2.1 1.215 6113 52 1219 1.31 455 2.4038 24 LAS 400 I 100 10 40 50 90 175 SLE 119 11 Li 0 110 10 ! S 40 41 S. 10 10 RIYA 150 10 BE ** 1 1 1. 1 1 24 BATS S10 ol 250 510 SE IS FE 20 Part 1 Projections Part 1 Notes REVISED Year 1 Part II Notes # of People 3 1 Days Clients per Month per day 20 7 24 5 Stylists Claire Total Clients Served per Month 420 120 540 Part 1 Projections Part 1 Notes REVISED Year 1 Part II Notes Month day Served per Month People 3 1 Stylists Claire 360 20 24 6 4 96 456 12:13 X Claires+Income+Stateme... REVISED Year 1 Part Notes March M Part 1 Projections Part 1 Notes INCOME STATEMENT Calum Mary INCOME 3. TOTAL INCOME COST OF GOCESSED Total.com GROS PROVIT OPERATING EXPENSES Rowe 4.13 13 mit I ... Tag 175 *** WAS M Rent af 89 50 : 5:53:25 tai Bet 89 1 1. 16 TOTAL EXPENSES NET INCOME 1. Number of He TOTAL CUSTOMERS OF THE MARKET 12:13 X Claires+Income+Stateme... REVISED Year 1 Part II Notes Apa th TO 130 12 12.10 TE 2.1 1.215 6113 52 1219 1.31 455 2.4038 24 LAS 400 I 100 10 40 50 90 175 SLE 119 11 Li 0 110 10 ! S 40 41 S. 10 10 RIYA 150 10 BE ** 1 1 1. 1 1 24 BATS S10 ol 250 510 SE IS FE 20