+++++++++++ableau 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. For which month did the company most underestimate units to be sold? (Hint: Find in which month inventory on hand moved closest to zero). For which month did the company most underestimate units to be sold? Review the Tableau visualization, and then answer the questions that follow. 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. How many units were sold that day and for what unit price? 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. What is the total number of units available for sale for the year, including beginning inventory and all monthly purchases? (Hint: Under Monthly Purchases, look at Running Sum of Units). 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. Which day has the highest daily revenue? Dn 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. What amount would be reported for sales revenue and gross profit for the year under FIFO? (Round your answers to the nearest whole dollar.) 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. How many units were actually sold by December 31 ? 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. What is the total cost of these units? (Hint: Under Monthly Purchases, look at Running Sum of Total Cost.) 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 weighted-average cost assumption, calculate cost of goods sold and the cost of ending inventory. (Round your answers to the nearest whole dollar.) 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.) 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 FIFO assumption, calculate cost of goods sold and the cost of ending inventory. (Hint: This calculation is made easier by using the Running Sum columns in Monthly Purchases) (Round your answers to the nearest whole dollar.) \begin{tabular}{|llrrr|} \hline February 28 & 3,100 & $25.15 & $77,965 & 9,900 \\ \hline March 31 & 3,000 & $25.25 & $75,750 & 12,900 \\ \hline April 30 & 2,800 & $25.30 & $70,840 & 15,700 \\ \hline May 31 & 4,200 & $25.40 & $106,680 & 19,900 \\ \hline June 30 & 4,340 & $25.60 & $111,104 & 24,240 \\ \hline July 31 & 3,720 & $25.75 & $95,790 & 27,960 \\ \hline August 31 & 3,300 & $25.80 & $85,140 & 31,260 \\ \hline September 30 & 3,000 & $25.85 & $77,550 & 34,260 \\ \hline October 31 & 3,100 & $25.85 & $80,135 & 37,360 \\ \hline November 30 & 4,400 & $25.90 & $113,960 & 41,760 \\ \hline December 31 & 3,000 & $26.00 & $78,000 & 44,760 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Janluary, & 104 & pSJ.uv & PS,04U.UU \\ \hline January 8 & 94 & $35.00 & $3,290.00 \\ \hline January 9 & 98 & $35.00 & $3,430.00 \\ \hline January 10 & 96 & $35.00 & $3,360.00 \\ \hline January 11 & 91 & $35.00 & $3,185.00 \\ \hline January 12 & 97 & $35.00 & $3,395.00 \\ \hline January 13 & 104 & $35.00 & $3,640.00 \\ \hline January 14 & 105 & $35.00 & $3,675.00 \\ \hline January 15 & 99 & $35.00 & $3,465.00 \\ \hline \end{tabular} Daily and Cumulative Sales Revenue