AutoSave . Off ACCT 3321-90L Comprehensive Exercises (Extra Credit) (2) - Excel Search (Alt+Q) Daniel Montanez DM X File Home Insert Draw Page Layout Formulas Developer Review Data View Help Share Comments LO & Cut Times New Romar ~ 11 ~ A" A ab Wrap Text _ AutoSum AY O Fill Paste LE Copy BIU MAY EE EE Merge & Center v $ ~ % 9 08 -20 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting v Table Styles Clear Filter > Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity D55 X V fx A B C D E F G H K M N 109 Show your calculations in the work area to the right. Failure to show your work will result in no credit for this exercise. 110 111 112 113 Exercise 3 up to 5 points Work Area 114 Berlin Company uses a periodic inventory system. For June, when the company sold 750 units, the following information is 115 available. 116 117 Units Unit Cost al Cost 118 April 1 Inventory $ 9 $ 3,150 119 April 15 Purchase 600 1 1 6,600 120 April 23 Purchase 300 14 4,200 121 1,250 $ 13,950 122 123 Requirements Answer 124 Compute April 30 Inventory using FIFO 125 126 Compute April 30 Cost of Goods Sold using FIFO 127 128 Compute April 30 Inventory using LIFO 129 130 Compute April 30 Cost of Goods Sold using LIFO 131 132 133 Show your calculations in the work area tpo the right. Failure to show your work will result in no credit for this exercise. 134 135 136 137 Exercise 4 up to 5 points Work Area Sheet1 (+ ) Ready EO Ex Accessibility: Investigate 100% Type here to search O X w P 58OF ~X 0 / E 10:58 PM 11/22/2021