I've already figured out the sales budget and production budget. Please help with the Direct Material's Budget for Cacao Beans.

The ChocoAlmo Company produces and sells chocolate bars filled with almond pieces. The 6-oz chocolate bar has two direct materials: 100% organic cacao beans and 100% organic almonds. The production process includes creating the chocolate from scratch using the cacao beans and chopping the almonds into the pieces that fill the chocolate bar. Indirect materials include very minimal amounts of sugar, milk, and salt, in addition to some packaging materials. ChocoAlmo is preparing budgets for the 2nd quarter ending June 30, 2021. For each requirement below prepare budgets by month for April, May and June, and a total budget for the quarter.

1. The previous years sales (2020) for the corresponding period were:

April May June July August

35,000 chocolate bars 44,000 chocolate bars 37,000 chocolate bars 45,000 chocolate bars 42,000 chocolate bars

The company expects the above volume of bar sales to increase by 7% for the period April 2021 August 2021. The budgeted selling price for 2021 is $9.00 per chocolate bar. The company expects 85% of its sales to be cash (COD) sales. The remaining 15% of sales will be made on credit. Prepare a Sales Budget for ChocoAlmo.

2. The company desires to have finished goods inventory on hand at the end of each month equal to 14 percent of the following month's budgeted unit sales. On March 31, 2020, the company expects to have 5,243 chocolate bars on hand. (Note: an estimate of sales in July is required in order to complete the production budget for June). Use the @ROUND function to round to the nearest whole number the number of chocolate bars desired in ending inventory. Prepare a Production budget.

3. The chocolate bars require two direct materials: Cacao Beans and Almonds.

Cacao Beans

Each chocolate bar requires 0.45 pounds (lbs) of Cacao beans. Management desires to have materials on hand at the end of each month equal to 11 percent of the following month's chocolate bar production needs. Use the @ROUND function to round to the nearest whole number the number of pounds of cacao beans desired in ending inventory. The beginning inventory of cacao beans, in April 2021, is expected to be 1,921 pounds. Cacao beans are expected to cost $8 per pound. (Note: budgeted production in July is required in order to complete the direct materials budget for June. Our supplier only allows purchases in whole pounds, so use the @ROUND function to round to the nearest whole number the number of pounds to purchase).

Almonds

Each chocolate bar also requires 0.10 pound of almonds. Management desires to have almonds on hand at the end of each month equal to 15 percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of pounds of almonds desired in ending inventory. The beginning inventory, in April 2021, is expected to be 582 pounds of almonds. Almonds are expected to cost $7 each. (Note: budgeted production in July is required in order to complete the direct materials budget for June. Use the @ROUND function to round to the nearest whole number the number of pounds of almonds to purchase.

Prepare a Direct Materials budget. Also, because two direct materials are required for production cacao beans and almonds - you will need a separate schedule for each direct material.