Problem 11-23

Hi can you please help me solve this using Excel? Thanks!

Example of drop down.

purchased, determine how many units of each subassembly Roedel should manufacture and how many units of each subassembly Roedel should purchase. What is the total manufacturing and purchase cost associated with your recommendation? $ Do you think the new machinery should be purchased? Explain. The input in the box below will not be graded, but may be reviewed and considered by your instructor. What is the total manufacturing and purchase cost associated with your recommendation? $ Do you think the new machinery should be purchased? Yes No below will not be graded, but may be reviewed and considered by your instructor. use the same base subassembly, but different cartridge and keypad subassemblies. 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