Question

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.

Answer 1

Answer 1

By using the matrix multiplication, we get that

After the calculations we get the values as mentioned below:

Now, we get that

COST	BOUMA	PINNACLE	ROCKFORD	MCGRAW
OFFICE SPACE	171690	164960	168245	163305
SCHOOL	212085	202495	202325	203120
APARTMENT	247525	261685	264710	258690
GROCERY STORE	150480	145810	151375	143515
TOTAL COST	781,780	774,950	786,655	768,630

MCGRAW is the company can complete each project at the lowest cost.(768,630)

Answer 2

Lets Highlight the cells that give the lowest cost for each building project:

COST $	BOUMA	PINNACLE	ROCKFORD	MCGRAW
OFFICE SPACE	171690	164960	168245	163305
SCHOOL	212085	202495	202325	203120
APARTMENT	247525	261685	264710	258690
GROCERY STORE	150480	145810	151375	143515

Answer 3

The below table shows which company should be hired for each project.

HIRED FOR PROJECT	COMPANY NAME	COST IN $
OFFICE SPACE	MCGRAW	163305
SCHOOL	ROCKFORD	202325
APARTMENT	BOUMA	247525
GROCERY STORE	MCGRAW	143515

Please Encourage us by Up Voting the Answer which is Very Helpful to us.
Thank You!