I want to create a 'profit calculator' in excel
- or -
Post a project like this1315
£105(approx. $132)
- Posted:
- Proposals: 7
- Remote
- #2984730
- Awarded
Helping ambitious, self-motivated business owners achieve time and cost savings by automating spreadsheets to allow for pro-active data-led decision making.
Birmingham
consultancy.datagro.io | Data Scraper | Web Scraping | Data Mining | Web Crawling | Data Scraping | Marketing Data | Data Lists | Excel Expert
City of London
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
164164981075417628842717786315100538734914834381
Description
Experience Level: Expert
The project is to create a profit margin calculator for pubs and bars for certain drinks.
The idea is that a customer can confirm the drink they want to serve (ie Gin & tonic), it will then show them the rrp and the margin. The rrp should be editable, but the rest locked so that they can see how the profit will change depending on what they charge.
Extra complexity is that they could also add a mixer (budget or premium) which has its own profit.
I'm looking for someone to help to create a simple interface where a customer can select the drink, the type of mixer and then see a profit margin. I have the attached spreadsheet which should be enough to power the calculations, so just need a Wizz to make it work.
The end result will be something that the customer can download. It will be a branded page with a simple interface where they can select the drink add a mixer (if appropriate), get a pre-filled RRP with Profit details. They then have the ability to manipulate the RRP to see how the margin might change.
This will be for Irish market, so we will need x2 downloads - one to cover Euros and one GBP - both currencies are covered in the attached file.
The idea is that a customer can confirm the drink they want to serve (ie Gin & tonic), it will then show them the rrp and the margin. The rrp should be editable, but the rest locked so that they can see how the profit will change depending on what they charge.
Extra complexity is that they could also add a mixer (budget or premium) which has its own profit.
I'm looking for someone to help to create a simple interface where a customer can select the drink, the type of mixer and then see a profit margin. I have the attached spreadsheet which should be enough to power the calculations, so just need a Wizz to make it work.
The end result will be something that the customer can download. It will be a branded page with a simple interface where they can select the drink add a mixer (if appropriate), get a pre-filled RRP with Profit details. They then have the ability to manipulate the RRP to see how the margin might change.
This will be for Irish market, so we will need x2 downloads - one to cover Euros and one GBP - both currencies are covered in the attached file.
Tom D.
100% (4)Projects Completed
4
Freelancers worked with
3
Projects awarded
50%
Last project
9 Feb 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