CET360 Ch. 12 Problems 1. Complete the overdraft calculation table below. Retainage is 10% until 5% of the total project has been retained. Progress payments are made the month after billing and are received the last day of that month, but are not transferred to reduce the LOC until the first day of the next month. Lake Project (with retainage) Time (Months) 2 4 5 6 Direct and Indirect Cost 200 250 150 Expenses 600 Markup (30%) 60 75 45 80 Total Billed 260 325 195 750 Retainage (10 % 26 325 1915 Payment Received 26 325 19-5 Income Cost to Date Paid to Date Overdraft end of month Interest on overdraft (2%/mo) Total amount financed* Note: Progress Payments are Received the last day of the month (in the column in which they appear) but are transferred to reduce the Line of Credit on the first day of the next month $800 2. Plot the expense and income curves for the previous problem. $720 What is the maxium overdraft? $640 $560 $480 When does it occur? $400 $320 $240 $160 $80 SO 1 2 3 MonthTotal cost 420dnal billed - 10 Apartment Project (with mobilization) Month March April May June Direct and Indirect Cost uly $4,500 500 800 1000 August Markup (20%) 850 10. 20 ) x 160 350 3509 754,000 Total Billed 200 170 700 - $3,500 Payment Received 600 963 1200 102 0 KID 4 20 - $3,000 150 1600 960 1250 1020 270 1920-15 $2, 500 $2,000 Cost to Date 500 1300 2300 3150 3509 3500 $1,500 Paid to Date 150 7504 1710 2910 3930 42 09 $1,000 Overdraft end of month /350 565.25 603 58 262-6-403- 43 $500 Interest on overdraft (1.5%) 15 5. 251 8.33 5,05 3.94 D N m Total amount financed 355- 25 563- 58 6+2. 63 266.57 (1403 . ) March Month Time owner pairs $ 160 mpbi. zution 800+ 355. 25- 600: 555. 25 Day month billed to The Max overdraft payments ( month after earned ) Cost subtract mob from last pyme ) reived ( line of credit ) ( LOC ) needs to be $ 604 K Min Cushion , maybe Set up # 700 K LOCCET360 Ch. 12 Problems 3. Complete the overdraft calculation table below. A $50K Mobilization payment is paid mid-July. Other progress payments are made in the middle of the month after billing and are transferred to reduce the LOC that same month. Bridge Project (with mobilization) Month July August September October Direct and Indirect Cost November December 100 500 600 250 21650 Markup (15%) 150 5 15 90 37.5 Total Billed 22. 5 15 1575 690 287.5 172.5 1840 Payment Received 50 K 15 575 690 237.5 122.5 Cost to Date 100 600 1200 1450 1620 1630 * Paid to Date 50 165 740 1430 1717.5 1840 Overdraft end of month 50 435 75 467-231 24 296 - 102. 69 Interest on overdraft (1.5%) 0:75 6.536 7. 009 0.514 (1540 Total amount financed 50- 75 447 . 201 474. 296 341 310 6 - 104-23) 4. Plot the expense and income curves for the previous problem. What is the maximum $750 overdraft? $700 $650 $600 $550 When does it occur? $500 OSTSA $400 $350 $300 $250 $200 $150 $100 $50 SO July August September October November December Ti