Question: This question is based on the economic order quantity (EOQ) theme. OurNon-ExistentWidgetCompany needs 1200 widgets every month. Widgets cost $500 each, but every time that

This question is based on the economic order quantity (EOQ) theme. OurNon-ExistentWidgetCompany needs 1200 widgets every month. Widgets cost $500 each, but every time that it orders one or more widgets, there is an order (or delivery) cost of $20. The annual holding cost of a widget is 20% of the purchase cost of a widget. a) Based on the Economic Order Quantity (EOQ) model, what is the optimal number of widgets to order at a time? Show clear calculations to get your result, with clearly documented cross-reference to any spreadsheet tab that you might use. Such a spreadsheet tab should also be clearly laid out. Clearly explain your working (4 marks) b) Following on your answer to a) immediately above, how many orders should be placed per annum? Again, show clear calculations to get your result, with clearly documented cross-reference to any spreadsheet tab that you might use. Such a spreadsheet tab should also be clearly laid out. Clearly explain your working. (4 marks) c) Re-visiting (a) above but now require that the number of widgets that must be ordered is an integer. What is the optimal number of widgets to order at a time? Again, show clear calculations to get your result, with clearly documented cross- reference to any spreadsheet tab that you might use. Such a spreadsheet tab should also be clearly laid out. Clearly explain your working. (2 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
