S.O.S. Mathematics CyberBoard

Your Resource for mathematics help on the web!
 It is currently Tue, 21 May 2013 14:29:20 UTC

 All times are UTC [ DST ]

 Page 1 of 1 [ 3 posts ]
 Print view Previous topic | Next topic
Author Message
 Post subject: Calculating contribution of increase/decreasing in %profitPosted: Sat, 5 Nov 2011 15:47:13 UTC
 S.O.S. Newbie

Joined: Sat, 5 Nov 2011 15:03:41 UTC
Posts: 2
I'm trying to find which product actually make total profit margin increase from Aug to Sep, and to what percentage it make the total
profit margin increase.

Code:
Aug                    Sep
Product   Sales       Profit   % Profit        Sales   Profit   % Profit
A              7          5         80%             7      6      81%
B              298        -10       -3%            298    -10      -3%
C              995        54        5%           1,003     53       5%
D              1,968      42        2%           2,149     75       3%
E              2,602      555       21%           2,885    650      23%
F              41          2         5%            41      2       4%
G              1,050      242       23%           1,241    254      20%
Total          6,961      890       13%           7,623   1,029      14%

What I did is that I divided each profit of each product with total sals and find the differences between Aug and Sep as shown below.
The product that has highest differences should be the product that causes the increase. So I conclude that the total profit margin
increase because of product E (0.6% difference). But this is because product E got 95.7 profit increase from Aug to Sep.

Code:
Product        Aug     Sep      Dif(%)  Diff (Profit Aug-Sep)
A               0%       0%      0.0%       0.1
B               0%       0%      0.0%      -0.1
C               1%       1%      -0.1%     -1.2
D               1%       1%      0.4%      32.9
E               8%       9%      0.6%      95.7
F               0%       0%      0.0%      -0.6
G               3%       3%      -0.1%    -11.9
Total           13%      14%      0.7%

However, as I change sales of product E from 2602 to 1700 as following (which cause profit margin in Aug to increase to 15%), I
dont think my calculation can be applied in this example. Please see below.

Code:
Product   Sales       Profit   % Profit        Sales   Profit   % Profit
A              7          5         80%             7      6      81%
B              298        -10       -3%            298    -10      -3%
C              995        54        5%           1,003     53       5%
D              1,968      42        2%           2,149     75       3%
E              1,700      555       33%           2,885    650      23%
F              41          2         5%            41      2       4%
G              1,050      242       23%           1,241    254      20%
Total          6,059      890       15%           7,623   1,029      14%

If I use the same strategy as previous example, the the decrease in profit margin should come from product G (-0.7% difference).

Code:
Product        Aug     Sep      Dif(%)  Diff (Profit Aug-Sep)
A              0%       0%      0.0%      0.1
B               0%      0%      0.0%     -0.1
C               1%      1%     -0.2%     -1.2
D               1%      1%      0.3%     32.9
E               9%      9%      -0.6%     95.7
F               0%      0%      0.0%     -0.5
G               4%      3%      -0.7%     11.9
Total          15%     14%      -1.2%

Top

 Post subject: Re: Calculating contribution of increase/decreasing in %profPosted: Sat, 5 Nov 2011 18:53:30 UTC
 Member of the 'S.O.S. Math' Hall of Fame

Joined: Sun, 24 Jul 2005 20:12:39 UTC
Posts: 3690
Location: Ottawa Ontario
Well, if you're a salesman, take it to a financial analyst...

What you're displaying seems to be "some analysis" intended
for a meeting; will be looked at, then forgotten about forever

> Total 15% 14% -1.2%
You can always make it look more inpressive by baptizing that -1.2%
"Monthly Sales Factor", then refer to it as : "this month's MSF"

I knowwwwwwww...used to pull such deviousities,
like getting an obscure calculation for the average
turnover of (as example) mortgages, and calling it "The Maturial Factor" ....
At meetings, NOBODY dared questionning it

_________________
I'm not prejudiced...I hate everybody equally!

Top

 Post subject: Re: Calculating contribution of increase/decreasing in %profPosted: Sat, 5 Nov 2011 19:12:38 UTC
 S.O.S. Newbie

Joined: Sat, 5 Nov 2011 15:03:41 UTC
Posts: 2
Hi Denis,

Well, I'm neither salesman nor a financial analyst. I did this intented for my business. This analysis is quite important for my work. I really hope someone could really answer this math.

Top

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 3 posts ]

 All times are UTC [ DST ]

Who is online

Users browsing this forum: No registered users

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forum

Search for:
 Jump to:  Select a forum ------------------ High School and College Mathematics    Algebra    Geometry and Trigonometry    Calculus    Matrix Algebra    Differential Equations    Probability and Statistics    Proposed Problems Applications    Physics, Chemistry, Engineering, etc.    Computer Science    Math for Business and Economics Advanced Mathematics    Foundations    Algebra and Number Theory    Analysis and Topology    Applied Mathematics    Other Topics in Advanced Mathematics Other Topics    Administrator Announcements    Comments and Suggestions for S.O.S. Math    Posting Math Formulas with LaTeX    Miscellaneous
Privacy Statement | Search the "old" CyberBoard

users online during the last hour