Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

his project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not

his project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor.

Using the Excel file you created for Butler and looking at requirement 1, how many graphics cards does the company need to sell in a month to break even if the selling price is $55.00 per unit, variable costs are $42.00, monthly fixed expenses are $8,450, with a volume of 700 units?

A. 650

B. 1,000

C. 700

D. 600

Using the Excel file you created fo Butler and looking at requirement 1, approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $75.00 per graphics card, variable costs are $42.00, and monthly fixed expenses are $8,450?

A. 450500

B. 800850

C. 550600

D. 650700

Using the Excel file you created for Butler and looking at requirement 1, what would the company's monthly profit be if it increases the selling price to $90.00, variable costs are $42.00, monthly fixed expenses are $8,450, and it sells 500 graphics cards?

A. $13,050

B. $17,950

C. $15,550

D. $13,150

Using the Excel file you created for Butler and looking at requirement 2, how many graphics cards does the company need to sell in a month to break even assuming that the selling price is $55.00 per unit, the variable cost has decreased to $32.00 and the monthly fixed expenses have increased to $10,350, with a volume of 700 units?

A. 450

B. 1,000

C. 500

D. 400

Using the Excel file you created forButler and looking at requirement 2, approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $75.00 per graphics card, the variable cost has decreased to $32.00 and the monthly fixed expenses have increased to $10,350?

A. 550600

B. 450500

C. 400450

D. 500550

Using the Excel file you created for Butler and looking at requirement 2, what would the company's monthly profit be if it increases the selling price to $90.00, the variable cost has decreased to $32.00, the monthly fixed expenses have increased to $10,350, and it sells 500 graphics cards?

A. $21,550

B. $18,650

C. $16,150

D. $15,550

image text in transcribedimage text in transcribed

A1 fic Sales price per unit A D E F G H J K L M M N o B $55.00 $42.00 1 Sales price per unit 2 Less: Variable cost per unit 3 Contribution Margin per unit 4 x Volume 5 Total Contribution Margin 6 Less: Fixed Expenses 7 Operating Income 700 $8,450.00 10 Monthly Target Profit -m two room Fooi 12 13 14 15 19 22 24 25 26 Butler (A) Butler (A) R2 + A1 for Sales price per unit D E F G H K. L M N. o B $55.00 $32.00 700 A 1 Sales price per unit 2 Less: Variable cost per unit 3 Contribution Margin per unit 4 X Volume 5 Total Contribution Margin 6 Less: Fixed Expenses 7 Operating Income 8 9 10 Monthly Target Profit 11 $10,350.00 $10,499.00 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Butler (A) Butler (A) R2

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

Exploring Strategic Change

Authors: Julia Balogun, Veronica Hope Hailey, Stafanie Gustafsson

4th Edition

0273778919, 9780273778912

More Books

Students also viewed these Accounting questions

Question

What is the difference between skewness and kurtosis?

Answered: 1 week ago