Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with formulas for b and c Chapter 1: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold $6,000 Variable selling $900

Please help with formulas for b and c

Chapter 1: Applying Excel
Data
Sales $12,000
Variable costs:
Cost of goods sold $6,000
Variable selling $900
Variable administrative $400
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 1-7
Traditional Format Income Statement
Sales $ 1,200
Cost of goods sold 6,000
Gross margin 6,000
Selling and administrative expenses:
Selling $ 3,100
Administrative 1,900 5,000
Net operating income $ 1,000
Contribution Format Income Statement
Sales $ 12,000
Variable expenses:
Cost of goods sold $ 6,000
Variable selling 600
Variable administration 400 7,000
Contribution margin 5,000
Fixed expenses:
Fixed selling 2,500
Fixed administrative 1,500 4,000
Net operating income $ 1,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Accounting

Authors: Anne Marie Ward, Andrew Thomas

9th Edition

1526803003, 978-1526803009

More Books

Students also viewed these Accounting questions