Please review the two excel attachments. Out of the two you will make one only.

Please review the two excel attachments. Out of the two you
will make one only. You need to add better formulas and also charts. Add a
graph for each component location and also add something that forecast the
product life cycle such as until when it will last. Also add a formula where it
goes red when inventory its reaching ZERO. Average the numbers to come up with
average user average pallets per item. Make it look professional.There needs to be a tab for each location. There needs to be
a tab for plant averages in this tab add the graph where you compare the plants
averages per item. Also add a tab where it tells when items needto be ordered again and when they are
reaching ZERO.
Attachments: