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