Question: hello if possible please use excel thanks (2 marks) M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other

hello if possible please use excel thanks
hello if possible please use excel thanks (2 marks) M. Cotteleer Electronics

(2 marks) M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. One of Cotteleer's components has an annual demand of 265 units, which is constant throughout the year. The carrying cost is estimated to be $1.25 per unit per year and the ordering cost is $19 per order. Please show your work for full points. (a) To minimize cost, how many units should be ordered each time an order is placed? (0.5 mark) (b) How many orders are needed per year with the optimal (c) What is the total annual cost of ordering and holding inventory? policy? (0.5 mark) mark)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!