mgt 370 w4 supplies for medics com case study 1

TWO FILES REQUIRED – EXCEL FOR ANALYSIS AND WORD FOR WRITING ** ALL WORK MUST BE SHOWN (EXCEL) AND IT MUST BE ORIGINAL AND NO PLAGARISM IN WRITING **

Assignment Detail:

Read the case study “Supplies for medics.com”, attached.

Write a paper of 750 words that includes the following:

1.Prepare a table-based ABC analysis of usage value.

Classify as follows:

i.A-items: top 20% of usage value

ii.B-items: next 30% of usage value

iii.C-items: remaining 50% of usage value

2.Calculate the inventory weeks for each item, for each classification, and for all the items in total.

3.Does this suggest that Pierre Lomouche’s estimate of inventory weeks is correct?

4.Based on the sample, analyze the underlying causes of the availability problem described in the text.

5.What recommendations would you give to the company

Include a minimum of three scholarly sources.

Format the paper using APA formatting.