Develop a business budgeting model in Excel
$5000-10000 SGD
Paid on delivery
2.1. Contractor shall develop Excel Budgeting Model and shall interface seamlessly with existing Finance system , which includes sharing of configuration tables (e.g. Cost Centre Code from FIN 2.0, Cost Centre Managers, Chart Of Accounts) and passing of data both ways (e.g. approved budget from Excel Budgeting Model, actual usage from Finance system) ie via ETL (extract, transform and load) approach.
2.2. Contractor shall be responsible for carrying out the following activities:
2.2.1. Conduct detailed requirements gathering sessions with relevant Organization officers to confirm user requirements, including screen and report layouts.
2.2.2. Work with project team (responsible for Finance to map out ETL requirements.
2.2.3. Configure Excel Budgeting Model based on requirements gathered.
2.2.4. Conduct user acceptance testing sessions to confirm requirements have been met.
2.2.5. Develop user guides and conduct user training sessions.
2.2.6. Transfer knowledge to Organization to enable future configuration to be done in-house after initial development.
2.3. Scope of work shall include :
2.3.1. Incorporate formula into budget entries using revenue/cost drivers and headcount information to arrive at initial estimate, to ease initial revenue and cost estimation
2.3.2. Establish interfaces to pass data from other systems such as student management system and HR systems into Excel Budgeting Model as drivers of the formula to arrive at estimates
2.3.3. Capture new headcount requests
2.3.4. Capture new asset requests
2.3.5. Provide consolidated financial statements and Analytics of budget and actual figures
2.3.6. Allow for what if and scenario analysis on financial statements
2.4. Contractor shall be proactive during requirements gathering sessions and propose intuitive screen/ /report designs that best meet the needs of Organization, including sharing best practices in other budgeting system that the Organization SIM should consider adopting.
Project ID: #13384220
About the project
10 freelancers are bidding on average $11289 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Hello there! I would love to work on this project. I am a Qualified Chartered Accountant (CPA equivalent) with 5 years of experience in the field of accounts, auditing, taxation and financial management. I am curren More
Hi, I would like to work for you. I will provide high quality and well researched business budgeting model plan with my senior level business experience. You may validate my profile which is also verified in Freela More
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More
Hi, I have extensive experience in excel and i can do your project with highest quality and without error.
Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed More
Hi, Can we discuss the project further? I have done similar project and understood the project outline. Please give me a chance. A trial will convince you. Looking forward to work with you.
Hello, sir. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards
Good day, My name is Nikola Nuspahic and I am business manager at BlueViSion IT Solutions. It is a team of web developing and market research experts from East Europe. Our expertise are Web Development, Database De More