Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Excel QS FMT Cash Flow - Labor

    Uploaded by

    Roshan de Silva
    The document presents cash flow information for the labor costs of a South Airfield Development & Rehabilitation project over a 22 month period. It shows the projected monthly costs and cumulative costs for cash flowing in and out. The cash inflow is projected to be $18 million over 90 days, while cash outflow is projected at $16.2 million over 60 days, resulting in a net positive cash flow of $1.8 million.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Excel QS FMT Cash Flow - Labor

    Uploaded by

    Roshan de Silva
    49 views1 page
    The document presents cash flow information for the labor costs of a South Airfield Development & Rehabilitation project over a 22 month period. It shows the projected monthly costs and cumulative costs for cash flowing in and out. The cash inflow is projected to be $18 million over 90 days, while cash outflow is projected at $16.2 million over 60 days, resulting in a net positive cash flow of $1.8 million.

    Original Description:

    Excel QS Fmt Cash Flow - Labor

    Original Title

    Excel QS Fmt Cash Flow - Labor

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document presents cash flow information for the labor costs of a South Airfield Development & Rehabilitation project over a 22 month period. It shows the projected monthly costs and cumulative costs for cash flowing in and out. The cash inflow is projected to be $18 million over 90 days, while cash outflow is projected at $16.2 million over 60 days, resulting in a net positive cash flow of $1.8 million.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    49 views1 page

    Excel QS FMT Cash Flow - Labor

    Uploaded by

    Roshan de Silva
    The document presents cash flow information for the labor costs of a South Airfield Development & Rehabilitation project over a 22 month period. It shows the projected monthly costs and cumulative costs for cash flowing in and out. The cash inflow is projected to be $18 million over 90 days, while cash outflow is projected at $16.2 million over 60 days, resulting in a net positive cash flow of $1.8 million.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 1

    SOUTH AIRFIELD DEVELOPMENT & REHABILITATION

    Labor Cash Flow In and Out

    PRODUCTIOIN VALUES
    18,000,000

    800.00

    16,000,000

    700.00

    500.00

    10,000,000
    400.00

    8,000,000
    300.00

    6,000,000

    200.00

    4,000,000

    100.00

    2,000,000

    10

    11

    No of Months

    12

    13

    Cost of Months

    14

    15

    16

    17

    18

    19

    20

    21

    22

    Cost of Cumalative

    CASH IN

    18,000,000.00

    800

    16,000,000.00

    700

    14,000,000.00
    Cumalative Cost

    No Months

    600.00

    12,000,000

    600

    12,000,000.00

    500

    10,000,000.00
    400
    8,000,000.00
    300

    6,000,000.00

    No Months

    Cumalative Cost

    14,000,000

    200

    4,000,000.00

    100

    2,000,000.00
    -

    0
    1

    10
    No of Months

    11

    12

    13

    Cost of Months

    14

    15

    16

    17

    18

    19

    20

    21

    22

    Cost of Cumalative

    CASH OUT
    18,000,000.00

    800

    16,000,000.00

    700
    600

    12,000,000.00

    500

    10,000,000.00
    400
    8,000,000.00
    300

    6,000,000.00

    No of Months

    Cumalative Cost

    14,000,000.00

    200

    4,000,000.00

    100

    2,000,000.00
    0.00

    10
    No of Months

    11
    Cost of Months

    12

    13

    14

    15

    16

    17

    18

    19

    20

    21

    22

    Cost of Cumaative

    Month
    Rate Per Month

    1
    2,377.46

    2
    2,377.46

    3
    2,377.46

    4
    2,377.46

    5
    2,377.46

    6
    2,377.46

    7
    2,377.46

    8
    2,377.46

    9
    2,377.46

    10
    2,377.46

    11
    2,377.46

    12
    2,377.46

    13
    2,377.46

    14
    2,377.46

    15
    2,377.46

    16
    2,377.46

    17
    2,377.46

    18
    2,377.46

    19
    2,377.46

    20
    2,377.46

    21
    2,377.46

    22
    2,377.46

    No of Month
    Cost of Month
    Cost of Cumalative

    82.00
    194,952
    194,952

    87.00
    206,839
    401,790

    286.00
    679,953
    1,081,743

    426.00
    1,012,797
    2,094,541

    533.00
    1,267,185
    3,361,726

    608.00
    1,445,494
    4,807,220

    600.00
    1,426,475
    6,233,695

    517.00
    1,229,146
    7,462,841

    196.00
    465,982
    7,928,823

    636.00
    1,512,063
    9,440,886

    690.00
    1,640,446
    11,081,332

    595.00
    1,414,588
    12,495,919

    594.00
    1,412,210
    13,908,130

    460.00
    1,093,631
    15,001,760

    140.00
    332,844
    15,334,604

    112.00
    266,275
    15,600,880

    110.00
    261,520
    15,862,400

    81.00
    192,574
    16,054,974

    63.00
    149,780
    16,204,754

    0
    16,204,754

    0
    16,204,754

    0
    16,204,754

    82
    194,952
    194,952

    87
    206,839
    401,790

    286
    679,953
    1,081,743

    426
    1,012,797
    2,094,541

    533
    1,267,185
    3,361,726

    608
    1,445,494
    4,807,220

    600
    1,426,475
    6,233,695

    517
    1,229,146
    7,462,841

    196
    465,982
    7,928,823

    636
    1,512,063
    9,440,886

    690
    1,640,446
    11,081,332

    595
    1,414,588
    12,495,919

    594
    1,412,210
    13,908,130

    460
    1,093,631
    15,001,760

    140
    332,844
    15,334,604

    112
    266,275
    15,600,880

    110
    261,520
    15,862,400

    81
    192,574
    16,054,974

    63
    149,780
    16,204,754

    87
    206,839
    401,790

    286
    679,953
    1,081,743

    426
    1,012,797
    2,094,541

    533
    1,267,185
    3,361,726

    608
    1,445,494
    4,807,220

    600
    1,426,475
    6,233,695

    517
    1,229,146
    7,462,841

    196
    465,982
    7,928,823

    636
    1,512,063
    9,440,886

    690
    1,640,446
    11,081,332

    595
    1,414,588
    12,495,919

    594
    1,412,210
    13,908,130

    460
    1,093,631
    15,001,760

    140
    332,844
    15,334,604

    112
    266,275
    15,600,880

    110
    261,520
    15,862,400

    81
    192,574
    16,054,974

    63
    149,780
    16,204,754

    0
    16,204,754

    318,579

    760,787

    149,780

    Cash In - Anticipated after 90 Days


    No of Month
    Cost of Month
    Cost of Cumalative
    Cash Out - Anticipated after 60 Days
    No of Month
    Cost of Month
    Cost of Cumalative

    Net Difference
    Monthly)
    Cash Out and In
    (Cumalative)

    82
    194,952
    194,952

    (
    -

    194,952 -

    11,887 -

    473,114 -

    332,844 -

    254,388 -

    194,952 -

    206,839 -

    679,953 -

    1,012,797 -

    1,267,185 -

    178,309

    19,020

    197,329

    763,164 -

    1,046,082 -

    128,383

    225,859

    1,445,494 -

    1,426,475 -

    1,229,146 -

    465,982 -

    1,512,063 -

    1,640,446 -

    1,414,588 -

    2,377
    1,412,210 -

    1,093,631 -

    332,844 -

    66,569

    4,755

    68,946

    42,794

    266,275 -

    261,520 -

    192,574 -

    149,780

    You might also like