Calculate product shipping

[JBX2018]

Hello all, new member to the Community looking for help. I was recently given a project at work and it has to do with Excel. I’m supposed to figure out how much product is being shipped and how many are staying behind. I was given a list of Product that has been delivered and a list of the ones that hasn’t been delivered and the reason they haven’t been delivered. Also, the lines(manufacuring line)that has the most issues and success. For example:
A. 200 boxes schedule to deliver today
B. 10 did not go because of CAPACITY/ line U
C. 50 did not go because of MATERIAL SHORTAGE/ line F
D. 20 did not go because they were NOT READY/ line M
E. 10 did not go because of OTHER REASONS/ line A
F. 110 got delivered on schedule
This list goes back 6 month. I have to create a report of all this with % graph and all. I’ll be honest here and say I have no clue as to how I should go about this project. If anyone here could guide me I’ll be very thankful.

 

[ranman256]

For data volume and analysis,you should be using Microsoft Access.
you don't use a screwdriver to pound in nails.

 

[JBX2018]

For data volume and analysis,you should be using Microsoft Access.
you don't use a screwdriver to pound in nails.

Thank you