Sort Monthly Purchases By: First in Last In \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Monthly Purchases } \\ \hline Day of Date & Units & Unit Cost & Total Cost & Running Sum of Units \\ \hline December 31 & 3,000 & $26.00 & $79,000 & 3,000 \\ \hline November 30 & 4,400 & $25.90 & $113,960 & 7,400 \\ \hline October 31 & 3,100 & $25.85 & $90,135 & 10,500 \\ \hline September 30 & 3,000 & $25.85 & $77,550 & 13,500 \\ \hline August 31 & 3,300 & $25.80 & $95,140 & 16,800 \\ \hline July 31 & 3,720 & $25.75 & $95,790 & 20,520 \\ \hline June 30 & 4,340 & $25.60 & $111,104 & 24,860 \\ \hline May 31 & 4,200 & $25.40 & $106,690 & 29,060 \\ \hline April 30 & 2,800 & $25.30 & $70,840 & 31,860 \\ \hline March 31 & 3,000 & $25.25 & $75,750 & 34,860 \\ \hline February 28 & 3,100 & $25.15 & $77,965 & 37,960 \\ \hline January 31 & 2,800 & $25.05 & $70,140 & 40,760 \\ \hline January 1 & 4,000 & $25.00 & $100,000 & 44,760 \\ \hline \end{tabular} Daily Sales Revenue \begin{tabular}{|lrrr|} \hline Day of Date & Units & Unit Price & Daily Sales Revenue \\ \hline \hline December 17 & 158 & $36.50 & $5,767.00 \\ \hline December 18 & 168 & $36.50 & $6,132.00 \\ \hline December 19 & 160 & $36.50 & $5,840.00 \\ \hline December 20 & 158 & $36.50 & $5,767.00 \\ \hline December 21 & 193 & $36.50 & $6,679.50 \\ \hline December 22 & 145 & $36.50 & $5,292.50 \\ \hline December 23 & 150 & $36.50 & $5,475.00 \\ \hline December 24 & 153 & $36.50 & $5,584.50 \\ \hline December 25 & 52 & $36.50 & $1,898.00 \\ \hline December 26 & 95 & $36.50 & $3,467.50 \\ \hline December 27 & 104 & $36.50 & $3,796.00 \\ \hline December 28 & 107 & $36.50 & $3,905.50 \\ \hline December 29 & 99 & $36.50 & $3,613.50 \\ \hline December 30 & 100 & $36.50 & $3,650.00 \\ \hline December 31 & 99 & $36.50 & $3,613.50 \\ \hline \end{tabular} Daily and Cumulative Sales Revenue Sort Monthly Purchases By: First in Last In On January 1 , a company begins the year with 4,000 units of inventory with a unit cost of $25. The company makes purchases at the end of each month based on expected units to be sold in the following month relative to current units on hand. Required: Complete this question by entering your answers in the tabs below. Using the LIFO assumption, calculate cost of goods sold and the cost of ending inventory. (Hint: this calculation is made easier by re-sorting monthly purchases and using the Running Sum columns) (Round your answers to the nearest whole dollar.)