Question: 7 Tech Zone Store offers volume discounts: 0-100 units at $50 each, 101-200 units at $45 each, over 200 units at $40 each. If a customer orders 250 units, their total purchase cost is?

please send correct answer Q2

USE GOOGLE SHEET   Use the template below and create your own invoice for purchased products of a VAT registered customer. The products are enumerated below with unit price at gross of VAT, a 3% discount has been given to the customer. Do all formulas required. Format the invoice for clarity.

Suppose a certain appliance store purchases the following items. Calculate the extended total after the trade discounts for each line, the invoice subtotal, and the invoice total. (Round your answers to the nearest cent.) Quantity Unit Merchandise Unit List 150 300 18 12 ea. ea. doz. Blenders Toasters Coffee Mills doz. Juicers $39.95 Trade Discounts $244.30 20/15/15 $37.88 20/10/10 30/9/6 $480.00 25/10/5 Invoice subtotal LA 1 Extra 5 % volume discount on total order $ 2 Invoice total $ +A Extended Total