Description: The Lopez Brake and Muffler shop installs mufflers on most domestic and foreign cars. The mufflers needed are bought for $30 each and are ordered in quantities of 1,300 units. Annual demand is 5,200 mufflers, the annual inventory holding cost rate is $3 per unit, and the order placing c cost is estimated to be $50. Calculate the following:

1. Average inventory level
2. The number of orders placed per year
3. The total annual inventory holding cost
4. The total annual ordering cost
5. The total annual cost

Format: This assignment is meant to be completed using a spreadsheet. You may submit it as an Excel file, though you may copy and paste your spreadsheet into the Word document and submit it that way if you prefer. Submit this assignment here.