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 evaluating your Excel workbook to calculate break-even values and optimal price (workbook name: Pricing and Breakeven Analysis 21.xls) and I'm confused by your calculations of variable cost. In your documentation it states that the variable cost is 69% of the revenue; but this percentage seems to change when you increase or decrease the average price and this percentage is also different in the calculation of the optimal price. How are you calculating the variable cost under those different scenarios?

A: The 69% is simply the example applied in the software. The variable cost is an input ie you input the value of variable costs for your business (you can obtan this from your P&L or on a unit sales basis).These costs include materials, production, distribution, and transaction costs etc. The variable cost percentage is simply this number as a percentage of the revenue ie in the example 69% is 345,000 / 500,000 (variable cost / business revenue). As you change the price and/or units sold then the revenue will vary (revenue = price * units sold) and so may the variable cost percentage. If the number of units sold changes then the variable cost in monetary terms will also change ie if each unit has a variable cost of \$10 and I sell 100 the variable cost is 1000 if I sell 80 it is 800.

Q: What password do I use if I want to delete the website information at the bottom of the spread sheet?

A: Input cells (blue) are not protected and are the only cells that should be changed for the software to function correctly. As outlined in the Terms and Conditions and Frequently Asked Questions page all non-input cells and Visual Basic code are protected to ensure integrity and protect source code. All input is via unprotected input cells, protected cells contain formula and should not be changed. The software is fully functional and the protection is in place to ensure the software formula and code is not corrupted. Bizpep retain full copyright and intellectual property rights at all times and the display of branding and web site information asserts copyright ownership and must not be removed.

Q: I just purchased the "Pricing and Breakeven Analysis" for Excel and the security level is set at high and I cannot enable the macros.

A: The security level is a setting in your Excel. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.Information on this is included in the FAQ Item at www.bizpep.com .

Q: I need full function access to the spreadsheet. I have paid for full access but the latest SW version does not allow me to enter a registration code.

A: To use the software macros must be enabled, without macros enabled you will not be able to input your registration details. Also some Mac systems do not support full macro functionality. To assist you I have attached a pre registered version of your software. Simply save it to your computer. If you are using a mac you can use the sheet tabs to access each sheet/page if the command buttons do not run.

Q: I need to un protect the workbook, what is the password?