Check your worksheet by changing the units sold in the Data to $6,000$ for Year $2$The cost of goods sold under absorption costing for Year $2$ should now be $$240,000.$ If it isn't, check cell C$41.$ The formula in this cell should be $=$IF$($C$26$ C$27,26*36+27-$C$26)*$B$36,$C$27$C$36).$ If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $$(34,000)$ for Year $2.$ That is$,$ the loss in Year $2$ is $$34,000$ under both methods. If you do not get these answers, find the errors in your worksheet and correct them.Why is the absorption costing net operating income now equal to the variable costing net operating income in Year $2?2,$Enter the following data from a different company into your worksheet:DataSelling price per unitManufacturing costs:Variable per unit produced:Direct materialsDirect labor.Variable manufacturing overheadFixed manufacturing overhead per yearSelling and administrative expenses:Variable per unit soldFixed per year$$75$$$12$$$5$$$7$$$150,000$$$1$$$60,000$Year $1$Year $2$Units in beginning inventory.Units produced during the yearUnits sold during the year... $.\mathrm{.}15,00012,00010,00012,0003.$Is the net operating income under variable costing different in Year $1$ and Year $2?$ Why or why not? Explain the relation between the net operating income under absorption costing and variable costing in Year $1.$ Explain the relation between the net operating income under absorption costing and variable costing in Year $2.$At the end of Year $1,$ the company's board of directors set a target for Year $2$ net operating income of $$500,000$ under absorption costing. If this target is met, a large bonus would be paid. to the CEO of the company. Keeping everything else the same from part $(2)$ above, change the units produced in Year $2$ to $50,000$ units. Would this change result in a bonus being paid to the CEO? Do you think this change would be in the best interests of the company? What is likely $12200$ en in Year $3$ to the absorption costing net operating income i sates remain constant al$12,000$ units per year?