Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Coastal Seafood purchases a variety of seafood (Cod, Tuna, Tilapia, Crab, etc.) from local fishing boats. The company packs the seafood in ice, and then

Coastal Seafood purchases a variety of seafood (Cod, Tuna, Tilapia, Crab, etc.) from local fishing boats. The company packs the seafood in ice, and then sells it in parcels. The cost-per-pound of each type of seafood fluctuates on a weekly basis. Coastal Seafood sells bulk orders at cost plus 60 percent. Smaller orders are sold at cost plus 90 percent. 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 product arrives, employees must record the type, total weight, and cost as a new journal entry. A spreadsheet is used to keep track of inventory totals. When seafood is bought or sold, employees must update the spreadsheet. When orders are placed, employees must refer to previous journal entries to calculate the selling price, and the spreadsheet to check availability. 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 that has been purchased at more than one cost, it is difficult to determine the correct selling price for that type of seafood.

3.The journal entries have to be reconciled with the spreadsheet on a daily basis. This process can take up to one hour to complete.

QUESTIONS

1.Create classes for the inventory and orders system.

2.Create a use case for placing a new order.

3.Write a memo explaining how the new system will eliminate the current shortcomings.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions