Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the DATEDIF formula and how to start this in order to answer question 1 Sally's Soaps Sally, your boss at Sally's

I need help with the DATEDIF formula and how to start this in order to answer question 1

image text in transcribed
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 snaps 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 in find another supplier. When you hand it back in 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? Isee 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 I 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 I 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). Hut all you have in do is set the formatting for that cell in General or in any number format. If you want to know the number of months or years between two dates, the best way is in use the DATE:DIP) function. However, you won't find this one in the function wizard so you will have to remember how in type it in yourself. The format for the function is DATED.Fewer ders, and dew, "whir"I. I'm meaning the unit of measure, can be "IN" for " form

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Strategy

Authors: Gerry Johnson, Kevan Scholes, Richard Whittington

2nd Edition

0273713108, 9780273713104

More Books

Students also viewed these Accounting questions