I have this question as a homework and i dont know how to solve it can you please show me the solving and explanation ( please submit solving in excel form sheet ) , thank you so much

Question 2 Plano Products manufactures a wide variety of chemical compounds and liquids for industrial uses. The standard mix for producing a single batch of 100 liters of its biggest selling product is as follows. Input Chemical Quantity (In liters) Cost (per liter) Total Cost Chem-A 20 $ 9 $ 180 Chem-B 60 12 720 Chem-C 45 24 1,080 125 $1.980 There is a standard 20 percent loss in liquid volume during processing due to evaporation. The finished liquid is put into 10-liter containers for sale. Thus, the standard material cost for a 10-liter container is $198 [ ($1.980 : 100 liters) x 10 liters per container] The actual quantities of direct materials and the cost of the materials placed in production during September were as follows ( materials are purchased and used at the same time). Input Chemical Quantity (in liters) |Total Cost Chem-A 16,960 $ 149.248 Chem-B 50.400 607,320 them-C 37,040 898,220 104 400 $1654.788 A total of 8,000 containers (80,000 liters) were produced during September Page 238 Required Calculate the total direct material variance for the liquid product for the month of September and then further analyze the total variance into: a. Materials price and efficiency variances