Neat Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $ 2,002,000 in September, $ 2,200,000 in October, $ 2,383,000 in November, and $ 2,530,000 in December. Neat Logos sets its prices to earn an average 40% gross profit on sales revenue. The company does not want inventory to fall below $ 445,000 plus 15% of the next month's cost of goods sold. Prepare a cost of goods sold, inventory, and purchases budget for the months of October and November.

If possible, could you show the steps? I am confused on how to calculate these numbers. Thank you!

Neat Logos Cost of Goods Sold, Inventory, and Purchases Budget For the Months of October and November October November Cost of goods sold Plus: Desired ending inventory Total inventory required Less: Beginning inventory Purchases