Sales Spreadsheet: Pricing per User and Margin Calculations
Budget: $30 – $250 AUD
I have a need for a spreadsheet that allows me to calculate total price based on numerous factors:
Various products with different prices per user and minimum sale prices
Total Price based on a calculation of User Count (factoring a minimum that must be met - Hard set)
Price factoring in a margin that can be manually entered and calculated
Price that factors off of the previous input with an additional margin calculation that can be manually changed
Key Requirements:
- Data Entry: I will manually input sales data into the spreadsheet.
- Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided.
Ideal Skills:
- Advanced Excel skills: Proficiency in creating complex formulas for unit price and margin calculations is essential.
- Data Analysis: Ability to present the calculated data in a clear and understandable format.
- Attention to Detail: Ensuring the accuracy of the calculations is crucial.
Various products with different prices per user and minimum sale prices
Total Price based on a calculation of User Count (factoring a minimum that must be met - Hard set)
Price factoring in a margin that can be manually entered and calculated
Price that factors off of the previous input with an additional margin calculation that can be manually changed
Key Requirements:
- Data Entry: I will manually input sales data into the spreadsheet.
- Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided.
Ideal Skills:
- Advanced Excel skills: Proficiency in creating complex formulas for unit price and margin calculations is essential.
- Data Analysis: Ability to present the calculated data in a clear and understandable format.
- Attention to Detail: Ensuring the accuracy of the calculations is crucial.