Simulation with excel.

Within the Farm, there is the grain and seed distributor $"$ Desde que amanece $".$ Given the increase in the price of corn, an analysis is proposed to determine the purchasing policy for said grain.

Based on historical sales data, the business manager has determined that daily demand behaves according to a normal distribution with a mean of $50$ bags of corn and a standard deviation of $5$ bags.

Currently the manager places an order for bags of corn every time the product runs out $($looking at the day's initial inventory$)$ but has decided to try two new policies:

$1.$ Order $200$ bags when inventory reaches $40$ units or less $($viewing inventory

start of the day$).$

$2.$ Order $1000$ bags monthly $($every $20$ days$)$ to achieve said inventory level.

Consider that on the first day an order is raised for $1000$ bags.

Considering:

$-$ Supplier delivery time is $1$ day

$-$ Start inventory of the simulation $170$ bags of corn

$-$ Cost of keeping $1$ bag in warehouse: $$50$ per day

$-$ Freight paid for a truck to receive the product $($it costs the same whether you order $1$

bag or $1500)$: $$50,000$ per order

Cost of lost sales: $$500$ per bag

$-$

Tip:

Each day record the beginning inventory, sales, ending inventory and the $3$ costs: holding cost $($depends on ending inventory$),$ ordering cost $($if an order is placed that day and freight is paid$)$ and cost of lost sales $($ if demand is greater than inventory at the beginning of the day$)$