How to handle multiple markups

[rdemyan via AccessMonster.com]

My app contains data on projects. I've recently added functionality to allow
for markups on a base cost. The code currently applies any markup to the
base cost only. However, in reality, some markups are on top of the base
cost + other markups. I have about 10 markups that can be applied and users
may want to change the order in which the markups are applied. Plus there
may be multiple markups that go just against the base.

Here's an example:

Base Cost : $20,000
Taxes: 5% on Base Cost
Design: 10% on Base Cost
Project Management: 10% on (Base Cost + Taxes + Design)
Overhead and Profit: 15% on (Base Cost + Taxes + Design + Project Management)
Contingency: 5% on (Base Cost + Design)

This is just an example, but I think I've conveyed the problem. Plus each
client may want to do this differently.

I have a table that keeps the markups for each category.

I need suggestions on how to setup the logic. Should I use a table with
columns that are the markup names. Then the user would check a checkbox if
prior markups and the Base Cost are to be used for calculating the markup in
question.

Even if I can put such a table together, it will be tricky with the coding.
The markups will need to be calculated in order so that if the code gets to
Overhead and Profit logic, the taxes, design and project management markups
will already need to have been calculated.

Any ideas would be helpful. Thanks.

--
Message posted via http://www.accessmonster.com

[Kc-Mass]

How about if you give them a Form with their projects base cost on it.
Then give them a combobox hooked to your mark up table where
they can select, in the order of their choosing, the markups that will be
applied.

As they select them, you place those markups, both name of markup
and the markup in an array. maybe you also show the math on the form.

When they have picked all of their markups, you walk the array building
a string of the markup names in order and also the successive total cost .
Then show both in the form for their review acceptance. If they accept
store the data, both string (so you can reconstruct it) and value in a
table.

Kevin C

"rdemyan via AccessMonster.com" <u6836@uwewrote in message
news:67d0c9e5aa622@uwe...

My app contains data on projects. I've recently added functionality to
allow
for markups on a base cost. The code currently applies any markup to the
base cost only. However, in reality, some markups are on top of the base
cost + other markups. I have about 10 markups that can be applied and
users
may want to change the order in which the markups are applied. Plus there
may be multiple markups that go just against the base.

Here's an example:

Base Cost : $20,000
Taxes: 5% on Base Cost
Design: 10% on Base Cost
Project Management: 10% on (Base Cost + Taxes + Design)
Overhead and Profit: 15% on (Base Cost + Taxes + Design + Project
Management)
Contingency: 5% on (Base Cost + Design)

This is just an example, but I think I've conveyed the problem. Plus each
client may want to do this differently.

I have a table that keeps the markups for each category.

I need suggestions on how to setup the logic. Should I use a table with
columns that are the markup names. Then the user would check a checkbox
if
prior markups and the Base Cost are to be used for calculating the markup
in
question.

Even if I can put such a table together, it will be tricky with the
coding.
The markups will need to be calculated in order so that if the code gets
to
Overhead and Profit logic, the taxes, design and project management
markups
will already need to have been calculated.

Any ideas would be helpful. Thanks.

--
Message posted via http://www.accessmonster.com

[Kc-Mass]

You know as I think about this, aren't there business rules that a firm has
that defines how the markups are applied? Wouldn't a firm require
conformance with those rules and couldn't you then define a simple formula
to apply that?
"rdemyan via AccessMonster.com" <u6836@uwewrote in message
news:67d0c9e5aa622@uwe...

My app contains data on projects. I've recently added functionality to
allow
for markups on a base cost. The code currently applies any markup to the
base cost only. However, in reality, some markups are on top of the base
cost + other markups. I have about 10 markups that can be applied and
users
may want to change the order in which the markups are applied. Plus there
may be multiple markups that go just against the base.

Here's an example:

Base Cost : $20,000
Taxes: 5% on Base Cost
Design: 10% on Base Cost
Project Management: 10% on (Base Cost + Taxes + Design)
Overhead and Profit: 15% on (Base Cost + Taxes + Design + Project
Management)
Contingency: 5% on (Base Cost + Design)

This is just an example, but I think I've conveyed the problem. Plus each
client may want to do this differently.

I have a table that keeps the markups for each category.

I need suggestions on how to setup the logic. Should I use a table with
columns that are the markup names. Then the user would check a checkbox
if
prior markups and the Base Cost are to be used for calculating the markup
in
question.

Even if I can put such a table together, it will be tricky with the
coding.
The markups will need to be calculated in order so that if the code gets
to
Overhead and Profit logic, the taxes, design and project management
markups
will already need to have been calculated.

Any ideas would be helpful. Thanks.

--
Message posted via http://www.accessmonster.com

[rdemyan via AccessMonster.com]

Thanks for the reply KC.

Yes, their are business rules but these can be somewhat different between
firms.

I decided to take the easy way out. When a project is created, the code
assigns a default markup scheme to the project (including relationships)..
I've given users a form where they can modify the markups assigned to a
project and the relationship. So the design markup, for example, markups the
sum of base cost + taxes + procurement + bond + contingency, etc.

The issue as I noted is how to actually do the calculation since to calculate
the design markup I have to have the taxes markup, the procurement markup,
the contingency markup, etc. first. There are 12 markups so far, so what I
did was to create a subroutine. I call the subroutine for each markup one at
a time. I then iterate through this entire thing 15 times. As the
iterations proceed, markups that were missing previously in the subroutine
(these would have been zero) now have a value, so the markup that is
currently being calculated is adjusted. Once all markups have been
determined, the calculated markup remains stable.

I've tested it and this simple solution seems to work.

Kc-Mass wrote:

>You know as I think about this, aren't there business rules that a firm has
that defines how the markups are applied? Wouldn't a firm require
conformance with those rules and couldn't you then define a simple formula
to apply that?

>My app contains data on projects. I've recently added functionality to
allow

[quoted text clipped - 36 lines]

>>
Any ideas would be helpful. Thanks.

--
Message posted via http://www.accessmonster.com