Part 2 Construction Cost

A sub-contractor needs to decide which companies they should hire for each type of building they want to construct.

Below is the estimated time it should take (in hours) for each of the different types of buildings they work on.

Building	Excavating	Framing	Electrical	Plumbing	Finishing
Office Space	45	100	88	132	312
School	56	250	147	28	290
Apartments	84	480	75	125	244
Grocery Store	95	160	26	78	236

Below are the hourly rates for some different construction companies in the area.

Company	Bouma	Pinnacle	Rockford	McGraw
Excavating	$350	$300	$285	$245
Framing	$225	$275	$280	$280
Electrical	$405	$375	$295	$350
Plumbing	$150	$240	$225	$200
Finishing	$250	$190	$230	$215

1. Input the information in the previous two tables in Excel. Make sure that you label all the information in your spreadsheet.

2. Use matrix multiplication to determine which companies can complete each project at the lowest cost. Label your new matrix with the appropriate labels.

3. Highlight the cells that give the lowest cost for each building project.

4. Make a table that clearly identifies which company should be hired for each project.