Create a Solver answer report for the current Solver model, then view the report results. 1...

  

Transcribed Image Text:

Create a Solver answer report for the current Solver model, then view the report results. 1 1 2020 Hourly Employees Contractor Level 1 Contractor Level 2 Foreman 2021 Hourly Employees Contractor Level 1 Contractor Level 2 Foreman Markup Fees Hours Billed Hourly Rate Total Billed 125,000 75,000 48,000 248,000 Units Sold 125,000 75.000 48,000 248,000 $25.00 $35.00 $60.00 Markup $ 3,125,000 25% $ 2,625,000 25% $ 2,880,000 20% $ 8,630,000 Price per Unit Revenues Unit Cost $25.00 $ 3,125,000 25% $35.00 $ 2,625,000 25% $ 2,880,000 20% $ 8,630,000 $60.00 Wages Paid Gross Profit 2,343,750 1,968,750 2,304,000 6,616,500 $2,013,500 Direct Costs Gross Profit 781,250 656,250 576.000 781,250 656,260 576,000 2,343,750 1,968,750 2,304,000 6,616,500 $2,013,500 Create a Solver answer report for the current Solver model, then view the report results. 1 1 2020 Hourly Employees Contractor Level 1 Contractor Level 2 Foreman 2021 Hourly Employees Contractor Level 1 Contractor Level 2 Foreman Markup Fees Hours Billed Hourly Rate Total Billed 125,000 75,000 48,000 248,000 Units Sold 125,000 75.000 48,000 248,000 $25.00 $35.00 $60.00 Markup $ 3,125,000 25% $ 2,625,000 25% $ 2,880,000 20% $ 8,630,000 Price per Unit Revenues Unit Cost $25.00 $ 3,125,000 25% $35.00 $ 2,625,000 25% $ 2,880,000 20% $ 8,630,000 $60.00 Wages Paid Gross Profit 2,343,750 1,968,750 2,304,000 6,616,500 $2,013,500 Direct Costs Gross Profit 781,250 656,250 576.000 781,250 656,260 576,000 2,343,750 1,968,750 2,304,000 6,616,500 $2,013,500