Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[ The following information applies to the questions displayed below. ] Orton Company distributes one product that sells for $ 1 1 . 5 0

[The following information applies to the questions displayed below.]
Orton Company distributes one product that sells for $11.50 per unit and incurs variable expenses of $8.25 per unit. Its monthly fixed expense is $80,000. The company currently pays its sales representatives a sales commission of $1.75 per unit sold; however, it is considering replacing these sales commissions with sales salaries of $70,000 per month. Orton would like your help in creating a cost-volume-profit (CVP) graph and a profit graph for both compensation scenarios up to a sales volume of 50,000 units.
Download the Excel file, which you will use to create the CVP graphs and profit graphs within Tableau.
Upload the Excel file into Tableau by doing the following:
Open the Tableau Desktop application.
On the left-hand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel."
Choose the Excel file and click "Open."
Since the only worksheet in the Excel File is "Orton Company" it will default as a selection with no further import steps nepred
Pr
Iption
I Commissions
Salaries.
Required:
Note: Note that for all questions below you may select more than one answer. Single click the box with 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. Any boxes left with a question mark will be automatically graded as incorrect.
6a. Why is the angle of the orange line steeper than the angle of the blue line?
? The contribution margin per unit in the salary-based compensation scheme is lower than the contribution margin per unit in the commission-based compensation scheme.
? The contribution margin per unit in the salary-based compensation scheme is higher than the contribution margin per unit in the commission-based compensation scheme.
? The total fixed expense in the salary-based compensation scheme is higher than the total fixed expense in the commission-based compensation scheme.
? The total fixed expense in the salary-based compensation scheme is lower than the total fixed expense in the commission-based compensation scheme.
6b. Which of the following statements explains how to compute the sales volume at which the two lines intersect?
? The difference between the two scenarios' total fixed expense divided by the difference between their respective contribution margins per unit.
The difference between the two scenarios' total fixed expense plus the difference between their respective contribution margins per unit.
The difference between the two scenarios' total fixed expense multiplied by the difference between their respective contribution margins per unit.
The difference between the two scenarios' total fixed expense minus the difference between their respective contribution margins per unit.
6c. Which of the following equations explains how to compute the difference in profit between the two scenarios at a sales volume of 50,000 units?
units -40,000 units
image text in transcribed

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

Financial Forensics Body Of Knowledge

Authors: Darrell D. Dorrell, Gregory A. Gadawski

1st Edition

0470880856, 978-0470880852

More Books

Students also viewed these Accounting questions