Browse All Question and Answer Items

Items selected where Topic is Product and Supplier Profitability Excel

Topic: Product and Supplier Profitability Excel
Q: I am looking for a tool to use to determine the cost of a product which uses both imported and local outsourced components and labour for assembly and installation- which also includes local shipping to trimmers then on to the install site and returning parts to HQ for recycling. I thought the PSPE workbook would be what I looking for but it is almost too far along the supply chain. I want to show item cost, shipping, duty, local shipping storage costs ( I thought you had something which showed the financial cost of inventory over time) , plus the cost of selling on credit, warranty allowance etc. The objective is to end up with a total local cost from which the selling price can be determined.

A: I think Product and Supplier Profitability www.bizpeponline.com is as close as we get (it does include some financing and holding costs). It sounds like a tailored design would be needed.

This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.

Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items

 

Topic: Product and Supplier Profitability Excel
Q: I have put in formula from my own in the input cells, which by the way didn't save. Are you saying in the input cells I can only put in numbers no formulas?

A: You can use formula in the form inputs but the calculated values must result in numbers ie all input values must equate to numbers. When you Save Profile only the value will be saved not the formula. As a non design work around if you want set formulas then you could input them into the Form but and they will be saved when you save the file but if you Retrieve a profile they will be overwritten so to have different profiles you would need to save each file as a different name.

This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.

Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items

 

Topic: Product and Supplier Profitability Excel
Q: I have been using the spread sheet and its useful to say the least. However, I couldn't help but notice few problems with it. for e.g. if I do change values in the spread sheet and resave it then most likely the numbers in the over all totalling sheets will not change and you will have to delet the sheet then make a new one inorder to have the correct data showing.

A: Values should be changed on the Form sheet only and when you Save Profile the updated values are transferred to the Table sheet and totals updated. The Table sheet does not include all formula only values updated from the Form when you save a profile. As outlined in the Help all value changes should be done on the Form sheet. When the profile is saved the table sheet is then updated.

This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.

Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items

 

Topic: Product and Supplier Profitability Excel
Q: I have been using the spread sheet and its useful to say the least. However, I couldn't help but notice few problems with it. for e.g. if I do change values in the spread sheet and resave it then most likely the numbers in the over all totalling sheets will not change and you will have to delet the sheet then make a new one inorder to have the correct data showing.

A: Values should be changed on the Form sheet only and when you Save Profile the updated values are transferred to the Table sheet and totals updated. The Table sheet does not include all formula only values updated from the Form when you save a profile. As outlined in the Help all value changes should be done on the Form sheet. When the profile is saved the table sheet is then updated.

This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.

Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items

 

Topic: Product and Supplier Profitability Excel
Q: I would like to purchase the Product & Supplier Profitability template. Once I have purchased same, will you provide me with the password to the workbook and sheet protect?

A: You will need to purchase a Commercial or Source License to receive unprotected software. With a standard Non-Commercial License 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. We also offer Commercial licenses and upon request with a Commercial license can provide an unprotected software version allowing you to view the formula applied, access cell contents to enhance your knowledge of software operation (macros remain protected) and undertake minor refinements (ie headings etc). Commercial licensing fees are 3 times Non-Commercial licensing fees. To access the source code of our software including the visual basic code (macros) a Source License is required. This license allows you to modify and adapt all components of the software to meet your specific needs. Source licensing fees are 3 times Commercial licensing fees. Source Code License details are available at www.bizpeponline.com . Please note that Bizpep retain full copyright and intellectual property rights at all times. I can provide additional detail as required.

This Question and Answer Item relates to Product and Supplier Profitability Excel from www.bizpeponline.com.

Browse Other Product and Supplier Profitability Excel Items - Browse All Question and Answer Items

 

Client Comments

"You guys are fantastick ...excellent service each and every time, without fail."

"This was my first software purchase over the internet. I am very please with the results."

"Whole transaction and result well done."

"Thank you sir for your prompt response and excellent service."

"...you guys were great!"

"Keep up the good work!!"

"Great as usual, Thanks."

"These are practical business tools and the service that you offer for modification and assistance to adapt to practical circumstances is outstanding."

"I really appreciate your time and responsiveness... I'll definitely be back to your site soon."

"I like the simplicity and layout of your product."

"Excellent for the three items."

more.... »