XYZ Company anticipates the following costs during the first year of operations. The company is attempting to project profitability if 100% of production is sold, and if 75% of production is sold. Use the pick lists associated with the boxed areas to select amounts for each cost category in the absorption and variable costing income statements that follow. Correct selections will turn the boxed areas green. Afterwards, answer the questions at the bottom of the spreadsheet. XYZ Company VARIABLE COSTING INCOME STATEMENT For the Year Ending December 31, 20XX \#VALUE! How much is ending inventory if 75% of the production is sold, and: XYZ uses absorption costing? XYZ uses variable costing? \begin{tabular}{|l|} \hline? \\ \hline \end{tabular}