please help solve the model by using excel for this practice problem

1. Lauren Muffet is interested in expanding her firm. After careful consideration, she has determined three areas in which she might invest additional funds: (1) Product research and development, (2) Manufacturing operations improvements, and (3) Advertising and sales promotion. She has $500,000 available for investment in the firm. She can invest in its advertising and sales promotion program every year, and each dollar invested in this manner is expected to yield a return of the amount invested plus 20% yearly. She can invest in manufacturing operations improvements every 2 years, with an expected return of the investment plus 30% (at the end of each 2-year period). An investment in product research and development would be for a 3-year period, with an expected return of the investment plus 50% (at the end of the 3-year period). To diversify the total initial investment, she wishes to include the requirement that at least $30,000 must be invested in the advertising and sales promotion program, at least $40,000 in manufacturing operations improvements, and at least $50,000 in product research and development initially (at the beginning of the first year). Lauren wants to know how much should be invested in each of the three alternatives, during each year of a 4-year period, to maximize the total ending cash value of the initial $500,000 investment. Solve the model by using Excel and state how much should be invested each year and in what options. 1. Lauren Muffet is interested in expanding her firm. After careful consideration, she has determined three areas in which she might invest additional funds: (1) Product research and development, (2) Manufacturing operations improvements, and (3) Advertising and sales promotion. She has $500,000 available for investment in the firm. She can invest in its advertising and sales promotion program every year, and each dollar invested in this manner is expected to yield a return of the amount invested plus 20% yearly. She can invest in manufacturing operations improvements every 2 years, with an expected return of the investment plus 30% (at the end of each 2-year period). An investment in product research and development would be for a 3-year period, with an expected return of the investment plus 50% (at the end of the 3-year period). To diversify the total initial investment, she wishes to include the requirement that at least $30,000 must be invested in the advertising and sales promotion program, at least $40,000 in manufacturing operations improvements, and at least $50,000 in product research and development initially (at the beginning of the first year). Lauren wants to know how much should be invested in each of the three alternatives, during each year of a 4-year period, to maximize the total ending cash value of the initial $500,000 investment. Solve the model by using Excel and state how much should be invested each year and in what options