ColorfulFurniture is preparing budgets for the second quarter ending June 30, 2020.For each requirement below prepare budgets by month for April, May, and June, and a total budget for the quarter.

1.The previous year's sales (2019) for the corresponding period were:

April 594

May 748

June 1,012

Quarter 2,354

July 1,342

August 825

1.The company desires to have finished goods inventory on hand at the end of each month equal to 10 percent of the following month's budgeted unit sales.On March 31, 2020, the company expects to have 65 sofas on hand. (Note: an estimate of sales in July is required in order to complete the production budget for June). make a production budget