I need help completing requirements 10-12. I got stuck after 10 and I don't know if it's correct. Attached are the other requirements already completed. Also under requirements 10-12, I don't know what to respond to analysis other than "the answer shows favorable or unfavorable." Again requirements 1-9 are already completed and attached below so you can see the progress.

Part A. Break-even Analysis The management of Quivers Inc. wants to determine the number of cases required to break even per month. The utilities cost, which is part of factory overhead , is a mixed cost. The following information was gathered from the first six months of operation regarding this cost: Utility Total Month Case Production Cost January 500 600.00 February 800 660.00 March 1,200 740.00 April 1,100 720.00 May 750 690.00 June 1,025 705.00 Instructions $1. Determine the fixed and variable portion of the utility cost using the high-low method. 2. Determine the contrinution margin per case. 13. Determine the fixed costs per month, including the utility fixed cost from question (1). 14. Determine the break-even num ber of cases per monthA B C D E F G H I J K L M N Requirement #4: Develop the direct materials purchases budget. Quivers Inc. Direct Materials Purchases Budget For the Month Ended August 31 Cream Natural Oils Bottles Total Base (oz.) (oz.) (bottles) Units required for production 137,500 41,250 16,500 Raw Materials Plus desired ending inventory 1,000 360 240 Units x Volume = Total Total units required 138,500 41,610 16,740 Cream Base 100 1,375 137,500 Less estimated beginning 250 290 600 41,250 inventory Natural Oils 30 1,375 Total materials to be 138,250 41,320 16,140 12 purchased Bottles 1,375 16,500 * Unit price $0.02 $0.30 $0.50 Total direct materials to be $2,765 $12,396 $8,070 purchased $23,231A B C D E F G H J K L Requirement #7: Develop the direct labor cost budget. Quivers Inc. Direct Labor Cost Budget For the Month Ended August 31 Labor Mixing Filling Total Units x Production Time ,Hour = Total Mixing 1,375 20 60 458 Hours required for 20 5 5 production of: 60 Filling 1,375 115 Ophelia Wax Product 458 115 x Hourly rate $ 18.00 $ 14.40 Total direct labor cost $8,250.00 $1,650.00 $ 9,900.00Requirement #8: Develop the factory overhead cost budget. Quivers Inc. Factory Overhead Cost Budget For the Month Ended August 31 Cost Fixed Variable Total Cases Cost Total Fixed Cost [ from Question 3] 1,375 500 19,460 Utilities 500 $ 275 $775 Variable Utility Cost 1,375 $ 0.20 19,735 Facility Lease 14,000 $14,000 Equipment Depreciation 4,300 $4,300 Supplies 660 $660 Total factory overhead cost $ 19,735A B C D E F G H K L Requirement #9: Create the budgeted income statement. Quivers Inc. Budgeted Income Statement Units x Price = Total For the Month Ended August 31 Sales 1,500 100.00 150,000 Sales $ 150,000 Selling Expenses 1,500 20.00 30,000 Finished goods inventory, August 1 Direct materials: $ 12,000 Direct materials inventory, August 1 392 Direct materials purchases [from Question 6] 23,231 Cost of direct materials available for use 23,623 Less direct materials inventory, August 31 248) Cream Base (oz.) Oils (oz.) Bottels (oz.) Total Cost of direct materials placed in production 23,375 Direct materials inventory, Augu 250 290 600 1,140 Direct labor [from Question 7] 9,900 Direct materials inventory, Augu 1,000 360 240 1,600 Factory overhead [from Question 8] 19,735 Cost of goods manufactured 53,010 Rate Cost of finished goods available for sale 65,010 Cream Base (oz.) 0.02 Less finished goods inventory, August 31 (7,000) Oils (oz. 0.30 Cost of goods sold 58,010 Bottels (oz.) 0.50 Gross profit 91,990 Selling expenses 30,000) Income from operations S 61,990A B C D E F G H J K Requirement #10: Determine the direct materials variance. Direct Materials Price Variance Actual Quantity Cream Base Natural Oils Bottles Cream BaseNatural Oil: Bottles Cases 1,500 1,500 1,500 Actual Price 0.02 $ 0.32 $ 0.42 Amount 102 31 12.5 Standard Price 0.02 $ 0.30 0.50 Total 153,000 46,500 18,750 Difference ($0.00) $0.02 ($0.08) *Actual Quantity (Units) 153,000 46,500 18,750 $ (612.00) $ 930.00 $ (1,500.00) Decision Favorable Unfavorable Favorable Analysis Direct Materials Quantity Variance Standard Quantity Cream Base Natural Oils Bottles Cream BaseNatural Oil: Bottles Cases 1,500 1,500 1,500 Actual Quantiy 153,000 46,500 18,750 Amount 100 30 12.0 Standard Quantity 150,000 45,000 18,000 Total 150,000 45,000 18,000 Difference 3,000 1,500 750 Standard Price 0.02 $ 0.30 $ 0.50 Direct MalenaIs QUOTmy $ 60.00 $ 450.00 $ 375.00 Decision Unfavorable Unfavorable Unfavorable AnalysisA B C D E F G H K Requirement #11: Determine the direct labor variance. Direct Labor Rate Variance Actual Time Mixing Filling Mixing Filling Department Departmen Actual Rate Units Standard Rate Minutes Difference Hours Actual Time (Hours) Total Direct Labor Rate Variance Decision Analysis Direct Labor Time Variance Standard Time Mixing Filling Mixing Filling Department Departmen Actual Time Units Standard Time Minutes Difference Hours Standard Rate Total Direct Labor Time Variance Decision AnalysisA B C D E F G Requirement #12: Determine the factory overhead variance. Factory Overhead Controllable Variance Variance overhead (utility cost) at standard cost Actual variable overhead Cases Variable overhead at standard cost Total fixed factory overhead Factory overhead controllable variance Total Decision Factory Overhead Volume Variance Fixed factory overhead rate Normal volume (cases) Cases Actual volume (cases) Total fixed factory overhead Difference Total * Fixed factory overhead rate $0.00 Decision AnalysisPart B. Budgets During July of the current year , the management of Quivers Inc. asked the controller, Robin, to prepare August manufacturing and income statement budgets. Demand was expected to be 1,500 cases of jet wax at $100 per case for August. Inventory planning information is provided as follows : Finished Goods Inventory Cases Cost Estimated finished goods inventory, Aug 300 # # # # # # Desired finished goods inventory, August 175 $7,000.00 Materials Inventory Cream Base (oz.) Oils (oz.) Bottels (oz.) Estimated materials inventory, August 1 250 290 600 Desired materials inventory, August 31 1,000 360 240 There was negligible work in process inventory assumed for either the beginning or end of the month; thus, none was assumed. In addition, there was no change in the cost per unit or estimated units per case operating data from January. Instructions 5.Prepare the August production budget. 6.Prepare the August direct materials purchases budget. 7.Prepare the August direct labor cost budget. Round the hours required for production to the nearest hour. 8.Prepare the August factory overhead cost budget. 9.Prepare the August budgeted income statement, including selling expenses.Part C. August Variance Analysis During September of the current year, Robin was asked to perform variance analyses for August. The January operating data provided the standard prices, rates, times, and quantities per case. There were 1,500 actual cases produced during August, which was 250 more cases than planned at the beginning of the month. Actual data for August were as follows: Actual Direct Actual Direct Material Materials Price Materials per Unit Quantity per Case Cream Base 0.016 102 (oz.) Natural Oils 0.32 31 (oz.) Bottles 0.42 12.5 Actual Direct Activity Actual Direct Labor Time Labor Rate per Case (minutes) Mixing 18.20 19.50 Filling 14.00 5.60 Actual Variable Overhead 305.00 Normal Volume (Cases) 1,600The prices of the materials were different from standard due to fluctuations in market prices. The standard quantity of materials used per case was an ideal standard. The Mixing Department used a higher grade labor classification during the month, thus causing the actual labor rate to exceed standard. The Filling Department used a lower grade labor classification during the month, thus causing the actual labor rate to be less than standard. Intruction S 10. Determine and interpret the direct materials price and quantity variances for the three materials. 11. Determine and interpret the direct labor rate and time variances for the two departments. Round hours to the nearest hour. 12 . Determine and interpret the factory overhead controllable variance. 13.Determine and interpret the factory overhead volume variance. Assess why are the standard direct labor and direct materials costs in the calculations for parts (10) and (11) based on the actual 1,500-case production volume rather than the planned 1,375 cases of production used in the budgets for questions (6) and (7)3A B C E F G H I J K 1 REQUIREMENT #1: Determine the fixed and variable portion of the utility cost using the high 2 High-Low Method Variable Differen Cost per Difference in Total Cost ce in Linit Producti 0.20 140 700 Variaby Total Cost e Cost Linits S + per Unit Fixed Prod Costs High Point 740.00 0.20 X 1,200 + $500.00 9 Low Point 600.00 = 0.20 X 500 $500.00 10A B C D E F G H REQUIREMENT #2: Determine the contrinution margin per case. Contribution Margin Selling Price 100.00 Less variable costs per case: Direct materials 17.00 Direct labor 7.20 Utilities /see Him-Low Method) 0.20 Selling expenses 20.00 Total variable costs per case 44.40 Contribution margin per case $ 55.60REQUIREMENT #3: Determine the fixed costs per month, including the utility fixed cost from question (1). Total Fixed Costs Utilities [see High-Low Method] 500 Facility lease $ 14,000 Equipment depreciation $ 4,300 Supplies 660 $ 19,460A E Requirement #4: Determine the break-even num ber of cases per month. Break-even Analysis Unit Break-even Sales (units) Fixed Costs Contribution Margin 350 = 19,460.00 55.60A B C D E F REQUIREMENT #5: Develop the production budget. Quivers Inc. Production Budget For the Month Ended August 31 Cases Expected cases to be sold 1,500 Plus desired ending 175 inventory Total units required 1,675 Less estimated beginning -300 inventory Total units to be 1,375 produced