If someone could help me solve this. I would like formulas for each to know how to solve in the future. Thank you.

Hank Manufacturing makes cleaning solvent sold in large containers with a plastic liner. Company policy requires that ending inventories of raw materials for each month be 15% of the next month's production needs. The policy was met for the ending inventory of December in the prior year. The cost of one gallon of chemicals is $2.00. Th cost of one liner is $1.60. 1. Calculate the ending inventory of chemicals (in gallons) for December of the prior year, and then for January and February. (3 points-must use a formula/calculation in each cell) JaFD1 2. Calculate the ending inventory of plastic coating (in units) for December of the prior year, and then for January and February. (3 points-must use a formula/calculation in each cell) 3. Complete a direct materials purchases budget for the chemicals (in gallons) for January. ( 10 points-must use a formula/calculation when necessary). Hint: Remember to use accounting underlining