AutoSave WH- Week 3 Homework Student (2) Excel Search X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X [D- Calibri 11 - AA === 29 Wrap Text General 27 Daste H BLU- === A Insert Delete Format += Analyze $ -% Merge & Center Conditional Format as Cell Formatting Table Styles Styles Data Sort & Find Filter Select Editing Coboards Font Alignment F Number Cells Analysis 031 C E F H 1 L M 0 A S V w > Y 2 2 A B Raw Materials 20,000 G FG 260.000 WP 150,000 coegu 5 5 7 400 000 9 19 80,000 70,000 11 12 13 1.) PO OH Rate MOH 14 actual applied 15 13 17 18 by computer underapplied OH 13 20 21 (2) COGMP 223) unadjusted COGS? 253b) what options are available for eliminating the MOH? 24 254) Cost of Job 215 if we markicup 2546 26 DM 3.500 given 27 DL 2.700 siven 28 MOH no me first 29 Tecar Cost 90 Markup S1 Soles Price Assistance Tab 1 Tab 2 1 PROBLEM 3-25 Schedule of Cost of Goods Manufactured: Overhead Analysis ILOD-1, LOS-2, LOS, LOS-B, LOS Gian Products operates a border costing system and ples overhead cost to jobs on the basis of direct masseproduction or on the basis of raw materials purchased its predetermined overhead rate was based on a cost formula that estimated saco, manufacturing everes for an estimate one of 500.000 de meters colars to be used in production The company has provided the following . cat for completed year Purchase of raw materials ww 1510.000 Director $90,000 Manufacturing overheads indir bor 3170.000 Property taxes 548.000 Depreciation of equipment 5200,000 Mwand 395.000 ce $7,000 ent, but 3180,000 d d Tab 3 Tab 4 Tab 5 Tab 6 Tab 7 Tab & 8 + Ready Average: 123900 Count 20 Sum 991200 - 75% BI A E 3:08 PM 11/2/2001