Case study gap fillergap filler is a recruitment and labour

Assignment Help Database Management System
Reference no: EM13373976

Case Study: Gap Filler

Gap Filler is a recruitment and labour hire company (i.e., ‘staffing solutions') that services the agricultural and food processing industries in regional Victoria. Gap Filler provides short-term and temporary labour to farmers, horticulturalists, orchardists, vineyards, and a range of food and beverage packaging and processing businesses.

For example, during the apple harvest, Gap Filler provides fruit pickers to orchardists and personnel to work in apple packaging and processing plants. Gap Filler also recruits personnel for permanent positions (e.g., farm workers and managers, and supervisors for packaging and processing facilities). Gap Filler started in 1997 as a small family run business based in Shepparton, approximately 200 km north-east of Melbourne. Gap Filler has gradually developed business operations across regional Victoria and has offices located in Hamilton, Swan Hill, Sale, and Warrnambool. The Shepparton office serves as the head office for Gap Filler and this is where the accounts and the senior management team are located.

The company employs 48 staff in a variety of fulltime and part time roles. Gap Filler recorded turnover of just over $16 million for the financial year ended 2013. The Gap Filler sales team have successfully developed ongoing business relationships with a variety of large and smaller businesses. Unfortunately much of this sales information and marketplace intelligence resides with sales team members rather than captured by any company information system. An ongoing challenge for the business is matching its supply of reliable workers available for hire to the seasonal and fluctuating demand of its customers. Keeping up to date records on over 400 workers' availability, contact details, currency of certifications for operating equipment (e.g., heavy vehicles, forklifts, and loaders), and how well the workers are performing on the job is also a challenge. Currently this worker information is stored on a Microsoft Access database which struggles to meet the business's needs.

Moreover, Gap Filler's administrative staff are required to manually transfer much of this worker information from hard copy forms and emails into the Access database. Companies using Gap Filler's workers email through the number of hours clocked up each week. Gap Filler would like to improve the systems used for managing worker information and recording workers hours.

About eight years ago the company invested in a labour hire and sales system (Filler-IT). Unfortunately the Filler-IT system is becoming increasingly difficult to maintain. The Filler-IT system has also proved difficult to modify for the changing business environment. Moreover, the business wishes to take labour hire bookings, record workers' hours, and payments via the internet. Unfortunately, the Filler-IT system does not readily support online transactions. The business uses QuickBooks (Enterprise version) to run its accounts. For general computing requirements, the company operates desktop and laptop computers operating Microsoft Vista and Office 2007.

The company's directors recognise that a review of the Gap Filler's business information system needs is required, especially given that the Filler-IT system is getting to the end of its useful life. You have been asked by the Gap Filler'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 that could be used to effectively meet these requirements?

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

You are free to structure the report as your group see fit. Your aim should be to produce a report that follows a logical order taking the reader from a situational analysis to your group's recommendations and the rationale for these. A suggested structure for this report follows.

1. Introduction
2. Description of the business
3. The key information required to successfully operate the business
4. BIS requirements
5. Recommended information systems and how these will meet business requirements

Reference no: EM13373976

Questions Cloud

Bonds and term structure1 graph the bond yield to maturity : bonds and term structure1. graph the bond yield to maturity ytm on the y-axis of an xy-scatter plot with the bond to
You are to turn in a powerpoint presentation with detailed : you are to turn in a powerpoint presentation with detailed notes which fully detail the stakeholder issues that are of
Subjecct title conflict in martial relationships and : subjecct title conflict in martial relationships and forgiveness in marital infidelity.divided into the following
Answer one of the following questions1 what reasons do : answer one of the following questions1. what reasons do epicurus and socrates give for not fearing death?2. why does
Case study gap fillergap filler is a recruitment and labour : case study gap fillergap filler is a recruitment and labour hire company i.e. lsquostaffing solutions that services the
Write a 600 -900 word persuasive essay for a ninth grader : write a 600 -900 word persuasive essay for a ninth grader about why the death penalty should be allowed as a form of
Magine youre teaching in an empty classroom there are only : magine youre teaching in an empty classroom. there are only four walls your students and yourself there is no
Discuss lady macbeths role in the : discuss lady macbeths role in the play
Write two essays as outlined asenglish essaysessay i write : write two essays as outlined asenglish essaysessay i write a formal essay using mla format on the unusual stylistic

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd