1. Income Analysis (50 Points) Data File needed for this exercise: Income.xlsx \ Jane Smith is a financial analyst at Stellar Robotics in Starville, California. The company is launching a new series of space exploration drones capable of collecting data on distant planets. Jane needs your assistance in analyzing a projected financial statement for the company's operations, calculating the breakeven point for the product, and determining the optimal pricing strategy. \ Enter Your Name and Student ID \ (a) Open the workbook called Income.xlsx and save it as Stellar Robotics Income.xlsx. \ (b) Insert a Documentation worksheet and add an appropriate title for the workbook in cell A1. In cell B3 enter your name. In cell B4 enter your student number. In cell B5 enter the completion date of your assignment and in cell B6 enter a sentence to describe the purpose of the workbook. \ Preliminary Task \ (a) Navigate to the Financial Statement worksheet and compute the Total Material Cost, Total Manufacturing Cost, Total Variable Expenses, Total Fixed Expenses, and Total Revenue. (b) Complete the Summary section on the worksheet and save your workbook. \ Goal Seek \ Determine the number of units the company needs to sell at the current price to break even. Note that at the break-even quantity, total expenses equal total revenue (Hint: use Goal Seek). Keep the original value of Units Produced and Sold and enter your answer in cell B31. Save your workbook. \ One-Variable Data Table \ (a) Utilize a one-variable data table to compute the Total Revenue, Total Expenses, and Net Income if the company sells (Units Produced and Sold) 50,000 to 200,000 units in increments of 25,000 (Enter these values in cells D7:D13). \ (b) Apply custom number formats to label the formula references as Revenue, Expenses, and Net Income. Bold and center these labels. \ (c) Create a Scatter chart based on your findings (Units sold, revenue, and expenses). You should have 2 lines on your chart. Move the chart to a new worksheet named Revenue-Expense Analysis. \ (d) Save your workbook. \ Two-Variable Data Table \ (a) Utilize a two-variable data table to calculate the Net Income based on Units Produced and Sold (50,000 to 200,000 units in increments of 25,000 cells E21:E27) and Price per Unit ($180 to $200 in increments of $5 cells F20:J20). \ (b) Create a Scatter chart based on your results. You should have 5 lines on your chart (Net income when the sale price is $180, $185, $190, $195, and $200). Move the chart to a new worksheet named Income Analysis. \ (c) Apply custom number format to designate the formula references as Net Income. (d) Save your workbook.