Assignment for 12/3/2020-MUST COMPLETE IN EXCEL (put each problem on a separate tab) and SUBMIT VIA CANVAS - Will be graded for accuracy, SHOW ALL WORK. 1. PRODUCTION AND PURCHASES BUDGETS (5 points) At the beginning of April, Pretty Pillow Co. had 3,400 pillows and 8,500 pounds of raw materials on hand. Budgeted sales for the next three months are: April 11,000 pillows May 12,000 pillows June 10,000 pillows Pretty Pillow wants to have sufficient raw materials on hand at the end of each month to meet 20% of the following month's production requirements and sufficient pillows on hand at the end of each month to meet 30% of the following month's budgeted sales. Two pounds of raw materials, at a standard cost of $2.20 per pound, are required to produce each pillow. a. Prepare a production budget for April and May. b. Prepare a purchases budget in units and dollars for April