176985602337900

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.

Description
Date

Bidding period ended early.

Feb 11, 2013

Job awarded.

Feb 4, 2013

Job awarded.

Jan 31, 2013
Close

Job Description

  |  Change History >>

Updated

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

    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
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

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

 United States  |  
Winner
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,...
1
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 37421609  |  Submitted: Feb 1, 2013 09:11 ET 
Delivery
Within 1 day
$75.00

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

A SIVA KUMAR      
A SIVA KUMAR's identity has been verified.  Learn More
 India  |  
Winner
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...
1
  |  
 0.0   |  Private   |  2 Jobs
Bid ID: 37397786  |  Submitted: Jan 31, 2013 15:14 ET 
Delivery
Within 1 week
$54.79
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »