A B C D The following data from the just completed year are taken from the accounting records of Fatimah Company (in dollars): 1 2 Number of units sold (units) 3 Selling Price (S/unit) Variable selling expense per unit (S/unit) 4 Total fixed selling expense ($) 5 Variable administrative expense per unit (S/unit) 6 Total fixed administrative expense (S) 7 20,000 451 5 30,000 3 43,000 8 Direct labor cost (S) 66,000 Calculate in sheet Manufacturing overhead applied to work in process (S) "Overhead 9 applied" Actual manufacturing overhead cost(S) 10 11 Indirect materials (S) 12 Purchases of materials during period (S) 290,000 28,000 140,000 12 13 14 15 16 17 18 19 Account Balances of Inventory accounts: Beginning Ending Balance (S) balance ($) Raw Materials 5,000 9,000 Work in process 15,000 4,000 Finished goods 9,000 2,000 20 Instructions. Please prepare the following reports in the assigned tabs of the excel file: 21 Sheet 1. Calculate POHR, overhead applied and under- or overapplied overhead E F 22 Sheet 2. Prepare a schedule of cost of goods manufactured. 23 Sheet 3. Prepare a schedule of cost of goods sold; 24 25 26 Sheet 4. Sheet 5. Prepare a traditional format income statement; Prepare a contribution format income statement. HW Assignment 1. Overhead applied 2. Schedule of COGM 3. Schedule of COGS Paste E15 1 . Acial 10 A- A- Copy Wap Custom B format U Merge & C Condtional Format Formating b Cal Styles De Formal :xfx A 203 C D E F G H 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost 8 Actual total amount of the allocation base 9 10 Enter a formula into each of the cells marked with a ? below 11 12 Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost 14 Estmated total amount of the allocation base 15 Predetermined overhead rate 16 17 Computation of underapplied or overapplied manufacturing overhead 18 Actual manufacturing overhead cost 19 Manufacturing overhead cost applied to Work in Process during the year 20 Predetermined overhead rate 21 Actual total amount of the allocation base 22 Manufacturing overhead applied 23 Underapplied (overapplied) manufacturing overhead Machine-hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours 7 machine-hours ? per machine-hour ? per machine-hour ? machine-hours " ? 24 25 26 27 28 20 CH- Share Ya fim Excel File Edit View Insert Format Tools Data Window Help hw Home Insert Draw Page Layout Formulas Data Review View Cut Calibri (Body) 16 -AA- Wrap Text Copy Paste BIU Merge & Center Format A1 1 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 xfx Schedule of Cost of Goods Manufactured Schedule of Cost of Goods Manufactured C D E HW Assignment 1. Overhead applied 2. Schedule of COGM 3. Schedule of COGS 4. Tradition Ready Accessibility: Investigate Home Insert Draw Page Layout Formulas Data Review View Cut Calibri (Body). 11 A- A- Copy Paste BI Format E3 x fx A C E F 1 2 3 A S 6 7 Schedule of Cost of Goods Sold 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 Ready HW Assignment 1. Overhead applied Accessibility: Investigate 2. Schedule of COGM 3. Schedule of COG Paste A1 1 2 619 9 10 11 0123 14 15 B Format A fx Traditional Format Income Statement B Traditional Format Income Statement C D E 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Ready HW Assignment Accessibility: Investigate 1. Overhead applied 2. Schedule of COGM 3. Schede NAILL 14 1 2 3 4 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 Copy Paste B I U Format E5 x fx A B C D E F Contribution Format Income Statement HW Assignment 1. Overhead applied 2. Schedule of COGM 3. Schedule of Ready Accessibility: Investigate