Using the data below please do the following in an Excel spreadsheet and e-mail it directly to me.

1. Prepare an income statement using variable costing (25 points) 2. Compute the unit product cost under both absorption and variable costing (10 points) 3. If net income under absorption costing equals $210,000, prepare a report reconciling the difference in net operating income between absorption and variable costing for the year (5 points)
Units in beginning inventory 0
Units produced 12,000
Units sold 11,250
Selling price per unit $90
Variable costs per unit:
Direct materials $20
Direct labor $10
Variable manufacturing overhead $8
Variable selling and administrative $5
Fixed costs in total:
Fixed manufacturing overhead $180,000
Fixed selling and administrative $150,000

What is your question here? It seems straightforward to me.

To complete the requested calculations in an Excel spreadsheet and send them to you via email, follow these steps:

1. Open Microsoft Excel on your computer.
2. Create a new blank spreadsheet.
3. Input the following data into the spreadsheet:

- Units in beginning inventory: 0
- Units produced: 12,000
- Units sold: 11,250
- Selling price per unit: $90
- Variable costs per unit:
- Direct materials: $20
- Direct labor: $10
- Variable manufacturing overhead: $8
- Variable selling and administrative: $5
- Fixed costs in total:
- Fixed manufacturing overhead: $180,000
- Fixed selling and administrative: $150,000

4. Calculate the income statement using variable costing (25 points):

- Create columns for the following categories: Units, Sales Revenue, Variable Expenses, Contribution Margin, Fixed Expenses, and Net Income.
- Enter the corresponding values for each category based on the provided data.
- Use formulas to calculate the values for the Contribution Margin, Fixed Expenses, and Net Income columns.

5. Compute the unit product cost under both absorption and variable costing (10 points):

- Create a column for the Unit Product Cost and enter the corresponding values for each costing method.
- Use formulas to calculate the unit product cost for both absorption and variable costing.

6. Prepare a report reconciling the difference in net operating income between absorption and variable costing for the year (5 points):

- Create a new section in the spreadsheet.
- Calculate the net income under absorption costing using the given value of $210,000.
- Use formulas to calculate the difference in net operating income between absorption and variable costing.
- Include a brief explanation of the reconciliation process and your findings.

7. Once you have completed the spreadsheet with the requested calculations, save the file to your computer.

8. Open your email application and compose a new email.

9. Attach the Excel spreadsheet to the email.

10. Enter your email address in the recipient field.

11. Write a brief message stating that the requested calculations have been completed and that the Excel spreadsheet with the results is attached.

12. Send the email.

Please note that as an AI bot, I can guide you through the steps, but I do not have the capability to execute them myself or send emails.