Q. Can you please complete this by 2am. It's due 4/28 at 7am. I will increase bid to $30.
"Gustavo Supply is a merchandiser of three different products. The company’s February 28 inventories are footwear, 18,500 units; sports equipment, 80,000 units; and apparel, 50,000 units. Management believes that excessive inventories have accumulated for all three products. As a result, a new policy dictates that ending inventory in any month should equal 29% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow.
Using MS Excel, prepare a merchandise purchases budget (in units) for each product for each of the months of March, April, and May"

part 2: Analysis Component to be completed using MS Word

The purchases budgets for Gustavo Supply should reflect fewer purchases of all three products in March compared to those in April and May. What factor caused fewer purchases to be planned? Suggest business conditions that would cause this factor to both occur and impact the company in this way."