Cost Assignment

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

2020/11 2020/12 2021/01 2021/02

Materials $30,000 - - -

External Contractors $15,000 $15,000 $15,000 $30,000

Direct delivery cost $45,000 $15,000 $15,000 $30,000

Indirect delivery cost $5,000 $5,000 $5,000 $8,000

Project delivery cost $50,000 $20,000 $20,000 $38,000

Corporate overhead
$10,000 $10,000 $10,000 $10,000
recovery

Sub-total $60,000 $30,000 $30,000 $48,000

Rounding

Total $60,000 $30,000 $30,000 $48,000

Cummulative Cost $60,000 $90,000 $120,000 $168,000

$1,400,000

$1,200,000

$1,000,000
Cummulative Cost

$800,000

$600,000

$400,000

$200,000 $168,00
$120,000
$60,000 $90,000
$0
2020/11 2020/12 2021/01 2021/0
2021/03 2021/04 2021/05 2021/06 2021/07

$25,000 $25,000 $30,000 $50,000 $70,000

$40,000 $50,000 $60,000 $60,000 $70,000

$65,000 $75,000 $90,000 $110,000 $140,000

$8,000 $8,000 $8,000 $9,000 $10,000

$73,000 $83,000 $98,000 $119,000 $150,000

$10,000 $10,000 $12,000 $12,000 $12,000

$83,000 $93,000 $110,000 $131,000 $162,000

$83,000 $93,000 $110,000 $131,000 $162,000

$251,000 $344,000 $454,000 $585,000 $747,000

S-Curve
$1,400,000
$1,257,000
$1,202,000
$1,200,000 $1,117,000
$1,022,000
$1,000,000
$907,000

$800,000 $747,000

$585,000
$600,000
$454,000
$400,000 $344,000
$251,000
$200,000 $168,000
$60,000 $90,000 $120,000

$0
2020/11 2020/12 2021/01 2021/02 2021/03 2021/04 2021/05 2021/06 2021/07 2021/08 2021/09 2021/10 2021/11 2021/12

Months
2021/08 2021/09 2021/10 2021/11 2021/12

$95,000 $30,000 $20,000 $20,000 -

$40,000 $60,000 $50,000 $40,000 $30,000

$135,000 $90,000 $70,000 $60,000 $30,000

$10,000 $10,000 $10,000 $10,000 $10,000

$145,000 $100,000 $80,000 $70,000 $40,000

$15,000 $15,000 $15,000 $15,000 $15,000

$160,000 $115,000 $95,000 $85,000 $55,000

$160,000 $115,000 $95,000 $85,000 $55,000

$907,000 $1,022,000 $1,117,000 $1,202,000 $1,257,000

$1,257,000
02,000

1/11 2021/12
Total % of Total

$395,000 31.4

$575,000 45.7

$970,000 77.2

$116,000 9.2

$1,086,000 86.4

$171,000 13.6

$1,257,000 100.0

$0

$1,257,000

You might also like