Department Budgeted HC Actual HC Finance 27 34 Human Resources 28 24 Marketing 20 18 Operations 60 54 Procurement 35 35 TOTAL 170 165 Using Excel: 1) In the column next to Actual HC, calculate the percentage...

80.2K

Verified Solution

Question

General Management

Department Budgeted HC Actual HC
Finance 27 34
Human Resources 28 24
Marketing 20 18
Operations 60 54
Procurement 35 35
TOTAL 170 165
Using Excel:
1) In the column next to Actual HC, calculate the percentage ofactual headcount for each department.
3) Insert a COMBO Chart, by selecting just the Department,Budgeted HC and Actual HC cell values (Do not includetotal). Do not select % of actual count at thistime.
4) Provide key findings/comparative analysis for eachdepartment.
Please provide instructions as to how this can be done on Excel.Thank You.

Answer & Explanation Solved by verified expert

4.0 Ratings (693 Votes)

The percentage can be calculated by dividing the correspondingActual Head count with total Actual Head count multiplied by 100or click percentage icon in home tabCombo Chart can be made by See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Department	Budgeted HC	Actual HC
Finance	27	34
Human Resources	28	24
Marketing	20	18
Operations	60	54
Procurement	35	35
TOTAL	170	165