$$ Problem statement $------------$Consider a retail chain $$Dhupchick$$ in Mumbai with three stores: Store Andheri, Store Borivali, and Store Chembur. The chain sells three products: Product $1,$ Product $2,$ and Product $3.$ These products are stored in a central warehouse, which has limited capacity.

$$ The task is to determine how much of each product should be ordered for each store and how much should be kept in the warehouse, minimizing the total costs associated with ordering, transportation, and holding, while meeting each store's demand.

$$ Data Overview Demand at Each Store $($units$)$:

$$ Store A: Product $1$: $100,$ Product $2$: $80,$ Product $3$: $60$

$$ Store B: Product $1$: $120,$ Product $2$: $90,$ Product $3$: $70$

$$ Store C: Product $1$: $110,$ Product $2$: $85,$ Product $3$: $75$

$$ Costs $($per unit$)$:

$$ From Warehouse to Store A: Product $1$: $$2,$ Product $2$: $$3,$ Product $3$: $$1$

$$ From Warehouse to Store B: Product $1$: $$3,$ Product $2$: $$2,$ Product $3$: $$2$

$$ From Warehouse to Store C: Product $1$: $$4,$ Product $2$: $$3,$ Product $3$: $$3$

$$ Holding Costs at Warehouse: Product $1$: $$0\mathrm{.}50,$ Product $2$: $$0\mathrm{.}75,$ Product $3$: $$0\mathrm{.}25$

$$ Warehouse Capacity: $500$ units

$$ Objective and Constraints Objective: To minimize the total cost of inventory management, including ordering, transportation, and holding costs, while ensuring that the demand at each store is fully met.

$$ Constraints:

$1.$ The total number of units stored in the warehouse cannot exceed $500$ units.

$$ The quantity of each product delivered to each store must meet or exceed the store's demand Constraints Demand Satisfaction

Warehouse Capacity y$1+$y$2+$y$3<=500.$ Solve the problem in excel sheet