can you please assist me with the correct formula i am unable to proceed. where the question marks are i need to input the correct formula to match with what is in the other excel. not sure what i am doing wrong

For LIFO (B) I typed in the 1900 i am unable to put in the formula to bring it to the 1900 prior the Formula i put in give me a figure of 2200 i do not how what happen why i can't get 1900 for the answer. I would like to see how you came up with your answer and what formula to type into the excel sheet.

Thank You

Required information [The following information applies to the questions displayed below.) In this Applying Excel exercise you will practice using absolute cell referencing, t- calculate and compare the effects of the LIFO, FIFO, and the Weighted Average Watch the tutorial video and then complete Parts 1 and 2 to practice and apply th HIR MINC.505 SUMISHI 520 D 5.500 U Tocal Court Dale Se M 3.MD Units Sold 0 SER LIFO Date Number of Units Beginning 1.200 March 12 2.200 2,700 October 22 3.900 June 5 2.700 3.000 tion applies to the questions displayed below.] exercise you will practice using absolute cell referencing, the MIN function, and formulas to e the effects of the LIFO, FIFO, and the Weighted Average inventory costing methods. eo and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. ITUT 2700 sent to your instructor for grading. - Lab (Excel) Saved Download the 'Applying Excel' worksheet below and save it to your compute worksheet. Enter formulas in cells that contain question marks (only use formulas). After en question marks, verify that the amounts match the example below. (a) FIFO Units Remaining Ending Inventory $ 9 a Units Sold 1,200 2,200 2,700 2,400 8,500 Cost of Goods Sold $12,300 22,660 28,080 25,440 $88,480 es 1,500 1,500 15,900 $15,900 (b) LIFO Endine Pien rks (only use formulas). After entering formulas in all of the cells that contain the example below. 8 Ending Inventory $ 0 @ 15,900 $15,900 ng Ending Inventory $12,300 (b) LIFO Units Sold Cost of Goods Sold $ 19,570 28,080 41, 340 $88,990 Units Remaining 1,200 300 Ending Inventory $12,300 3,090 1,900 2,700 3,900 8,500 0 1,500 $15,390 (c) Weighted-average cost Cost of Units Sold Goods Sold 8,500 $88,723 Units Remaining 1,500 Ending Inventory $15,657 Calculate gross profit baloia Required information (d) Calculate gross profit Sales revenue Cost of goods sold Gross profit FIFO $255,000 88,480 $166,520 LIFO $255,000 88,990 $166,010 Weighted- average $255,000 88,723 $166, 277 Check your worksheet setup and formulas by changing the unit costs as noted below. Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Cost 10.50 10.40 10.30 10.20 lanen 15 ann allen andinn June 5 October 22 2,100 3,900 10.30 10.20 You should now have a FIFO ending inventory balance of $15,30 Profit of $167,391 using the Weighted Avergage Method. If you do not get this answer, review your worksheet and the form Save your completed Applying Excel form to your computer an You will use this worksheet to answer questions in Part 2. 20 Dry balance of $15,300, a LIFO ending inventory balance of $15,720, and a Gross age Method orksheet and the formulas you used. to your computer and then upload it here by clicking "Browse". Next click "Save". stions in Part 2 upload a response file (15MB max) =MIN(D18,SE$11-SUM($117:1918)) D E F H Few the tutorial, then complete the worksheet, replacing the question marks below with formulas. Required: (a) Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the FIFO method (b) Calculate Cost of Goods Sold and Ending Inventory using the LIFO method. (c) Calculate Cost of Goods Sold and Ending Inventory using the Weighted Average Method. (d) Calculate Gross Profit under all three methods. Given Information: Sales = Sale Price = 8,500 units 30 la FIFO Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3.900 Unit Cost 10.25 10.30 10.40 10.60 Total Cost 12.300 22.660 28,080 41,340 Student Workbook Alignment Units B. D E F G Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Cost 10.25 10.30 10.40 10.60 Total Cost 12,300 22,660 28,080 41,340 Totals 10,000 104,380 DATE Beginning March 12 June 5 October 22 LIFO mber of Units Sold 1,200 2,200 2,700 3,900 Unit Sold 10.25 10.30 10.40 10.60 Total 12,300 22,660 28,080 41,340 Student Work Styles H J (a) FIFO Units Remaining Endir inventory Units Sold 1,200 2,200 2,700 2,400 Cost of Goods Sold 12,300 22,660 28,080 25,440 0 1,500 8,500 89,480 1,500 15.000 (b) LIFO Units Remaining Ending Inventor Units Sold 1,200 5,100 2,700 3,900 Cost of Goods Sold ? 2 2 2 ? ? 2 Conditional Formatas coll Formatting Table Ne tam H 2 5,100 2,700 3,900 7 (c) Weighted average cost Units Sold Cost of Goods Sold Units Remaining (d) Calculate gross profit Sales revenue Cost of goods sold Gross profit FIFO 2 2 2 Nam 2 D E G View the tutorial, then complete the worksheet, replacing the question marks below with formulas. Required (a) Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the FIFO method (b) Calculate Cost of Goods Sold and Ending Inventory using the UFO method. (c) Calculate Cost of Goods Sold and Ending Inventory using the weighted Average Method (d) Calculate Gross Profit under all three methods. Given Information: Answers Sales = Sale Price = 8,500 units 30 (a) FIFO 0 11 12 13 14 15 16 17 TE Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Cost 10.25 10.30 10.40 10.60 Total Cost 12,300 22,660 28,080 41,340 20 Student Workbook type here to search Spiceland Supplying the Home Insert Page Layout Formulas Date Review View Help Dalbe ~ 11 A A 2 BIU 29 Wrap Text 08 Morge & Carrier Gora $ %692 Con la Forming Coord Font Alignment A23 A 5 G H Required: (a) Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the PFO method. b) Calculate Cost of Goods sold and Ending Inventory using the LIFO method. (c) Calculate Cost of Goods Sold and Ending Inventory using the Weighted Average Method (d) Calculate Gross Profit under all three methods. 7 9 Given Information: Sales Sale Price = 8,500 units 30 (a) FIFO 10 11 12 13 14 15 16 17 18 19 20 21 Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Total Cost Cost 10.25 12,300 10.30 22,660 10.40 28,080 10.60 41,340 10,000 104,380 Totals 22 h) UFO 11 A A G Merge Center $ -% 982 Condal Format Farming 5 Aliment Numb (a) FIFO Ending Inventory 0 Units Sald 1,200 2,200 2,700 2,400 Cost of Goods Sold 12,300 22.560 28.080 25.400 Units Remaining 0 0 0 1,500 15,900 8,500 88.40 1,500 15,900 (b) UFO Units Remaining 2 Ending Inventory Units Sold 0 1,900 2,700 3,900 Cost of Goods Sold 0 19,570 28,080 41,340 7 2 2 2 2 8,500 88,480 L125 Page Layout Sage-1-1 View Help Sexch Formulas Prva -11-AA- ted A Mage & Cie E WA BIU $ -% -28 Cordone tomach Tom Table H 1,900 2,700 3,900 0 19,570 28,080 41,340 7 2 2 2 2 3 8_500 18,40 ? id) Weighted average cost Units Sold Cost of Goods Sold Units Remaining Ending Inventory 2 Id Calculate gross profit FIFO Wested UFO 7 2 Sales revenue Cost of goods sold Gross profit > 2 Download the "Applying Excel' worksheet below and save it to your comput worksheet. Enter formulas in cells that contain question marks (only use formulas). After e question marks, verify that the amounts match the example below. (a) FIFO Units Remaining Ending Inventory $ Cost of Goods Sold $12,300 22,660 28,080 25, 440 $88,480 Units Sold 1,200 2,200 2,700 2,400 8,500 @ 1,500 1,500 15,900 $15,900 Below and save it to your computer. View the tutorial video, and then complete th marks (only use formulas). After entering formulas in all of the cells that contain tch the example below. ts ining Ending Inventory $ 500 @ 15,900 $15,900 500 anits Ending -- Lab (Excel) Saved Required information Sales revenue Cost of goods sold Gross profit FIFO $255,000 88,480 $166,520 LIFO $ 255,000 88,990 $ 166,010 Weighted average $255,000 88,723 $166,277 Check your worksheet setup and formulas by changing the unit costs as noted below: Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Cost 10.50 10.40 10.30 10.20 You should now have a FIFO ending inventory balance of $15,300, a LIFO ending inventor ethod TTLUN LUNDExternal browser og launch Lab (Excel) a Required information 10. Deginning March 12 June 5 October 22 2,200 2,700 3,900 10.40 10.30 10.20 You should now have a FIFO ending inventory balance of $15 Profit of $167,391 using the Weighted Avergage Method. If you do not get this answer, review your worksheet and the balance of $15,300, a LIFO ending inventory balance of $15,720, and a Gross e Method. ksheet and the formulas you used. your computer and then upload it here by clicking "Browse". Next click "Save". ions in Part 2 D E G iew the tutorial, then complete the worksheet, replacing the question marks below with formulas. Required: (a) Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the FIFO method (b) Calculate Cost of Goods Sold and Ending Inventory using the UFO method. (c) Calculate Cost of Goods Sold and Ending Inventory using the weighted Average Method. (d) Calculate Gross Profit under all three methods. Given Information: Sales Sale Price = 8,500 units 30 Answers (a) FIFO Date Beginning March 12 June 5 October 22 Number of Units 1,200 2,200 2,700 3,900 Unit Cost 10.25 10.30 10.40 10.60 Total Cost 12,300 22,660 28,080 41,340 Student Workbook 4 Type here to search Page Layout Formulas Data Review View Calton 11 15 Wraplex El Merge Center $ -% 9 Font f D G H the tutorial, then complete the worksheet, replacing the question marks below with formules Required (a) Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the FIFO method (b) Calculate Cost of Goods Sold and Ending inventory using the UFO method. Id Calculate Cost of Goods Sold and Ending Inventory using the Weighted Average Method (d) Calculate Gross Profit under all three methods. Given Information: Sales Sale Price = 8,500 units 30 (a) FIFO Date Beginning March 12 June 5 October 22 Number of Units 1,200 2.200 2,700 3,900 Unit Total Cost Cost 10.25 12,300 10.30 22,660 10.40 28,080 10.60 41,340