Problem 2: Invoice
Re-create the Sales Invoice model below for purchased products with the format and features shown in
Figure 3. You may use the Item, Quantity and LlstPrlce data as provided.
. Discount Rate, Discount Threshold and lIST_Rate amounts should be specifled as shown and
referenced In formulae so that any changes In those values will be automatically applied to the
Sales Invoice calculations.
. Compute the Discount values so that e.g.. 7.50% Is displayed for Items when Quantity exceeds
the Discount Threshold but remain blank otherwise (not zeros).
. Sa Ic_PrIce = the List_Price except when discount applys.
. Total = the item total price for the quantity ordered;
. Subtotal = the total of all line item totals;
. lIST = the specified rate applied to the Subtotal
. Amount_Due = the sum of Subtotal and HST
Get Free Quote!
275 Experts Online