Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at the bottom of the database listing, row 37 columns E, F, G. The pie chart should show the values, the legend should indicate Overtime Hours and NonOvertime, and the chart title should be Total Daily Hours. Place this chart so that it will fill cells K1:R16. (Hint: When selecting the data for this chart remember that pie charts show parts of a whole so theres no reason to include a total if you are displaying the parts making up that total.) [In spreadsheets, does it make sense to put totals at the bottom of the database?] 6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender for each department number. Start the criteria in cell E40 and the data table in cell E44. 7) SUBTOTALS - Create a Subtotal showing the total hours worked by department and the total overtime hours worked by gender within each department. Change to Outline View 3. [Which department works the most hours and do you see something odd about the overtime hours?] Copy the subtotal information to Sheet 2 using Copy/Paste Special Values (previously undisplayed/hidden data will appear when copied to Sheet 2). Remove the Subtotaling on Sheet 1 using the Remove All button before continuing. 8) GOAL SEEK - In cell E7, place a formula that will multiply the Overtime Rate (B3) by the Total Number of Overtime Hours. Perform a Goal Seek to determine the overtime rate necessary to achieve $400 in total overtime pay. Leave the goal seek in place so that it can be graded. 9) EXTRACT (Advanced Filter) - Sort the database by the employees' names in ascending order. Extract just the name and the department number (Dept. No.) of those who worked more than 8 hours. Start the criteria in cell A40 and the extract output in cell A44. 10) DATA TABLE on SHEET 3 create a One-Variable Data Table that will take the ODD numbers from 1 to 55 and will show each of the following independent calculations: multiply by $6.64; divide by 3.245; add $8.23 to each number; subtract 4 from each number.

1 Manufacturing
Hourly Rate: $ 6.64
Overtime Rate: $ 8.23 2 Sales
3 Computer
Average Hours Worked by Males in Dept No 2: 8.038461538
Total Number of Overtime Hours: 36
Total Overtime Pay:
Employees Gender Dept No Department Hours Worked Overtime Hours NonOvertime Daily Daily Pay
Darrell, Bailey M 2 4 0 4 $ 26.56
Shelton, Kent M 1 8 0 8 $ 53.12
Diffee, Kois F 3 6 0 6 $ 39.84
Stull, Marlene F 3 0 0 0 $ -
Crenshaw, Sheila F 1 10 2 8 $ 69.58
Denton, Susie F 1 9 1 8 $ 61.35
Huntington, Mike M 2 7 0 7 $ 46.48
Hall, Mike M 2 5 0 5 $ 33.20
Smith, Brian M 3 12 4 8 $ 86.04
Hill, Peggy Joan F 3 9 1 8 $ 61.35
Hill, Joy F 1 10 2 8 $ 69.58
White, Bill M 3 11 3 8 $ 77.81
Whitehead, Bobby M 2 3 0 3 $ 19.92
Adkins, Dorinda F 2 0 0 0 $ -
Boucher, Leslie F 3 9 1 8 $ 61.35
Clayton, Rex M 1 12 4 8 $ 86.04
Trice, Ricky M 3 14 6 8 $ 102.50
Webb, William W. M 1 11 3 8 $ 77.81
Carman, Nancy F 2 7 0 7 $ 46.48
Savoie, Tony M 3 9 1 8 $ 61.35
Webb, Patsy F 2 8 0 8 $ 53.12
Hammons, Larry M 1 6 0 6 $ 39.84
Lee, Tammy F 3 7 0 7 $ 46.48
Tibbetts, Rusty M 2 8 0 8 $ 53.12
Pierson, Tony M 1 11 3 8 $ 77.81
Pierce, Sammy M 3 13 5 8 $ 94.27
209 36 173 $ 1,445.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forest Management Auditing

Authors: Lucio Brotto

1st Edition

0367605872, 978-0367605872

More Books

Students also viewed these Accounting questions