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

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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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