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

Transcribed Image Text:Better By the Numbers began operations on January 1, 2018. The company
The management of Better by the Numbers would like to determine the
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
number of cases required to break-even per month.
commission of $5.88 per case.
Utilities cost, a part of factory overhead, is a mixed cost. Following is
January 2018 direct materials, direct labor and factory overhead costs are as
information gathered for the first six months of operations regarding total
utilities costs:
follows:
2018
Case Production
Utility
Total Cost
DIRECT MATERIALS
January
1,600
$ 820
Cost
Behavior
Units per
February
1,900
Cost per
Direct Materials
868
Case
unit
Cost per Case
March
1,360
698
Nutrient base
variable
100 oz.
$0.06
$ 6.00
April
1,400
767
Essential oils
variable
30 oz.
$0.30
9.00
May
1,450
780
Bottle (8-oz.)
variable
12 bottles
$0.60
7.20
June
1,200
644
$ 22.20
Requirements:
1.
Determine the fixed and variable portion of the utility cost using the
high-low method.
DIRECT LABOR
Time per
2.
Determine the contribution margin per case.
Direct Labor
Cost per Case
Labor Rate
Cost
Behavior
Department
3.
Determine the fixed costs per month, including the utility fixed cost
per Hour
$ 18.00
$ 14.50
Case
from part (1).
variable
15 min.
$ 4.50
Mixing
Filling
4.
Determine the break-even number of cases per month.
variable
12 min.
2.90
21 min.
$7.40
Part B: AUGUST BUDGETS
FACTORY OVERHEAD
Cost Behavior
August demand is expected to be 1,500 cases at a sales price of $100 per case.
Total Cost
Inventory planning information follows:
mixed
740
350cases $
Utilities
Estimated finished goods inveħtory, Aug. 1"
12,800
6,300
fixed
Facility lease
Equipment depreciation
Supplies
21,000
fixed
420 cases
Desired finished goods inventory, Aug 31"
$23,310
940
fixed
$ 20,780
Nutrient Base
OilsBottles
400 oz.
PART A: BREAK-EVEN ANALYSIS
Estimated materials inventory, Aug. 1"
O Focus
2:29 PM
ENG
4/12/2021
ates)
w/

Transcribed Image Text:Editing
Voice
Editor
2
3
4.
1.5
10
130 oz.
100
Mixing
$ 18.75
$ 14.00
Desired materials inventory, Aug. 31t
14.4 min.
300 oz.
Filling
13.2 min.
230 oz.
70
Work in process inventory was negligible, so none is assumed
The standard quantity of materials used per case was an ideal standard.
There is no change in cost data from January.
Actual Variable Overhead was $325
Standard (Budgeted) Volume is 1,600 cases
Requirements:
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
5.
6.
Determine and interpret (favorable/unfavorable) the direct
materials price and quantity variances for each of the three
10.
7.
production to the nearest whole hour)
materials
8.
Prepare a Factory Overhead Budget for August
11.
Determine and interpret the direct labor rate and time variances for
the two departments, rounding hours to the nearest hour
Determine and interpret the factory overhead controllable variance
9.
Prepare a Budgeted Income Statement, including selling expenses, for
12.
August
13.
Determine and interpret the factory overhead volume variance
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 Actual Direct
Materials
Price per Unit Quantity per Case
98 938
31 935
$0.065 per OZ.
Nutrient base
$0.36 per oz.
Essential oils
12.5 bottles
$0.55 per bottle
Bottle (8-oz.)
Actual Direct
Actual Direct Labor
Labor
Time per Case
Rate
O Focus
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