Speling Company has the following sales projection (in units) for the nex sx monehs Feb: 16000 Mar 19000 Apr 14000 May: 21000 Jun: 17000 Jul: 12000 Each unit sells for S40 Speling has prepared the folowing sales budget for the quater of Apri May and June Sales Budget May 17000 otal 2000 Sales in price per unit revenue 4000 $40 $560000 x $40 $840000 680000 $2080000 speling's cost of goods sold is 80% of ns sales revenue. The company has a poicy mat it keeps 10% of next mo es budget dast af gods sold as onding metry. The co Oany adea ty the budgeted amout of inventory on hand at April Prepare a purchases budget on paper or, PREFERABLY, in Excel for the quarter of Agnil, May and June Iif you build your schedule using formulas in excel, multipie attempts will be much faster ) What is the cost of inventory at April 1 (Beginning inventory What is the budgeted cost of purchases in May What is the desired cost of inventory at the end of the quarter