please use excel to answer

QUESTION 46 A company has analyzed profitability over the year and found the following information for their highest and lowest months of production: August November units 1.000 800 total expenses 543,000 $40,000 sales revenue $100,000 $80,000 Required: a. Use a High-Low method to calculate both the variable cost per unit and fixed costs. b. Use a sensitivity analysis to determine the increase to net income expected if the company increase sales revenues by 530.000 c. Determine the break-even point in units for this company. d. If the company hoped to achieve a target profit of $80,000, how many units would they need to sell? You must record your final answers to parts a-d in the answer space provided below. Label all answers. Note: You must show your work for partial credit. You may use the Excel file provided to document work and calculations or you may type work into the answer box below ExcelFile xlsx