Maximo Open Forum

We use maximo to track sign fabrication orders, installation, & raw materials used to create the signs.  I would like to add a billing report to the mix.   Just about every sign has size and color variables.  Would like to reduce the total number of items to reduce the number of pricing updates needed. 

For example.   a down right arrow sign could be in 4 sizes and 4 different colors 2 Different Grade of film.  Currently that item would need 32 items in items master in order to have it bill report come up accurately.

Is there a way i could automate the raw materials also.   As to only have to update my raw material pricing instead of all the item master variables separately.

Current method is to manually enter everything.

Spreadsheet is easy,  

metal size + base vinyl type of same size as metal + Legend vinyl type of same size as metal + labor time = cost  ( all costs based on raw material entry)

Maximo would have me do all the math and input it for every line item.  Id like to only update the pricing of the raw materials like the spreadsheet. and let maximo do the rest incorporated in the order tracking instead of a separate entry point..