Now assume infinite time horizon (Periods 1, 2, 3, ..., o), constant demand and MC **** as above, and the discount rate of 30%. In this case, Excel simulations show that the resource will be depleted/consumed over longer than 2 periods (5 actually): (You can play with the Depletion Simulation.xls in the Homework folder but need Excel Solver In Excel, go to File Options => Add-Ins => Manage: Excel Add-ins => Solver Add-in)