英语论文网

Any text in the body of the assignment should be sized 11or 12 point, 1.5 line spacing. Unless specified (eg Visio tasks) diagrams can be drawn using any appropriate tool (including hand-drawn).

It is assumed that you will have a basic knowledge of electronic spreadsheet principles before this assignment is attempted.  The assignment should be completed using Microsoft Excel.  It will be marked using Excel 2007. If features from other versions used do not work when opened with Excel 2007 the feature will not gain marks. 

 
D. CASE STUDY 

Whitlew Transport

This case concerns a company whose sales and client base have grown encouragingly, but whose MISs (Management Information Systems) have not grown accordingly.  It now faces external pressures from customers and the competition to improve its operations.

Whitlew Transport was founded in the late 1970s by Robert Whitmore and https://www.51lunwen.org/TurnitinPlagiarism/his brother-in-law, Richard Lewis.  They started from humble beginnings with two trucks that they drove and maintained themselves and in which they transported coal from open-cast workings to the nearby electricity generating stationst. Now there are more than 20 vehicles in the fleet, annual turnover is nearly $4 million and they have long since ceased to drive themselves.

The company’s key activities are transport and warehousing.  It provides a service to clients by storing their goods which arrive in bulk from overseas in one of 3 warehouses in the top of the South Island, and then delivering these direct to the customer in the agreed shipment sizes.  The major costs incurred by Whitlew are, therefore:

wages (for drivers and warehousemen);
diesel fuel for the vehicles;
maintenance costs for vehicles; and
overheads necessary to operate the warehouse function.

Whitlew Transport has achieved a prominent position in the marketplace through delivering a satisfactory service whilst maintaining a low price.  The pricing has been achieved through providing a service based on combining different clients’ delivery and storage requirements, rather than dedicating vehicles and warehouse space to particular clients.  As a result the storage peaks and troughs of individual clients can be smoothed, and on delivery several small orders for particular delivery points can be combined on one vehicle, yielding economies of scale.

The clients demand service of the highest quality which embraces:

Accurate receipt and checking in of their product.  This information is then swiftly supplied to them so that they can process supplier payments.
Due care to maintain the quality of the product while in the warehouse, including the accurate rotation of date-sensitive food items.  Any damage to stock through careless handling, or failure to rotate sell-by dates effectively, can lead to claims on Whitlew to the value of the inventory concerned.
Accurate picking and delivery of orders to their customers.  Failures in this regard involve Whitlew in the costs of bringing the wrong products back to the warehouse – with even more opportunity for damage due to excessive handling – and of organising emergency deliveries to correct mistakes.本论文由英语论文网提供整理，提供论文代写，英语论文代写，代写论文，代写英语论文，代写留学生论文，代写英文论文，留学生论文代写相关核心关键词搜索。