Margin and Multiplier Help

[tomthumb_KTM]

Working on a project where I have multiple columns that have cost, sale, and margin then multiplier with cost, sale, and margin. Both before and after the multiplier the margin is the same. However, when I sum the totals, then check the margins they are different before and after the multiplier.

I am unable to load a mini sheet just the pic. My work computer is locked down by the IT department and I am unable to get the mini sheet software to work. So, I can only load a pic and I am hopeful someone can help.

Thanks!

 

[Scott Huish]

I don't know if I can help, but when you click on that picture, it's so tiny, it's unreadable. Perhaps you can just copy and paste from your spreadsheet to here.

 

[tomthumb_KTM]

Hopefully this is a better pic.

 

[tomthumb_KTM]

Totals

Cost

30,554.49​

23,421.70​

58,453.10​

21,615.87​

343,452.98​

441,601.49​

541,562.81​

442,314.25​

537,828.86​

467,147.10​

2,907,952.65​

Cost

Sell

42,120.61​

33,452.05​

77,211.03​

30,608.56​

435,278.32​

544,653.09​

667,671.12​

545,743.77​

662,915.12​

577,602.21​

3,617,255.88​

Sell

Margin

0.275​

0.300​

0.243​

0.294​

0.211​

0.189​

0.189​

0.190​

0.189​

0.191​

0.196​

Margin

Multiplier

30.00​

32.00​

19.00​

14.00​

1.00​

6.00​

1.00​

3.00​

1.00​

1.00​

Multiplier

Sum Cost

916,634.70​

749,494.40​

1,110,608.90​

302,622.18​

343,452.98​

2,649,608.94​

541,562.81​

1,326,942.75​

537,828.86​

467,147.10​

8,945,903.62​

Total Cost

Sum Sell

1,263,618.30​

1,070,465.60​

1,467,009.57​

428,519.84​

435,278.32​

3,267,918.54​

667,671.12​

1,637,231.31​

662,915.12​

577,602.21​

11,478,229.93​

Total Sell

Margin

0.275​

0.300​

0.243​

0.294​

0.211​

0.189​

0.189​

0.190​

0.189​

0.191​

0.221​

Margin

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)