Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When planning a start-up, whats wrong when I get a calculation error message saying that “the sub-models are not producing identical results”?

April 26, 2017calculation Error identical message planning producing start-up sub-models wrong

0

Posted

When planning a start-up, whats wrong when I get a calculation error message saying that “the sub-models are not producing identical results”?

1 Answer

0

Posted

Not applicable to Exl-Plan releases 1.2 or higher – to check release, select *Exl-Plan Help | About Exl-Plan … This may happen when you project monthly direct costs in Monthly Assumption Report No. 3 but have zero monthly sales corresponding to these costs. This becomes very apparent in the quarterly reports and Exl-Plan’s error trapping and CHECK report will signify a problem. The simple solution is to transfer any monthly direct costs for which there are no corresponding monthly sales into monthly overhead costs in Monthly Assumption Report No. 4. In other words, only show monthly costs as being “direct” for months in which sales are being projected.