Find Jobs
Hire Freelancers

Job Costing in an excel form

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
i create a form however it is a prototype of what I want. I don't know how to make the boxes do what they need to do. This is a job costing tool so I can see what my profit and loss is on different projects that I have going on. my Staff does either or : Move Out inspections, Repairs, Painting, Cleaning, Landscaping. Each staff member makes a different amount of money per hour. At the bottom of my form I want a breakdown to calculate how much each job is costing me compared to how much I sold the job for. I realize this is direct cost but there is a indirect cost to figure in as well that includes a % for things like insurance , workers comp, etc. I did not include this in my form but I would like it to. Please see attached for for better understanding.
Project ID: 11625791

About the project

30 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
I am a BI professional with 7+ yrs of experience. Expert in Excel and VBA. I am a new freelancer and willing to perform the job at low price to gain reputation. Your review matters to me more than the money. This job requires simple excel calculation functions. I intend to write VBA user-defined functions for the job, so that the user can use the form himself to get the numbers (in legible English terms, rather than complex calculations). Please visit my profile and scroll to my github account ([login to view URL]) to evaluate me.
$30 USD in 1 day
5.0 (2 reviews)
1.5
1.5
30 freelancers are bidding on average $118 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working sample work before you consider awarding me the project. Thanks, Jay
$200 USD in 2 days
5.0 (918 reviews)
9.4
9.4
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. We have 100% client satisfaction ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$100 USD in 1 day
4.9 (530 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
5.0 (499 reviews)
8.0
8.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 USD in 2 days
5.0 (328 reviews)
7.5
7.5
User Avatar
I posses expertise in all the aspects of Management Accounting, Financial Accounting, Financial Reporting, Financial Analysis and Bookkeeping with years of experience. I also hold sound skills in MS Excel with expertise in utilizing Excel Spreadsheets for all of the above tasks.
$50 USD in 1 day
4.8 (241 reviews)
7.3
7.3
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$150 USD in 3 days
4.8 (333 reviews)
7.3
7.3
User Avatar
I can do it for you quickly and exactly .
$100 USD in 3 days
4.9 (122 reviews)
7.1
7.1
User Avatar
Hi: I have created Quoting Tools before for other clients. Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss your requirements in detail.
$80 USD in 3 days
4.9 (168 reviews)
7.1
7.1
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details. It might help you to know that I own an engineering consulting company registered in the state of Illinois. You could deal with me as an individual freelancer or as a business, whichever better suits your needs. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$100 USD in 2 days
4.8 (179 reviews)
7.2
7.2
User Avatar
Hello there, I reviewed the Excel form you shared and can modify it in such a way that it will become very easy for you to capture the costs and also compare with the sale price and hence arrive at the profit. I am an Excel expert and have done more than 500 projects here on freelancer with Excellent ratings. I can assure you of a very high quality work. If you could send the spreadsheet version of this form, I would be able to ask more relevant queries and create a new setup for you. Look forward to hear from you and thank you for considering my bid Best Regards, Rishi (Automyze Consulting)
$88 USD in 3 days
4.9 (97 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 3 days
4.9 (121 reviews)
6.3
6.3
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$111 USD in 3 days
4.9 (43 reviews)
5.2
5.2
User Avatar
HI I am an excel-vba Expert and I can finish your project so fast start the chat to discuss more I suggested the best price to win the project
$56 USD in 5 days
5.0 (37 reviews)
5.3
5.3
User Avatar
Hello, I would like to propose a different solution for this. Instead of making this in excel, I suggest to use an application to develop this. That way you will be able to store the information for future use as well as search by any specific date or staff member. If this is not what you want, I can always develop a simple design in excel to achieve that is requested in the pdf file. Please let me know. Thanks Aanvik
$250 USD in 5 days
5.0 (13 reviews)
4.8
4.8
User Avatar
Hi, i can make calculations using Java script. I can do this in PDF. when the worker enters values it will auto calculate and display output in desired field. but your description is bit confusing me. shall we discuss clearly? thank you.
$170 USD in 2 days
5.0 (4 reviews)
3.7
3.7
User Avatar
Greetings of the day! I would love to assist you with the project. I have been working in excel for last 3 years now. Creating dashboard and making data analysis in excel is my everyday task. I can assure you the best quality work. Would love to hear back and discuss more over chat. Regards.
$60 USD in 2 days
4.2 (11 reviews)
3.5
3.5
User Avatar
Hi, I checked your file and want to be sure that I correctly understood it : in the 2 upper tables you want to fill-in the cashing from your clients; then the larger table is to contain information about your staff’s hours of work on the project and the amounts they should be compensated; the lowest table should calculate your profits based on the price of your bid, the labor and material costs and other costs (insurance, workers comp,etc). Is that correct ? If so, what should be the relation between the receipts in the upper tables and the Bid Amount? Do you know all the components that should be included in the indirect cost and the percentages? Based on my experience with Excel, I’d like to discuss the opportunity of working on this project. Looking forward to hear from you Regards, Augustin
$60 USD in 1 day
5.0 (4 reviews)
2.7
2.7
User Avatar
With me is more than seven years of experience in the field of Accounting, Finance, Business Management and Economics. I can help you with any of your needs that are related to these topics. I am also proficient in several accounting software like Quickbooks Online, Sage and MYOB. I can also help you prepare for your business plan and help you with any thing about your business. I can assure you that I can be of help to you more than anyone else. I don't resell project and I make them myself!
$222 USD in 3 days
4.2 (3 reviews)
2.9
2.9
User Avatar
Hello, It is with great interest that i write to you about your project, for the past five years, i have been working as a banker and finance professor. An addition i'm specialist in technical and fundamental analysis of the stock market. Also i'm excellent in French and Arabic. I am waiting for your answer to explain in detail how we could mutually benefic each other. Thank you for your consideration, i look forward to hearing from you soon.
$90 USD in 3 days
0.0 (0 reviews)
0.2
0.2
User Avatar
20 years of experience with Excel spreadsheets If you need Formulas, pivot tables, graphs any other kind of things that the excel can provide. Well trained with preparing Data Templates of any kind for Sap If you choose me, you will get the job done the way you want and on time
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
NORCO, United States
4.9
2
Payment method verified
Member since Jan 12, 2010

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.