Product Supplier Profitability

Determine your profit by product and supplier. Product Supplier Profitability allows you to identify the true costs associated with your products. It does this by considering initial costs (purchase, transport, receiving, and reject), on-going costs (storage, overheads), as well as finance and customer return costs. Calculations are presented in both Form and Table view for effective display. Supplier/Product profiles are created in Form view and cost analysis by unit and profile applied. Sensitivity functions allow you to test variations for Stockturn and Customer Returns. Each profile can be saved to the Table view providing a database of profiles with Sub Totals by supplier and calculations for the Total Business. A Template feature allows you to set up standard profiles.

This application is suitable for all resale business operations regardless of size. It allows you to build a complete product/supplier database with a cost breakdown and analysis for each profile, each supplier and the Total Business. From this you can critically compare suppliers and products to determine true profit contributions.

Product Supplier Profitability

Download Product Supplier Profitability

downloadzip file Download Product Supplier Profitability - Compressed Zip file


downloadexcel file Download Product Supplier Profitability - .xlsm file

This application is a macro-enabled spreadsheet developed in Microsoft Excel and will only function when opened using a spreadsheet program with macros enabled. You can download Product Supplier Profitability free of charge for evaluation. In evaluation mode some functionality is restricted. To license your application and fully enable all functions requires the purchase of an application license. If you have not already please consider buying a license to fully enable your application.

If you download the Compressed Zip file unzip/uncompress the downloaded file and save the content .xlsm application file. If you download the .xlsm file simply save the .xlsm file. Open the .xlsm file and follow the instructions. Macros must be enabled for this application to function. If you cannot access input or command buttons do not operate macros are not functioning. In this case please refer to your spreadsheet help to enable macros. This application does not access or alter your system or system files in any way. To uninstall simply delete the saved files.

Application suitability must be independently assessed and use indicates acceptance of any and all associated risk.

Help Product Supplier Profitability

Product Supplier Profitability provides profitability analysis for supplier profiles individually and in total.


The Form sheet allows you to Retrieve Templates, Saved Profiles, Sub Totals, or a Total Business Profile from the dropdown list. With Templates and Saved Profiles you can add new data (blue cells), test sensitivity (tan cells), and view results (yellow cells). You can step through the input cells using your Tab key. All value changes should be done from the Form sheet. Save Profile saves your created profile to the Table sheet. When applying sensitivity the tested values are displayed in the yellow Adjusted cells. These adjusted values are used in calculations and when saving the profile. Only Save Profile after you have added input values to the Form Sheet. If you Save while there are calculation errors due to missing values these will be added to the Table and you will need to delete the Profile for the Totals to be valid. Sub Totals are the sum of all profiles for the supplier. The Total Business profile is the sum of all supplier profiles in the table and gives a compound view of profitability. To delete a profile select it from the dropdown list and Delete.

The Form sheet performs calculations to determine profitability. The formula in the yellow cells can be viewed to enhance understanding. Excel errors i.e. #DIV/0! etc indicate that input data is missing. For additional comments mouseover the red markers in the Form sheet.


The Table sheet displays all saved profiles, Sub Totals, and the Total Business profile. Values should only be changed in the Form sheet. All formula are not included on the Table sheet only values from Form sheet calculations. Reset allows you to delete all added profiles and return the software to its initial default state.


The Template sheet displays the set Templates. You can Add templates and set them up with default values in the blue cells as required, change the Template identifier using the supplier and product values. The yellow cells contain formula that will be applied when the template is saved to the Table sheet (ignore any values in Template sheet yellow cells). You can also Delete added templates. The Base Profile Template (the first template) cannot be deleted, it is used as the base for all new templates.

License Product Supplier Profitability

Please consider supporting application development. Licensing your application will fully enable all functions.

License your application now
  $69.00 USD per year

Secure online transaction processing is provided via PayPal. License details are sent by email as soon as your transaction is processed and will fully enable your application.

Application suitability must be independently assessed and use indicates acceptance of any and all associated risk.

Product Supplier Profitability


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'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 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