Solve all asked questions in step wise manner. Draw network flow model clearly and give linear programming model with decision variables, constraints and objective function. To be solved in excel clearly with answer and sensitivity reports. Give optimal solution

3) Joe Jones wants to establish a construction fund (or sinking fund) to pay for a new bowling alley he is building. Construction of the bowling alley is expected to take 6 months and cost $300,000. Joe's contract with the construction company requires him to make payments of $50,000 at the end of the second and fourth months, and a final payment of $200,000 at the end of the sixth month when the bowling alley is completed. Joe has identified four investments that he can use to establish the construction fund; these investments are summarized in the following table: The table indicates that investment A will be available at the beginning of each of the next 6 months, and funds invested in this manner mature in 1 month with a yield of 1.2%. Similarly, funds can be placed in investment C only at the beginning of months 1 and/or 4 , and they mature at the end of 3 months with a yield of 5.8%. Joe would like to determine an investment plan whereby the amount he deposits in month 1 will ensure there is enough money to meet the required payments for this project. Of course, he would also like to minimize the required deposit amount in month 1. A. Draw a network flow model for this problem. B. Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints. C. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. c. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. d. Provide a screenshot of the Answer Report including the top section with the log from Solver. D. What is the minimum amount that he needs to deposit in Month 1 ? How should he invest the funds for the project? Communicate the recommendation in plain English