Question

83 84 85 69.99 39.19 41.18 23.36 8055 8056 8057 8058 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/13/23 10/13/23 10/13/23 10/13/23 10/13/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/11/22 8059 8059 8059 8060 8061 8061 8062 8063 8063 8063 8064 8065 8065 8066 8067 8068 8068 8068 8069 8070 8071 8072 8072 8072 8073 8074 8075 8075 8075 8076 8077 8078 3091 PED-TER 3034 PED-FCS 3020 WHL-TGT 3041 COM-FCS 3015 PED-FCS 3015 FLI-16M 3015 WHL-TMX 3049 WHL-TGT 3050 COM-FCS 3050 PED-T3A 3076 FLI-16H 3036 FLI-16H 3036 FLI-STX 3036 WHL-T30 3025 COM-FCS 3081 PED-TPR 3081 WHL-T30 3093 FLI-TMX 3037 WHL-TGT 3087 FLI-STX 3087 FLI-H04 3087 PCG-HOW 3090 FLI-H01 3025 PED-TER 3096 WHL-T3P 3095 PED-T3A 3095 FLI-TMX 3095 WHL-T30 3060 PCG-HOW 3027 FLI-H04 3095 PED-FER 3095 FLI-THR 3095 FLI-HO4 3065 COM-FCS 3043 FLI-16M 3080 FLI-HO1 3080 FLI-16M 3063 FLI-USB 3031 PED-T3A 3031 PCG-HOW 3014 PED-FER 2014 ILUSR TFRP Rudder T16000M FC T-GT Racing T16000M FC T16000M FC T 16000M SF TMX Pro Rac T-GT Racing T16000M FC T3PA Add-Or T1600M FCS T1600M FCS T-Flight Stich T300RS Offic T16000M FC TPR Pedals - T300RS Offic TMX Force F T-GT Racing T-Flight Stich T-Flight Hota Hotas Warth T-Flight Hota TFRP Rudder T300RS Raci T3PA Add-Or TMX Force F T300RS Offic Hotas Warth T-Flight Hota Ferrari Racin TWCS Thrott T-Flight Hota T16000M FC T 16000M SE T-Flight Hota T 16000M SE USB Joystick T3PA Add-Or Hotas Warth Ferrari Racin TSR Lovetick 614.91 172.35 39.19 117.83 249.99 614.91 172.35 69.99 97.3 97.3 39.99 319.99 172.35 497.38 319.99 159.84 614.91 39.99 34.65 462.81 59.99 69.99 426.41 69.99 159.84 319.99 462.81 34.65 79.99 59.99 34.65 172.35 117.83 59.99 117.83 21.99 69.99 462.81 79.99 2199 354.66 89.15 23.36 69.36 147.62 354.66 89.15 36.4 52.53 52.53 21.04 170.61 89.15 284.93 170.61 87.3 354.66 21.04 19.76 232.13 30.17 41.18 231.54 36.4 87.3 170.61 232.13 19.76 43.51 35.18 19.76 89.15 69.36 30.17 69.36 12.06 36.4 232.13 43.51 12.06 111 112 113 114 115 116 117 118 119 120 121 122 123 120 8078 8079 8080 8080 8081 eng1

Answer 1

1)

Option B - 3008

Gross margin = Sales price - Cost = 34.65 - 19.76 = 14.89 or 15

2)

Option C - 137

There are total 4 transactions with customer 3080

Total Sales Price = 117.83 + 21.99 + 59.99 + 117.83 = 317.64

Total Cost = 69.36 + 12.06 + 30.17 + 69.36 = 180.95

Total Gross margin = Total Sales price - Total cost

= 317.64 - 180.95 = 136.69 or 137

3)

Option D - 15

If we swap sales price with gross margin, then 14.89 is new sales price. Rounded off to 15

4)

Option D - 3013

There are total 8 transactions done with customer 3013

Total of such sales are 79.99 + 497.38 + 426.41 + 79.99 + 614.91 + 249.99 + 97.3 + 497.48

= 2543

5)

Option C - WHL-TGT

Total transactions for SKU WHL-TGT are 15 and each transaction is for 614.91

Total Sales = 614.91 x 15 = 9223.65 or 9,224