Solve on excel and show how you got answer please!

Budgeted sales of gloves for First Fleet for the first six months of the year 2018 are as follows: Months January February March April May June Unit Sales 350,000 410,000 380,000 360,000 640,000 750,000 The beginning inventory for 2018 is 105,000 units. The budgeted inventory at the end of a month is 30 percent of units to be sold the following month. Purchase price per unit is $3 per unit. Required: Prepare a purchases budget in units and dollars for each month, January through May