Do some Excel Work

Completado Publicado Aug 7, 2015 Pagado a la entrega
Completado Pagado a la entrega

I am the country manager of an Oil and Gas service company in IRAQ.

Job 1

We currently have a call off contracts for various Operators in the region How this works is that we submit to the client a CTR (Cost Time Resource) Estimate based on an agreed schedule of rates (See attached CTR 3rd tab on the sheet) this is then approved by the client and a Purchase order is issued and we carry out the work utilising various resources such as Labour, Equipment, transport etc.

What I would like is a cost / spend tracker template that we can implement for each Purchase order, this should work by each day someone will input the utilised resources (Labour, Supervision, Admin, transport, and equipment that have been utilised on the job the sheet should then calculate the spend for that day. The attached sheet is was we use just now.

The sheet should contain the following.

• Original value of the Purchase order defined by Labour, Equipment and PSD transport,

• The actual spend

• The funds remaining

• % Spend and remaining

• I also need is a summary of the total weekly spend for each week . I have attached the cost tracking sheet that we currently use.

• Spend Burn down chart

• Weekly report

I am looking for an easy to use sheet that captures all of the information, looks super professional, allows me to have a weekly report / summary of the spend, a cumulative summary of the spend, the sheet should be easily transferable to multiple Purchase orders and possibly with a dashboard.

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #8224900

Sobre el proyecto

9 propuestas Proyecto remoto Activo Aug 7, 2015

Adjudicado a:

raghav1101

Hi, I would love to work on this project. I am a chartered accountant (CPA equivalent) with 5 years of experience in the field of accounts and finance. I have 8 years of experience in Microsoft Excel including working Más

$235 USD en 3 días
(60 comentarios)
5.8

9 freelancers están ofertando un promedio de $250 por este trabajo

Teloquence

A proposal has not yet been provided

$282 USD en 4 días
(292 comentarios)
7.4
sy3d

hi hru please check my profile, i've no incomplete project and no bad wording for my work sorry to say, no attachment found, please attach file, so i review the file and see what i've to do lets discuss, i ass Más

$211 USD en 3 días
(251 comentarios)
6.9
deepbluetech

A proposal has not yet been provided

$250 USD en 3 días
(160 comentarios)
6.6
roomitech

Hi, I was invited to the project by freelancer.com staff and i have a track record of 100% successful projects in last 5 years. I understood your requirements but i don't see any sample file attached as you mentioned. Más

$235 USD en 3 días
(56 comentarios)
6.2
talhamunir2002

Give me Web URL i will scrape data from there... Give me Web URL i will scrape data from there... Give me Web URL i will scrape data from there... Give me Web URL i will scrape data from there... Give me Web UR Más

$200 USD en 5 días
(172 comentarios)
5.8
Venkylancing

A proposal has not yet been provided

$164 USD en 3 días
(104 comentarios)
6.0
dangersystem

Hello there, Just read the whole description carefully, I think i am able to complete your job within minimum time and with best result Please ask me any inquiry you are searching for, I am ready to discuss with Más

$264 USD en 10 días
(104 comentarios)
5.5
sheak

Hello! I am extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!

$411 USD en 10 días
(16 comentarios)
4.7