F6 ! . B D G M N Q R 1 Get in the habbit of selecting entire columns of data rather than specific ranges of rows. A small after-market discount store maintains an invenotry of items in the list below. Please compose formulas to complete each row of the inventory table. (You will also need to add a formula to calculate some summary values to the right of the table.) Specific instructions for each column are included as comments on the labels indicated by the small red triangle markers in the upper-right of those cells). Monetary values should be formatted as currency or accounting, and percentages should be formatted as percentages. (Percent of total inventory value should show two decimal places; the other should not show any decimal places.) 3 WHOLESALE VALUE OF INVENTORY PERCENT OF TOTAL INVENTORY VALUE ISRP LARKUP AIOUNT ISRP LARKUP PERCENTAGE DISCOUNTED PRICE SALES PROFIT PER UNIT TARKUP PERCENTAGE SALES TAX PER FINAL COST PER UNIT (INCLUDING CUSTOLER'S The little red triangles in the upper- right corners of cells indicate that there is a "Coment" that can be viewed by moving your cursor over the cell. ITNO STOCK $225.00 STANDARD DISCOUNT 46% SALES TAX RATE: 6.00% TOTAL WHOLESALE VALUE OF EVERYTHING IN INVENTORY: AVERAGE MSRP MARKUP PERCENTAGE: HUBER OF THOLESALE COST ISRP PER UNITS IN 4 ITEI SKU# PER UNIT UNIT 5 SY-570B $9.00 $22.00 25 6 XT-6206U $11.00 $27.00 23 7 IE-7244B $24.70 $45.80 14 8 RG-8125T $23.40 $68.90 17 9 HQ-9173X $24.90 $60.60 15 10 VZ-10179 $7.20 $8.70 14 11 MH-1192D $18.90 $49.20 25 22 12 EN-12540 $22.30 $51.40 19 13 GL-13159N $22.80 $43.00 14 KQ-1451R $5.60 $8.70 24 15 DN-15214A $18.40 $37.10 16 YN-16244B $23.10 $46.70 12 17 VL-17159M $10.60 $22.10 21 18 00-1885H $9.60 $24.601 19 DA-192020 $22.10 $36.00 14 20 WX-20200R $14.30 $22.60 15 21 RG-211010 $21.90 $49.70 5 22 OT-222012 $8.20 $16.00 23 23 ID-23187A $20.00 $32.40 22 24 VX-24129D $13.20 $40.80 25 KH-25216R $11.30 $24.70 6 26 CE-26226F $21.00 $55.00 14 27 SW-271817 $37.00 4 28 LJ-28250W $18.10 $33.10 24 29 CE-29107E $17.20 $26.90 30 XU-30229R $6.90 $12.90 21 31 TE-31185Y $20.601 $50.40 24 AVERAGE EFFECTIVE MARKUP PERCENTAGE: $18.30