Kitchen Appliances R US is a specialist white goods store established by George Black and his…
Kitchen Appliances R US is a specialist white goods store established by George Black and his wife Georgina. They stock a supply of kitchen white goods (ovens, stoves, range hoods, fridges and dishwashers).
George has chosen to stock a limited range of manufacturers and sells them at discount prices. He has calculated different discounts for each manufacturer based on his analysis of the difference between the cost price of items to him and the recommended retail price (See the Manufacturer Discounts table). Before selling an item to a customer the discount is deducted from the recommended retail price.
Goods are delivered to customers via an external courier service. In the past George offered free delivery to all customers. However, this policy proved very costly and George has modified his policy so that only customers purchasing items which cost $2000.00 or more receive free delivery.
Georgina keeps a record of all sales. She realises that there is a lot of valuable information in the sales records that could be used to run the business more effectively and has decided to record sales data in a simple spreadsheet model.
|
In the spreadsheet which Georgina plans to develop she needs to record:
|
Complete the following IPO chart using the numbers 1, 2 and 3 to show which cell you are referring to:
|
INPUT |
PROCESSING |
OUTPUT |
|
For each sale: Item Manufacturer Manufacturer Discounts table |
1 |
% discount for each item sold |
|
2 |
Recommended retail price multiplied by % discount. |
Discount ($) |
|
For each item sold: Recommended retail price Discount ($) |
Recommended retail price minus Discount ($) |
3 |
