valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 55
Questions & Answers
Q: I'm using the trial version of the Pricing and Breakeven Analysis Excel 21 spreadsheet. In my industry our average price per unit is around $0.25-$0.27 per pound. In your spreadsheet the Price in the Current Operating Performance Data displays a "0" instead of 0.25 or 0.27. How can I get the spreadsheet to displace decimals so that I can see my values?
A: Use a unit that has no decimal places ie 1 unit is 100 items in this case input 25 or 27 and the result will be based on 100 units. Another way of looking at it is as using pence (cents) as the base input ie input 25 or 27 and the result is in pence. Please note thast all input and output must be of the same type so if you input 25 or 27 as pence then revenue / costs must also be in pence ie 1000000 pounds becomes 10000000 pence to display results for single units in pence.
Question and Answer Item 55 - Browse All Question and Answer Items