Statistics-QA72

Statistics-QA72 Online Services

 

Instructions

 

  1. Download the Excel file: xlsx. It contains information about customers, mechanics, and other details of a mechanical garage. Descriptions of the fields are as follows

    2.  

Column Name Description
A Customer ID unique number assigned to each customer
B Customer Name name of each customer
C Mechanic # unique number assigned to the mechanic who completed the job
D Car Type make of vehicle on which the work was completed
E Work Completed type of repair that was performed on the vehicle
F Num Hours length of time taken (in hours) to complete the work
G Cost of Parts cost of parts associated with completing the repair
H Total Charge amount charged to the customer for the repair

 

     

    You can read more about our case study assignment help services here.
     

    How it Works

    How It works ?

    Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

    Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

    Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

    Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

    Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

    Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

    Case Approach

    Scientific Methodology

    We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

    Defining Problem

    The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

    Structure Definition

    The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

    Research and Analysis

    This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

    Conclusion & Recommendations

    A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

    Related Services

     

  1. Add two additional columns in order to get a deeper analysis of the data
    • Net Revenue (total charge minus cost of parts)
    • Net Revenue per Hour (net revenue divided by number of hours)
  • Create pivot tables to help you answer the following questions
       

    1. Design a table that shows the performance of the mechanics (in terms of average revenue per hour). Who is the best employee (mechanic)?
    2. The CEO of the garage has decided to give a full refund to William E. Morin in order to retain him as a customer. What is the financial impact of that decision on the company?
    3. Which mechanic works the most hours?
    4. Which type of service is the most valuable for the garage?

      5.  

    5. Design a three dimensional table that calculates the average revenue per hour by Mechanic, Car Type and Work Completed. Which work (repair), on which type of car brings more value, and who is performing that job?
    6. Provide a table showing the most valuable customers of TREVOR.
    7. In your analysis, provide a specific marketing product TREVOR should offer to the most valuable customers.

     

  • Create a 3- to 5-page report to management that provides answers to each of the questions in Question 3 above. The report should include, for each question, an explanation of how your analysis of the pivot table you created enabled you to answer the question, along with implications for running the business (what would the report mean? for example, how would management use each result to make decisions? what types of decisions could be made with the information?). Use tables, graphs, etc., to represent your observations and recommendations based on these analyses. Make sure your report has an introduction and a conclusion. For formatting guidelines, see Writing An Analytical Report. REPORT MUST BE IN MEMO/LETTER STYLE NOT IN PIONT FORM. MUST INCLUDE INTRODUCTION AND CONCLUSION.

    •  

For this assignment, you must submit

 

  • an Excel spreadsheet
    AND
  • a Word document

Marking criteria
 
You will be marked according to the following criteria.

 

Spreadsheet
 
Calculated data columns added correctly (/2 marks)
 
Each pivot table is set up correctly (/12 marks)
– Average revenue per hour by mechanic
– Financial impact by customer
– Hours by mechanic
– Most valuable service
– Which repair on which car by which mechanic is most valuable?
– Most valuable customers
 
Tables are formatted for readability and style (/1 mark)		 /15
Analytical Report
 
Report describes each analysis and its implications. (/8 marks)
 
Report is professional, well written, and organized. (/2 marks)		 /10
Total Grade /25

When naming your assignment files for submission, be sure to include your last name, the course name, and the assignment number, as in this example: smith cmis351 assign2.docx
 
When your assignment is complete, return to this page and follow the instructions for submitting it.
 
All of your course work must be submitted before 12:00 midnight (Mountain Time) on the final day of your contract.
 
To account for administration, processing, and marking times, please allow up to eight business days from submission for the return of your marked assignment.
 
product code: Statistics-QA72

 
Looking for best Statistics-QA72 online,please click here
 

Summary