Find Jobs
Hire Freelancers

Create an Excel Profit Calculation Template

$2-8 USD / hour

Closed
Posted over 5 years ago

$2-8 USD / hour

I'm looking for someone who can build an Excel template to calculate potential profit based on a number of variables. The template should be simple to use/understand, and have a clean/visually appealing design. The variables/inputs will include: * Product name * Product category (together with price, this field will be used to look up sales costs) * Product price (together with category, this field will be used to look up sales costs) * Product COGs * Order fulfillment method (based on input, the fields listed below will either be active or inactive) * Order fulfillment cost * Product weight (together with product dimensions, this field will be used to look up fulfillment costs) * Product dimensions (length, width, and height; together with product weight, this field will be used to look up fulfillment costs) The output should be profit margin, calculated based on: * Product price * Product COGs * Sales costs (lookup/calculation based on product category and price inputs) * Fulfillment costs (lookup/calculation based on product weight and dimensions) * Storage costs (lookup/calculation based on product dimensions) In your proposal, please indicate turn-time for this project and include relevant work samples. Thank you!
Project ID: 17940615

About the project

39 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $6 USD/hour for this job
User Avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Create an Excel Profit Calculation Template. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Entry, Data Processing, Excel. Please ping me for more discussion.
$10 USD in 40 days
4.9 (284 reviews)
7.7
7.7
User Avatar
Hi, Please send me the excel file to estimate my working hours. I have experience with analysing financial information in organizations and businesses (I know how to convert P&L and BS files to one database in Excel from Intuit QuickBooks, SAP, ERP, etc.), within a multi-currency environment and the global marketplace, especially, in consolidated accounting, COGS forecasting and budgeting. I am also a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, including the preparation of dynamic dashboards (scenarios) and charts. More on that, I develop financial modules including business valuation methodology & ratios. I served as CFO, Controller, and Chief Accountant at global parent companies. During my career, I have gained valuable experience in diverse sectors, including VC’s, private investors, start-ups, retailers, power plants, farms, insurance companies, universities, construction businesses, hospitals, nursing, medical equipment manufacturers, and traders, among others. My combined experience, knowledge, and creativity will lead to exceptional results that will exceed your expectations.
$12 USD in 40 days
4.9 (60 reviews)
6.6
6.6
User Avatar
Dear client I have previously carried out a number of projects in excel using macros and formulas. I can certainly help you in this project. My estimated time is around 15 hrs to complete. Kindly contact me for further details. Roy
$10 USD in 15 days
4.9 (267 reviews)
6.5
6.5
User Avatar
Hi there, I'm expert in Advance Excel, Formula and Function. Please check my profile as I've done several excel project successfully. I'm ready to start immediately. Please feel free to contact with me. Thanks, Mohiuddin.
$5 USD in 40 days
4.7 (114 reviews)
6.1
6.1
User Avatar
Hello, we are a team of excel experts that are certified from microsoft, if you are interested in hiring the best team that has 15 years of experience let us know.
$10 USD in 40 days
5.0 (37 reviews)
5.2
5.2
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$8 USD in 40 days
4.7 (54 reviews)
5.3
5.3
User Avatar
Hello sir Welcome in my profile appreciate if you contact me to see how can work on your project , I am cost engineer and deal with huge data base for different fields in mega projects ... and expert in excel and can built dynamic database to can easy update any time by your self Thanks
$5 USD in 40 days
5.0 (21 reviews)
4.9
4.9
User Avatar
I can assure you that I will be able to assist you in your task in time with quality work. I have already completed so many projects. Please have a look on my portfolio and profile. I have listed many successful projects in my work history area. I am waiting to be hired in this project to show my skills. Regards
$5 USD in 40 days
4.9 (11 reviews)
4.2
4.2
User Avatar
Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am very proficient with VBA, Macros and Excel dashboards. My business and financial background is also a perfect fit for your work. Please come to chat to discuss further. I have the experience in supporting many businesses in supporting many activities with o% errors. I can do this work satisfying your business requirements. Look forward to discussing with you of the opportunity further. We can discuss the project budget. Kind regards, Dilip.
$15 USD in 40 days
5.0 (15 reviews)
4.2
4.2
User Avatar
Hi Good Day! I can help you to complete your excel template in 3-4 days. But of course it can be lessen. Please accept my bid. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$5 USD in 40 days
5.0 (11 reviews)
3.2
3.2
User Avatar
Hello sir, I have 4+ experience developer. I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
$4 USD in 40 days
5.0 (6 reviews)
2.6
2.6
User Avatar
i have learned excel from lynda and i know each and every formula related to this task. Thanks for taking time to read my proposal. You're also welcome to review my Freelancer profile. I am ready to begin immediately and I will finish this task within time limit.
$5 USD in 10 days
5.0 (4 reviews)
2.4
2.4
User Avatar
Dear Sir, I have read your case carefully and wanted to make a proposal that I hope you may be interested in. I think that to solve the problem it would be a better option to access a database before an excel. It is true that with excel you could do something similar to what you see, but a database has much more potential and whenever you want it can be expanded without too many problems. In addition, if it is the case that the data obtained by the queries or reports of the database must be exported to excel, the same access allows it. If you are interested in the proposal tell him that he could have it ready in about 1 weeks (20 hours / week). If I finally want to do it in excel I can also do it, although my advice is to do it with access because it is more friendly, powerful, easy to learn, it can be used in a network from several PCs, etc ... If you want more information, please, contact me. Best regards
$2 USD in 20 days
5.0 (1 review)
1.0
1.0
User Avatar
Hi , I have more than 12+ years of experience in Reporting (Business Intelligence/operations-MIS), excel based dashboard, data analysis, data management, report automation using VBA etc. Pls. message me to connect further. Timing mentioned is approximate. Thanks,
$5 USD in 40 days
5.0 (1 review)
0.3
0.3
User Avatar
After thorough review of the job functions and looking at my experience for the past years I believe I am the person you are looking for. I already handled the same project like this and help you with this using excel such as profit/loss for the period. We can also customized other features so that it will look more appealing and useful for your business. To dicuss more about this project feel free to contact me at your most convenient time.
$6 USD in 40 days
4.0 (1 review)
0.0
0.0
User Avatar
I am good in excel such as formula and graph. I have a full time work so i can commit 4-6 hours a day during weekdays and 8-10 hours during weekend. I am a efficient worker.
$6 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This will be my first online job,however,i believe in myself. Am a hardworking lady who delivers within deadlines.I will do my best to give you quality work as you desire. I'm learned;i have a degree in commerce(Finance option)from a reputable university in kenya. Jomo Kenyatta University of Agriculture and Technology. Kindly give me a chance to proof myself. Regards, Mary.
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, my name is Konstantinos and I am a new but ambitious freelancer willing to deliver high-quality Data services. My working experience in Excel includes: Data entry - Data Transformation Functions Macros Add-ins to integrate with other applications At present, I am working as a web developer at a Greek IT company. Your task seems to be clear and pretty straightforward. I am sure I can deliver your excel template in 1 week time provided I will work for about 20 hours. I would be pleased to supply you with any further information. In case you have any further questions, feel free to contact me. Thank you for considering my application. Yours sincerely, Cheilakos Konstantinos
$5 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello
$4 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have expert to work in execl.I will complete your work at time. I am punctual in my work.
$5 USD in 70 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tampa, United States
0.0
0
Member since Oct 2, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.