Re-create the Sales Invoice model below for purchased products with the format and features shown in

computer science

Description

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

Instruction Files

Related Questions in computer science category