Browse All Question and Answer Items

Items selected where Topic includes breakeven

<<   <   Page  1  2  3  4  5  6  7  8  9   >   >>

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.

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.

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 www.bizpeponline.com may be of interest as well as the Pricing and Breakeven Analysis www.bizpeponline.com .

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 www.bizpeponline.com .

<<   <   Page  1  2  3  4  5  6  7  8  9   >   >>

<