Excel EOQ & Price-Break Optimisation Model -- 2

Offer description

Paid fixed-price test task: Excel model for order quantity and price-break optimisation. More work to follow if it goes well. We are a UK packaging distributor. We will provide an anonymised sample of about 50 items: annual demand and weekly variability, unit price at up to 3 price breaks, MOQ, pallet quantity, holding cost % and ordering cost per order. The model must: - Calculate the economic order quantity for each item, then adjust it for MOQ, price breaks and full pallets - Show the total annual cost (purchase + holding + ordering) at each feasible option and pick the lowest - Flag where moving up to a higher price break pays back after the extra holding cost, with the annual £ difference against the current order quantity - Test a one-off volume deal: is it worth taking, give...

Skills and categories

Similar offers