I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.


It might be possible to help if you provided sample data and expected results.

The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the answer
of 5.

"Glenn" wrote:

Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.


It might be possible to help if you provided sample data and expected results.

How did you come up with 5 as the answer?


Gizmo wrote:
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the answer
of 5.

"Glenn" wrote:

Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected results.

Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15*pm, Glenn wrote:
How did you come up with 5 as the answer?

No, my clock is fine. The message below was sent at 9:15 am local time, and
that's how it shows up in my newsreader. This one is being sent at about 10:05 am.

Pete_UK wrote:
Glenn, I think your system clock is an hour out.

Pete

On Apr 28, 4:15 pm, Glenn wrote:
How did you come up with 5 as the answer?

Can you explain how you get an answer of 5 ?

Do you really mean highest common factors ? If so, what about other
factors ?

Take a look he

http://www.helpwithfractions.com/lea...nominator.html

Hope this helps.

Pete

On Apr 28, 3:03*pm, Gizmo wrote:
The numbers I am working with are 3,000,0000 and 4,800,000. *I know the
answer is 5. *I need to come up with a formula that will give me the answer
of 5.



"Glenn" wrote:
Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected results.- Hide quoted text -

- Show quoted text -

I am currently enrolled in a cost accounting class. Our last excel problem
is that we have been given a solution page for an projected income statement
and there are 2 items that the company sells.

Regular Sander Mini-sander Total
Sales $3,000,000 $1,800,000 $4,800,000
Less VE $1,800,000 $900,000 $2,700,000
CM $1,200,000 $900,000 $2,100,000
- DFE $3000,000 $450,000 $750,000
ProdMrg $900,000 $450,000 $1,350,000
Less: Common fixed expenses $600,000
Operating Income $750,000

Units sold 75,000 30,000

Unit sales price $40 $60
Unit variable expenses $24 $30
Unit combination margin $16 $30
Sales mix 5 2
Package unit contribution margin $80 $60 $140

Break-even units 48215 19286

Break-even proof
Regular Sander Mini-sander Total
Sales $1,928,571 $1,157,143 $3,085,714
Less: Variable expenses $1,157,143 $578,571 $1,735,714
Contribution margin $771,429 $578,571 $1,350,000
Less: Direct fixed expenses $300,000 $450,000 $750,000
Product margin $471,429 $128,571 $600,000
Less: Common fixed expenses $600,000
Operating Income $0

"Pete_UK" wrote:

Can you explain how you get an answer of 5 ?

Do you really mean highest common factors ? If so, what about other
factors ?

Take a look he

http://www.helpwithfractions.com/lea...nominator.html

Hope this helps.

Pete

On Apr 28, 3:03 pm, Gizmo wrote:
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the answer
of 5.



"Glenn" wrote:
Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected results.- Hide quoted text -

- Show quoted text -

I tried to post the spreadsheet that I am looking at, but as you can see it
did not come out well.

"Gizmo" wrote:


"Pete_UK" wrote:

Can you explain how you get an answer of 5 ?

Do you really mean highest common factors ? If so, what about other
factors ?

Take a look he

http://www.helpwithfractions.com/lea...nominator.html

Hope this helps.

Pete

On Apr 28, 3:03 pm, Gizmo wrote:
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the answer
of 5.



"Glenn" wrote:
Gizmo wrote:
I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected results.- Hide quoted text -

- Show quoted text -

The only place that you've got 5 in that collection of numbers is where you
have apparently divided your "units sold" figure of 75000 by the highest
common factor of 75000 and 30000. The 2 in the adjacent column presumably
comes from similarly dividing 30000 by that same highest common factor.
The function for highest common factor is GCD.

3000000 and 1800000 do not come into that calculation, as they are the
result of multiplying the units sold by the unit sales price.
--
David Biddulph

"Gizmo" wrote in message
...
I am currently enrolled in a cost accounting class. Our last excel problem
is that we have been given a solution page for an projected income
statement
and there are 2 items that the company sells.

Regular Sander Mini-sander Total
Sales $3,000,000 $1,800,000 $4,800,000
Less VE $1,800,000 $900,000 $2,700,000
CM $1,200,000 $900,000 $2,100,000
- DFE $3000,000 $450,000 $750,000
ProdMrg $900,000 $450,000 $1,350,000
Less: Common fixed expenses $600,000
Operating Income $750,000

Units sold 75,000 30,000

Unit sales price $40 $60
Unit variable expenses $24 $30
Unit combination margin $16 $30
Sales mix 5 2
Package unit contribution margin $80 $60 $140

Break-even units 48215 19286

Break-even proof
Regular Sander Mini-sander Total
Sales $1,928,571 $1,157,143 $3,085,714
Less: Variable expenses $1,157,143 $578,571 $1,735,714
Contribution margin $771,429 $578,571 $1,350,000
Less: Direct fixed expenses $300,000 $450,000 $750,000
Product margin $471,429 $128,571 $600,000
Less: Common fixed expenses $600,000
Operating Income $0

"Pete_UK" wrote:

Can you explain how you get an answer of 5 ?

Do you really mean highest common factors ? If so, what about other
factors ?

Take a look he

http://www.helpwithfractions.com/lea...nominator.html

Hope this helps.

Pete

On Apr 28, 3:03 pm, Gizmo wrote:
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the
answer
of 5.



"Glenn" wrote:
Gizmo wrote:
I am trying to find a formula that will give me the least common
denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected
results.- Hide quoted text -

- Show quoted text -

The least common denominator of those numbers is in fact not 5, but
24000000. =LCM(A1,A2)
If you wanted the highest common factor it would be 600000. =GCD(A1,A2)
--
David Biddulph

"Gizmo" wrote in message
...
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the
answer
of 5.

"Glenn" wrote:

Gizmo wrote:
I am trying to find a formula that will give me the least common
denominator
for doing a cost account spreadsheet with sales mix.


It might be possible to help if you provided sample data and expected
results.

Actually, that would "Least Common Multiple" and "Greatest Common Divisor".


David Biddulph wrote:
The least common denominator of those numbers is in fact not 5, but
24000000. =LCM(A1,A2)
If you wanted the highest common factor it would be 600000. =GCD(A1,A2)
--
David Biddulph

"Gizmo" wrote in message
...
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the
answer
of 5.

"Glenn" wrote:

Gizmo wrote:
I am trying to find a formula that will give me the least common
denominator
for doing a cost account spreadsheet with sales mix.

It might be possible to help if you provided sample data and expected
results.

Hi Gizmo,

The easiest way to do that is with xlpREDUCEFRACTION():

http://precisioncalc.com/xlpREDUCEFRACTION.html

BTW, xlpREDUCEFRACTION is not limited to Excel's 15 significant
digits. It can reduce fractions where the numerator and/or denominator
have as many as 32,767 significant digits.

xlpREDUCEFRACTION can also simplify fractions even where
simplification would not be a reduction, if desired (set the
always_simplify argument to TRUE). For example:

xlpREDUCEFRACTION(2.6,10,,TRUE)

Returns:

13/50


You'll need to download and install the Free Edition of xlPrecision:
(it never expires)

http://precisioncalc.com/xlprecision.html


Thanks,

Greg Lovern

http://PrecisionCalc.com
More Power In Excel



On Apr 28, 6:12*am, Gizmo wrote:
I am trying tofinda formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.