3. At Gilbert Electronics you are responsible for sourcing computer chips for your electronics. You currently purchase an annual 30,000 units of chips from supplier Beta. The holding cost per unit per year is equal to $45 (the inventory holding cost factor is 15% and the unit cost is $300), and the cost of placing an order is $450. a. What is the EOQ for these computer chips? Your purchasing manager has been negotiating with your supplier some more and was able to get a multi- product discount. The supplier could lower the per unit price to $200 if you order silicon wafers at the same times as the computer chips. You need 20,000 units pf the silicon wafers per year. Your supplier is offering you the following for the silicon wafers. . The cost per unit is $100. The inventory holding cost factor would be 15%, and your order placement cost is also $450. b. What would be your total costs if you ordered both products based on the computer chip's optimal ordering cycle? c. What would be your total costs if you ordered both products based on the silicon wafers's optimal ordering cycle? d. If you were to optimize your total costs, what would you use for Q for the computer chips? What is the total costs? And what would be the ordering cycle? (hint: you need to use the "solver" function in MS Excel for this question.) For Q3b, What would be your total costs if you ordered both products based on the computer chip's optimal ordering cycle? 32.578 O 33.204 0 34.002 O 34,598 QUESTION 8 For Q3c. What would be your total costs if you ordered both products based on the silicon wafers's optimal ordering cycle? O 40.266 40.674 41,079 42,693 QUESTION 9 For Q3d. If you were to optimize your total costs, what would you use for Q for the computer chips? O 775 822 949 1095 For Q3d, If you were to optimize your total costs, what would be the ordering cycle? 20 O 11.5 O 10 O 8.5