Excel Spreadsheet- Margin Calculator

IN PROGRESS
Bids
27
Avg Bid (AUD)
$35
Project Budget (AUD)
$30 - $250

Project Description:
Hi,

We are looking for simple spreadsheet that automatically calculates sale price depending on quantity ordered.

I have a table set with margin percentage and we want to use that table to calculate sale price depending on quantity order.

For example- Someone wants a quote on product A based on X units what is the sell price.

We want to be able to automate this so we just have a field were we enter product name and units required. Then sell price is returned. You will need to create if functions. Please also allow for odd quantities. ie we enter 175 units. The formula will need to select the right price break. I also want to be able to change the margin percentages as need be.

See attached file for reference. I want to be able to add info into the green fields and sell price to be returned in the red cell.

Please submit your best pricing.

Thanks,

Skills required:
Excel
Additional Files: Sell+Price+Calculator.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
$ 30
in 0 days
$ 30
in 0 days
$ 30
in 1 days
$ 50
in 1 days
$ 30
in 1 days
Hire Pichart
$ 30
in 1 days
$ 30
in 1 days
$ 30
in 0 days
Hire ruchipuri
$ 30
in 0 days