Chat with us, powered by LiveChat Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend. Most products | Wridemy

Sales determine your profitability and whether or not youll stay in business. Sales are also your estimate of how much youll have available to spend. Most products

Sales determine your profitability and whether or not you’ll stay in business. Sales are also your estimate of how much you’ll have available to spend. Most products and services will require “softer” estimates. The sales forecast will also help you assess your capacity needed (and help you chose adequate space, etc.). Review the example provided with this assignment. This is just an example and is very specific to the assumptions for this business (Spirit Spa). Your projections should reflect your business and your assumptions and may look completely different than the example provided.

Make sure you do not use a calculator to do this assignment. The whole point of using Excel is to have it do the work for you and allows you to easily change assumptions which will change all other related calculations on your sales projections. Also, your instructor (or your supervisor if you were doing this in the real world) can tell whether your calculations are correct just by looking at the formula, thereby eliminating the need to recalculate all of your numbers

https://kean-edu.zoom.us/rec/share/Ncze_bixkTxUaHuC0hDQF8edzVEYq8_zUEnq4q1slTAGtgOOTIUTMRZDu26zbOA6.6k91qioZDuNVVHTH?startTime=1670078968000
Passcode: +8KUH??*

MGS3013 Unit 6 AS Instructions

Sales determine your profitability and whether or not you’ll stay in business. Sales are also your estimate of how much you’ll have available to spend. Most products and services will require “softer” estimates. The sales forecast will also help you assess your capacity needed (and help you chose adequate space, etc.).

The projected sales number is going to be entered in LivePlan as the base for your financial projections.

Review the example provided with this assignment. This is just an example and is very specific to the assumptions for this business (Spirit Spa). Your projections should reflect your business and your assumptions and may look completely different than the example provided.

Make sure you use formulas and do not use a calculator to do this assignment. The whole point of using Excel is to have it do the work for you and allows you to easily change assumptions which will change all other related calculations on your sales projections. Also, your instructor can tell whether your calculations are correct just by looking at the formula, thereby eliminating the need to recalculate all of your numbers.

Directions:

1) Prepare your sales projections for three to five years in Excel. Before submitting your Excel spreadsheet for grading make sure you:

· Check to see that you are not missing any formulas.

· Format each cell with numbers to round up to the nearest dollar

· Format all cells properly – $, %, column width, etc.

· Format page layout properly for orientation, footers, gridlines, etc.

· Format to print – should not be more than two pages, one is more likely.

2) Save your Excel spreadsheet in .xls format and use the following naming convention:

CourseID_U#_Your Last Name_Your First Name_Sales Projections

e.g. MGS 3013_U6_Smith_John_Sales Projections

3) When you are ready to upload your assignment, click on the title of the assignment and attach your spreadsheet. You may leave comments in the Submission text if you have anything you wish to discuss with your instructor about your assignment.

4) You are allowed two attempts on this assignment. Your instructor will provide you with comments on your sales projections and you may submit another attempt if needed.

,

S al

es P

ro je

ct io

ns S

pi ri

t S pa

in U

ni on

, N J

Y ea

r 1

Y ea

r 2

Y ea

r 3

Y ea

r 4

Y ea

r 5

G ro

w th

ra te

p er

y ea

r 1.

1 1.

1 1.

05 1.

05 C

ity P

op ul

at io

n, U

ni on

, N J

(c ity

-d at

a. co

m )

54 ,0

50 Ta

rg et

A ge

(f em

al es

o ve

r 4 5-

64 y

rs o

ld ) c

en su

s. go

v – e

xt ra

po la

te d

fro m

N J

da ta

14 %

7, 56

7 Ta

rg et

A ge

m ed

ia n

in co

m e

>$ 50

,0 00

(T ot

al p

ot en

tia l m

ar ke

t) – e

xt ra

po la

te d

fro m

c en

su s.

go v

da ta

68 %

5, 14

6 M

ar ke

t p en

et ra

tio n

(H ow

m uc

h of

th e

to ta

l m ar

ke t m

y bu

si ne

ss w

ill c

ap tu

re ?

– c om

pe tit

io n

is a

b ig

fa ct

or )

15 %

77 2

A ve

ra ge

n um

be r o

f v is

its p

er y

ea r (

Y ea

r 1 )

3 2,

31 6

A ve

ra ge

p ric

e pe

r v is

it $1

10 To

ta l S

al es

y ea

r 1 (

U ni

on o

nl y)

25 4,

70 5

$

A dd

iti on

al s

al es

fr om

c us

to m

er s

in U

ni on

C ou

nt y

(e xp

re ss

ed a

s a

% o

f U ni

on s

al es

) 15

% 38

,2 06

$

To ta

l S al

es p

er Y

ea r

$2 92

,9 11

$3 22

,2 02

$3 54

,4 22

$3 72

,1 43

$3 90

,7 51

A ve

ra ge

s al

es /s

pa in

U S

(c en

su s.

go v

-2 01

2) $2

78 ,7

88 A

ve ra

ge s

al es

/s pa

in N

J (c

en su

s. go

v- 20

12 )

$3 07

,3 03

D ay

s op

en

pe r y

ea r

# of

c us

to m

er s

pe r d

ay C

ap ac

ity c

he ck

N ot

e: I

f y ou

h av

e a

ca pa

ci ty

li m

it, th

is li

ne s

er ve

s to

d o

a re

al ity

c he

ck .

20 0

12

N ot

e: It

em s

in re

d w

ou ld

n ot

b e

in cl

ud ed

in y

ou r s

al es

p ro

je ct

io ns

. Th

ey a

re o

nl y

th er

e fo

r i ns

tru ct

io na

l p ur

po se

s.

C :U

se rs

G ai

lD oc

um en

ts D

oc um

en ts

G en

er al

K ea

n M

an ag

em en

tO n

lin e

30 13

U ni

t 6 A

ss ig

nm en

tM G

S3 01

3_ U

6_ Sa

le s

Pr oj

ec tio

ns E

xa m

pl e

8/ 15

/2 01

6 5

:3 0

PM

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA