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 $5.88 per case. 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: January 2018 direct materials, direct labor and factory overhead costs are as follows: 2018 Case Production Utility Total Cost DIRECT MATERIALS January 1,600 $ 820 Cost Units per February 1,900 868 Cost per unit Direct Materials Behavior March 1,360 698 Case 100 oz. Cost per Case Nutrient base variable $0.06 $6.00 April 1,400 767 1,450 1,200 Essential oils variable May 780 30 oz. 12 bottles $0.30 9.00 June 644 Bottle (8-oz.) variable $0.60 7.20 Requirements: $ 22.20 1. Determine the fixed and variable portion of the utility cost using the high-low method, 2. 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 DIRECT LABOR Department Cost Time per Labor Rate Direct Labor 3. per Hour $ 18.00 $ 14.50 Cost per Case $ 4.50 2.90 Behavior Case Mixing variable 15 min. 4. Filling variable 12 min. 21 min. $7.40 Part B: AUGUST BUDGETS FACTORY OVERHEAD August demand is expected to be 1,500 cases at a sales price of $100 per case. Cost Behavior Total Cost Inventory planning information follows: $ 740 12,800 6,300 940 Utilities mixed 350casess Estimated finished goods invehtory, Aug. 1" fixed Facility lease Equipment depreciation Supplies 21,000 fixed Desired finished goods inventory, Aug 31" $ 23,310 420 cases fixed $ 20,780 Nutrient Base OilsBottles 400 oz. PART A: BREAK-EVEN ANALYSIS Estimated materials inventory, Aug. 1"
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 $5.88 per case. 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: January 2018 direct materials, direct labor and factory overhead costs are as follows: 2018 Case Production Utility Total Cost DIRECT MATERIALS January 1,600 $ 820 Cost Units per February 1,900 868 Cost per unit Direct Materials Behavior March 1,360 698 Case 100 oz. Cost per Case Nutrient base variable $0.06 $6.00 April 1,400 767 1,450 1,200 Essential oils variable May 780 30 oz. 12 bottles $0.30 9.00 June 644 Bottle (8-oz.) variable $0.60 7.20 Requirements: $ 22.20 1. Determine the fixed and variable portion of the utility cost using the high-low method, 2. 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 DIRECT LABOR Department Cost Time per Labor Rate Direct Labor 3. per Hour $ 18.00 $ 14.50 Cost per Case $ 4.50 2.90 Behavior Case Mixing variable 15 min. 4. Filling variable 12 min. 21 min. $7.40 Part B: AUGUST BUDGETS FACTORY OVERHEAD August demand is expected to be 1,500 cases at a sales price of $100 per case. Cost Behavior Total Cost Inventory planning information follows: $ 740 12,800 6,300 940 Utilities mixed 350casess Estimated finished goods invehtory, Aug. 1" fixed Facility lease Equipment depreciation Supplies 21,000 fixed Desired finished goods inventory, Aug 31" $ 23,310 420 cases fixed $ 20,780 Nutrient Base OilsBottles 400 oz. PART A: BREAK-EVEN ANALYSIS Estimated materials inventory, Aug. 1"
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Hello. I need help with part 12 and 13. Can you please help me
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education