Excel work

Closed - This job posting has been filled and work has been completed.

Job Description

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.