PFA

PFA


Sally’s Soaps Sally, your boss at ‘Sally’s Soaps’, just walked into your office. She is a little upset as she hands you a print out of an email she just received. You take it and read: Sally, I really don’t understand what has been happening with my shipments, they never arrive on time! I am losing sales and upsetting customers with stockouts. I have been a retailer of Sally’s Soaps since you were mixing soaps out of your kitchen. We used to get such great customer service when it was just you and your family. It really seems that you have gone corporate and no longer care for the small retailers that helped you become successful. If my shipments don’t start arriving on time I am going to have to find another supplier. When you hand it back to her she says: “I like making soap, not shipping boxes. I hired you so I would not have to tape up another box. What is happening here? Let me know what is going on by the end of the day so I can call this client and repair this damage”. As Sally walks out your door, you reach for your computer and pull up some shipping data for the last month. Questions to answer: 1. Examine the distribution (histogram, box and whisker plot) between the Order Date and the Date Shipped. What conclusion do you draw? (See Helpful Notes below for calculating the difference between two dates. 2. Which products are most likely to be shipped late? (For each product count the number times the product was shipped in 1 day, 2 days, etc…) 3. Which shipping method is most likely used on late shipments? (For each shipping method count the times shipped out in 1 day, 2 days, etc…) 4. Which customers should Sally personally follow up with? Why? (For each customer count the times product was shipped out in 1 day, 2 days, etc…) Helpful Notes:   If need to know the number of days between two dates, that is very easy to do in Excel. Just subtract one date from the other. Excel may automatically format the cell with the formula in it as a date, which means instead of seeing a number (29), you’ll see a date (1/29/1900). But all you have to do is set the formatting for that cell to General or to any number format.   If you want to know the number of months or years between two dates, the best way is to use the DATEDIF() function. However, you won’t find this one in the function wizard so you will have to remember how to type it in yourself.  The format for the function is DATEDIF(start date, end date,”unit”). Unit meaning the unit of measure, can be “D” for 1. Conduct a case analysis, draw conclusions, and present your findings (answer to the questions) MAKE SURE I CAN SEE/ACCESS ALL OF THE FORMULAS YOU HAVE USED WITHIN YOUR SPREADSHEET SUBMISSION. 2. Create a mini presentation (can be a Power Point) that answers all of the questions posed within the case  (Use charts and graphs to show your analysis and conclusions when presenting your findings) 1. This is your creation and can be presented in any format as long as you have shown your responses to the questions through your analysis 2. Use the Excel skills you have learned thus far to ensure a quality mini presentation 3. The response for this assignment can vary and will depend on your evaluation of the case and data; it is your own data exploration, analysis, and conclusion findings to respond to Sally's inquiry 4. Make sure your case is backed up with your data findings within your mini presentation 3. Upload your completed presentation file with all resources cited in APA format