please help me with this assignment iam having a hard time with it

A 1 Sales price per unit 2 3 Less: Variable cost per unit Contribution Margin per unit X Volume 4 5 Total Contribution Margin 6 Less: Fixed Expenses 7 Operating Income 8 9 10 Monthly Target Profit B $70.00 $60.00 800 $7,500.00 C DE yo er her mer Requirements The controller for the Braxton 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 $70.00, the variable cost is $60.00, and monthly fixed expenses are $7,500. The company is currently selling 800 of the graphic cards per month. The company has a requirement that each product generate monthly operating income (profit) of $12,500 or more. Requirements for the Excel analysis 1. Assume that the sales price is $70.00 per unit, variable costs are $60.00, monthly fixed expenses are $7,500, with a volume of 800 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,200 units down to 600 units in 50-unit increments and sales prices of $70.00 up to $105.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 $70.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 $70.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 $90.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price to $100.00 and sells 700 graphics cards? 2. Now assume that the variable cost has decreased to $55.00 and the monthly fixed expenses have increased to $9,750. 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 $70.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 $70.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 $90.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price to $100.00 and sells 700 graphics cards? Print Done X 0 This 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 Braxton 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 $70.00 per unit, variable costs are $60.00, monthly fixed expenses are $7,500, with a volume of 800 units? OA. 750 B. 700 O C. 1,200 D. 800 Using the Excel file you created for Braxton 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 $90.00 per graphics card, variable costs are $60.00, and monthly fixed expenses are $7,500? OA. 600-650 B. 700-750 C. 750-800 OD. 650-700 Using the Excel file you created for Braxton and looking at requirement 1, what would the company's monthly profit be if it increases the selling price to $100.00. variable costs are $60.00, monthly fixed expenses are $7,500, and it sells 700 graphics cards? OA $17,000 OB. $22,500 OC. $26,250 D. $20,500 Using the Excel file you created for Braxton 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 $70.00 per unit, the variable cost has decreased to $55.00 and the monthly fixed expenses have increased to $9,750, with a volume of 800 units? OA. 650 0 000 B. 1,200 OC. 600 D. 700 Using the Excel file you created for Braxton 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 $90.00 per graphics card, the variable cost has decreased to $55.00 and the monthly fixed expenses have increased to $9,750? A. 650-700 B. 700-750 OC. 600-650 D. 850-900 Using the Excel file you created for Braxton and looking at requirement 2, what would the company's monthly profit be if it increases the selling price to $100.00, the variable cost has decreased to $55.00, the monthly fixed expenses have increased to $9,750, and it sells 700 graphics cards? A. $24,000 OB. $18,250 OC. $21,750 D. $20,250