Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a Multipart question, each part is a separate page, not sure if that matters. I know nothing about the class so if possible
This is a Multipart question, each part is a separate page, not sure if that matters.
I know nothing about the class so if possible can I get the answers super clear with answers and parts corresponding.
THANK YOU SO MUCH!
I tell everyone I know about this amazing website!
part 1 2 3 $12,000 5 Data Sales Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling Fixed administrative $6,000 $600 $400 9 10 $2,500 $1,500 11 12 13 Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. Exhibit 1-7 14 18 17 18 $ 12,000 6,000 6,000 Copy Formulas 20 Traditional Format Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses Selling Administrative Net operating income 21 $ 3,100 1,900 22 5.000 $ 1,000 23 24 25 26 $ 12.000 27 $ 6,000 600 29 30 Contribution Format Income Statement Sales Variable expenses Cost of goods sold Variable selling Variable administration Contribution margin Fixed expenses: Fixed selling Fixed administrative Net operating income 400 7,000 5.000 31 32 2,500 1,500 34 4,000 $ 1,000 35 38 part 2 B E K Chapter 1: Applying Excel 2 D G Req. 1: Enter $900 for the green variable selling cell in the data section. The Net Operating Income should now be $700 and the Contribution Margin should be $4,700 in red bold text. If not, go back to the formulas page, make corrections, press the copy formulas button, and recheck your answers until they are correct. When correct, answer the questions below. 4 $12,000 5 6 7 Data Sales Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling Fixed administrative $6,000 ? $400 How much is the gross margin? 10 $2,500 $1,500 11 12 13 14 Exhibit 1-7 15 Did the Gross Margin change from the previous Formulas page? 16 17 ? 18 ? ? 19 Traditional Format Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling Administrative Net operating income 20 21 ? 22 ? ? 2 Why or why not? 24 25 26 ? 27 28 ? 2 29 Contribution Format Income Statement Sales Variable expenses Cost of goods sold Variable selling Variable administration Contribution margin Fixed expenses: Fixed selling Fixed administrative Net operating income 30 31 ? ? ? 32 33 ? 34 ? ? 35 ? part a 1 Chapter 1: Applying Excel 2 Req. 2: Enter the data changes from req. 2 on page 45 of the textbook in the green data cells on the left. After the data is entered, answer the questions below. 4 ? 5 ? 6 7 Data Sales Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling Fixed administrative ? ? B What happened to the variable and fixed costs after the 10% increase in Sales? 9 10 $2,500 $1,500 11 12 13 14 Exhibit 1-7 15 Did the Contribution Margin change by 10%? Why or why not? 16 17 2 18 ? 19 ? Traditional Fomat Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling Administrative Net operating income 20 21 ? 22 ? ? Did theNet Operating Income increade by 10%? Why or why not? 23 2 24 25 26 ? 27 28 ? 29 ? 30 Contribution Format Income Statement Sales Variable expenses: Cost of goods sold Variable selling Variable administration Contribution margin Fixed expenses Fixed selling Fixed administrative Net operating income ? ? ? 31 32 33 ? 34 ? 2 35Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started