Not sure if all pics are needed but I included them. Just need 13.
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 $95 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.06 variable 30 oz. $0.34 variable 12 bottles $ 0.60 Nutrient base Essential oils Bottle (8-oz.) Direct Materials Cost per Case $ 6.00 12.00 7.20 $ 25.20 Department Cost Behavior variable variable DIRECT LABOR Time per Labor Rate Case per Hour 15 min. $ 20.00 6 min. $ 15.50 21 min. Mixing Filling Direct Labor Cost per Case $5.00 1.55 $ 6.55 FACTORY OVERHEAD Cost Behavior Total Cost Utilities mixed $ 600 Facility lease fixed 14,000 Equipment depreciation fixed 4,300 Supplies fixed 512 $ 19,412 The management of Better by the Numbers would like to determine the number of cases required to break-even per month. Utilities cost, a part of factory overhead, is a mixed cost. Following is information gathered for the first six months of operations regarding total utilities costs: 2018 Case Production Utility Total Cost January 500 $ 510 February 800 585 March 664 1,100 640 May 950 590 June 1,025 Regeirements: Determine the fixed and variable portion of the utility cost using the high-low method. Determine the contribution margin per case. Determine the fixed costs per month, including the utility fixed cost from part (1). Determine the break-even number of cases per month 1,200 April 635 Part B: AUGUST BUDGETS August demand is expected to be 1,500 cases at a sales price of $100 per case. Inventory planning information follows: Estimated finished goods inventory, Aug. 1* 280 cases $12,880 Desired finished goods inventory, Aug. 31" 175 cases $ 7,719 Nutrie Estimated materials inventory, Aug. 1" Desired materials inventory, Aug. 31" Nutrient Base 350 oz. 600 oz. Oils 280 oz. 180 oz. Bottles 100 72 Work in process inventory was neolicihle se none is assumed August demand is expected to be 1,500 cases at a sales price of $100 per case. Inventory planning information follows: Estimated finished goods inventory, Aug. 1st 280 cases Desired finished goods inventory, Aug. 31st 175 cases Nutrient Base Estimated materials inventory, Aug. 1st 350 oz. Desired materials inventory, Aug. 31 6 00 oz. $12,880 $ 7,719 Oils Bottles 280 oz. 100 180 oz. 72 Work in process inventory was negligible, so none is assumed There is no change in cost data from January. Requirements: Prepare a Production Budget for August Prepare a Direct Materials Purchase Budget for August Prepare a Direct Labor Budget for August. (round hours required for production to the nearest whole hour) Prepare a Factory Overhead Budget for August Prepare a Budgeted Income Statement, including selling expenses, for August After August was completed, variance analysis needs to be performed. January operating data provided the standard prices, rates, times, and quantities per case. There were 1,500 actual cases produced during August. Actual August data: Actual Direct Materials Price per Unit Actual Direct Materials Quantity per Case Nutrient base Essential oils Bottle (8-oz.) $0.056 per oz. $0.45 per oz. $0.55 per bottle Actual Direct Labor 102 ozs. 31 ozs. 12.5 bottles Actual Direct Labor Time per Case Rate Mixing Filling $ 20.25 $ 15.00 14.6 min. 5.5 min. 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: Determine and interpret (favorable/unfavorable) the direct materials price and quantity variances for each of the three materials Determine and interpret the direct labor rate and time variances for the two Nepartments, rounding hours to the nearest hour Determine and interpret the factory overhead controllable variance 13. Determine and interpret the factory overhead volume variance