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.

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

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 Finance Questions!