Find Jobs
Hire Freelancers

MRP and Earned Value

$30-250 USD

Completed
Posted about 5 years ago

$30-250 USD

Paid on delivery
One data file is from a SAP system and updated weekly. The second file/sheet is a base file that will not change but needs to be compared to current data. Finally, the third file/sheet is the schedule. The project always begins with the second file to create a baseline budget. The schedule is then created based on previous delivery of material from the baseline. The third file updated weekly need to be ingested into the file to compare what was originally in the baseline for cost and schedule. This also has to identify additions/differences from baseline to the current weekly file. Some lines will have duplicate material but may be assigned to a separate account and/or the same. It the same, the quantity and cost need to be summed. The material is summed into a kit or module and needs to be added together so that the sheet shows progress to complete. The data needs to be available on a dashboard tab that reflects earned value data and graphs for each account or work package. This is a material resource plan and earned value together into one file. The weekly file will be updated weekly in the file.
Project ID: 19310591

About the project

7 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
Awarded to:
User Avatar
Hi, I can prepare reports and dashboards in Excel by importing external databases from Intuit QuickBooks, (SQL, or Excel file) and manipulating the data in a structured database. During the process, Excel validates the data and populates the info in report templates based on the needed parameters and criteria (I use pivot table reports and graphs which updated automatically the reports). Also, there is an option to export the info in PDF or CSV files. There is a report generator which enables you to develop templates independently. username id and password can secure the files. During my career, I've served as a CFO, Controller and Chief Accountant at various companies worldwide and have experience bookkeeping and managing financial information (Intuit QuickBooks, SAP, ERP, etc) in a multi-currency environment of the global marketplace. I am a specialist in cash flow managing, liquidity solutions and COGS (for more than 30 years I have used ERP's to manage inventory systems, including physical inventories and unique inventory categories). 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.  With these skills,  I develop financial modules including business valuation methodology & ratios for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios).
$100 USD in 1 day
4.6 (18 reviews)
6.0
6.0
7 freelancers are bidding on average $145 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD in 4 days
4.9 (198 reviews)
7.6
7.6
User Avatar
super super cute little face and you can do it for me to come over and over again and I don't know what I want to upload like some of the African American Horror Story hotel episode of the African American Horror Story hotel episode of the African American Horror Story hotel episode of the African American Horror Story hotel episode of the African American Horror movies with my mom and dad is going on with my mom is gonna go back to
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Industrial Engineer with 7 years of experience in Project Management/ Engineering for major Oil&Gas Projects. Advanced skills in Excel, VBA, SAP integration , Project Baseline and Budget Analysis in SAP/ MS Project/ Primavera P6, Dashboards, etc. Experience in Project Cost Estimation /Project Finance / Públic and Corporate Bidding / Risk Management/ etc. Formed in PMBOK 6 edition and AACE standards For more details please visit my profile. Best Regards
$222 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
Hi, I hope all is well. I am a Certified Public Accountant here in the Philippines. I have been working as an auditor/accountant/finance analyst since 2010 (i.e., immediately after my graduation and after passing the licensure examination). I left my job last year to pursue one of my dreams of having my own business. Now, since the business is already stable, I am looking for an online job to fulfill the future needs of my family. This project looks easy but needs to be accurately done on a timely basis to be useful and relevant.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Santa Barbara, United States
5.0
1
Payment method verified
Member since Apr 21, 2019

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.