Hi, I have just upgraded to FMP 10 in hopes that it will help me quickly solve an analytical problem
I have with my business. I produce and market hand saws. I have the usual five principal Input costs,
those of the raw materials - steel and wood (pine), the working of these materials, their packaging, their
distribution, and finally the product's promotion. The final wholesale or Internet sales price (Output) is
a constant I feel I must maintain.
Therefore, if the cost of any of the five Inputs increases, I will have to decrease the costs of the other Inputs
proportionally, or as I wish. I have been making these calculations manually, but I would like this to happen
automatically. Thus, when I make changes in one of the Input values, the other Input values will change
correspondingly, so that the resultant sum of the five Inputs will always equal the same unchanged Output value.
The five Inputs are related, but I have yet to find an "operator" which would change their values as described
above. From the literature I have seen, the script trigger OnObjectModifer in FMP 10 appears to be the key
function, but I have no idea how to use it, which steps I should take.
Could anyone help me? Many thanks, Gasser
If I take your post as written, I get:
Raw Materials + Manufacture + Packaging + Distribution + Promotion = Wholesale Price (output)
That appear to produce a gross profit of $0. Surely that can't be right?