valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Question includes Pricing or Answer includes Pricing
<< < Page 1 2 3 4 5 6 7 8 9 10 > >>
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
Q: I tried to add a worksheet to my breakeven workbook and was not able to do so. Alternatively, I tried to copy my column of data for variable costs onto the data input sheet, but doing so was prevented by a password. Would unprotecting the data entry sheet or entering a new worksheet cause any problems? I'd like to save my data in the same file as the one where its analysis occurs.
A: No problems, attached is a modified Pricing and Breakeven Analysis Excel which includes an added Unprotected worksheet at the end of the workbook. You can add anything you like in this sheet and link directly to the inputs as required.
Question and Answer Item 56 - Browse All Question and Answer Items
Q: I am having a problem with determining which figures to use for a Break-Even Analysis in a non-profit organization. Fixed and Variable costs are not a problem. We need to figure out whether we should provide equipment services, or continue contracting the service out, and where the break-even point is. All of our costs are calculated on a per-patient-day basis. We bill only one amount to insurance or Medicare which is a per-patient-day figure. This covers all services, drugs, nursing, physicians, etc. Does anyone have any idea how to solve this problem?
A: Try calculating the break-even point for the service when you deliver it, to do this you will need to determine/apportion the component of your fee that relates to this service and apply the variable and fixed costs. If the contract fee is less than your breakeven then you should contract it out, if not do it in house. The Profit Contribution Breakdown https://bizpep.com/profitcontribution.html may be of interest as well as the Pricing and Breakeven Analysis https://bizpep.com/pricebreakevenanalysis.html .
Question and Answer Item 57 - Browse All Question and Answer Items
Q: I found your site online and wondered if you have an Excel spreadsheet "break even" report designed for hotels?
A: Our Pricing and Breakeven Analysis software is designed to suit all businesses. It is suitable for break even analysis of hotels. You can access further details and download from https://bizpep.com/pricebreakevenanalysis.html .
Question and Answer Item 58 - Browse All Question and Answer Items
Q: Several years ago I purchased your Pricing and Breakeven Analysis product. I'm very happy with it. I want to put it on a new Mac that I purchased. In trying to open the spreadsheet on the Mac, it says the spreadsheet is locked up and cannot be opened. There seem to be some passwords to prevent the formulas from being broken. That has not been a problem on the PC, but it is on the Mac. Can you please provide whatever info I need so my formulas are not locked down with some password, so I can use the product on my Mac?
A: The protection is in place to prevent formula being overwritten and is the same when run on Excel. All inputs are in non protected cells so the protection should not be an issue. The software is designed to run on Excel and with some Mac's it may not be fully compatible. If this is the case you could try our browser based Business Analysis software https://bizpep.com/businessanalysis.html . This is a web /browser based version of our software that will run directly in your browser. It includes Pricing and Breakeven Analysis.
Question and Answer Item 2058361 - Browse All Question and Answer Items