Does the answer in 3 differ if the sales are totaled
4. Does the answer in 3 differ if the sales are totaled and then
the commission calculated instead of a commission earned on each
sale? If so, how much for each salesperson?
Â
5. Construct a pivot table to show how many total units were
sold in the three districts by each of the salespeople.
Â
6. Management is considering offering a bonus for sales made
into Sales Disctrict 3. How much would it cost the company if they
offered an additional 17% commission on the sales made in District
3?
Â
7. Create a chart to show management what percentage of the
Gross Sales wasAfA?Ac€A! Expenses, what part Commission and
what part profit for MIS INC?
Answers
Status NEW
Posted 02 May 2017 11:05 AM
My Price 15.00
-----------
Attachments
file 1493725929-471329_1_636292579037949186_Answer---Excel-Help.xlsx preview (310 words )
MI-----------S I-----------NC ------------ S-----------ale-----------s D-----------ata----------- fo-----------r W-----------idg-----------ets-----------Dis-----------tri-----------ctU-----------nit-----------sGr-----------oss-----------Exp-----------ens-----------esS-----------mit-----------hJo-----------nes-----------Pet-----------ers-----------onA-----------lbe-----------rtA-----------ver-----------age----------- sa-----------le -----------pri-----------ceA-----------nsw-----------er -----------Q1 -----------Sal-----------esp-----------ers-----------onP-----------rof-----------itR-----------ow -----------Lab-----------els-----------Gra-----------nd -----------Tot-----------alS-----------um -----------of -----------Uni-----------tsS-----------um -----------of -----------Gro-----------ssS-----------um -----------of -----------Exp-----------ens-----------esS-----------um -----------of -----------Pro-----------fit-----------2. -----------Whi-----------ch -----------sal-----------esp-----------ers-----------on -----------has----------- cr-----------eat-----------ed -----------the----------- mo-----------st -----------pro-----------fit----------- fo-----------r M-----------IS -----------INC-----------? A-----------nsw-----------er -----------:Fr-----------om -----------bel-----------ow -----------piv-----------ot -----------tab-----------le -----------we -----------obs-----------erv-----------e P-----------ete-----------rso-----------n h-----------as -----------cre-----------ate-----------d m-----------ost----------- pr-----------ofi-----------t.1-----------. W-----------hat----------- is----------- th-----------e a-----------ver-----------age----------- sa-----------les----------- pr-----------ice----------- fo-----------r a----------- wi-----------dge-----------t?C-----------omm-----------iss-----------ion----------- 33-----------%4.----------- Do-----------es -----------the----------- an-----------swe-----------r i-----------n 3----------- di-----------ffe-----------r
Not Rated(0)