Hello everyone, I am trying to build a table that gives profitability of about 10 different items. For ecample there are 10 different type of bikes, at different prices and margins. The table lists all the detail for the calculations by multipling price * margin at various levels of production-output weekly.

See example below, it is a simpler version of exactly what I am trying to do. Thanks ahead for any and all who help and respon!

Luke

profit model.PNG

model-macro.xlsx