Excel work

Closed - This job posting has been filled and work has been completed.
Web & Mobile Development Scripts & Utilities Posted 2 years ago

Hourly Job

As Needed
Less than 1 week

Details

My small requirement is below:

I have a small firm where around 5-8 resources work on monthly daily rate basis.

Need an excel master sheet which is having below requirement:
1.As a user I can register new resources with following details:
a)Resource name
b)Resource Daily Rate
c)VAT required
d)Duration of contract
e)Daily rate customer

On Monthly sheet say January if I enter No of days next to Resource column then it should calculate amount paid to resource & my profit and additionally it should have place holder to enter invoice no,Invoice received date & Payment date, If VAT required is Yes then VAT should be calculated based on below formula
(daily rate* no of days)*19%

If profit then it should be Green else RED should be that column.
If a month has more then 1 resource work then it should club all profit & loss and show a summary.


About the Client

(5.00) 1 review

Germany
Munich 03:43 PM

14 Jobs Posted
15% Hire Rate, 5 Open Jobs

$138 Total Spent
2 Hires, 0 Active

Member Since Nov 19, 2012