subject :- Bussiness analytics and deciaion making

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 2. 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 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 $2.00 each, and 7/11 sells them for $3.25 per pack. Each snack pack has a shelf life of 12 months. 7/11's average sales are 40 per week. The annual inventory holding cost rate is 20% and it costs the shop 15% to place an order with Old Dutch If Old Dutch offers a 5% discount on orders of 800 or more, a 10% discount for 1600 or more, and a 15% discount for 2100 or more determine 7/11's optimal order quantity. (8 marks) To get the credit for this question, you must show all the steps and all of the calculations