valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1

Browse All Question and Answer Items

Items selected where Item is 10908

Questions & Answers

Q: I may not always need 5 columns - problems entering zeros.

A: Profit Contribution Breakdown Excel is designed for 5 segments (Products and Customers). If you have less than five you can either divide your existing segments into 2 (or more) resulting in multiple segments with the same values (ie duplicates). Alternatively for the not required Product or Customer segment set the Segment Revenue and Transaction data to very low numbers and the relative indicators and potential and ability values to 0 except a single fixed cost relative indicator (usually Other) which is used to add a cost equal to the revenue of the segment (so the comparative values are valid). For example in the product segment for a Revenue of 1 we need a Fixed cost of 1 for 0 profit. This is done by setting the Fixed Cost Other to 1 in the Overall performance data sheet and allocating all of this to the empty product segment by setting the empty Product segment relative indicator to 100 and all other segment relative indicators to 0 for the Fixed cost Other. In the attached file I have set the Customer segment 4 and Product segment 4 in this manner for your reference.

Question and Answer Item 10908 - Browse All Question and Answer Items