# Formulas

I need help with set-up, formulas, to calculate the problem.

---

1. I Carry rent trucks for moving and hauling. Each truck costs the company an average of $8,000, and the inventory of trucks varies monthly depending on the number that are rented out. During the first 8 months of last year, I Carry had the following ending inventory of trucks on hand:

MONTH NUMBER OF TRUCKS MONTH NUMBER OF TRUCKS

January 26 May 13

February 38 June 9

March 31 July 16

April 22 August 5

I Carry use a 20 percent annual interest rate to represent the cost of capital. Yearly costs of storage amount to 3 percent of the value of each truck, and the cost of liability insurance is 2 percent.

a. Determine the total handling cost incurred by I Carry during the period January to August. Assume for the purposes of your calculation that the holding cost incurred in a month is proportional to the inventory on hand at the end of the month.

b. Assuming that these 8 months are representative, estimate the average annual cost of holding trucks.

---

(Full problem also found in attached file)

Â© BrainMass Inc. brainmass.com March 4, 2021, 6:27 pm ad1c9bdddfhttps://brainmass.com/business/inventory-management/formulas-45436