I am doing assignment for school and stuck at one question. Its distance study, so contacting instructor is not an option.
Question is: I made 3 new column on sheet of inventory, In first column I have to change the price to reflect discount of 24%, but only for items in stock( another column) over 100, otherwise price won't change.
Second: If quantity of stock is smaller than 80, place an order for 50, if not, order 0
Third: Assume that data values stored in Unit price column represent the wholesale price ( WP). Determine Recommended Retail Price (RRP) based on the following business rule. If WP is greater than 20, RRP will be increased by 28%. If not, RRP will be increased by 35%.
This is like way too advanced for me and have no idea where to turn.