Adam De Angelis is the owner of Phototoprint.com.au, an online business that prints and produces photo quality
Question:
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:
|
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 ($) |
Principles of Taxation for Business and Investment Planning 2017
ISBN: 9781259753015
20th edition
Authors: Sally M. Jones, Shelley C. Rhoades-Catanach, Sandra R. Callaghan