Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Williams Bros. Appliances Inventory and Point-of-Sale System Interview Notes January 30, 2017 When the owners need to acquire additional inventory, they refer to various manufacturers'

Williams Bros. Appliances

Inventory and Point-of-Sale System

Interview Notes

January 30, 2017

When the owners need to acquire additional inventory, they refer to various manufacturers' catalogs and promotional materials, as well as industry reports and evaluations. They currently stock products from Whirlpool, GE, Kitchenaid, Maytag, Frigidaire, Tappan, Amana, Hotpoint, Roper, White Westinghouse, Sony, RCA, and Toshiba. If a customer prefers to special order a product, they can also accommodate them. Most special orders take 2-3 weeks to arrive.

For regular stock items, Ted or Will completes a two-part carbonless Purchase Order (see example in Figure 3) and mails or faxes it to the manufacturer's regional sales manager. After all the information has been entered, they calculate the extended price for each line item, and total the purchase order. The top copy is sent via mail or fax, and the second copy is filed in the "Ordered Inventory" folder.

When the ordered items arrive, Ted or Will pull the second copy of the Purchase Order out of the "Ordered Inventory" file and confirms that what they received was what they had ordered. If there are any items that are backordered (they ordered something but it didn't arrive with the rest of the shipment) they write a note on the purchase order, make a copy, and place this now third copy back in the "Ordered Inventory" folder. The second copy showing the items that were received is placed in the "Update New Inventory" folder.

Before the end of the day, Ted or Will goes through the "Update New Inventory" folder and records all products they received that day in a three-ring notebook--one notebook for each manufacturer (see example in Figure 4). When a product is sold and after it has been delivered, Ted or Will goes through the "Sales" folder, and for each product that was sold, selects the appropriate inventory notebook, matches the sold item with the listed item based on product number and serial number, and write down the date of the sale in the notebook. At the end of each week, one of the owners will also go through the "Sales" folder, and create a "Weekly Sales Report" of everything that was sold during the week. This report lists the product, manufacturer, product number, serial number, cost, and price. This report is then totaled to provide a record of weekly sales. Ted and Will would like to be able to see sales by product line, and by manufacturer, and would also like to create this report daily, but they just don't have the time.

a) Draw the state transition diagrams (STD) for the intended information system of the scenario?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Hands-On Database

Authors: Steve Conger

2nd Edition

0133024415, 978-0133024418

More Books

Students also viewed these Databases questions

Question

=+10. What is the brand's character or personality?

Answered: 1 week ago

Question

3. Is there opportunity to improve current circumstances? How so?

Answered: 1 week ago

Question

2. What do you believe is at the root of the problem?

Answered: 1 week ago