Excel formula for units of production depreciation

Excel formula for units of production depreciation

In production, depreciation occurs whenever an asset losses its value due to heavy use. When considering the units of production, depreciation is not calculated based on the duration an asset is used, but rather, it is calculated based on the number of units produced. For instance, if an asset K produces 50 units and the