Part 3: Hourly employees must pay union dues of $ 0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $ 0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues( if any) for the first employee. Write the formula.
Part 4: Salaried and Exempt employees( Pay Codes E and S) are covered by the company’ s health insurance. The deduction is $ 10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction( if any) for the first employee. Write the formula so that it may be copied to the other employees without modification.( Points: 40)
( TCO 3) You are a Microsoft Office trainer for DeVry University. The training topic for the current month is charts using Microsoft Excel. During each training session from different departments or cohorts, the following frequently asked questions were asked and you decide to create a document formalizing answers and suggestions.
My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important?
My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why?
My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why?
My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important?( Points: 40)
( TCO 5) You work for a local construction firm“ DeVry Engineering Group” and your supervisor, Jessica, needs an updated earned value analysis index of the prior month for an existing capital project( 0000001) that has a current Budget at Completion( BAC) of $ 1500.00, a current earned value of( EV) of $ 300, a current actual cost( AC) of $ 500.00, and a current planned value( PV) of $ 350.00. In order to calculate the current average index, assume the following variables and standard formulas below:
Cost Variance( CV) EV – AC Cost Performance Index( CPI) EV / AC Schedule Variance( SV) EV – PV Schedule Performance Index( SPI) EV / PV