,.. |\"Wrap Text Currend Assignment Tasks |Merge & Center , | $ . Four J\'s Pain
ID: 3598438 • Letter: #
Question
,.. |"Wrap Text Currend Assignment Tasks |Merge & Center , | $ . Four J's Painting & Find & Use the IF function to complete the "Time Bonus $" column of table 1. If an employee earns a time bonus (i.e, the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "lob Pay" for that project times the bonus percentage in cell M11. Otherwise "Time Bonus $" is 0. 8 points rences (e.g. B16:C30 yee Wage Information Bonus Information Jake Jennifer 10% $48 Outcome - Table 1 - Painting Projects Hours Worked Hourly Wage Difficulty Quality Time Bonus? Outcome Bonus? Job Pay Time Bonus $ Outcome Bnus Total Pay $2,808 $2,000 4,472 $1,974 $4,056 $1,786 $2,652 $1,728 $2,496 $2,100 $3,478 $2,448 $3,360 $2,726 $3,102 YES $2,808 $2,000 $4,472 $1,974 $4,056 $1,786 $2,652 $1,728 $2,496 $2,100 3,478 $2,448 $3,360 $2,726 $3,102 $2,400 $2,256 3,250 $3,050 $3,792 NO BONUS NO BONUS NO BONUS NO BONUS 40 $50 86 NO BONUS NO 78 38 BONUS NO BONUS NO BONUS BONUS NO BONUS NO BONUS NO BONUS NO BONUS BONUS BONUS NO BONUS BONUS NO BONUS NO BONUS 36 48 S52 S50 $47 $48 74 NO 70 58 $2,256 $3,250 $3,050 $3,792 NO YES 1NO BONUS Table 3 - Employee Summary Average Cost/Job. #DIV/0! True Cost/Hour #DIV/0! Total Pay #of Touch-ups Cost Touch-ups Employee # of Jobs Total Hours , $400 Cost Google Spending Event Profit | Past Events | PivotTable Quest - 4:20 PM Desktop » 4: 10.220017Explanation / Answer
4) =IF(I16="NO BONUS", 0,M11*K16)
5) =IF(J16="NO", 0,M12*K16)
6) =IF(AND(E16<=60,H16>1),"Good Job",IF(E16>60,"Too Much Time","Poor Quality"))
As Estimated hours is not given, that is taken as 60.
Write all the formulas in the first row of every solution and drag to the last row
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.