You are an accountant for an appliance parts supply company. You have just completed a special promotion and need to analyze its success. You have been provided a file with a sheet named “Sales Promo Analysis” containing a list of items in the promotion along with each item’s cost and selling price. You now must update it with the quantity of items sold during the promotion and to determine the following calculations in steps 1 through 7. Scenario: