using Excel

Create an income statement based on the values shown below. Assume that the company produces enough cleaning robots to have a 1 percent surplus over units sold. For example, if the company sells 100 unit, they would produce 101 units. This production surplus should be incorporated in the Income Statement used throughout this assignment because it will have significant impact on the Expenses. Revenue 85,300 $185 Variable Expenses Units Sold Price per Unit Material Cost per Unit Manufacturing Cost per Unit Salaries and Benefits Advertising Administrative Miscellaneous $91 $62 $950,000 $390,000 $280,000 $240,000 Fixed Expenses According to the Income Statement, how many units should the the company produce if they expect to sell 85,300 units? Please type the number with thousand separators with no decimal point (e.g. 123,456). Please describe the Income Statement created in the previous question by filling in the blanks using appropriate numbers (include thousand separators with two decimal points, e.g. 123,456.78). If Grenadier Robotics expects to sell 85,300 cleaning robots at $185 each, the company will generate a total revenue of $ Under these estimates, the company should incur $ of Total Variable Expenses, $ of the Fixed Expenses, and the Net Income of $ Based on the Income Statement, how many units the company would have to sell at its current price (i.e., $185) to break even? Please enter the number of units with thousand separators with no decimal point, e.g. 123,456 Create a one-variable data table to calculate the total revenue, expenses, and net income if the company sells from 75,000 to 200,000 units in incremerlts of 25,000 At 150,000 unit sold, Grenadier Robotics would generate $ in Revenue and $ in Net Income. Please enter the numbers with thousand separators and two decimal points (e.g. 123,456.78)