Using Basic EOQ Model please solve the situation( explain it in Excel Form with formula) IVA will launch it's newly registered proprietary product Double Nickel 250 WDG as a control of black sigatoka diseases in banana which is sourced from Certis USA. The company wants to know the optimal order size and total inventory cost for the product given an estimated annual demand of 8,000 Kg, an annual carrying cost of Php 40 per kilogram and an ordering cost of Php 8,500. The Supply Chain department wants to know also the number of orders annually, the time between orders (order cycle), and the re-order point. The company office is open at a total of 264 days in a year and the supplier's lead time is 45 days.

Given:
Demand (D)	8000	Kg
Carrying Cost (Cc)	40	Php/Kg
Ordering cost (Co)	8500	Php
d=Demand/264 days	30.303	kg/day
Lead time (L)	45	days
Re-order '(R) = dL	1363.64	Kg