PROBLEM: We are trying to determine a retail price for each piece/part of a board game without knowing the cost of each individual piece/part and only knowing the cost of the game as a whole.
THE SOLUTION: We need a formula or algorithm (built in either excel or stand-alone program) that we can input the known variables and get an approximate value of what a piece might be worth based on the information we provide.
The variables we know for sure:
1.) (COST) Our cost of the game as a whole
2.) (TOTAL COUNT)The total count of the pieces/parts
3.) (INDIVIDUAL COUNT)The count of each individual piece (example: there is only 1 red car in this game OR there is exactly 5 blue ships in this game)
A variable that is subjective:
1.) (QUALITY)The quality of the piece (Pieces come in all shapes and sizes. Some are made of cheap plastic and some are made of more expensive materials like wood or metal). This variable is highly subjective and can only be judged in relation to all other pieces. We know for sure that a large high-quality metal figure costs more than a small cheap plastic figure. Somehow, someway we need to be able to account for this difference.
There also may be more variables that we haven't thought of.
Normally the formula for price/piece would be (COST/TOTAL COUNT). This formula simply divides the total cost by the number of pieces/parts. However, this formula quickly breaks down when you try to reason that a single dice is worth the same amount as the game board itself. It just doesn’t work. We need a much more sophisticated formula to help us determine the retail price of our pieces.
IMPORTANT: Please keep in mind that we will need the price of each piece for a game. Each piece's value may also influence other piece's values. For instance, if the game has a board included then the board will be the most expensive part in the game. It will bear a large portion of the "cost" of the game. The other pieces will need to make up the rest of the cost of the game.
I’m not sure how well I’ve done in explaining the problem that we have and what we need. If you have any questions please let me know.