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-02.) Direct Materials Cost per Case $6.00 12.00 7.20 $ 25.20 Department Cost Behavior DIRECT LABOR Time per Labor Rate Case Der Hour Direct Labor Cost per Case ious 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 PART A: BREAK-EVEN ANALYSIS 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 March 1,200 664 April 1,100 640 May 950 590 June 1,025 635 Requirements: 585 1. Determine the fixed and variable portion of the utility cost using the high-low method. 2. Determine the contribution margin per case. Requirements: 1. Determine the fixed and variable portion of the utility cost using the high-low method. 2. Determine the contribution margin per case. 3. Determine the fixed costs per month, including the utility fixed cost from part (1). 4. Determine the break-even number of cases per month CE 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. 1st 280 cases $ 12,880 Desired finished goods inventory, Aug. 31st 175 cases $ 7,719 Nutrient Base Oils Bottles Estimated materials inventory, Aug. 1st 350 oz. 280 oz. 100 Desired materials inventory, Aug. 31st 600 oz. 180 oz. 72 Work in process inventory was negligible, so none is assumed Work in process inventory was negligible, so none is assumed There is no change in cost data from January. Requirements: 5. Prepare a Production Budget for August 6. Prepare a Direct Materials Purchase Budget for August 7. Prepare a Direct Labor Budget for August. (round hours required for production to the nearest whole hour) 8. Prepare a Factory Overhead Budget for August 9. Prepare a Budgeted Income Statement, including selling expenses, for August Part C: AUGUST VARIANCE ANALYSIS 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 102 ozs. 31 ozs. 12.5 bottles Actual Direct Labor Rate Actual Direct Labor Time per Case 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: 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