Browse All Question and Answer Items

Items selected where Topic includes breakeven

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

Questions & Answers

Topic: Pricing and Breakeven Analysis Excel
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.

This Question and Answer Item relates to Pricing and Breakeven Analysis Excel from www.bizpeponline.com.

Browse Other Pricing and Breakeven Analysis Excel Items - Browse All Question and Answer Items

 

Topic: Pricing and Breakeven Analysis Excel
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.

This Question and Answer Item relates to Pricing and Breakeven Analysis Excel from www.bizpeponline.com.

Browse Other Pricing and Breakeven Analysis Excel Items - Browse All Question and Answer Items

 

Topic: Pricing and Breakeven Analysis Excel
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 .

This Question and Answer Item relates to Pricing and Breakeven Analysis Excel from www.bizpeponline.com.

Browse Other Pricing and Breakeven Analysis Excel Items - Browse All Question and Answer Items

 

Topic: Pricing and Breakeven Analysis Excel
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.

This Question and Answer Item relates to Pricing and Breakeven Analysis Excel from www.bizpeponline.com.

Browse Other Pricing and Breakeven Analysis Excel Items - Browse All Question and Answer Items

 

Topic: Pricing and Breakeven Analysis Excel
Q: I need to un protect the workbook, what is the password?

A: Input cells (blue) are not protected and these are the only cells you need access to. As outlined in the Terms and Conditions and Frequently Asked Questions page all non-input cells and Visual Basic code are protected to ensure formula integrity and protect source code. You do not need to unprotect any cells. The software is fully functional and the protection is in place to ensure the software code is not corrupted. We do offer Commercial licenses for the use of software for inter-business support, advice, or consulting and upon request with a Commercial license can provide an unprotected software version allowing you to view the formula applied to enhance your knowledge of software operation (macros remain protected). Our standard Non-Commercial license is for private and internal business use only. You can upgrade from a Non-Commercial license to a Commercial license at www.bizpep.com . Please note that Bizpep retain full copyright and intellectual property rights at all times. Please refer to the FAQ topic at www.bizpep.com .

This Question and Answer Item relates to Pricing and Breakeven Analysis Excel from www.bizpeponline.com.

Browse Other Pricing and Breakeven Analysis Excel Items - Browse All Question and Answer Items

 

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

bizpep
<
buy
email
search
I am very impressed with the functionality of your Business Valuation Model, the lay out and the user friendliness. Your purchasing and registration procedure is also excellent.Robert de Rooy ... thank you for a brilliant and easy to use tax system, you have literally saved me hours and hours of work with simple clicks and drag from my accounting software to BAS-I.C my bas is done.Lisa Groundwater Thank you for this great software!Cedric Franklin This is the best model I have seen in a few decades.Darren Stevenson ...a resounding '1' for excellence. I am pleased with the performance of the software, the ease of use and the overall service. I am glad that I went ahead and ordered it. I plan to make heavy use of it during the rest of my MBA program and in my work life. No doubt I will be purchasing other programs from you. You have what I need.Judy Bottita the software has really simplified my tax and therefore my life! Thanks so much!Gail Tagarro Thanks very much for putting the BAS-I-C software 'out there' - so far it seems terrific and perfect for what I need.Chris Hargreaves I just down loaded the excel version...awesome....thanks so muchEdward M. Rouse great model for small biz and start up!Russell Smith I have my own accounting firm and I must admit that I am very impressed ... IT IS OUTSTANDING.Robert B. Wester, Jr Excellent software program. I have already referred several folks to your site to download the demo. Hopefully, they will turn into sales for you. Good Luck!Anthony Beebe Wow...you're good. Thanks for your help...and the rapid response was greatly appreciated. I think you have a great product; I've been doing 'if/then' scenarios on future options for my company, and it is quite fascinating using your program...You guys were great...exactly what I was looking for...I was very impressed with your customer service...great follow-up and execution. The software is easy to use, as was your web site. Thanks for your software; if I need any business software, I would be happy to look at you guys first. Keep up the good work.Kevin O'Keefe Thanks your program it was great for me starting out in my small business, definitely recommend it for startups.Jayne Bachelor I was greatly impressed...Michelle Lamont Great Software...Art Vedner I'm just starting to use this system for BAS reporting and am enjoying the simplicity and ease of use....I give you guys 5 stars.Jodie Maurer I am very impressed with the model.Jozua Fokker I think you have an excellent product and I look forward to trying some more of your software. I am very pleased!Rod Butler ...the system works great.Lyslei Chirico ...works perfectly.Hendry Buter You have excellent products that have saved me several hours of time. Ease of purchase is excellent. Keep up the good work and keep coming up with improved business models. You are absolutely on the right track.Denis Cowley Now to begin my third year with your excellent system ... How lucky I am to have bought your software. Thank youZoe Harrison Now that I have purchased the program, I honestly believe the price is ridiculously low for the power, utility and results generated by the program.Martin Caplan Just started playing with your software and I like it!Roger Loweth I just purchased your software - it's wonderful.Roger Varner I have been very happy with software purchase and was going to purchase another app... Thanks again for the great software!Frank Brown The Business Valuation software that runs in Excel saved my company a lot of time in evaluating an acquisition candidate. The instructions are clear and straightforward, and the program worked flawlessly.Tom Sweet I have loved your BAS Business Accounts Software and think it's ideal for sole traders (which was the reason I purchased it).Nicole Cornish Great piece of software. It has been a real winner in presentations here already. I have more to explore with it, too.Chad Haight ...I am in the midst (or shall we say was in the midst) of selling my company for a much lower amount...your software is working wonderfully...i think i shall send you a bottle of your favorite...Sean Hawley Love this application! It certainly can improve one's comfort level, especially the small business owner, when talking to the financial people. Seems to me like you can get a quick budget snapshot as well as the business valuation. Thanks again!Stan Shaw I am impressed with your business valuation model.Peter Davies Am really enjoying working with this programme, I am sure within the next week I will be putting an order in. I have found it so easy to use, wish I had known about it years ago, life would have been much easier.Lyn Laycock This spreadsheet has really made my life easy and I have recommended it to my colleagues.Moses Mwanjirah We are very pleased with your Business Valuation Model.Steve Geringer ...very easy to use.Karl Hayes Just purchased your great spreadsheet.Terje Larsen I think it is a very useful spreadsheet and I'm using it and I haven't found anything better and have stopped looking.Antoine Matarasso I am very happy with the Excel valuation model supplied. I think it constitutes good value for money and has been of great help to me in my work.Graham Ireson Well done. It proved very useful for me already.Roland Mechler The program is quite easy to use.Jackquie Grant I still love the software.Jim Dickey Received and working great... Excellent service.Kevin Long ...very user friendly...Abel Acuna I recently purchased a copy of this package and have found it to be extremely helpful as a quick valuation tool...This is a great piece of software...Jim Wendler