AutoSave OF AA ACC 215 Chapter One - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 12 X G ab Wrap Text General ~ A A 1 ED 2 Insert Delete Format Y Paste B I U --- = = Merge & Center $ % ! Saf Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity V B8 fx Oasis Manufacturing reports the information below for 2017, A B C D E F G H J L 3 4 Cells highlighted in green contain a drop-down arrow; select information from list. in the cells highlighted in grey, enter the appropiate number in those cells. When the correct amount is entered, the cell will change color. for 2017 Required: 1. Prepare the schedule of cost of goods manufactured for the year. 2. Compute cost of goods sold for the year. 1. Begin. Inv. Purchases Avail. for use OASIS MANUFACTURING Schedule of Cost of Goods Manufactured For Year Ended December 31, 2017 Raw Materials Inventory 20,000 63,000 83,000 DM used 36,000 47,000 End. Inv. Total manufacturing costs 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Total cost of work in process Work in Process Inventory 28,000 47,000 55,000 27,500 157,500 Cost of goods mfg Begin. Inv. DM used Direct labor Overhead Avail, for mfg. Enter as a positive value. Cost of goods manufactured 133,500 2. End. Inv. 24,000 OASIS MANUFACTURING Partial Income Statement For Year Ended December 31, 2017 Cost of goods sold Begin. Iny Cost of goods Avail, for sale Finished Goods Inventory 32,000 133,500 165,500 Cost of Goods Sold 64,500 Goods available for sale 101,000 Enter as a positive value. End. Inv. Cost of goods sold E 1-8 E 1-15 E QS 1-16 + Edit + 125%