Jack is concerned about how many clients that Jack's Mowing are losing. In particular, Jack feels that
Fantastic news! We've located the answer you've been seeking!
Diane has indicated that while she does not have a record of clients that Jack's Mowing may have lost, she has indeed kept a list of jobs that were unable to be performed over the past 2 years.
Diane has also made notes of each instance that a job could not be performed due to Jack being either overbooked, or unwell.
Jack has asked Diane several specific questions to help understand this aspect of the business including:
a) How much revenue was lost as a result of jobs not performed?
b) What were the reasons for jobs not performed?
c) How many jobs can Jack expect will not be performed next year?
d) How many hours of work should Jack offer to a casual employee to minimize revenue lost from jobs not performed?
REQUIRED: For each question asked by Jack:
i) Identify whether it is best resolved using descriptive, diagnostic, predictive or prescriptive analytics;
ii) Suggest data that would be useful for providing an answer; and
iii) Highlight difficulties with the analysis necessary to address the question
Related Book For