Assume that instead of 500 units being completed and transferred out, 600 units were completed and transferred out. There are 100 partially completed units in ending work in process inventory. Create of a copy of your new model onto another tab in Excel. Update the model on the new spreadsheet to include this new data and answer the questions following the report. 2) What was the effect on cost per equivalent unit? Why did it change? 3) What as the effect on total costs in the Cost Reconciliation Schedule? 4) What was the effect on total transferred out costs and ending WIP costs in the Cost Reconciliation Schedule? Assume that instead of 500 units being completed and transferred out, 600 units were completed and transferred out. There are 100 partially completed units in ending work in process inventory. Create of a copy of your new model onto another tab in Excel. Update the model on the new spreadsheet to include this new data and answer the questions following the report. 2) What was the effect on cost per equivalent unit? Why did it change? 3) What as the effect on total costs in the Cost Reconciliation Schedule? 4) What was the effect on total transferred out costs and ending WIP costs in the Cost Reconciliation Schedule