Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help on requirements #10-13. please explain. Thank you! Better By the Numbers began operations on January 1, 2018. The company produces eight- ounce

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

I need help on requirements #10-13. please explain. Thank you!

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 Behavior Units per Case Cost per unit Nutrient base Essential oils Bottle (8-oz.) variable variable variable 100 oz. 30 oz. 12 bottles $ 0.06 $0.34 $ 0.60 Direct Materials Cost per Case $ 6.00 12.00 7.20 $ 25.20 DIRECT LABOR Department Cost Behavior Time per Case Labor Rate per Hour $ 20.00 $ 15.50 Mixing Filling variable variable 15 min. 6 min. 21 min. Direct Labor Cost per Case $5.00 1.55 $ 6.55 FACTORY OVERHEAD Utilities Facility lease Equipment depreciation Supplies Cost Behavior mixed fixed fixed fixed Total Cost $ 600 14,000 4,300 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 April 1,100 664 640 590 May 950 June 1,025 635 Requirements: 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 Part A 1. High Activity Level Low Activity Level Change Variable Cost Per Case Fixed Cost at High Level Fixed Cost at Low Level Part A 2. Sales Price Less: Variable Cost Direct Material Direct Labor Utilities Selling Commission Total Variable Cost Contribution Margin Case Production Utility Total Cost 1200 664 500 510 700 154 0.22 400 400 Per Case $95.00 25.20 6.55 0.22 20.00 51.97 43.03 14000 4300 Part A 3. Fixed Costs Per Month: Facility Lease Equipment Depreciation Supplies Utilities Total Fixed Costs Per Month Part A 4. 512 400 19212 Break even number of cases per month 19212/43.03 $446.48 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: $ 12,880 $ 7,719 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. 31st 600 oz. Bottles Oils 280 oz. 180 oz. 100 72 Work in process inventory was negligible, so none is assumed There is no change in cost data from January. Requirements: Paragraph Styles 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 B Production Budget Cases Budgeted Sales Add: Desired Ending Inventory Total Needed Less: Beginning Inventory Budgeted Production Direct Material Purchase Budget 1500 175 1675 (280) 1395 Oils Bottles Part B 6. Nutrient Base 1395 12 16740 72 Budget Production Material Required Per Case Total Material Required for Budgeted Production Add: Desired Ending Inventory Total Need Less: Beginning Inventory Budgeted Purchases in Units Cost Per Unit of Material Budgeted Purchased in Cash 100 139500 600 140100 (350) 139750 0.06 $8385 1395 30 41850 180 42030 (280) 41750 0.34 $14195 16812 (100) 16712 0.60 $10027 SUJJ $14173 002) Part B Direct Labor Budget Mixing Filling 1395 0.25 349 1395 0.10 140 Budgeted Production Hours Required Per Case Total Hours Required for Budgeted Production Cost Per Hour Budgeted Purchases in Cash Factory Overhead Budget 20 6975 15.50 2162 Part B Utilities Factory Lease Equipment Deprecation Supplies Budgeted Overhead Budgeted Income Statement 600 14000 4300 512 19412 Part Cost Per Hour Budgeted Purchases in Cash ash Factory Overhead Budget 20 15.50 6 9752162 Part B 8. Utilities Factory Lease Equipment Deprecation Supplies Budgeted Overhead Budgeted Income Statement 600 14000 4300 512 19412 Part B 9. 150000 H 12880 32642.80 Sales Less: Cost of Goods Beginning Inventory Materials Consumed Beginning Inventory Materials Purchased Ending Inventory Direct Labor Factory Overhead Cost of Goods Available for Sale Ending Inventory Cost of Goods Sold Gross Margin Less: Selling and Administrative Expenses Net Income 176.20 32607 -140.40 9137 19412 74071.80 -7719 66352.80 83647.20 -30000 53647.20 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 Time Actual Direct Labor per Case $ 20.25 Mixing Filling 14.6 min. 5.5 min. $ 15.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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

=+b) Drivers scores on the written part of a driving test.

Answered: 1 week ago