1-4 is done. Need 5-8 with how to work it. Thanks!
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 Mixing Cost Behavior variable variable DIRECT LABOR Time per Labor Rate Case per Hour 15 min. $ 20.00 6 min. $ 15.50 21 min. Direct Labor Cost per Case $5.00 1.55 $ 6.55 Filling 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 585 March 1,200 664 April 640 May 950 590 June 1,025 635 Requirements: 1,100 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 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 Nutrient Base Oils Bottles Estimated materials inventory, Aug. 1 350 oz. 280 oz. 100 Desired materials inventory, Aug. 31" 600 oz. 180 oz. 72 Work in process inventory was neolicihlo sonone is accumod 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. 15 280 cases $ 12,880 Desired finished goods inventory, Aug. 31* 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 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
