The company will start the production of a new piece made of aluminium. Before manufacturing can begin, a preliminary costing is required. Data obtained from the London metal exchange shows the price of steel over the month of August $2020$:

Day

$ per Ton

Note: the gap in the days sequence is when data was not available.

$1$

$1680$

$2$

$1710$

$3$

$1739$

$4$

$1722$

$5$

$1744$

$8$

$1730$

$9$

$1750$

$10$

$1754$

$11$

$1738$

$12$

$1730$

$15$

$1720$

$16$

$1733$

$17$

$1747$

$18$

$1756$

$19$

$1723$

$22$

$1736$

$23$

$1733$

$24$

$1737$

$25$

$1738$

$26$

$1762$

Exchange rate at the time of costing: $1$$ $=0\mathrm{.}78$

UK VAT rate: $20\%$

It is anticipated that a batch of $6000$ pieces will be produced with a weight of $1\mathrm{.}5$kg each. The machine used in the manufacturing process takes $3$min to produce each part.

These will be bought by one of your long$-$standing customers, Havering Engineering LTD$.$

Because of the amount of parts required and for being a loyal customer, your company is offering a $5\%$ discount on the sales invoice.

A deposit of $2500$ will be paid by the client before the start of the production. Your company operates on a $20\%$ profit margin per item produced.

In order to produce your costing and to prepare the invoice, you must perform the following sequence of operations:Produce a line graph showing the price of aluminium variations over $26$

days

Convert the average cost into pound Sterling using the given exchange rate

Calculate the amount of aluminium required to produce $6000$ parts

Calculate the cost of the aluminium required to make those pieces using

the average cost

Calculate the cost per piece being manufactured to $2-$decimal point

$6.$ From the unit cost add a $20\%$ profit margin; this will be the unit price $(2-$

decimal point$)$

Estimate the number of parts made in $1hr$ and how many days it will take to

produce the whole batch