The COGS volume allocation lookup table and associated drop down menue includes all of the volume categories but not the total volume? How do I include the total volume in the lookup table and thus the drop down menu so total volume can be used as a COGS driver?
Adding a category to the Lookup Table only adds a new volume category across the entire model.
Thanks,
Ryan
Hi Ryan - which COGS module are you using? Is it the Cost of Goods Sold (Unit Costs, Volumes, Links In) module? And if so which time series?
Either way, you should be able to do this by customizing the existing module as follows:
You can see an example of where this is been done for revenue linking into debtors by downloading the following Debtors (Debtor Days) module:
www.modano.com/content/libraries/modano/modules/debtors-debtor_days-a-us
If this doesn't make sense, perhaps export the COGS module from your workbook (Modano tab, Module menu, Export to File menu item) and upload it (as a module/*.modm) file to this thread and I'll have a crack at it for you.
Michael, thanks for the reply. I am using the COGS (Unit Costs, Volumes, Links In) module, monthly time series.
I was able to get total volumes working with your help.
Ryan