Copies Made 750 200 500 1,001 Copying Cost $22.50 $8.00 $15.00 $20.02 Delivery Charge $0.00 $7.00 $7.00 $0.00 Total Cost $22.50 $15.00 $22.00 $20.02 3 Copies A Delivery Charges 1 2 3 B 1 Sales Price Number Price 2 Of copies Per Copy 3 1 $0.07 10 $0.06 5 100 $0.05 6 200 $0.04 7 500 $0.03 8 1,000 $0.02 4 Pricing 1. Write an Excel formula in cell Copies!B2, which can be copied down the column, to determine the cost of making copies 2. The company also offers delivery. Their delivery charges are as follows: For orders under $5, there is a s5 delivery fee. Orders at least SS but smaller than $20 have a $7 delivery fee, Orders of S20 or more are delivered free of charge. Set up a reference table on the Delivery worksheet so that you can write a reference function to calculate the delivery cost for each order. Organize the table in a horizontal format. Delivery 3. Write an Excel formula in cell Copies!C2, which can be copied down the column the column, to calculate Delivery Cost. Use the reference table you created in question 2