IPO Chart

Adam De Angelis is the owner of Phototoprint.com.au, an online business that prints and produces photo quality books, posters and calendars. Customers utilise free on-line software to upload photos and design photo books and calendars which are then uploaded to phototoprint.com.au. Phototoprint produces the products on high quality paper and delivers them to the customer within a two week period.

Adam advertises a limited range of products and advertises them online. Prices vary according to the item ordered. (See Charge Per Item table) He utilises a number of discount deals web-sites to promote his products. These sites enable customers to obtain discount coupons entitling them to a 10% discount. For each order Adam records whether a discount code has been used.

Adam keeps a record of all sales. He 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 data in a simple spreadsheet model.

In the spreadsheet which Adam plans to develop, he needs to record: Cost for each item ordered Percentage discount for each item ordered Discount ($) for each item ordered Total charge for each item ordered Total monthly revenue

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 order: Item Charge per Item table	1	Cost per item
For each order: Discount code used? (yes, no) Discount %	If discount code equals yes then discount rate, otherwise leave blank	2
For each order: % discount Cost of item	3	Discount ($)