Determine the new operating income using the following assumptions:Selling Price/unit: $27Variable Cost/unit: 18Unit Sales Volume: 25,000 units Total Sales: $550,000 Less: Variable Expenses Variable CGS Starting Materials 10,000 Materials Purchased 165,000 Ending Materials 31,000 Materials Used 144,000 Production Labor 202,000 Electricity--production 35,000 Variable admin expenses Electricity--office 10,000 Contribution Margin 159,000 Contribution Margin Ratio 0.29 Less: Fixed Expenses Factory Supervision 40,000 New Tech 45,000 Fixed admin expenses Rent 25,000 Advertising 5,000 Office Labor 25,000 Total 55,000 Operating Income 64,000 Please show your Excel calculations
Determine the new operating income using the following assumptions:Selling Price/unit: $27Variable Cost/unit: 18Unit Sales Volume: 25,000 units Total Sales: $550,000 Less: Variable Expenses Variable CGS Starting Materials 10,000 Materials Purchased 165,000 Ending Materials 31,000 Materials Used 144,000 Production Labor 202,000 Electricity--production 35,000 Variable admin expenses Electricity--office 10,000 Contribution Margin 159,000 Contribution Margin Ratio 0.29 Less: Fixed Expenses Factory Supervision 40,000 New Tech 45,000 Fixed admin expenses Rent 25,000 Advertising 5,000 Office Labor 25,000 Total 55,000 Operating Income 64,000 Please show your Excel calculations
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Determine the new operating income using the following assumptions: Selling Price/unit: $27 Variable Cost/unit: 18 Unit Sales Volume: 25,000 units |
Total Sales: | $550,000 | ||
Less: Variable Expenses | |||
Variable CGS | |||
Starting Materials | 10,000 | ||
Materials Purchased | 165,000 | ||
Ending Materials | 31,000 | ||
Materials Used | 144,000 | ||
Production Labor | 202,000 | ||
Electricity--production | 35,000 | ||
Variable admin expenses | |||
Electricity--office | 10,000 | ||
Contribution Margin | 159,000 | ||
Contribution Margin Ratio | 0.29 | ||
Less: Fixed Expenses | |||
Factory Supervision | 40,000 | ||
New Tech | 45,000 | ||
Fixed admin expenses | |||
Rent | 25,000 | ||
Advertising | 5,000 | ||
Office Labor | 25,000 | ||
Total | 55,000 | ||
Operating Income | 64,000 |
Please show your Excel calculations
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
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