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)

CE 210 please show all work

Answer 1

Overdraft Calculation with Moblization Advances
	Months
	1		2		3		4		5		6
Direct Costs	25,000		65,000		75,000		15,000
Indirects Costs	5,000		5,000		5,000		5,000
Sub Total	30,000		70,000		80,000		20,000		-		-
Markup 15% (total cost x 15/100)	4,500		10,500		12,000		3,000		-		-
Total Billed (total cost + markup)	34,500		80,500		92,000		23,000		-		-
Retainange Withheld	863		2,013		2,300		575		-		-
Payment Received		-		33,638		78,488		89,700		22,425		-
Total cost to date	30,000		1,00,000		1,80,000		2,00,000		2,00,000		2,00,000
Total amount billed to date	34,500		1,15,000		2,07,000		2,30,000		2,30,000		2,30,000
Total paid to date		-		33,638		1,12,125		2,01,825		2,24,250		2,24,250
Overdraft end of the month	30,000		1,00,300		1,47,666		90,655		1,861		-20,564
Interest on the Overdraft Balance	300		1,003		1,477		907		-		-
Total Amount Financed	30,300		1,01,303		1,49,142		91,561		1,861		-20,564
Calculation of Retainage Witheld
5% of 50% of first amount
Months	Retainange %	Amount	50% of amount	Retainange amount
1	5%	34,500.00	17,250.00	862.50
2	5%	80,500.00	40,250.00	2,012.50
3	5%	92,000.00	46,000.00	2,300.00
4	5%	23,000.00	11,500.00	575.00
5	5%		-	-
6	5%		-	-
Payment received at the end of next month.
Calculation of overdraft
Year	Op. Overdraft	Production Cost	Amount Received	Total	Interest	Total
1	-	30,000.00	-	30,000.00	300.00	30,300.00
2	30,300.00	70,000.00	-	1,00,300.00	1,003.00	1,01,303.00
3	1,01,303.00	80,000.00	33,638.00	1,47,665.00	1,476.65	1,49,141.65
4	1,49,141.65	20,000.00	78,488.00	90,653.65	906.54	91,560.19
5	91,560.19		89,700.00	1,860.19	18.60	1,878.79
6	1,878.79		22,425.00	-20,546.21	-205.46	-20,751.67