In this work you must present in PDF FORMAT (Excel files are not accepted), you must show ALL the calculations that help you decide the final decision, the discussion must be justified based on the numbers.

Problem Due to COVID-19 issues, MPG Corporation is experiencing inventory issues. The Christmas season is approaching, and decisions must be made so as not to have a shortage of products, but not overproduction. Faced with this challenge, which represents a demand that is difficult to forecast, MPG must take risks, but the CEO wants to hear from his business advisers what is the best offer to buy a THM-480 product that has a daily demand of 37 units per day. For each order, the company must pay $ 400, in addition historically the rate of maintaining inventory has been assessed at 32%. It is important to take into account that the company has a daily storage capacity of 40 units, for each additional unit that it stores there is a cost of $ 1. What is the recommendation that you would give to the CEO, justify his answer, do not round values until the end of your study! Remember that you cannot send the excel sheet as an answer, if so, your grade will be 0.

All your work must be in the solution (including individual costs, EOQ, number of orders, etc.)

Discount Number Discount Quantity Discount (%)

1 0 to 499 0

2 500 to 999 3

3 1000 to 1499 3.5

4 1500 to 1999 3.9

5 2000 and over 4.2