Analysis of products report

Job ID: 33254945

Budget: $2 – $8 USD

I would like to get analysis to attached report with below requirements.

Specify the MAD qty of each materials.
Specify the MAD Amount by materials and Total.
Specify the shortage and excess.
Calculate the forecast. (Lead time = 60days and 30days safety stock)
Specify the Stock Month.
How much is the required qty to be ordered and by how much?
Specify the 80/20 sharing. (80% demand = 20% of Lines).
Other Analysis. (by your own judgement).