Question
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
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
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