PLS SOLVE THE EXCEL

Instructions: Solve the following problems. For items (1) and (2}, the answers are indicated in red. Show your complete solutions to arrive at the answer. For item (3), show your complete solutions and interpret your answers. 1. China Shaolin Electronics Trading Corporation supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. One of the components has an annual demand of 250 units, and this is constant throughout the year. Carrying cost is estimated to be USD 1.00 per unit per year, and the ordering cost is USD 20.00 per order. a. To minimize cost, how many units should be ordered each time an order is placed? 100 units b. How many orders per year are needed with the optimal policy? 2.5 orders per year What is the average inventory if costs are minimized? 50 units d. Suppose the ordering cost is not USD 20.00, and the company has been ordering 150 units each time an order is placed. For this order policy to be optimal, what would the ordering cost have to be? USD 45.00 2. ASELSAN is a distribution company that has an annual demand for a metal detector of 1,400 units. The cost of a typical detector to ASEL'SAN is USD 400.00. Carrying cost is estimated to be 20% of the unit cost, and the ordering cost is USD 25 per order. If ASELSAN orders in quantities of 300 or more, it can get a 5% discount on the cost of the detectors. Should ASELSAN take the quantity discount? Assume the demand is constant. Total cost without discount is USD 562,366 and total cost with discount is USD 543,517. 3. The costs of placing an order are PHP 150. It is estimated that 1,000 units will be used in the next 12 months. The carrying cost per unit per month is PHP 2.50. a. Compute EOQ. b. What is the reorder point if leadetime is 4days? c. There is a 60% probability of stock-out. Compute for safety stock and revised reorder point if standard deviation is 2t E1