Answer in excel

Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 3,000 units plus 20% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 12.600 units. b. The raw materials inventory on hand at the end of the month must be equal to 40% of the following month's production needs for raw materials. The raw materials inventory on June 30 for material R2D8 is budgeted to be 40.320 pounds. The cost per pound of raw material is $3.50. c. The company maintains no work in process inventories and the selling price per unit of Super Jet dry is $47.50. A sales budget for Super Jet dry for the last six months of the year follows: July August September Budgeted Sales in Units 48.000 60.000 75,000 40.000 30,000 20,000 October November December Required: a. Prepare a sales budget for Super Jet dry for the months of July, August, and September, and the quarter in total. b. Prepare a production budget for Super Jetdry for the months of July, August, and September and the quarter in total. c. Prepare a direct material purchases budget showing the quantity and cost of material R2D8 to be purchased for July, August, and September and for the quarter in total. July August September Quarter Sales Budget Sales in units Price Total Sales Revenue Production Budget Sales in units Ending Inventory Needed Beginning Inventory Units to be produced Direct Materials Purchases Production in units Pounds Required Ending Inventory Needed Beginning Inventory Purchases Cost DM Cost