based off this information, i need part B answer. creating a spreadsheet and solving it. question: what is the optimal solution? round to three decimal places.

Investment in year i into investment B in thousands of dollars, Cj= Investment in year I into imvestment C in thousands of dollars, and D,= invastment in year (a) Formulate an ts model for this problem to find the smallest initial investment (in thousands of dollars). MIN: Subject to: Cash Flow Year 2 Cash Flew Year 3 Cash Flow Year 4 Cesh Fow Year 5 Cash Flow Year 6 Cash Fow Year? Cosh Flow Year B Cash Flow Year 9 A,br,CrDj0 (b) Create e spreadsheet model for this problem and solve it using Solver. What is the optimal solution? (Round your answers to three decimal places) u2,A2,A3,AN,A3,A6,A7,A3,B1,B3,B5,B2,C3,C4,D2)=(