Excel EOQ & Price-Break Optimisation Model -- 2

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, given extra holding cost and a stock-ageing risk %?
- Keep all inputs on one labelled sheet, use formulas only (no macros), and include a short notes tab explaining the method

In your bid please give:
- A fixed price and delivery time for this task
- Your hourly rate for future work
- An example of a similar model (screenshots fine)
- Confirmation you will sign an NDA and assign IP to us

Strong Excel modelling essential; inventory, procurement or supply chain experience preferred. UK-based preferred. Power BI or SharePoint skills are a plus for later packages (supplier segmentation, buying plans, dashboards). Payment by milestone on acceptance.