please help me with this excel practice assignment

B C D 1) Cahuilla Corporation predicts the following sales in units for the coming four months Sales in units April 240 May 280 June 300 July 240 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 finished goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of B. Each month's ending Raw Materials Inventory should be 30% of the following month's production needs. 1). Prepare the production budget for May and June. 2) Prepare the raw material purchase budget for May and June. 3 Name of Company Production Budget 9 April May June 0 1 Next Month's Budgeted Sales 2 Ratio of Inventory to future sales 3. Budgeted Ending inventory (in units) 4 Add: Budget sales for the month Total required Units for production 6 Less: Budgeted beginning Inventory Units to be produced 18 19 10 April May June Units to be produced Material required per unit Material needed for production Budgeted ending inventory Total material required Less: Beginning Inventory Material to be purchase Purchase Price per unit Total cost of material to be purchased