AutoSave Off H2 Week 3 Homework Student (2) - Excel Search o File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X Cambria 11 - AI === Wrap Text General SI LTX ' y Fa IN Analyze Data Paste BI U Insert Delete Format A y .00 Y E - E Merge & Center $ %) - Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Analysis J21 for B E C E F G G H 1 K K L M N N O P Q O R S 1 Tab #1 2 3 Beginning RM Inventory 60,000 4 Purchases of RM 690,000 5 Ending RM Inventory 45,000 6 Direct Labor 135,000 7 Manufacturing Overhead (actual = applied) 370,000 8 Beginning WIP Inventory 120,000 9 Ending WIP Inventory 130,000 10 11 Raw Materials WIP* 12 60,000 120,000 13 690,000 705,000 705,000 1,200,000 14 135,000 15 370,000 16 FG* COGS*** 1,200,000 17 18 45,000 130,000 19 20 21 Calculate COGM 22 Assistance Tab 1 Tab 2 Tab 3 Tab 4 Tab 5 Tab 6 Tab 7 Tab 8 + Ready Average: 383888.8889 Count: 30 Sum: 6910000 + 100% o J. a E 1:37 PM 11/2/2021