Four J\'s Painting is a home painting contractor that completes interior paintin

Question

Four J's Painting is a home painting contractor that completes interior painting work for new construction projects. Four J's Painting has four employees: Jim, Jill, Jake, and Jennifer. You have been hired to determine how the company can be more efficient and provide better service. You have tracked information on the last 20 painting projects in table 1. Employees receive bonuses for efficient and high-quality work. Occasionally, some jobs require additional work to correct flaws (touch-up work). Information about the projects that required touch-up work is stored in table 2. Table 3 summarizes information about the employees. Table 4 categorizes the projects according to difficulty. Complete tables 1 through 4 to determine how to more efficiently and effectively run the company. Complete each task so that the formulas you use can be copied and pasted down to complete the columns of the tables. Do not name your lookup tables; rather, you should keep them as references (e.g. B16:C30).

Can't figure out the formulae for these two below:

Use the SUMIF function to complete the "Cost Touch-ups" column in table 4. Reference the appropriate field in table 2 as your range and the "Difficulty" rating in table 4 as your criteria.

Use the AVERAGEIF function to complete the "Average Hours/Job" column in table 4. Reference the appropriate field in table 1 as your range and the "Difficulty" rating in table 4 as your criteria.

er. Youhave been hired to determine how the information on the last 20 painting projects intable 1. Employees Painting hasour employees: Jim, Jill, Jake, and Jennife oompany canbe more efficient and provide better service. Youhave tracked receive bonuses for efficient and high-quality work. ccasionally, some jobs require additional work to correct flaws (touch- up work). Information about the projecs that required touch-up work is stored in table 2. Table 3 summarizes information about the employees. Table 4categorizes the projects according to difficuty. Complete tables 1through 4 to determine how to more efficiently and effectively run the company. Complete eachtask sothat the formulas you use can be copied and up work is stored intable 2. Table 3 summarizes mplete tables 1through 4 to determine hovw asted down to complete the columns of the tables. Do not name your lookup tables; rather, you should keep them as ge Information Bonus Information Jake Jennifer Table 1- Painting Projeots IEstimated Hours Employee lours Worke Hourly VageDifficultyQualit ie Bonus utcome Bonus Job Pay Jime Bonus lutcome Bonus Total PayComments $2.808T $2,200 Poor Quality FALSE FALSE $4,472 $447 FALSE $1,974Too Much Tim $4,867Too Much Tim $2,917 Too Much Ti $2,074Too Much Tim $2,995 Poor Quaity Poor Quality FALSE FALSE FALSE $2,448 Too Much Tim $3,360 Too Much Tim $2,999Too Much Ti $3,722 Too Much T $2,640 Too Much Tim $2,482 Poor Quality $3,250 $3,050 Too Much Ti $4,550 Too Muoh T $3,360 $2,256 FALSE Table 3 -Employee Summary Table 2-Touchup Projects Employee Difficult Employee of Job:Total Hours Total Pay of Touch-upst Touch-uyera ge CostlJcTrue CostHour $13,066 Table 4-Project Summary by Difficulty Difficulty of Job. Total Pay of T ouch-upost Touch-u Total Cost verage CostlJoerage HourstJob $9944 $21,104 0 oma SE SE SE JE SE LE SE SE SE SE LE LE LE SE SE Hou 013 200 55 3.2 .3.2.1 3 3.1.22.111-23.123.3.1 123a-5 54 4042 78 38 36 48 42 74 ST-70 58 68-43-47-65-61 79 54 8 4:04 5 4 5 4 70 o 70 60 70 50 50 668 b.1. 2. 3. 4.5.6789 10-11. 13-14-15-16 17-18 19 . 1.5.8. 11-12 13 16 20 1 2 3 4 5 6 7 8 9 10 11 12 13 14 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 1 2 3 4 5 46 47 48 49 50

Explanation / Answer

1.
=sumif($D$40:$D$46,G46,$E$40:$E$46)
2.
=averageif($G$16:$G$35,G46,$E$16:E$35)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.