1) Model (3marks per question) and solve (3 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) Alpha remote produces three models of safellite radios. Model A requires 28 min of work on assembly line 1 and 30 min of work on assembly line 2. Model B requires 22 min of work on assembly line 1 and 26 min of work on assembly line 2. Model requires 25 min of work on assembly line 1 and 34 min of work on assembly line 2. At most, 30 labor-hours of assembly time on line 1 and 25 labor-hours of assembly time on line 2 are available cach day. It is anticipated that Alpha remote will realize a profit of S24 on model A and S23 on model B and S27 on model C. How many satellite radios of each model should be produced each day to maximize the profit? b) Patricia has at most $60,000 to invest in securities in the form of corporate stocks. She has narrowed her choices to three groups of stocks. growth stocks that she assumes will yield a 14% return (dividends and capital appreciation) within a year, speculative stocks that she assumes will yield a 12% return (mainly in capital appreciation) within a year and EFTs which average at 9% retum per 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 and at least twice as much in EFTs as in growth stocks, Hint: Total money is the only resource 2) Solve the following case and report the optimal total annual cost (minimum total annual cost): A local 7/11 sells Old Dutch snack packs. Packs cost $1.20 each, and 7/11 sells them for $3.25 per pack. Each snack pack has a shelf life of 12 months. 7/1l's average sales are 60 per week. The annual inventory holding cost rate is 40% of the cost, and it costs the shop $5.00 to place an order with Old Dutch a) Determine the optimal order quantity. (2 marks) b) If Old Dutch offers a 10% discount on orders of 1200 or more, a discount for2000 or more, and a 20% discount for 3000 or more determine 7/1l's optimal order quantity. (6 marks) To get the credit for this question, you must show all the steps and all of the calculations