Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel Macro (project cost allocations for different EE types)
Sign in to Add to Watch List

Finance & Management > Accounting

View Change History

The client has made the following changes to the job.


Bidding period ended early.

Feb 11, 2013

Job awarded.

Feb 4, 2013

Job awarded.

Jan 31, 2013

Job Description

  |  Change History >>


  • Posted: Thu, Jan 31, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Each month a report is produced (see Report tab) detailing employees, their hours worked by project, hourly rate (which is based on an 8hr day, 40 hour work week) and some other details. We need a simple macro that will convert the output file to calculate the project cost allocation.

This where it gets tricky because the hourly rate shown on the report can and cannot be the actual rate employees are paid. For salaried EE's this is their rate based on a 40 hour work week, and calculating the project allocation is not simply their rate x's hours worked. For hourly EE's project allocations are simply a function of their rate x's the number of hours applied to each project. See the What We'd Like tab to show the types of EE's.

The project cost allocation for Salaried EE's is a function of the time applied against a project as a % of total time worked, multiplied by the actuall cost of the employee for the time period.

The final product should show a summary of the hours w...

Sign in or Register to see more

Desired Skills
Microsoft Excel, Analytics
Job ID: 37394645
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Denmark  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37459416  |  Submitted: Feb 2, 2013 18:09 ET 
Proposal SEALED

 United States  |  
Need an Excel-based project completed? My Excel skills are tested out in the Top 1% of all eLance users and I am equally proficient in Excel 2013,...
 0.0   |  Private   |  0 Jobs
Bid ID: 37421609  |  Submitted: Feb 1, 2013 09:11 ET 
Within 1 day

 India  |  
I would like to introduce myself as the Partner of R. Khaitan & Associates, a reputed Chartered Accountant Firm of Kolkata, West Bengal (India)....
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37409758  |  Submitted: Feb 1, 2013 01:17 ET 
Proposal SEALED

A SIVA KUMAR's identity has been verified.  Learn More
I am a B.Com graduate with sound knowledge in computer (Windows, Excel, Tally, ) and social media networking sites. Cost Accounts Part 1 1. Nature...
 0.0   |  Private   |  0 Jobs
Bid ID: 37397786  |  Submitted: Jan 31, 2013 15:14 ET 
Within 1 week
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »