Q$\mathrm{.}1\mathrm{.}2$ Determine the overall total value of the eight tools by inserting an appropriate

formula in cell D$10.$

Q$\mathrm{.}1\mathrm{.}3$ Kim has been told that she should increase the overall totalvalue of all of the eight

parts by $25\%$ to reflect the effect of price inflation on the cost price of the took

over the five$-$year period whenthe section of the railway line was not in operation.

Determine what this inflation adjustment amount will be for all of the eight tools

by inserting an appropriate formula into cell D$12.$

Q$\mathrm{.}1\mathrm{.}4$ Determine the current overall total value of the eight tools, including the inflation

adjustment amount, by inserting an appropriate formula into cell D$14.$

Q$\mathrm{.}1\mathrm{.}5$ Determine the average current value of the total stock of the eight tools using the

overall total value determined in cell D$14$ and the total quantity of tools by

inserting an appropriate formula in cell D$16.$

Question $2$

$($Marks: $20)$