A partially completed version of the worksheet is shown below. To complete the spreadsheet, you need to understand the discount policy, which states that a discount is given if the total sale is equa...


A partially completed version of the worksheet is shown below. To complete the spreadsheet, you<br>need to understand the discount policy, which states that a discount is given if the total sale is equa<br>to or greater than the discount threshold.<br>Complete the worksheet in the figure, then create two additional scenarios for different selling<br>strategies. In one scenario lower the discount threshold and discount percentage to $3000 and 12%,<br>respectively. Increase these values in a second scenario to $10,000 and 20%. Save all three scenarios<br>and submit the completed assignment.<br>MIAMI, FLORIOA<br>AMOUNTOF OisCoUNT DISCOUNTED TOTAL<br>SALES TAX<br>AMOUNT DUE<br>PROGRAM<br>CURRENT PRICE UNITS SOLD 1OTAL SALE<br>CUSTOMER NAME<br>AAA SOFTWARE SALES Norton Utities<br>COMPUSOFT. INC<br>35<br>45<br>15<br>30<br>17<br>116.99<br>Microsoft Office 2010 $<br>317.95<br>కం 55<br>59.99<br>KINGS BAY SOFTWARE Adobe Photoshop<br>MICROSALES INC<br>PC& Me software<br>Personal Software Sales Quicken Deluxe<br>Service Software<br>Software and More<br>Software to go<br>Unique Software Sales Microsoft Office 2010S<br>Quicken Deluxe<br>Microsoft Office 2010 S<br>317.95<br>59.99<br>Adobe Photoshop<br>Norton Utilities<br>Norton Utilitirs<br>116.99<br>116.99<br>317.95<br>15<br>50<br>50<br>Number Of Customers<br>Discount Threshold<br>Discount Percentage<br>5,000.00<br>15%<br>6.5%<br>Highest Current Price<br>Fewest units Sold<br>Sales Tax<br>Total amount due<br>uno Ảy<br>

Extracted text: A partially completed version of the worksheet is shown below. To complete the spreadsheet, you need to understand the discount policy, which states that a discount is given if the total sale is equa to or greater than the discount threshold. Complete the worksheet in the figure, then create two additional scenarios for different selling strategies. In one scenario lower the discount threshold and discount percentage to $3000 and 12%, respectively. Increase these values in a second scenario to $10,000 and 20%. Save all three scenarios and submit the completed assignment. MIAMI, FLORIOA AMOUNTOF OisCoUNT DISCOUNTED TOTAL SALES TAX AMOUNT DUE PROGRAM CURRENT PRICE UNITS SOLD 1OTAL SALE CUSTOMER NAME AAA SOFTWARE SALES Norton Utities COMPUSOFT. INC 35 45 15 30 17 116.99 Microsoft Office 2010 $ 317.95 కం 55 59.99 KINGS BAY SOFTWARE Adobe Photoshop MICROSALES INC PC& Me software Personal Software Sales Quicken Deluxe Service Software Software and More Software to go Unique Software Sales Microsoft Office 2010S Quicken Deluxe Microsoft Office 2010 S 317.95 59.99 Adobe Photoshop Norton Utilities Norton Utilitirs 116.99 116.99 317.95 15 50 50 Number Of Customers Discount Threshold Discount Percentage 5,000.00 15% 6.5% Highest Current Price Fewest units Sold Sales Tax Total amount due uno Ảy

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here