Cost Sheet using Matrix Table or database for drop down options to calucate cost
Create a Cost Sheet using multiple Maxtric Table at each item, creating drop down options on the cost sheet.
The matrix can be updated regularly with updated cost.
Each item on the cost sheet will have a matrix
The cost sheet will then add up each item's cost at the bottom
There should be an open text field to add in special cost
There should be a total cost line, adding up all the costs
There should be a markup line to set markup price/suggested price
There should margin line to see profit margin
Margin, markup price should be auto calculated based on default % but it can also be input to recalculate based on cost
There should be option for multiple columns for cost comparison based on size and color option as those are the 2 know variables that affect cost.