Please answer this Question in a Table Clearly. Rquirements is in second picture. Answer what ever is blank and number the question and parts.

Better By the Numbers began operations on January 1, 2018. The company produces eight ounce bottles of hand and body lotion called Radiant One. The lotion is sold wholesale in 12- bottle cases for $100 per case. There is a selling commission of $20 per case. January 2018 direct materials, direct labor and factory overhead costs are as follows: DIRECT MATERIALS Cost Units per Cost per Behavior Case unit variable 100 oz. $ 0.02 variable 30 oz. $ 0.30 variable 12 bottles $ 0.50 Nutrient base Essential oils Bottle (8-oz.) Direct Materials Cost per Case $ 2.00 9.00 6.00 $ 17.00 Department Cost Behavior variable variable DIRECT LABOR Time per Labor Rate Case per Hour 20 min. $ 18.00 5 min. $ 14.40 25 min. Mixing Filling Direct Labor Cost per Case $ 6.00 1.20 $ 7.20 FACTORY OVERHEAD Cost Behavior Total Cost Utilities mixed $ 600 Facility lease fixed 14,000 fixed Equipment depreciation 4,300 fixed Supplies 660 $ 19,560 C: AUGUST VARIANCE ANALYSIS part C: Aud August was completed, variance analysis needs to be performed. After August w January operating noperating data provided the standard prices, rates, times, and quantities per case. here were 1,500 actual cases produced during August, 250 more than planned at the beginning of the month. Actual August data: Actual Direct Materials Quantity per Case Nutrient base Essential oils Bottle (8-oz.) Actual Direct Materials Price per Unit $0.016 per oz. $0.32 per oz. $0.42 per bottle Actual Direct Labor Rate 102 ozs. 31 oz. 12.5 bottles Actual Direct Labor Time per Case 19.5 min. 5.6 min. Mixing Filling $ 18.20 $ 14.00 The standard quantity of materials used per case was an ideal standard. Actual Variable Overhead was $305 Standard (Budgeted) Volume was 1,600 cases Requirements: 10. Determine and interpret (favorable/unfavorable) the direct materials price and quantity variances for each of the three materials 11. Determine and interpret the direct labor rate and time variances for the two departments, rounding hours to the nearest hour 12. Determine and interpret the factory overhead controllable variance 13. Determine and interpret the factory overhead volume variance 10.Direct Materials Price Variance: Nutr! BASE 68 Sen OILS BOTTLES Interpretation Frvonrable nnfowerobe Forrowroble 30 120 Price (nov): Acthont anonity (sto unit Price - Actual unit : 1500 x 10.02 -0.016) = -1500 Y (0.30 -0.32) --30 = 1600 X 10.50 -0.42) 120 Direct Materials Quantity Variance: Nutr. RASE Essm, OILS BOTT IL COMPREHENSIVE PROBLEM 11. Direct Labor Rate Variance: Continued aunthos and wei Sh MIXING FILLING DEPARTMENT DEPARTMENT Wowok 6000 Forwombok 3000 Lav Auntal time (old morte -Acthard hote) 30,000 (18 - 18.20) 6000 760 (N10-14) 3000 Direct Labor Time Variance: MDONG DEPARTMENT FILLING DEPARTMENT COMPREHENSIVE PROBLEM Continued 12.Factory Overhead Controllable Variance: 13.Factory Overhead Volume Variance