*** Please give me a clean and clear process or interpretation of the answer. If you have used Excel, plz paste the data that you have used to solve the question as well.

1. I am in charge of inventory management at a department store that is open 365 days a year. Data such as the example were collected while reviewing the inventory of heaters among the products. I decided to apply the EOQ model to derive the optimal order amount (Q). Accordingly, the optimal order amount (Q), the total cost (TC), the number of orders per year (N), order cycle per year.T), and the reorder point (R) are? (up from the first decimal place)

example)

Annual Demand(D) = 6000 / Purchase price(P) = 50

Annual inventory maintenance cost(H) = 25 / Ordering Cost(S) = 30 / Lead Time = 5 Days