Reference no: EM131403

Analyse and explain the business information systems required for this a small to medium size business. The information systems identified will need to support the several aspects of the business (e.g., inventory, sales, maintenance, delivery, and accounts).

Give a brief group presentation to the class. All group members will need to contribute equally to the preparation and delivery of the presentation. The presentation could be no longer than 15 minutes in duration.

Prepare an individual report outlining the information systems recommended for the case study business. This report should identify: (a) the key external and internal business requirements that the selected information systems need to address, and (b) how the recommended systems provide the core information required to successfully operate the business. The case study for this assessment is provided below.Your report should be no longer than 2,000 words excluding references and appendices. Please ensure you provide a coversheet for your assignment. The coversheetshould also show the word count for your assignment (i.e., excluding appendices and references). The report should be written in 12 point font with 1.5 line spacing. Kaplan Business School uses Turnitin software. If your lecturer has any concerns that your report includes material that has been inappropriately copied from another source or student, then we may ask for a Microsoft Wordversion of your report to run through the Turnitin program.
Feedback: Comments and a mark will be returned to you within two weeks of submission.

Case Study: EquipHire

EquipHire is a commercial and domestic equipment hire company with 11 branches across metropolitan Sydney, Newcastle, and Wollongong. The family owned business was started 18 years ago by two brothers. The company employs 78 staff in a variety of fulltime and part time roles.EquipHire recorded turnover of just over $18 millionfor the financial year ended 2012. About eight years ago the company invested in a sales and hire system (HireIT). Unfortunately the HireIT system is becoming increasingly difficult to maintain. The HireITsystem has proved also difficult to modify for the changing business environment. Moreover, the business wishes to take equipment hire bookings and payments via the internet and the HireIT system does not readily support online transactions.

Approximately 70% of the sales are to the commercial sector (i.e., construction, engineering, and building trades), although home DIY sales are now the fastest growing part of the business. EquipHire hire a range of building and engineering tools (e.g., concrete cutters, chainsaws, nail guns, wielding gear, and dumpy levels), plant (e.g., compressors, mobile platforms, generators, small excavators, and trenchers), and other equipment (e.g., glassware for party hire, tables and chairs, high capacity heaters, and marquee tents).

The costing for large and long term hires is carried out on an ad hoc basis using spreadsheets. Managing the company's inventory of plant for hire is a particular challenge. The company finances most of its large plant with third parties, thus it needs to ensure high equipmentutilisation rates (i.e., sales) to service this financing. The company is struggling to make good decisions around how much plant they should hold(in total and by location) to meet the demand forhire. The demand for plant and equipment hire is seasonal and also affected by fluctuating construction activity. The company has recognised that the quality of equipment checking and maintenance is notconsistent enough to ensure good levels of ongoing repeat customer business.

The business uses QuickBooks to run their accounts and equipment maintenance is run through an Access database. The delivery and pick up of equipment is carried out manually using carbon-copy receipt books. This data is then manually transferred into HireIT. For general computing the company operates desktop and laptop computers operating Microsoft XP and Office 2007.

The company directors recognise that a review of the EquipHire's business information system needs is required, especially given that the HireIT system is getting to the end of its useful life. You have been asked by the EquipHire's directors to write a preliminary report that: (a) outlines the company's business information system (BIS) requirements, and (b) makes recommendations on the core systems that would meet these BIS requirements.

Key questions to address:

1. What are the main activities that the business undertakes?

2. Where in the business are the crucial decisions made?

3. What types of information does the business require to operate successfully?

4. What are the requirements for the:

a. transaction processing system?

b. sales and customer relationship management (CRM)?

c. inventory?

d. planning and scheduling?

e. accounts?

f. decision support and management information systems?

5. What are the different types of business information systems could be used to effectively meet these requirements?

6. What core information systems do you recommend the business adopt?