Use excel and show work please!

Homework Approach to solve the problem Determine total time needed at each processing stage for both the products to identify the bottleneck process . Based on the contribution margin (selling price.component costs-labor costunit) for each product, determine the dollar return per constraint minutes Use that information to make a decision of best product mix D 2. Memily Case ... Sound Design produces small speakers and other audio components for use with computers and mp3 players. One plant is dedicated to two small speaker systems (the 1100 and is in which an mp3 player can be docked). The products are similar, but have different components and slightly different process requirements (depicted DENT) MOON 4 What changes, if any, as the made a various Sport in plomme Case Case Sting -1920 Selling her -5195 i100 D 1500 They prodoce to stock and know the demand assen in the diagram Anabor cost to be the Also assume that cachape of production has to houts of processing time available per week . What product is will maximize erect An engineer gest modification to work contro allow it to also handle tak done by work center Bir needed. However, because of the changes, all the activities on bow take 4 minutes (not and task on reduces to 3 minutes from current and minutes Case Is this a good change? What happens to the bottleneck when the change is made Any other thought about the proposed change? Homework Approach to solve the problem Determine total time needed at each processing stage for both the products to identify the bottleneck process . Based on the contribution margin (selling price.component costs-labor costunit) for each product, determine the dollar return per constraint minutes Use that information to make a decision of best product mix D 2. Memily Case ... Sound Design produces small speakers and other audio components for use with computers and mp3 players. One plant is dedicated to two small speaker systems (the 1100 and is in which an mp3 player can be docked). The products are similar, but have different components and slightly different process requirements (depicted DENT) MOON 4 What changes, if any, as the made a various Sport in plomme Case Case Sting -1920 Selling her -5195 i100 D 1500 They prodoce to stock and know the demand assen in the diagram Anabor cost to be the Also assume that cachape of production has to houts of processing time available per week . What product is will maximize erect An engineer gest modification to work contro allow it to also handle tak done by work center Bir needed. However, because of the changes, all the activities on bow take 4 minutes (not and task on reduces to 3 minutes from current and minutes Case Is this a good change? What happens to the bottleneck when the change is made Any other thought about the proposed change