I HAVE AN EXCEL DOCUMENT BUT I'M NOT SURE HOW TO UPLOAD IT.

AutoSave OFF svo Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share Comments X Arial ~ A 10 = = Insert v 0 General ab Wrap Text PA 28 Ou 8 Delete v Paste BI Av Merge & Center V V $ % ) .00 000 Conditional Format Cell Formatting as Table Styles Ideas Sensitivity Format v Sort & Filter Find & Select * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx B D E F G H - J K L 1 2 3 Sampson Company uses a job order cost system with overhead applied based on direct labor hours. See Estimated Overhead for 2014 720,000 4 5 Estimated Direct Labor Hours for 2014 24,000 During January the comapny had the following transactions: (a) Purchased $10,000 of raw materials on account. (b) Issued the following materials into production: Direct materials 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Amount Explanation 7,000 Job 102 Job 103 2,000 Used on both jobs. 2.000 5.000 Indirect materials Total 9,000 (c) Recorded salaries and wages as follows: Direct labor 6,000 4,000 Amount Explanation 10,000 Job 102 Job 103 For factory 4,000 supervision For administrative 5,000 staff 26 Indirect labor Salaries Total 27 28 29 30 31 32 19,000 (d) Applied overhead to jobs based on the number of direct labor hours required Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 125% AutoSave OFF os5 - Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share o Comments Insert v Arial 10 A A ab Wrap Text General HI HILL LIV PV 5280 O 3 Delete BI Paste 990 Av Merge & Center $ % ) .00 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Format v Find & Select Sensitivity Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx B D E F G H - J K L (d) Applied overhead to jobs based on the number of direct labor hours required Job Number Job 102 Job 103 Direct labor hours 300 200 Total 500 Recorded the following actual manufacturing costs: Rent Depreciation Insurance Utilities Insurance Amount Explanation 6,000 Paid factory rent in cash 5,000 Factory equipment 3,000 expire 2,000 it. Total 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 16,000 (f) Recorded the following general and administrative costs: Advertising Depreciation Other expenses Amount Explanation 2,000 Advertising paid in cash 3,000 Office equipment 1,000 paid. Total 6,000 (9) Sold Job 101, which is recorded in Finished Goods: Sales Price Cost 55.000 30,000 (h) Completed Job 102 but did not sell it; Job 103 is still in process at year-end. Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 5 IN 125% AutoSave OFF no svu = Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments X Arial A A 10 ab Wrap Text General #Insert D Delete ir 29 O Paste B I Av Merge & Center Ideas $ % ) Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Format Find & Select Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx A B D E F G H J L 64 65 66 (h) Completed Job 102 but did not sell it; Job 103 is still in process at year-end. Requ 67 ired: 68 1 Compute the predetermined overhead rate. 69 Predetermined 70 overhead rate 71 72 2 Compute how much overhead would be applied to jobs during the period: 73 Overhead applied 3 Compute the total cost of Jobs 102 and 103 at the end of the period. You will enter your calculation in the Where will the cost of each of these jobs appear on the Balance sheet? enter your answer to #3 here. 4 Post the journal entries to the T' Accounts in the 'Ledger Accounts' tab. Calculate the ending balances in all 5 Calculate the amount of over- or underapplied overhead in the "Ledger Accounts' tab. 74 75 76 77 78 79 80 31 82 36 83 as 84 OF 85 86 27 37 88 89 90 91 92 93 94 95 96 97 98 6 Post the journal entry in the T accounts to dispose of the overhead balance in the 'Ledger Accounts' tab. 7 Prepare a statement of cost of goods manufactured report in the 'Reports' tab. 8 Prepare an income statement in the 'Reports' tab. Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 125% Comprehensive Problem 1 (S2-3 on page 104) Copy formatting from one location and apply it to another Home Insert Draw Page Layout Formulas Arial 10 ~ AP Data Review View Share 0 Comments = = 0 Insert v PM ab Wrap Text = General PA ou Ou 5 Delete v Paste B I U 2 Merge & Center v $ %) V .00 000 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format v Find & Select V A L12 X fixe A B D E F G H J L M N O Q 2 3 4 5 Manufacturing Overhead Raw Materials Inventory 10,000 1/1 Balance 6 7 8 9 10 11 12 Underapplied Overapplied 1/31 Balance 13 14 15 Job Sheet: 102 15,000 Job Sheet: 103 Work in Process Inventory 15,000 1/1 Balance 16 17 18 19 Beginning Balance add: Direct Materials add: Direct Labor add: Applied Overhead 20 21 22 Total Manufacturing Costs 15,000 1/31 Balance 23 24 25 Cost of Goods Sold 1/1 Balance Finished Goods Inventory 30,000 26 27 28 29 30 31 32 Unadjusted 1/31 1/31 Balance Adjusted 1/31 Sales Revenue Selling, General, and Administrative Expenses 33 34 35 36 37 38 39 40 41 42 43 1/31 Balance 1/31 Balance Given Ledger Accounts Reports + AutoSave OFF S5- Comprehensive Problem 1 (S2-3 on page 104) Q Arial Insert V 10 v AA ab ab Wrap Text General ITIV Dv TH WE Ou 5 DX Delete v Paste BIU A Z Lv Sort & Filter V E E V Merge & Center Ideas Sensitivi $ % ) V Conditional Format Cell Formatting as Table Styles Format Find & Select 0 L12 x fx B D E F G H J K M N O P 24 25 Cost of Goods Sold Finished Goods Inventory 30,000 1/1 Balance 26 27 28 29 30 31 32 Unadjusted 1/31 1/31 Balance Adjusted 1/31 Sales Revenue Selling, General, and Administrative Expenses 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 1/31 Balance 1/31 Balance Cash and Other Assets 100,000 Payables and Other Liabilities 85,000 1/1 Balance 1/1 Balance 1/31 Balance 1/31 Balance Stockholders' Equity 70,000 1/1 Balance 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 1/31 Balance Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 5 + 10 AutoSave OFF o svo Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments Arial ~ AI v 10 LI = = Insert v DO General ab Wrap Text HEA ou Ou 5 Delete v Paste B I Merge & Center V $ % ) V Ideas .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Sensitivity V C45 x fx A B D E F G H - K Coda Company Cost of Goods Manufactured Report For the Month of January 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Beginning Raw Materials Inventory Plus: Raw Material Purchases Less: Indirect Material Used Less: Ending Raw Materials Inventory Direct Materials Used in Production Direct Labor Manufacturing Overhead Total Current Manufacturing Costs Plus: Beginning Work in Process Inventory Total Work in Process Less: Ending Work in Process Inventory Cost of Goods Manufactured 20 1 8 Coda Company Income Statement For the Month of January 21 22 23 24 25 26 27 28 Sales Revenue Less: Cost of Goods Sold Beginning Finished Goods Inventory Plus: Cost of Goods Manufactured" (see schedule above) Cost of Goods Available for Sale Less: Ending Finished Goods Inventory Unadjusted Cost of Goods Sold Under-/Overapplied Overhead Adjusted Cost of Goods Sold Gross Profit Less: Operating (Period) Expenses Net Income from Operations 29 30 31 32 33 34 35 36 37 38 39 40 41 1 1 Given Ledger Accounts Reports + AutoSave OFF svo Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share Comments X Arial ~ A 10 = = Insert v 0 General ab Wrap Text PA 28 Ou 8 Delete v Paste BI Av Merge & Center V V $ % ) .00 000 Conditional Format Cell Formatting as Table Styles Ideas Sensitivity Format v Sort & Filter Find & Select * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx B D E F G H - J K L 1 2 3 Sampson Company uses a job order cost system with overhead applied based on direct labor hours. See Estimated Overhead for 2014 720,000 4 5 Estimated Direct Labor Hours for 2014 24,000 During January the comapny had the following transactions: (a) Purchased $10,000 of raw materials on account. (b) Issued the following materials into production: Direct materials 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Amount Explanation 7,000 Job 102 Job 103 2,000 Used on both jobs. 2.000 5.000 Indirect materials Total 9,000 (c) Recorded salaries and wages as follows: Direct labor 6,000 4,000 Amount Explanation 10,000 Job 102 Job 103 For factory 4,000 supervision For administrative 5,000 staff 26 Indirect labor Salaries Total 27 28 29 30 31 32 19,000 (d) Applied overhead to jobs based on the number of direct labor hours required Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 125% AutoSave OFF os5 - Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share o Comments Insert v Arial 10 A A ab Wrap Text General HI HILL LIV PV 5280 O 3 Delete BI Paste 990 Av Merge & Center $ % ) .00 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Format v Find & Select Sensitivity Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx B D E F G H - J K L (d) Applied overhead to jobs based on the number of direct labor hours required Job Number Job 102 Job 103 Direct labor hours 300 200 Total 500 Recorded the following actual manufacturing costs: Rent Depreciation Insurance Utilities Insurance Amount Explanation 6,000 Paid factory rent in cash 5,000 Factory equipment 3,000 expire 2,000 it. Total 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 16,000 (f) Recorded the following general and administrative costs: Advertising Depreciation Other expenses Amount Explanation 2,000 Advertising paid in cash 3,000 Office equipment 1,000 paid. Total 6,000 (9) Sold Job 101, which is recorded in Finished Goods: Sales Price Cost 55.000 30,000 (h) Completed Job 102 but did not sell it; Job 103 is still in process at year-end. Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 5 IN 125% AutoSave OFF no svu = Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments X Arial A A 10 ab Wrap Text General #Insert D Delete ir 29 O Paste B I Av Merge & Center Ideas $ % ) Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Format Find & Select Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H6 fx A B D E F G H J L 64 65 66 (h) Completed Job 102 but did not sell it; Job 103 is still in process at year-end. Requ 67 ired: 68 1 Compute the predetermined overhead rate. 69 Predetermined 70 overhead rate 71 72 2 Compute how much overhead would be applied to jobs during the period: 73 Overhead applied 3 Compute the total cost of Jobs 102 and 103 at the end of the period. You will enter your calculation in the Where will the cost of each of these jobs appear on the Balance sheet? enter your answer to #3 here. 4 Post the journal entries to the T' Accounts in the 'Ledger Accounts' tab. Calculate the ending balances in all 5 Calculate the amount of over- or underapplied overhead in the "Ledger Accounts' tab. 74 75 76 77 78 79 80 31 82 36 83 as 84 OF 85 86 27 37 88 89 90 91 92 93 94 95 96 97 98 6 Post the journal entry in the T accounts to dispose of the overhead balance in the 'Ledger Accounts' tab. 7 Prepare a statement of cost of goods manufactured report in the 'Reports' tab. 8 Prepare an income statement in the 'Reports' tab. Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 125% Comprehensive Problem 1 (S2-3 on page 104) Copy formatting from one location and apply it to another Home Insert Draw Page Layout Formulas Arial 10 ~ AP Data Review View Share 0 Comments = = 0 Insert v PM ab Wrap Text = General PA ou Ou 5 Delete v Paste B I U 2 Merge & Center v $ %) V .00 000 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format v Find & Select V A L12 X fixe A B D E F G H J L M N O Q 2 3 4 5 Manufacturing Overhead Raw Materials Inventory 10,000 1/1 Balance 6 7 8 9 10 11 12 Underapplied Overapplied 1/31 Balance 13 14 15 Job Sheet: 102 15,000 Job Sheet: 103 Work in Process Inventory 15,000 1/1 Balance 16 17 18 19 Beginning Balance add: Direct Materials add: Direct Labor add: Applied Overhead 20 21 22 Total Manufacturing Costs 15,000 1/31 Balance 23 24 25 Cost of Goods Sold 1/1 Balance Finished Goods Inventory 30,000 26 27 28 29 30 31 32 Unadjusted 1/31 1/31 Balance Adjusted 1/31 Sales Revenue Selling, General, and Administrative Expenses 33 34 35 36 37 38 39 40 41 42 43 1/31 Balance 1/31 Balance Given Ledger Accounts Reports + AutoSave OFF S5- Comprehensive Problem 1 (S2-3 on page 104) Q Arial Insert V 10 v AA ab ab Wrap Text General ITIV Dv TH WE Ou 5 DX Delete v Paste BIU A Z Lv Sort & Filter V E E V Merge & Center Ideas Sensitivi $ % ) V Conditional Format Cell Formatting as Table Styles Format Find & Select 0 L12 x fx B D E F G H J K M N O P 24 25 Cost of Goods Sold Finished Goods Inventory 30,000 1/1 Balance 26 27 28 29 30 31 32 Unadjusted 1/31 1/31 Balance Adjusted 1/31 Sales Revenue Selling, General, and Administrative Expenses 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 1/31 Balance 1/31 Balance Cash and Other Assets 100,000 Payables and Other Liabilities 85,000 1/1 Balance 1/1 Balance 1/31 Balance 1/31 Balance Stockholders' Equity 70,000 1/1 Balance 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 1/31 Balance Given Ledger Accounts Reports + Select destination and press ENTER or choose Paste 5 + 10 AutoSave OFF o svo Comprehensive Problem 1 (S2-3 on page 104) Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments Arial ~ AI v 10 LI = = Insert v DO General ab Wrap Text HEA ou Ou 5 Delete v Paste B I Merge & Center V $ % ) V Ideas .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Sensitivity V C45 x fx A B D E F G H - K Coda Company Cost of Goods Manufactured Report For the Month of January 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Beginning Raw Materials Inventory Plus: Raw Material Purchases Less: Indirect Material Used Less: Ending Raw Materials Inventory Direct Materials Used in Production Direct Labor Manufacturing Overhead Total Current Manufacturing Costs Plus: Beginning Work in Process Inventory Total Work in Process Less: Ending Work in Process Inventory Cost of Goods Manufactured 20 1 8 Coda Company Income Statement For the Month of January 21 22 23 24 25 26 27 28 Sales Revenue Less: Cost of Goods Sold Beginning Finished Goods Inventory Plus: Cost of Goods Manufactured" (see schedule above) Cost of Goods Available for Sale Less: Ending Finished Goods Inventory Unadjusted Cost of Goods Sold Under-/Overapplied Overhead Adjusted Cost of Goods Sold Gross Profit Less: Operating (Period) Expenses Net Income from Operations 29 30 31 32 33 34 35 36 37 38 39 40 41 1 1 Given Ledger Accounts Reports +