Please fill out the pictures provided with answers. If you photo shop the answers in the boxes that would be appreciated

WAD HnMan 1.PR 06-10 Lace Product Action Failed Insert Page Layout Formulas Data View Tell me what you want to do Bradley Buty Share & File Home * 11 Num. Anal 2 O re Copy TH pit A- === Sage & Comf. Migrant Number Iner Delle Format Paste * fumma part Cena Son Find & Concorallo Fong To Tom Styles CAR Cell ding HIS Unit A D C E F G H K L N 0 P QR S T U VW XY Z AA AB C C Balances ACEAE B 30 10 37 .JOURNAL Description Debit Credit 20 -39 -1012 41 12 43 44 45 -16 47 19 19 50 61 3. Gloss pro for the sales puid 53 Endingimentory cost 56 57 20 59. 60 61 Inventory under uro wuld be 63 64 65 66 67 68 69 70 71 72 73 74 15 76 77 78 70 Pr. 6-18 al INT Rraty 11 FTP - + 10-10 FM 767 Partly cloudy. c O Ei links G x 1 Desktop 481223/2007 PR 6-1B FIFO perpetual inventory Obj. 2, 3 The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: SHOW ME HOW EXCEL TEMPLATE Date Transaction Apr. 3 8 11 30 May 8 Number Per Unit Total of Units 25 $1,200 $30,000 75 1,240 93,000 40 2,000 80,000 30 2,000 60,000 60 1,260 75,600 50 2,000 100,000 20 2,000 40,000 80 1,260 100,800 40 2,250 90,000 25 2,250 56,250 35 1,264 44,240 44 2,250 99,000 Inventory Purchase Sale Sale Purchase Sale Sale Purchase Sale Sale Purchase Sale 10 19 28 June 5 16 21 28 Instructions S WRD Fin Man 14e_PR 06-1B - Excel (Product Activation Failed) 1 File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Bradley Bruny Share % Cut > M Arial - 10 - A A Ee Wrap Text AY o Paste E Copy - Format Painter A === Merge & Center - $ % 6388 Insert Delete Format Conditional Format as Formatting Table AutoSum - Fill- Sort & Find & Clear - Filter Select- Editing Clipboard Font Alignment Number Styles Cells J15 f Unit L N O P Q R S T U V w X Y Z AA AB AC AE A B C D E F G H | J K 1 Problem 6-1B 2 Name: 3 Section: 4 6 Score: 0% 6 7 Key Code: [Key code here] 3 Instructions 9 Answers are entered in the cells with gray backgrounds. 10 Cells with non-gray backgrounds are protected and cannot be edited. 11 An asterisk (*) will appear to the right of an incorrect entry. In part 1, only final inventory cost-Column K - will be graded 12 13 14 1. Purchases Cost of Goods Sold Inventory 15 Unit Total Unit Total Unit Total 16 Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost 17 Apr. 3 25 $1.200 $ 30,000 18 8 19 20 11 21 22 30 23 May 8 24 25 10 26 27 19 28 28 29 30 June 5 31 16 21 28 B2 B3 34 35 36 B7 38 39 30 Balances Pr. 6-1B Ready EU 100%