•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
List and net pricing workbook formula
Our take
To create an effective pricing workbook for your product, you need a formula that accurately calculates both net and list prices based on your costs. Begin with Sheet 2, where you input your product costs. Next, apply the tariffs and freight to these costs, and multiply the total by 3 to determine your net price. Finally, divide the net price by 0.3 to establish the list price, ensuring to round up to the nearest $0.25. This structured approach will streamline your pricing strategy efficiently.
I'm creating a workbook for our list and net pricing for one of our products. I have two sheets so far. Sheet 1 will show the list and net pricing while sheet 2 has our costs for the product. I need help creating a formula that will take our costs from sheet 2, multiply that by the tariffs, plus freight. Then I would need for it to multiple that result by 3 to get our net price. Then I would need to take our net price and divide that by .3 to get our list price. The list price would also need to be rounded up to the nearest $0.25.
Can someone help me with that?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#AI formula generation techniques#rows.com#formula generator#Excel compatibility#google sheets#financial modeling with spreadsheets#Excel alternatives#list pricing#net pricing#formula#net price#workbook#costs#pricing workbook#rounded up#tariffs#freight