Question: Please help Date Explanation Units Unit cost Total Cost 1-Jan Beginning inventory 250 $ 12.50 $ 3,125.00 1-Feb Purchase 450 $ 14.00 $ 6,300.00 1-Mar
Please help
| Date | Explanation | Units | Unit cost | Total Cost |
| 1-Jan | Beginning inventory | 250 | $ 12.50 | $ 3,125.00 |
| 1-Feb | Purchase | 450 | $ 14.00 | $ 6,300.00 |
| 1-Mar | Purchase | 350 | $ 16.00 | $ 5,600.00 |
| 1-Apr | Sale | 1,000 | ||
| Units purchased | 1,050 | Total cost | $ 15,025.00 | |
| Units sold | 1,000 | |||
| Units in ending inventory | 50 |

5 Examen #3 Problema Comprensivo Estudiante - Excel Kristal Estrada 7 o File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 12 - AA = = = ab Wrap Text General WE AT O HH Paste > A Merge & Center $ % % 4.0 .00 Insert Delete Format AutoSum Fill Sort & Find & Clear Filter Select Editing Conditional Format as Cell Formatting Table Styles Styles 7.0 Clipboard Font Alignment Number Cells B5 X for Date B D E F E G H 1 J K L M M N 0 o P Q 0 R S T U 44 45 46 Ending inventory 47 48 49 50 51 52 53 Cost of Goods Sold 1000 Total cost Units $ 14,400.00 units 2 2 50 total cost $ 625.00 54 SISTEMA DE INVENTARIO PERPETUO WEIGTED AVERAGE 55 7 7 56 Purchases Cost Per unit COST OF GOODS SOLD Cost Per unit Total Cost Balance Cost Pet unit Date Units Total Cost Units Units Total Cost 57 58 59 60 61 62 63 64 65 66 67 68 69 70 Ending inventory Cost of Goods Sold Total cost Units 2 2 2 units total cost Activate Windows Go to Settings to activate Windows, Part 1 Part II Part III + Select destination and press ENTER or choose Paste Average: 11733.91667 Count: 31 Sum: 211210.5 3 W + 70% + Type here to search PI a W 79F Partly sunny la 4)) 5:56 PM 3/10/2022
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
