Given the following cost expenditures for a small

  • Purdue University
  • CE 222
  • Homework Help
  • agrawa12
  • 3
  • 100% (10) 10 out of 10 people found this document helpful

This preview shows page 1 - 3 out of 3 pages.

1.Given the following cost expenditures for a small warehouse project, calculate the peak financial requirement, the monthly overdrafts and the financial requirements in each month.Assume an 8% markup. Retainage is 8% throughout the project. Finance charge is 18% per annum. Payments are billed at the end of the month and are received one month later. Draw the overdraft profile, and present the total costs, billings and payment on the same figure.(Note: when calculations give decimals, round upto the next dollar) (10 pts)
CE222/CEM 201 Homework #6 (Date) Abhinav Agrawal 1/1 Page-2 1 2 3 4 5 Direct Cost 23,000 65,000 57,000 35,000 20,000 Indirect Cost 8,000 10,500 7,500 12,500 13,000 MONTH 1 2 3 4 5 6 Direct Cost 23,000 65,000 57,000 35,000 20,000 Indirect Cost 8,000 10,500 7,500 12,500 13,000 Total Cost 31,000 75,500 64,500 47,500 33,000 Total Billed ( 8 % markup) 33,480 81,540 69,660 51,300 35,640 Retainage witheld ( 8 %) 2,679 6,524 5,573 4,104 0 Payment received 30,801 75,016 64,087 47,196 54,520 Total cost to date 31,000 106,500 171,000 218,500 251,500 251,500 251,500 Total amount billed to date 33,480 115,020 184,680 235,980 271,620 271,620 271,620 Total paid to date 30,801 105,817 169,904 217,100 271,620 Overdraft at end of month 31,000 106,965 142,269 116,888 87,554 41,672 -12,222 Interest on overdraft balance (1.5 per month) 465 1,605 2,135 1,754 1,314 626 TOTAL AMOUNT FINANCED 31,465 108,570 144,404 118,641 88,868 42,298 -12,222
CE222/CEM 201 Homework #6 (Date) Abhinav Agrawal 1/1 Page-3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture