Final answer:
To find the new optimal inventory policy and the total variable inventory cost per year (TVC), Tim Madsen can use the EOQ model with planned shortages. Solver can calculate the optimal order quantity, the number of orders per year, and the TVC.
Step-by-step explanation:
To find the new optimal inventory policy and the total variable inventory cost per year (TVC), Tim Madsen can use the EOQ model with planned shortages. In this model, the unit shortage cost is $200. By using Microsoft Excel Solver, Tim can input the relevant data, such as the unit cost of $3,000, the annual cost of holding items in inventory estimated at 20% of purchase cost, and the administrative cost of placing each order being $75. Solver can then calculate the optimal order quantity, the number of orders to be placed per year, and the total variable inventory cost per year.