please show work. the two blanks in the left column should come from the drop down in the last picture

Annie's Homemade prepares a direct materials budget for its ice cream base, which is the foundational component of all ice cream flavors. It includes ingredients such as whole milk, heavy cream, and sugar that provide a "blank canvas" for creating create specific flavors. The company buys ice cream base from a supplier for $62 per case, each of which contains two 2.5-gallon bladders. Each 2.5 gallon bladder produces an average of 40 servings of ice cream. The company always maintains ending inventories equal to 20% of next quarter's production needs. The estimated quarterly production (in servings) for next year are as follows. Required: Prepare a direct materials budget by quarter and in total for next year. Required production in servings Servings per case Number of cases needed to meet production Add desired ending inventory in cases Less beginning inventory in cases Less desired ending inventory in cases