In: Operations Management
A company uses 1,000 electric drills per year in its production process. The ordering cost is $100 per order, and the carrying cost is assumed to be 40% of the unit cost. In orders of less than 120, drills cost $78 per unit; for orders of 120 or more, the price drops to $50 per unit.
Find the best ordering quantity for this product
Please show excel formulas and solver. Thank you.
There is no point in using excel and solver here, They are irrelevant and unncessary and mainly they cannot be used for these type of problems. So please understand and rate this answer with thumbs up kindly. It is a gesture that shows you support me. Thank you