Using the information given in the "Project Info" Tab develop a MONTHLY cash flow chart (10 POINTS) ON THIS TAB and answer the following questions for additional points. POINTS QUESTIONS 1. What do you think is a reasonable line of credit request for this project. Why? 3 3 2. What is the estimated closing balance? 3 3. What is the estimated contribution amount? 3 4. What is estimated percentage of profit based on your total project cost including interest? 4 5. What percentage of O&P should you have charged in order to end up with a closing balnce that is 15% of the total costs including interest? 5 6. Draw a single chart that includes all of the below data in the requested format. a. Monthly cost (column chart) b. Cumulative monthly cost excluding interest (line chart) c. Monthly closing balance (column chart) d. Cumulative monthly SOV (line chart) 6 7. Assume that the data given in the Project Info tab is your plan (the basis of your BCWS) If you receive the following information by the end of week 4 from the project site, how would you assess the cost and schedule performance of the Excavate for Foundations activity? Make sure to calculate CPI, SPI, CV and SV for the "Excavate for Foundations" activity, in order to answer this question Project Status Update as of Week 4 Name of Activity Complete Expenses Excavate for Foundations 20% $5,000 6 8. Based on the data given in the above question (Question #7), what do you think will be the final cost and duration of the project? Activity Project Overhead Clear and Grub Excavate for Foundations Footings Slab on Grade Scheduled Budget Duration $ 12,000.00 Project Duration $ 5,000.00 3 weeks $ 24,000.00 4 weeks $ 18,000.00 3 weeks $ 7,600.00 2 weeks Overhead and Profit Annual Interest Rate for debt 10% 8% * Assume that a month has 4 weeks. * You cannot charge the owner for the bank interest expenses. * Owner will pay monthly (every 4 week) Payments will be submitted by the end of each month starting the end of first month. Payments will be received 2 weeks after application "Project Overhead" will be a continuous cost with a linear distribution throughout the project With the exception of Project Overhead which will have the same duration as the entire project, all activities will be linearly scheduled (one after another) in the order given above and no two activities will be happening at the same time. Retainage will be held from each payment at 10% of the "cumulative earned value" in parallel to the methodology used in AIA-G702/ G703 forms. Using the information given in the "Project Info" Tab develop a MONTHLY cash flow chart (10 POINTS) ON THIS TAB and answer the following questions for additional points. POINTS QUESTIONS 1. What do you think is a reasonable line of credit request for this project. Why? 3 3 2. What is the estimated closing balance? 3 3. What is the estimated contribution amount? 3 4. What is estimated percentage of profit based on your total project cost including interest? 4 5. What percentage of O&P should you have charged in order to end up with a closing balnce that is 15% of the total costs including interest? 5 6. Draw a single chart that includes all of the below data in the requested format. a. Monthly cost (column chart) b. Cumulative monthly cost excluding interest (line chart) c. Monthly closing balance (column chart) d. Cumulative monthly SOV (line chart) 6 7. Assume that the data given in the Project Info tab is your plan (the basis of your BCWS) If you receive the following information by the end of week 4 from the project site, how would you assess the cost and schedule performance of the Excavate for Foundations activity? Make sure to calculate CPI, SPI, CV and SV for the "Excavate for Foundations" activity, in order to answer this question Project Status Update as of Week 4 Name of Activity Complete Expenses Excavate for Foundations 20% $5,000 6 8. Based on the data given in the above question (Question #7), what do you think will be the final cost and duration of the project? Activity Project Overhead Clear and Grub Excavate for Foundations Footings Slab on Grade Scheduled Budget Duration $ 12,000.00 Project Duration $ 5,000.00 3 weeks $ 24,000.00 4 weeks $ 18,000.00 3 weeks $ 7,600.00 2 weeks Overhead and Profit Annual Interest Rate for debt 10% 8% * Assume that a month has 4 weeks. * You cannot charge the owner for the bank interest expenses. * Owner will pay monthly (every 4 week) Payments will be submitted by the end of each month starting the end of first month. Payments will be received 2 weeks after application "Project Overhead" will be a continuous cost with a linear distribution throughout the project With the exception of Project Overhead which will have the same duration as the entire project, all activities will be linearly scheduled (one after another) in the order given above and no two activities will be happening at the same time. Retainage will be held from each payment at 10% of the "cumulative earned value" in parallel to the methodology used in AIA-G702/ G703 forms