Question
May I please have help with this? Need help answering the 5 multiple choice questions at the end. I would greatly appreciate it and make
May I please have help with this? Need help answering the 5 multiple choice questions at the end. I would greatly appreciate it and make sure to upvote! Thank you
1. Using the Excel file you created for Butler and looking at requirement 1, how many graphic 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. 1,000 B. 700 C. 650 D. 600
2. Using the Excel file you created for 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. 650-700 B. 550-600 C. 800-850 D. 450-500
3. 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 graphic cards?
A. $13,150 B. $17, 950 C. $13, 050 D. $15,550
4. 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. 400 B. 1,000 C. 500 D. 450
5. Using the Excel file you created for Butler 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. 550-600 B. 450-500 C. 500-550 D. 400-450
The controller for the Butler Corporation wants to use the What-if Analysis tool in Excel to analyze the sales price, volume, and profit related to the graphics card it manufactures. The sales price of the graphics card is $55.00, the variable cost is $42.00, and monthly fixed expenses are $8,450. The company is currently selling 700 of the graphic cards per month. The company has a requirement that each product generate monthly operating income (profit) of $10,500 or more. Requirements for the Excel analysis 1. Assume that the sales price is $55.00 per unit, variable costs are $42.00, monthly fixed expenses are $8,450, with a volume of 700 units. Use formulas to calculate the contribution margin per unit, total contribution margin, and operating income. Also add $1 less than the target profit to a cell below the profit calculation. Create a data table in Excel using the What-if Analysis tool. Use volumes of 1,000 units down to 400 units in 50-unit increments and sales prices of $55.00 up to $90.00 in $5 increments. Use conditional formatting to shade the cells in the data table that meet or exceed the company's target profit. Using this data table, answer the following questions: a. How many graphics cards does the company need to sell in a month to break even if the selling price remains at $55.00 ? b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $55.00 per graphics card? target profit if the selling price remains at $55.00 per graphics card? c. 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? d. What would the company's monthly profit be if it increases the selling price to $90.00 and sells 500 graphics cards? 2. Now assume that the variable cost has decreased to $32.00 and the monthly fixed expenses have increased to $10,350. All other data remains the same. Create a new profit calculation in Excel (as you did in Requirement 1) with the new variable cost and the new monthly fixed expenses. Using this new data table, answer the following questions: a. How many graphics cards does the company need to sell in a month to break even if the selling price remains at $55.00 ? b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $55.00 per graphics card? c. 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? R1 - Cell F15 if the "What-If" $(3,250.00) table is started in cell E2 R2 - Cell F15 if the "What-If" $(1,150.00) table is started in cell E2 Check Figures ReadyStep 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