CASES. CASE 1
Nippon Sushi and Sashimi Shack
Nippon Sushi and Sashimi Shack is a family-owned business that operates on the Gulf Coast. The company already uses both financial and point-of-sale (POS) software, but has been unable to find a suitable system to manage its inventory and purchase orders. You are an independent consultant who has been hired to develop an inventory and order system for the company.
Nippon Sushi purchases a variety of seafood (tuna, mackerel, shrimp, eel, crab, etc.) from local fishing boats and fresh vegetables from local farmers to make sushi and sashimi. Other food products are purchased from an Asian grocery wholesaler. Nippon Sushi sells its products through a variety of outlets, most notably its restaurant. The company sells prepackaged sushi and sashimi to supermarkets, hospitals, and other companies for resale. To ensure profitability, the company prices its products based on the estimated material cost that goes into producing them. Restaurant food is sold at cost plus 200 percent, wholesale orders are sold to retailers at cost plus 60 percent and smaller orders including catering events are sold at cost plus 100 percent. Due to the volatility in prices of seafood, menu prices are updated on a regular basis.
Currently, the company uses a journal to record its purchases and orders. Any employee can add, edit, or strike out a journal entry. When new seafood or vegetable products arrive, employees must record the type, total weight, and cost as a new journal entry. A spreadsheet is used to keep track of inventory totals. Wholesale and retail prices are manually calculated and entered into the POS software. Inventory is pulled out of stock on a first in, first out basis.
As the business continues to grow, this system is becoming less viable. Some of the shortcomings include:
1. Employees sometimes make clerical mistakes or forget to record transactions.
2. When the inventory holds a particular type of seafood or produce that has been purchased at different times and costs, it is difficult to determine the correct cost bases and some older food is spoiling before getting sold because food preparers are taking out stock in the wrong order.
3. Sales prices have to be manually calculated, a process that can take a lot of time to complete.
You have completed the systems planning phase; the next step is to create an object-oriented model of the inventory and orders system.
1. Create a use case diagram for an inventory and order system.
2. Create a class diagram for classes you would expect to find in Nippon Sushi’s system.
3. Create a sequence diagram for some aspect of the new system.
4. Create a state transition diagram that describes a changing state in the system.
AutoParts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas. The business is based on the idea of discount prices for auto parts that are always in stock or can be delivered within hours. The owners have decided to computerize their operations to allow them to better track their business and manage their inventories for just in time deliveries for sales. Data to be gathered for each customer sale includes invoice number, date, parts number, cost, retail price. Customer data is collected that includes basic contact information and vehicles owned, which includes vehicle make and model. For parts that have to be delivered to the store to fulfill a customer purchase, a transfer request is created. Data associated with these transfers include tracking number, invoice number, date, parts number, origination location (store or warehouse) number, destination store number.
1. Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities.
2. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.
3. Create fully normalized 3NF table designs for the system.
4. Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats.
You are a systems analyst contracted by Cornucopia, an Internet-based retail company that sells earth friendly products. You and your consulting firm have recently completed development of a new system for managing orders and inventory for Cornucopia. System architecture has already been decided, and you are ready to embark upon installation, evaluation, and training for the new system.
Cornucopia was started seven years ago by its founder, Aidan Perry. It has grown from an in-home business to a company that employs five people in addition to the business owner, and has office and warehouse space in an office park designed to encourage small businesses. The business has relied upon a simple point of sales system that requires manual processes for taking orders, billing, and managing inventory. The new IS will provide the support necessary for the company to expand. None of the employees have worked with an IS system similar to the one designed.
2. Develop a data conversion plan that specifies which data items must be entered, the order in which the data should be entered, and which data items are the most time-critical.
3. Discuss what options Cornucopia should consider for a changeover method for the new transaction system and provide specific reasons to support your choice.
4. The management of Cornucopia has decided to perform a post-implementation evaluation to assess the quality of the system. Who should be involved in the process? What investigative techniques should be used and why?