Chapter 12: Question #16 (Please answer using Excel or in a digital form, not handwritten)

16. A company will begin stocking remote control devices. Expected monthly demand is 800 units. The controllers can be purchased from either supplier A or supplier B. Their price lists are as follows: Ordering cost is $40 and annual holding cost is 25 percent of unit price per unit. Which supplier should be used and what order quantity is optimal if the intent is to minimize total annual costs