Massey Engineering Works $($MEW$)$ is one of four subsidiaries of Massey New Zealand.

Massey New Zealand provides support services from its head office to its four subsidiaries

MEW, NEW, SEW and MFW$.$ The head office uses the reciprocal method to allocate the head

office costs to the four subsidiaries. The relevant information to perform the calculation has

been provided below:

a$.$ Fill in the table below for the equations for the support departments using the

reciprocal method and up to $4$ decimal places $($Note that you will need to rearrange

the order so that they align with the column headings.$)$:

Total Marks for Question $3$a $(9$ marks$)$

b$.$ Invert the matrix in Excel and write the results in the table below up to $9$ decimal

places.