Reference no: EM132449839 , Length: 2 pages

Case Study Question:

Gerry's Business Data for Year ending June 201X

Driver Data

Age	Number	Ave Annual Wage $000's	Ave. kms./ Driver / Year	Total $ Fines for Group	Gym Membership	Ave. Sick Days / Year / Driver	Ave Turnover %
21-30	6	43.5	141,000	10,560	5	7	9.3
31-40	27	46.2	138,500	35,640	19	7	5.2
41-50	23	46.7	135,500	20,240	12	11	2.9
51-60	18	44.3	132,600	7,920	5	14	1.2
>60	2	42.3	129,500	440	0	16	0.5
Total	76	46.2		$74,800	41

Business Data

Month	Orders Received $000''s	Sales Invoiced $000's	Total kms Driven (000's)
Jul	1,790	1,883	998
Aug	1,665	1,782	928
Sept	1,670	1,680	875
Oct	1,590	1,620	839
Nov	1,515	1,580	836
Dec	1,100	1,540	796
Jan	1,450	1,170	583
Feb	1,680	1,550	795
Mar	1,705	1,650	855
Apr	1,738	1,680	875
May	1,605	1,783	924
Jun	1,660	1,895	1,008
Total	19,168	19,813	10,312

 Customer Data

Customer	Orders Received $000''s	Sales Invoiced $000's	Total kms Driven (000's)
A	11,180	11,650	6,132
B	2,995	3,260	1,707
C	1,395	1,450	755
D	1,055	1,085	570
E	955	986	505
All Others	1,588	1,382	643
Total	19,168	19,813	10,312

Part a) Gerry, the owner of Gerry's Transport Pty. Ltd. wants you to respond to the following:

Part b) Gerry's company employs 76 drivers. 20 are aged over 50 years, and of these, 5 go to a gym regularly. Of the drivers under 50 years, 36 attend a gym regularly. As long distance driving is physically demanding Gerry is concerned that the lack of regular exercise may affect the performance of the over 50 drivers. Gerry has asked you to look at the available data, specifically gym membership, sick days and Kms. driven, to see if there is any statistical evidence to show performance is affected by not having gym membership. Respond to Gerry with supporting statistical evidence.

Part c) Gerry's pays his drivers a fixed weekly wage, which varies according to age and experience. Some of the drivers are asking to be paid on a $ rate per kilometre basis as they say the current pay basis favours older drivers and penalises younger ones. Gerry does not, in principle, have a problem with this, but he would like some statistical data to enable him to make a decision. Are the younger drivers correct in their assertion? Support your answer with appropriate statistical data.

Part d) Gerry has a "gut feeling" that his business is both seasonal and trending downwards. Using the Orders Received and Sales Invoiced data, identify any seasonality and trend in the 201X year.

Part e) Gerry would like to see in graphical form
• a comparison of sales invoiced by customer with orders received by customer, and
• Amount invoiced by kilometre by customer

Create illustrative graphs and add any comments that Gerry might be interested in.

Part f) Undertake your own internet research to answer the following questions:

i. In Gerry's Driver Data the average wage for a truck driver was quoted as $46,200 p.a. Is this amount realistic currently? Reference your sources.

ii. Was the sales amount invoiced per Km to Gerry's customers realistic in today's economic climate? Again reference your sources.

Attachment:- Case Study Question.rar