HR PLANNING LAB 2 [Compatibility Mode] - Word Table Tools Jennelle jackson X File Home Insert Design Layout References Mailings Review View Help
View the step-by-step solution to:

Question

HRPLANNING.png


I am trying to find the formula in

order to predict the HIGH, MID, and LOW for 2016, 2017 and 2018. The numbers are already there, but I need to learn HOW they got those numbers. Also need to do it for the employee section.


Please help! Thanks so much!

HRPLANNING.png

HR PLANNING LAB 2 [Compatibility Mode] - Word
Table Tools
Jennelle jackson
X
File
Home
Insert
Design Layout References Mailings Review
View
Help
Design
Layout
Tell me what you want to do
Share
& Cut
Be Copy
Arial
V 12 V A A Aa- A
AaBbCcDa AaBbCcl AaBbCc AaBbCcDd AaBbCcD( AaBbCcD. AaBbC AaBbCcDd AaBbCcDa
Find -
Paste
Format Painter
BI U - abe X2 X? A - Z - A.
Emphasis 1 Heading 1 1 Heading 2 1 Normal
Gac Replace
Strong
Subtitle
Title
1 No Spac... Subtle Em..
< < >
Select -
Clipboard
Font
Paragraph
Styles
Editing
HR PLANNING - LAB 2
YOUR NAME
ENVELOPE FORECASTING
SALES & HUMAN RESOURCE NEEDS
CURRENT
FORECAST
YEAR
2015
2016
2017
2018
SALES ($1,000's)
HIGH
475.000
655,750
650.228
760,766
MID
475,000
527,250
585,248
649,625
LOW
475,000
498,750
523,688
549,872
EMPLOYEES
HIGH
2,375
2,779
3.251
3,804
MID
2,375
2.636
2,926
3,248
LOW
2,375
2,494
2,618
2,749
ANNUAL SALES GROWTH
11%
MARGIN OF ERROR (+/-)
6%
RATIO OF EMPLOYEES/SALES
0.005
(1/200)
n
Page 2 of 2
252 words E
English (Canada)
-
100%
O
Type here to search
W
X
N
P
ENG
5:33 PM
US
10/14/19

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes