Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 75,240 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 228,000 units; third quarter, 500,000 units; and fourth quarter, 238,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 33% of the next quarters budgeted sales. (Ending inventory for the first quarter does not comply with company policy.) Each transmission requires 0.66 pounds of a key raw material. Electro Company aims to end each quarter with an ending inventory of direct materials equal to 33% of next quarter's budgeted materials requirements. Direct materials cost $184 per pound.

Prepare a direct materials budget for the second Quarter

I need to understand how to calculate budgeted ending inventory and budgeted beginning inventory.

Electro Company
Direct Materials budget
Second Quarter
Budgeted Production (units)	317,760	Units
Materials requirements per unit	0.66	lbs.
Materials needed for production (lbs)	209,722	lbs.
Budgeted Ending Inventory (lbs)		lbs.
Materials to be purchased (lbs)		lbs.
Materials Price per pound	$184	per lb.
Total Cost of Direct materials purchases