Expert answer:Creating a report

Answer & Explanation:Guideline: The responses have to be well thought out and complete with professionalism. The responses have to also correspond with the questions completely and be answered completely.I NEED THIS ASSIGNMENT BY 12- MIDNIGHT CENTRAL STANDARD TIME NOVEMBER 21TH, 2015.20151120163544assignment_productivity_and_staffing_anaysis_report__1_.doc
20151120163544assignment_productivity_and_staffing_anaysis_report__1_.doc

Unformatted Attachment Preview

PRODUCTIVITY & STAFFING ANALYSIS
Instructions
Design a spreadsheet using Excel to calculate and report the productivity statistics for the
Health Information Department for the week of October 2
Situation
The HI Department staff completes a weekly report where they record the following:
1. Work volume received
2. Work volume completed
3. Hours worked on each activity
You also have the following information
•
•
Work standards for each activity on a per hour basis
Total hours paid for the department for the week
PRODUCTIVITY REPORT LOG: October 2
Activity
Received
Completed
Chart Assembly
Chart Analysis
Coding
Abstracting
Report Filing
Chart Retrieval
Release of Info
160
160
160
160
1200
985
125
150
135
152
165
1175
935
140
Standard.
Units/Hour
7
5
5
9
30
24
13
Hours Worked
21.0
33.0
46.0
13.0
42.0
33.0
13.0
Time card hours paid: 209.5
1
HIA 4010/Controlling Part 2/Staffiing/Productivity & Analysis Report
CONSTRUCTING A SPREADSHEET IN EXCEL FOR PRODUCTIVITY
REPORT
•
You must prepare a weekly report for your administrator that provides the
following data elements.
•
Use the formula indicated to perform the calculations
•
Follow the same format as the Productivity Log and add these columns to the
report.
Note: The first 5 columns of the spreadsheet are the same as the Productivity Log.
1. Element: Percentage of work received that was completed
Column Heading: Percentage completed
Calculation: Work completed/received
2. Element: Actual work units completed per hour
Column Heading: Actual Units/Hour
Calculation: Work completed/Hours worked
3. Element: Variance of units completed to the work standard
Column Heading: Variance
Calculation: (Actual units/hour) –Standard
4. Element: Percentage that the variance represents compared to the work standard
Column Heading: Variance percentage
Calculation: Variance/Standard
5. Element: Given the work completed and the standard, calculate the hours you
expect the activity to take
Column Heading: Expected work hours
Calculation: Work completed/Standard
6. Element: Calculate how productive your staff is—both total hours
worked and total expected work hours
Calculation: Productivity percentage: Actual = the actual hours/hours paid;
Productivity percentage: Expected = expected hours/ hours paid
2
HIA 4010/Controlling Part 2/Staffiing/Productivity & Analysis Report
ASSIGNMENT
• Using the data from page 1 and the information on page 2, design a
spreadsheet using Excel, that reflects the department’s productivity.
• The spreadsheet should include all items (both given and calculated) using
the following specifications.
1. Include a report title and column headings as provided.
2. Include your name and the date on the bottom right hand side of the report as a
footer.
3. Use Excel to perform the calculations above by inserting formulas.
4. All percentages and numbers must be carried to one decimal place.
5. Adjust column widths so headings and activity titles fit.
6. Print the spreadsheet and the formulas, using landscape format. If necessary,
adjust to fit on one page using the Page Setup feature. To print the formulas,
choose, “Options”, on the “Tool” menu and check “Formulas”.
7. Using Excel, construct 3 graphs to best show the following data:
a. Work received compared to work completed
b. Variance percentage of all activities
c. Actual compared to expected work hours
8. After preparing your report, analyze the data. What conclusions can you draw
for your administer? Where are the problem areas in the department? Where
are the productive areas? Prepare a brief paragraph of your data analysis and
attach to the report using a memo format.
For Submission: 40 points as broken down as below:
1. Spreadsheet (1 workbook with 3 tabs)
a. Spreadsheet
10 points
b. Printed formulas
2 points
c. Three Graphs
9 points (3 point for each one)
2. 4. Analysis of data submitted in a memo format
a.
b.
c.
d.
e.
3. Memo summarizing results
3
15 points
How productive are they?
What was the variance?
How many hours was the work expected to get done?
How long did it actual take?
What are some problem areas?
4 points
HIA 4010/Controlling Part 2/Staffiing/Productivity & Analysis Report
4
HIA 4010/Controlling Part 2/Staffiing/Productivity & Analysis Report
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades