Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: 1 Chapter 2: Applying

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: 1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs 6 Cost of goods sold 7Variable selling 8 Variable administrative $19,000 $9,500 1,000 $800 9 Fixed costs 10 Fixed selling 11 Fixed administrative $2,500 1,500 12 If your formulas are correct, you should get the correct answers to the following questions (a) What is the gross margin now? HEWLETT-PACKARD CILLROulT H&MUSA N NetflixPeaks&Pines Mtn V If your formulas are correct, you should get the correct answers to the folloving questions (a) What is the gross margin now? ross margin (b) What is the net operating income now? t operating in (c) What is the contribution margin now? ntribution margin HEWLETT-PACKARD 2. Suppose that sales re 8% higher than the data provided in requirement 1. A. 1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs $20,520 6 |Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs: 10 Fixed selling 11 Fixed administrative 12 $10,260 $1,080 $864 $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? ross margin HEWLETT PACKA 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? s margn (b) What is the net operating income now? Net operating income (c) What is the contribution margin now? tribution margin HEWLETT-PACKAR UNIVERSITY | (d when sales increase by 8%, which of the following should also increase by 8% in a merchandzing company? rou may select more than one answer. Single click the box w the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.) variable cost Fxed cost Gross margin Cortributionmagn Net operating income (e) when sales r orease by am, which of he folowing should increase by more than 8% in a merharduro con per y? You may select more than one answer single click the box with the question mark to produce check mark for a corect answer and double click the boa with the question mark to ompry the box ror, wong answer) Fined cost Gross margin Contribution margn Net operaing roome

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

The Solitary Auditor

Authors: Michael Knapp

1st Edition

161163878X, 978-1611638783

More Books

Students also viewed these Accounting questions

Question

How Does the Work Fit with the Organizations Structure? l698

Answered: 1 week ago