solution

Prepare a project charter for the Fixer Upper Project. Assume the project will take six months to complete and cost about $350,000 (or agreed upon price), that you estimate you will spend $40,000 for renovations. The first three months of the project will involve finding and closing on the property, and the last three months will involve fixing up the property, finding renters (preferably two renters), and preparing financial information for you and your aunt. Assume the project starts on October 1 and finishes on April 1. Recall that the main project objectives are to find and renovate a house that your Aunt Julie would own but you would live in and be able to rent out one to three rooms. Julie has also agreed that she will let you earn equity on the house. As she has said to you a few times, “Pretend I’m your banker, and it’s your home.” You will do all of the renovation planning work, including creating detailed cost estimates for all of the renovations, preparing a detailed schedule for the renovations, overseeing renovations, preparing a rental agreement and a strategy for finding renters, and creating a spreadsheet to analyze your “mortgage” payments and other financial information. Use the project charter template provided on the companion Web site, and review the sample in the text.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Create a milestone list for the executing part of the renovation part of this project, and include at least 10 milestones and estimated completion dates for them. Assume that you close on the house on Jan. 1, you and some friends will tear out the carpeting, gut the kitchen, and prepare the walls for painting the first two weeks in January, and you, your aunt, and three friends will paint the interior walls the third weekend in January. Assume your friend will fly in the first week of February. You will have the flooring and windows put in as soon as possible after the kitchen is done and do other necessary work so that you can move in by Feb. 20 and then start showing some rooms to potential renters. Ideally you would like the house to look like a home and have two renters sign agreements no later than April 1.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Use the WBS you created earlier, the milestone list you developed in numbers 2 above, and the new information provided to create an initial Gantt chart and network diagram in Project 2010 for the project. Create one Gantt chart for the actual fixer upper project, assuming a start date of October 1 and end date of April 1. Create a second Gantt chart for your team to do this case study, including all the project management tasks and the dates of your class for them. (You will break down the renovation work in more detail in the Executing part of this project.) Estimate task durations and enter dependencies, as appropriate. Print the Gantt chart and network diagram.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Create a spreadsheet to summarize financial information that includes four sheets called Loan, Cash Flow, Investment, and Sell. Name the first sheet Loan and figure out your monthly payments and interest paid on a loan from your Aunt Julie for $350,000 over 30 years, using realistic interest rates. (Hint: Look into loan amortization schedules and current mortgage rates). Add a second sheet call Cash Flow to show your total monthly expenses, including the cost for utilities, taxes (assume $3,500 per year, increasing 3% per year), homeowners insurance, basic maintenance, etc. on top of the payment you make to your aunt. Also include other expenses, such as food, gas, car payments, etc. Add your projected income, including money you would receive from renters. Assume you earn $50,000/year at your job and pay taxes, of course. Determine your monthly cash flow for a year. Add a third sheet called Investment to show your aunt that she is making a good investment, assuming she could have invested the same amount of money ($350,000) in a safe, lowinterest investment. Add a fourth sheet called Sell that assumes you sell the house in ten years for $450,000. Suggest options to your aunt for how to handle that situation, including your equity in the house.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"