I need to make adjustments and fix a google sheet.
- or -
Post a project like this793
£75(approx. $94)
- Posted:
- Proposals: 7
- Remote
- #3504241
- Awarded
|BPR|Research|Marketing|Translations|Design|Technical Support|Assistance|more... much more...
Quilmes
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
Regensburg
Excel | Google Sheets | Google Apps Script Automation | VBA Macro | Dashboard | Data Analysis
Karachi
2454441229858825437783684847504159153650506741298
Description
Experience Level: Expert
Estimated project duration: 1 day or less
I have a google sheet and my intention is to derive potential listing prices for Amazon items.
The sheet needs to be able to show all items involved in pre listing cost and post listing cost.
Currently there is an issue whereby,
- To determine the full cost of item we need to know the listing cost, which is determined by the chosen listing price
- Listing price needs to incorporate a 10% profit target
- there are around 50 product categories each charging a different percentage for Amazon Sale Referral fee.
These combine issues mean we have a circular reference which needs to be controlled for.
The objective of the sheet is to have a final listing price visible for any input price, and for that final listing price to be
A: rounded up or down to nearest .49/.99
B: A ten percent profit on item purchase price (all items below 20.00 need 2 dollar profit, anything above 20 dollars will have 10% profit)
Please apply only if you have read the advert, please do not answer my project questions with random keyboard keys.
Thank you for your help, more info provided on request.
The sheet needs to be able to show all items involved in pre listing cost and post listing cost.
Currently there is an issue whereby,
- To determine the full cost of item we need to know the listing cost, which is determined by the chosen listing price
- Listing price needs to incorporate a 10% profit target
- there are around 50 product categories each charging a different percentage for Amazon Sale Referral fee.
These combine issues mean we have a circular reference which needs to be controlled for.
The objective of the sheet is to have a final listing price visible for any input price, and for that final listing price to be
A: rounded up or down to nearest .49/.99
B: A ten percent profit on item purchase price (all items below 20.00 need 2 dollar profit, anything above 20 dollars will have 10% profit)
Please apply only if you have read the advert, please do not answer my project questions with random keyboard keys.
Thank you for your help, more info provided on request.
Louis B.
100% (16)Projects Completed
9
Freelancers worked with
11
Projects awarded
31%
Last project
28 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies