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"

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

Hello. I need help with part 12 and 13. Can you please help me 

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: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/
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Financial Planning
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education