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 $50 Employee Hourly Wage 10% Jake $47 Bonus Information Time Outcome 10% Jennifer $48 Table 1 - Painting Projects Quality Time Bonus? Outcome Bonus?..... Job ID Estima ted Hours Hours Worked Hourly Wage Difficulty Pay Time Bonus $ Outcome Bonus $ al Pay Comments Employee Jim Jim Jake Vouw Jim Jake www Jim Jennifer Jim lake Jennifer Jennifer Jake Jake Jill Jennifer Jill ...3 Jennifer Employee Jim # of Jobs Total Hours Table 2 - Touchup Projects Employee . Difficulty Job ID Table 3 - Employee Summary Total Pay... # of Touchups Cost Touchups. Average Cost/Job L $400 #DIV/0! .. $250 #DIV/0! HIVIOL $300 #DIV/0! $2.300 #DIV/0! True Cost/Hour... #DIV/0! #DIV/0! #DIV/0! #DIV/0! Jake Jennifer Cost $400 $600 $300 $700 $500 $250 $500 Difficulty Average Hours/Job Total Pay $9,944 $21,315 $21,104 $4,919 $2,200 Table 4 - Project Summary by Difficulty # of Touchups Cost Touchups... Total Cost $9,944 $21,315 $21,104 $4,919 $2,200 Average Cost/Job $2,486 $3,045 $3,015 $4,919 $2,200 1 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 $50 Employee Hourly Wage 10% Jake $47 Bonus Information Time Outcome 10% Jennifer $48 Table 1 - Painting Projects Quality Time Bonus? Outcome Bonus?..... Job ID Estima ted Hours Hours Worked Hourly Wage Difficulty Pay Time Bonus $ Outcome Bonus $ al Pay Comments Employee Jim Jim Jake Vouw Jim Jake www Jim Jennifer Jim lake Jennifer Jennifer Jake Jake Jill Jennifer Jill ...3 Jennifer Employee Jim # of Jobs Total Hours Table 2 - Touchup Projects Employee . Difficulty Job ID Table 3 - Employee Summary Total Pay... # of Touchups Cost Touchups. Average Cost/Job L $400 #DIV/0! .. $250 #DIV/0! HIVIOL $300 #DIV/0! $2.300 #DIV/0! True Cost/Hour... #DIV/0! #DIV/0! #DIV/0! #DIV/0! Jake Jennifer Cost $400 $600 $300 $700 $500 $250 $500 Difficulty Average Hours/Job Total Pay $9,944 $21,315 $21,104 $4,919 $2,200 Table 4 - Project Summary by Difficulty # of Touchups Cost Touchups... Total Cost $9,944 $21,315 $21,104 $4,919 $2,200 Average Cost/Job $2,486 $3,045 $3,015 $4,919 $2,200 1
