Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sort Monthly Purchases By: First In Last In begin{tabular}{|lrrrr|} hline & multicolumn{4}{c}{ Monthly Purchases } hline Day of Date & Units & Unit Cost
Sort Monthly Purchases By: First In Last In \begin{tabular}{|lrrrr|} \hline & \multicolumn{4}{c}{ Monthly Purchases } \\ \hline Day of Date & Units & Unit Cost & Total cost & Running Sum of Units \\ \hline January 1 & 4,000 & $25.00 & $100,000 & 4,000 \\ \hline January 31 & 2,800 & $25.05 & $70,140 & 6,800 \\ \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} Actual Units Sold and On Hand Daily Sales Revenue \begin{tabular}{|c|c|c|c|} \hline Day of Date & Units & Unit Price & Daily Sales Revenue \\ \hline January 1 & 102 & $35.00 & $3,570.00 \\ \hline January 2 & 104 & $35.00 & $3,640.00 \\ \hline January 3 & 101 & $35.00 & $3,535.00 \\ \hline January 4 & 101 & $35.00 & $3,535.00 \\ \hline January 5 & 96 & $35.00 & $3,360.00 \\ \hline January 6 & 97 & $35.00 & $3,395.00 \\ \hline January 7 & 104 & $35.00 & $3,640.00 \\ \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 & & & \\ \hline \end{tabular} Daily and Cumulative Sales Revenue 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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started