1) Model ( 3marks per question) and solve (2 marks per question) the following scenarios using "solver" tool in excel Note that you must submit the excel document to get credit for this question a) Soundex produces three models of satellite radios. Model A requires 15 min of work on assembly line 1 and 10 min of work on assembly line 2. Model B requires 10 min of work on assembly line 1 and 12 min of work on assembly line 2. Model C requires 12 min of work on assembly line 1 and 14 min of work on assembly line 3. At most, 28 labor-hours of assembly time on line 1 and 22 labor-hours of assembly time on line 2 are available each day. It is anticipated that Soundex will realize a profit of $12 on model A and $10 on model B and $11 on model C. How many satellite radios of each model should be produced each day to maximize Soundex's profit? b) Patricia has at most $45,000 to invest in securities in the form of corporate stocks. She has narrowed her choices to two groups of stocks: growth stocks that she assumes will yield a 15% return (dividends and capital appreciation) within a year and speculative stocks that she assumes will yield a 25% return (mainly in capital appreciation) within a year. Determine how much she should invest in each group of stocks to maximize the return on her investments within a year if she has decided to invest at least 3 times as much in growth stocks as in speculative stocks. Hint: Amount of money in growth stock with yield of 0.15, and amount of money in speculative stock with yield of 0.25 are variables Total money is the only resource Investment ratio is the second constraint 1) Model ( 3marks per question) and solve (2 marks per question) the following scenarios using "solver" tool in excel Note that you must submit the excel document to get credit for this question a) Soundex produces three models of satellite radios. Model A requires 15 min of work on assembly line 1 and 10 min of work on assembly line 2. Model B requires 10 min of work on assembly line 1 and 12 min of work on assembly line 2. Model C requires 12 min of work on assembly line 1 and 14 min of work on assembly line 3. At most, 28 labor-hours of assembly time on line 1 and 22 labor-hours of assembly time on line 2 are available each day. It is anticipated that Soundex will realize a profit of $12 on model A and $10 on model B and $11 on model C. How many satellite radios of each model should be produced each day to maximize Soundex's profit? b) Patricia has at most $45,000 to invest in securities in the form of corporate stocks. She has narrowed her choices to two groups of stocks: growth stocks that she assumes will yield a 15% return (dividends and capital appreciation) within a year and speculative stocks that she assumes will yield a 25% return (mainly in capital appreciation) within a year. Determine how much she should invest in each group of stocks to maximize the return on her investments within a year if she has decided to invest at least 3 times as much in growth stocks as in speculative stocks. Hint: Amount of money in growth stock with yield of 0.15, and amount of money in speculative stock with yield of 0.25 are variables Total money is the only resource Investment ratio is the second constraint