CSC 2540 Systems Analysis and Design 1 Course Project
CSC 2540 Systems Analysis and Design
Course Project – Part 1
As college students at Indiana University in the 1980s, Bob and Thelma Mellankamp often dreamed of starting their own business. While on their way to an economics class, Bob and Thelma drove by Myrtle’s Family Restaurant and noticed a "for sale" sign in the window. Bob and Thelma quickly made arrangements to purchase the business, and Hoosier Burger Restaurant was born. The restaurant is moderately sized, consisting of a kitchen, dining room, counter, storage area, and office. Currently, all paperwork is done by hand. Thelma and Bob have discussed the benefits of purchasing a computer system; however, Bob wants to investigate alternatives and hire a consultant to help them.
Perishable food items, such as beef patties, buns, and vegetables are delivered daily to the restaurant. Other items, such as napkins, straws, and cups, are ordered and delivered as needed. Bob Mellankamp receives deliveries at the restaurant’s back door and then updates a stock log form. The stock log form helps Bob track inventory items. The stock log form is updated when deliveries are received and also nightly after daily sales have been tallied.
Customers place their orders at the counter and are called when their orders are ready. The orders are written on an order ticket, totaled on the cash register, and then passed to the kitchen where the orders are prepared. The cash register is not capable of capturing point- of- sale information. Once an order is prepared and delivered, the order ticket is placed in the order ticket box. Bob reviews these order tickets nightly and makes adjustments to inventory.
In the past several months, Bob has noticed several problems with Hoosier Burger’s current information systems, especially with the inventory control, customer ordering, and management reporting systems. Because the inventory control and customer ordering systems are paper-based, errors occur frequently. These errors often affect delivery orders received from suppliers as well as customer orders. Bob has often wanted to have electronic access to forecasting information, inventory usage, and basic sales information.
Bob and Thelma have come to realize that the current problems with their inventory control, customer ordering, and management reporting systems are seriously affecting Hoosier Burger’s day-to-day operations. At the close of business one evening, Bob and Thelma decide to hire the Build a Better System (BBS) consulting firm. Harold Parker and Lucy Chen, two of BBS’s owners, are frequent Hoosier Burger customers. Bob and Thelma are aware of the excellent consulting service BBS is providing to the Bloomington area.
The Hoosier Burger project development team has met several times with Bob and Thelma Mellankamp. During these meetings, Bob has stressed the importance of improving Hoosier Burger’s inventory control, customer ordering, and management reporting systems. Demand for Hoosier Burger food is at an all- time high, and this increased demand is creating problems for Hoosier Burger’s staff, creating stock- out problems, and impacting sales.
During rush periods, customers sometimes wait 15 minutes to place an order and may wait an additional 25 minutes to receive their order. Low-in-stock inventory items are often not reordered in a timely CSC 2540 Systems Analysis and Design
fashion, thus creating problems with the food preparation. For instance, vanilla ice cream is used to prepare vanilla malts, an item that accompanies the Hoosier Burger Special. Last week, Bob did not order enough vanilla ice cream, resulting in a last- minute dash to the grocery store.
Bob and Thelma have expressed their feelings that a new information system will be beneficial in the areas of inventory management, marketing, customer service, and food preparation. Additionally, the project team discussed with Bob and Thelma the possibility of implementing a point-of- sale system as an alternative design strategy.
Build a Better System
Build a Better System is a medium-size consulting firm based in Bloomington, Indiana. Six months ago, BBS hired you as a junior systems analyst for the firm. Harold and Lucy were impressed with your résumé, course work, and systems analysis and design internship. During your six months with BBS, you have had the opportunity to work along-side several senior systems analysts and observe the project management process.
On a Friday afternoon, you learned that you had been assigned to the Hoosier Burger project and that the lead analyst on the project is Juan Rodriquez. You will be participating in the project management process. Mr. Rodriquez has scheduled a meeting with you to review the project management process. You know from your brief discussion with Mr. Rodriquez that you will be asked to prepare various planning documents for the project.
Tasks you must complete:
Each task should be completed in a separate document. You will need to use MS Word, MS Project, or Open Project, and Excel to complete various parts of the project. Create a folder called yourlastnameCPP1. Save all the completed files (there should be 14) in this folder for submission. The name you MUST assign to each file is enclosed in parentheses at the end of each requirement. These are the only names I will look for in your submission folder and if I don’t find one you will receive 0 points for that part of the assignment. When you are finished you need to compress the file into a zipped folder for submission. I will only accept .zip files.
5. Prepare a Gantt chart using MS Project or Open Project for the Hoosier Burger project. Using the following information. Assume the project is set to start on September 1, 2011. (hbgantt.mpp) or (hbgantt.pod)
CSC 2540 Systems Analysis and Design