Review the Tableau visualization, and then answer the questions that follow. Sort Monthly Purchases By: First in 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 and 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 avallable for sale for the year, including beginilng inventory and all monthly purchases? (Hint: Under Monthly Purchases, look at Running Sum of Units). 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.) Complete this question by entering your answers in the tabs below. How many units were actually sold by December 31 ? 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? 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) Note: Round your answers to the nearest whole dollar. 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? Note: Round your answers to the nearest whole dollar. 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) Note: Round your answers to the nearest whole dollar. 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. Note: Round your answers to the nearest whole dollar. Complete this question by entering your answers in the tabs below. Which day has the highest daily revenue? Complete this question by entering your answers in the tabs below. How many units were sold that day and for what unit price? How many units were sold that day and for what unit price? Sort Monthly Purchases By: Firsta 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 thee 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 dally revenue? On January 1, a company begins the year with 4,000 units of inventory with a unt 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 thand. Required: Complete this question by entering your abwers in the tabs below. Using the weighted-average cont assumption, calculate cost of goode sold and the cost of ending inventory, Note: rlound your answers to the nearest wholo dollar. In 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 nd of each month based on expected units to be sold in the following month relative to current units on hand. equired: Complete this question by entering your answers in the tabs below. Using the LfFo asgumption, calculate cost of goods sold and the cost of ending inventory. (Hint: this calculation is made eisier by re-sorting monthly purchastas and using the Rurning Sum columne) Note: Round your anweis 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. What amount would be reported for sales revenue and gross profit for the year under FIFO? Notes 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 compary makes purchases at the nd 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 FIF assumption, calculate cost of goods sold and the cost of ending ifventory. (fint: this calculation is made eavier by using the Funning surn columns in Monthly frirchases) Notes Round your answers to the nearest whole doflar. 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 tobs 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). 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 told 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 cont of these units? (Hint: Under Monthly Purchasen, 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: Gotmplete this question by entering your answers in the tabs below. What is the total rumber of units available tor sale for the year, including beginning inventory and all monthly purchases? (1iint: Under Monthly Purchases, look at Running sum of Unitg)