Celine's Scooter Supply Ltd. Quarterly Income Statement Units Sold Price per Unit Total Revenue Administrative Leasing Marketing Salary and Benefits Total Fixed Expenses Material Cost per Unit Total Material Cost Manufacturing Cost per Unit Total Manufacturing Cost Total Variable Expenses Total Expenses Operating Income Revenue Fixed Expenses Variable Expenses Summary 875,000.00 $22.50 $19,687,500.00 $2,250,000.00 800,000.00 500,000.00 1,100,000.00 $4,650,000.00 $3.25 $2,843,750.00 $4.75 $4,156,250.00 $7,000,000.00 $11,650,000.00 $8,037,500.00 D E Units 250,000 275,000 300,000 325,000 350,000 375,000 400,000 425,000 450,000 475,000 500,000 525,000 550,000 575,000 600,000 625,000 650,000 H Break-Even Analysis Total Revenue Total Expenses Operating Income 19687500.00 5625000.00

Fundamentals of Financial Management (MindTap Course List)
15th Edition
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter4: Analysis Of Financial Statements
Section: Chapter Questions
Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...
icon
Related questions
icon
Concept explainers
Topic Video
Question
A
B
C
D
E
G
H
1
Celine's Scooter Supply Ltd.
Quarterly Income Statement
Break-Even
Analysis
2
3 Revenue
Units Total Revenue Total Expenses Operating Income
4
Units Sold
19687500.00
875,000.00
$22.50
5625000.00
Price per Unit
Total Revenue
250,000
275,000
6
$19,687,500.00
7 Fixed Expenses
300,000
8
Administrative
$2,250,000.00
325,000
9
Leasing
800,000.00
350,000
10
Marketing
500,000.00
375,000
11
Salary and Benefits
1,100,000.00
400,000
12
Total Fixed Expenses
$4,650,000.00
425,000
13 Variable Expenses
450,000
14
$3.25
475,000
15
$2,843,750.00
500,000
16
Material Cost per Unit
Total Material Cost
Manufacturing Cost per Unit
Total Manufacturing Cost
Total Variable Expenses
525,000
$4.75
$4,156,250.00
17
550,000
18
$7,000,000.00
575,000
19 Summary
600,000
20
Total Expenses
$11,650,000.00
625,000
21
Operating Income
$8,037,500.00
650,000
22
23 Name:
24 Instructions:
25
1. Use the formulas to calculate the following:
26
Total Revenue = Units Sold * Price per Unit
27
Total Fixed Expenses = sum all fixed expenses
28
Total Material Cost = Units Sold * Material Cost per Unit
29
Total Manufacturing Cost = Units sold * Manufacturing Cost per Unit
30
Total Variable Expenses =Total Material Cost + Total Manufacturing Cost
31
Total Expenses =Total Fixed Expense + Total Variable Expense
32
Operating Income = Total Revenue - Total Expenses
2. Use the function Data Table to derive the Total Revenue, Total Expense, and Operating Income for different amount of units
sold.
33
34
F
5
J
K
L
Enter the correct formula in cells F4,
G4, and H4. Then, use the
function Data Table (not the
formula) we learn in chapter 4 to
derive the Total Revenue, Total
Expense, and Operating Income for
different amount of units sold.
T
Transcribed Image Text:A B C D E G H 1 Celine's Scooter Supply Ltd. Quarterly Income Statement Break-Even Analysis 2 3 Revenue Units Total Revenue Total Expenses Operating Income 4 Units Sold 19687500.00 875,000.00 $22.50 5625000.00 Price per Unit Total Revenue 250,000 275,000 6 $19,687,500.00 7 Fixed Expenses 300,000 8 Administrative $2,250,000.00 325,000 9 Leasing 800,000.00 350,000 10 Marketing 500,000.00 375,000 11 Salary and Benefits 1,100,000.00 400,000 12 Total Fixed Expenses $4,650,000.00 425,000 13 Variable Expenses 450,000 14 $3.25 475,000 15 $2,843,750.00 500,000 16 Material Cost per Unit Total Material Cost Manufacturing Cost per Unit Total Manufacturing Cost Total Variable Expenses 525,000 $4.75 $4,156,250.00 17 550,000 18 $7,000,000.00 575,000 19 Summary 600,000 20 Total Expenses $11,650,000.00 625,000 21 Operating Income $8,037,500.00 650,000 22 23 Name: 24 Instructions: 25 1. Use the formulas to calculate the following: 26 Total Revenue = Units Sold * Price per Unit 27 Total Fixed Expenses = sum all fixed expenses 28 Total Material Cost = Units Sold * Material Cost per Unit 29 Total Manufacturing Cost = Units sold * Manufacturing Cost per Unit 30 Total Variable Expenses =Total Material Cost + Total Manufacturing Cost 31 Total Expenses =Total Fixed Expense + Total Variable Expense 32 Operating Income = Total Revenue - Total Expenses 2. Use the function Data Table to derive the Total Revenue, Total Expense, and Operating Income for different amount of units sold. 33 34 F 5 J K L Enter the correct formula in cells F4, G4, and H4. Then, use the function Data Table (not the formula) we learn in chapter 4 to derive the Total Revenue, Total Expense, and Operating Income for different amount of units sold. T
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Statements
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning