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 determining how to make the company more efficient and provide better service. You have tracked information on the last 20 painting projects on Table 1. Employees receive bonuses for efficient and high quality work. Occasionally some jobs require touchup work. Information about the projects that required touchup work is stored on Table 2. Table 3 summarizes information about your employees Table 4 categorizes 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 keep them as references (ex. B16:C30). Employee Wage Information Jim Jill $ 52 5 50 Employee Hourly Wage 10% Jake 547 Bonus Information Time Outcome 10% Jennifer S4R Table 1. Painting Projects Quality Time Bonus? Outcome Bonus ifficulty Employee WofJobs Hours Total Pay Average Cost/Job Table 2 - Touchup Projects Employee Difficulty Job ID cost WONO! Table 3 - Employee Summary Wof Touchups Cost Touchups $400 $250 $300 $2,300 $400 D1 DIV/0! #DIV/0! #DIV/0! True Cost/Hour NDIV/0! WDIV/0! NDIV/0! WDIV/0! $300 $700 $500 $250 $500 Table 4 - Project Summary by Difficulty of Touchups Cost Touchups Total Cost Difficulty of Jobs Average Cost/lob Average Hours/Job Total Pay $9,944 $21,315 $21,104 $4,919 $2,200 $21.315 $21,104 $4.919 $2,200 $3,015 $4,919 $2,200 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 determining how to make the company more efficient and provide better service. You have tracked information on the last 20 painting projects on Table 1. Employees receive bonuses for efficient and high quality work. Occasionally some jobs require touchup work. Information about the projects that required touchup work is stored on Table 2. Table 3 summarizes information about your employees Table 4 categorizes 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 keep them as references (ex. B16:C30). Employee Wage Information Jim Jill $ 52 5 50 Employee Hourly Wage 10% Jake 547 Bonus Information Time Outcome 10% Jennifer S4R Table 1. Painting Projects Quality Time Bonus? Outcome Bonus ifficulty Employee WofJobs Hours Total Pay Average Cost/Job Table 2 - Touchup Projects Employee Difficulty Job ID cost WONO! Table 3 - Employee Summary Wof Touchups Cost Touchups $400 $250 $300 $2,300 $400 D1 DIV/0! #DIV/0! #DIV/0! True Cost/Hour NDIV/0! WDIV/0! NDIV/0! WDIV/0! $300 $700 $500 $250 $500 Table 4 - Project Summary by Difficulty of Touchups Cost Touchups Total Cost Difficulty of Jobs Average Cost/lob Average Hours/Job Total Pay $9,944 $21,315 $21,104 $4,919 $2,200 $21.315 $21,104 $4.919 $2,200 $3,015 $4,919 $2,200
