Build Excel Simulation Models for an Inventory Control system with $($T$,$ Q$)$ Policy. Below is the

description of how this system works.

Assume that a company sells a product whose daily demand follows a simple discrete

distribution with a few possible values. Here is the distribution:

Demand $10203040$

Probability $0\mathrm{.}250\mathrm{.}350\mathrm{.}250\mathrm{.}15$

The inventory policy is it orders and receives every T days with a quantity of Q$.$ For example,

T$=10$ and Q$=200.$ The holding cost is $$0\mathrm{.}5/$day per unit and each order$$s fixed cost is $$200$

$($paperwork plus transportation cost$).$ Backorder is allowed and costs $$6/$day per unit.

Please build an Excel$-$based simulation model for such an inventory system. Simulate $20$ days.

Then use Data Table approach to investigate the optimal T for a given Q$=200($Replicate $20$

times$).$ I need clear answers step by step on Excel