Question

TABLE 12.3 Overdraft Calculations with Mobilization Payment Month 1 Direct cost $25,000 $65,000 $75,000 $15,000 ndirect cost 5,000 5.000 5.000 5.000 Subtotal 30,000 70,000 80,000 20,000 Markup (25%) 7.500 17.500 20,000 5.000 Total billed 37,500 87,500 100,000 25,000 Retainage withheld (10%) 3.750 8,750 Payment received $20,000 $33,750 $78,750 $100,000 Total cost to date 30,000 100,000 180,000 200,000 200,000 Total amount billed to date 37,500 125,000 225,000 250,000 250,000 Total paid to date $20,000 $53,750 $132,000 $232,500 Overdraft end of month 30,000 80,300 127,353 69,877 (29,424) nterest on overdraft balance 300 803 1,274 699 Total amount financed $30,300 $81,103 $128,627 $70,576 (29,424) Parentheses indicate a positive balance. $17.500 $250,000 (46,924)

Answer 1

No further information is given so not able to complete the table   

Overdraft calculations with Mobilization Payment

Month

Particular	1		2		3		4		5		6
Direct cost	$25000		65000		75000		15000
Indirect cost	5000		5000		5000		5000
subtotal	30000		70000		80000		20000
Markup (25%)	7500		17500		20000		5000
Total billed	37500		87500		100000		25000
Retainage withheld (10%)	3750		8750		10000		2500
Payment received		20000		33750		78750		100000		17500
Total cost to date	30000		100000		180000		200000		200000		200000
Total amount billed to date	37500		125000		225000		250000		250000		250000
Total paid to date		20000		53750		132000		232500		250000
Overdraft end of month	30000		80300		127353		69877		(29424)		(46924)
interest on overdraft balance	300		803		1274		699		0		0
Total amount financed	$30300		$81103		$128627		$70576		(29424)		(46924)