BUS Intro to Decision Science

I was solving this problem with a certain style but not able to think further. I would like to ask a solution for prob A. I want to get help how to structure a coefficients based on question and What to fill on following structure of Excel solving form. Or maybe a slight change on it. This is how I got taught and familiar with. Thank you.

y2y3={10ifteamsizeis5otherwise={10ifteamsizeis7otherwise 23. Roedel Electronics produces a variety of electrical components, including a remote controller for televisions and a remote controller for DVRs. Each controller consists of three subassemblies that are manufactured by Roedel: a base, a cartridge, and a keypad. Both controllers use the same base subassembly, but different cartridge and keypad subassemblies. Roedel's sales forecast indicates that 7000 TV controllers and 5000 DVR controllers will be needed to satisfy demand during the upcoming Christmas season. Because only 500 hours of in-house manufacturing time are available, Roedel is considering purchasing some, or all, of the subassemblies from outside suppliers. If Roedel manufactures a subassembly in-house, it incurs a fixed setup cost as well as a variable manufacturing cost. The following table shows the setup cost, the manufacturing time per subassembly, the manufacturing cost per subassembly, and the cost to purchase each of the subassemblies from an outside supplier: a. Determine how many units of each subassembly Roedel should manufacture and how many units Roedel should purchase. What is the total manufacturing and purchase cost associated with your recommendation? b. Suppose Roedel is considering purchasing new machinery to produce DVR cartridges. For the new machinery, the setup cost is $3000; the manufacturing time is 2.5 minutes right 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203