Reference no: EM132596629

National Bakery Limited is the main supplier of a variety of baked products to customers in Kingston. The company currently makes 25,000,000 a variety of baked products annually which uses baking flour. Production takes place evenly during the year. Each baked product uses 0.0002 kilogram of baking flour and the baking flour is used evenly during the period. National sells the baked products for $120 each which includes a mark-up of 20%. However, the operations manager believes that profits could increase if the company departs from the current policy. Currently, the company makes five equal orders per year. That is, the entity orders five times annually and orders are made instantaneously.

The chief executive officer (CEO) does not believe that the current order quantity is the optimal order quantity. As a result, he spent $10,000.00 last month to ascertain whether the optimal order quantity is different from the current policy. Moreover, he held discussion with the main suppliers of baking flour and was told that the current purchase can be reduced if the company orders more than the current lot size.

Further discussions indicated that the cost per kilogram would vary based on the quantity to be bought. A 2.5% discount will be given for orders doubling the current lot size, 5% discount for orders of 1,500 kilograms above the current lot size, 7.5% discount if the current lot size is four times the current lot size. It is also expected that orders will be made instantaneously and there will be no lead time between ordering and receiving the raw material. No discounts are given for orders less than the current lot size.

It was further highlighted that the entity designates an employee to place all orders; the employee is paid $62.50 per hour and each order takes on average six hours. Additionally, a transportation charge of $125 is associated with each order. The cost of storing is to be $15 per unit of average stock plus an opportunity cost. Furthermore, the opportunity cost of holding one kilogram is expected by be 10% of the current purchase cost. The current purchase price is 50% of the cost of each baked product.

Required:

Question a. how to calculate the EOQ based on the formula.

Question b. how to calculate the total cost based on the EOQ.

Question c. how to calculate the total cost for each alternate order quantities including the current policy.

Question d. Which order quantity is considered the optimal order quantity and why?