• Which graphs should be made with the data provided?
  • There are 5 demands provided below, and the data provided in the images.
  • Which graphs could be made representing what data?
    • for example: A histogram for Sales and Demand because...
      • what does a histogram help show? Why Sales and Demand in the same chart? What goes on the X-axis, and Y-axis?
    • As many charts as possibles
      • The lead time, re-order point, and order up to cannot be put in the graphs. Only use the data from Day - Total inv (after ordering) for graphs.
      • DAY, DEMAND, INV ON HAND, AVAILABLE TO SELL, SALES, LOST DEMAND, INV ON ORDER (BEFORE ORDERING), TOTAL INV (BEFORE ORDERING), ORDERS, RECEIPTS, INV ON ORDER (AFTER ORDERING), TOTAL (AFTER ORDERING). SHOULD ONLY BE USED.
      • NO PIE CHARTS
• The demands of the vp are below (1-5)

The VP has asked that you explore the model and build 2 slides with graphs showing the data for what she wants to present. Note that:

1. she will certainly want to see standard service metrics like case fill-rate (sales / demand)
2. there is a lot of attention paid to monthly case-fill rate numbers in staff meeting [sales over a 30 day period]/[demand over a 30 day period]
3. she has a strong preference for ordering in multiples of 12 (the number of items in a case)
4. she would like to better understand the impact of changing key parameters (lead-time, re-order points and order up to)
5. in the past she has expressed concern over "working with averages" and wishes to better understand risk/variation and the relatedness between the various metrics..

MORE INFO BELOW: