Cash Flow

N

Navin D. Mistry

Hi,

I want to prepare a cash flow. The project parameters are as follows:

Project Type: Construction (Interior fitout) of Retail Store.
Store Size: Approximately 5000 Sq.mtrs. distributed equally at 3 level
(Ground floor, First Floor, Second Floor)
Project Duration: approximately 100 days.

All the activities are outsourced to various contracting companies lik
Hvac, Electrical, fixturing, Carpentry, etc contractors.

All Cost of each activity is worked from a detailed BOQ which then sum
up to a contract value. For example, say: the contract value o
Electrical work is 1000 dollars.

My question is:

How Can I add the following payment terms for electrical contractor i
MSP?

Advance Payment before work start : 30%. Say, 300 dollars
Running bill Payments as the work progresses: 40%. Say, 400 dollars
Final bill payment after work completion: 30%. Say, 300 dollars.

I am struggling with:

Acrue at Start:allocates total cost at the start of the activity
Acrue at End: allocates total cost after completion of the activity
Acrue Prorated: allocates uniformly over the duration of the activity.

Is there any flexibility in MSP 2007 that can accomodate the paymen
terms as desired by me?

Please help.


Thanks and regards,

Navin D. Mistr
 
N

Navin D. Mistry

Thanks a Ton Trevor.

This has given me a good idea.


Thanks and regards,

Navin D. Mistr
 
S

Steve House [MVP]

Remember that MSP isn't a cash accounting application and doesn't track
revenues and payments at all. The "cash flow" it's reporting is not the
dates your payments are due, it is the distribution of your cost accrual in
relation to the project timeframe. I like to think of it as tracking when
you acquire the obligation to pay, not when the money actually has to leave
your bank account. If I do some work for you today, today is when you
acquire the obligation to pay me for it. Those assets from your budget have
been "spent" as of today even though you might not be required to actually
cut the cheque and make payment on my invoice for 30 days. Or considering
the opposite situation where you make an advance payment ... even though
you've sent a cheque 30 days in advance and the money has left your bank
account it hasn't really been spent yet. All you've done is move the asset
from one storage place to another and if you cancel the work you'll be able
to move it back again - it's not really a cost in the project until the work
is performed and you can no longer get a refund. Even if you can't get a
refund on the advance payment by cancelling the work, it's still not a
project cost but has to be charged against general overheads - since it's
not a cost that's required to drive the project forward, it shouldn't be
counted in the project's budget.
 
S

Sanjay

Dear sir/madam

We are a service providers for HVAC, ELECTRICAL, PLUMBING, FIRE-
FIGHTING etc..

We do designing and development for all the above services, not an
execution part at this time.

So we look for any OUTSOURCING jobs from any of the related clients
and the customers.

If you have any contacts or any links or if u share me the orders for
my concern, i think that it

is my pleasure to co-operate and satisfy the customers and the
clients.

So i think that it is suitable for my request and it is our duty to
serve for your concern. And sure that i am waiting for your positive
reply from your side. If you satisfy about my reply means shall i send
my company profile and same as from you side also.



Thanking you in anticipation,



regards



SANJAY C

(sc-online) 091-080-9900153155
 
S

Sanjay

Dear sir/madam

We are a service providers for HVAC, ELECTRICAL, PLUMBING, FIRE-
FIGHTING etc..

We do designing and development for all the above services, not an
execution part at this time.

So we look for any OUTSOURCING jobs from any of the related clients
and the customers.

If you have any contacts or any links or if u share me the orders for
my concern, i think that it

is my pleasure to co-operate and satisfy the customers and the
clients.

So i think that it is suitable for my request and it is our duty to
serve for your concern. And sure that i am waiting for your positive
reply from your side. If you satisfy about my reply means shall i send
my company profile and same as from you side also.



Thanking you in anticipation,



regards



SANJAY C

(sc-online) 091-080-9900153155
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top