Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 4 1 chapter 2: applying excel $66,000 3 data 4 sa

4 1 Chapter 2: Applying Excel $66,000 3 Data 4 Sales 5 Variable costs:...

80.2K

Verified Solution

Question

Accounting

imageimage

4 1 Chapter 2: Applying Excel $66,000 3 Data 4 Sales 5 Variable costs: 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs: 10 Fixed selling 11 Fixed administrative 12 $37,000 $3,700 $3,500 $2,500 $1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? Gross margin (b) What is the net operating income now? Net operating income (c) What is the contribution margin now? Contribution margin 2. Suppose that sales are 25% higher than the data provided in requirement 1. 1 Chapter 2: Applying Excel $82,500 3 Data 4 Sales 5 Variable costs 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs: 10 Fixed selling 11 Fixed administrative $46,250 $4,625 $4,375 $2,500 $1,500 Enter this new data into your worksheet. Make sure you enter all of the new data - not just the sales. (a) What is the gross margin now? Gross margin (b) What is the net operating income now? Net operating income (c) What is the contribution margin now

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students