show work please

Create excel spreadsheets for each of the following orders showing the Billed cost, shipping dollars, cash discount dollars, and the cost of Goods Sold. Complete all work in ONE spreadsheet and upload completed work to Canvas. 1. The sportswear buyer placed the following order: o 36 pants costing $10.75 each 48 pants costing $15.50 each 24 pants costing $17.50 each Shipping charges (paid by the store) were 6% of the billed cost (20pts) 2. Aluggage buyer purchased 72 attach cases that cost $40 each. The cash discount earned was 2%, and the store paid inward freight of $95. Find the total cost of the merchandise on this order. (10pts) 3. A gift shop has workroom costs of $575. The billed cost of merchandise sold amounted to $59,000, with cash discounts earned of $1,180, and freight charges of $650. Find the total cost of the merchandise. (10pts) 4. A specialty dress shop made purchases amounting to $3.700 at cost, with 8% cash discounts camned, workroom costs of $100, and no inward freight. Determine the total cost of the merchandise (10pts) 5. A sporting goods buyer placed the following order: . 18 nylon backpacks costing $22 each. + 12 two person tents costing $54 each .6 camp stoves costing $55 each Shipping costs paid by the store were $60, and a cash discount of 1% was taken (20pts) 6. What amount should be paid to the vendor for the merchandise listed below? (20pts) UNITS ITEM UNIT Price 18 Billfold $25.00 each 6 Glasses case $15.00 each 121 French purse $30.00 each Key case $12.50 each They buyer qualifies for the 3 % discount and is also responsible for transportation charges of $13.84. 7. A shoe buyer purchased 48 sneakers with a wholesale cost of $50 each. The buyer is offered a 2% discount and shipping charges are $68. (10pts)