I must use the information given to fill out the chart

Quality Custom Cabinets Ltd. November 2019 Page 1 of 2 5 Quality was very busy during November of 2019 completing cabinets for 6 their customers in time to be installed before Christmas. 8 The following are expenses and costs incurred during the month: Mfg OH Direct Expenses Selling Expenses Admin Expenses 450 1.180 5.235 3.240 1.260 245 1,155 500 810 325 2.925 4,180 236 2.830 670 975 3.100 1.985 26.935 10 Accounting and Legal Expense 11 Advertising 12 Cabinet Doors 13 Cabinet Hardware 14 Consumable Materials 15 Depreciation - Delivery equipment 16 Depreciation - Office equipment 17 Depreciation - Factory equipment 18 Depreciation - Showroom 19 Donations 20 Employee benefits - Administration 21 Employee benefits - Sales 22 Employee benefits - Factory 23 Finish (Stain & Lacquer) 24 Insurance - Office 25 Insurance - Factory 26 Insurance - Vehicles 27 Interest Expense 28 Labor - Administration 29 Labor. Sales 30 Labor. Factory 31 Office Supplies 32 Payroll taxes - Administration 33 Payroll taxes - Sales 34 Payroll taxes - Factory 35 Rent - Office building 36 Rent - Factory building 37 Rent - Showroom 38 Repairs & maintenance - Office 39 Repairs & maintenance - Factory 40 Repairs & maintenance - Showroom 41 Factory Supplies 42 Small Tools Expense 43 Telephone 44 Truck expense 45 Uniforms Factory 46 Utilities - Office 47 Utilities - Factory 48 Utilities - Showroom 49 Wood 50 51 Total 980 240 180 2.655 1,500 750 260 2.385 880 1,525 1.510 755 2,130 415 155 LA 990 380 10.680 90.295 Quality Custom Cabinets Ltd. November 2019 Page 2 of 2 57 The predetermined overhead allocation rate for the year is based on the following: 59 Estimated total annual manufacturing overhead 60 Estimated total annual direct labor hours 169,576 9,635 63 The Alladena job was started and completed in November 54 65 The job cost card shows the following: 67 Materials 68 Direct Labor hours 69 Direct Labor dollars 70 Manufacturing overhead applied 3,884 190 4.275 72 Required: 73 (1) Compute the Manufacturing overhead applied to the Pinto job 74 75 2) Compute the Gross Profit for the Pinto job id income was 77 3) Complete columns above showing manufacturing overhead, selling expenses and administrative expenses 78 Place each amount in the right column and total the columns You will need these totals for problem 14 & 5 below) 1085 Hours 80 4) Assuming that the total direct labor hours for the month were 81 Compute the overhead variance and state whether it is under applied or over applied 83 5) Prepare November's Income Statement with the information from above and the following: 84 85 Beginning Raw Materials 6,500 86 Ending Raw Materials 4875 87 Beginning Work in Process 8.250 88 Ending Work in Process 10.560 89 Sales 106,000 90 Note: No Finished Goods inventory 91 Use actual manufacturing overhead, not applied. Numbers used in example 10.000 6.000 7,500 10.000 115,000 95 Quality Custom Cabinets Lid. 96 Income Statement 97 For the Month Ended November 30, 2018 Example of Income Statement Imperial Custom Cabinets Ltd. Income Statement For the Month Ended November 30, 2017 115,000 100 Sales 101 102 COGS 103 Beginning Raw Materials 10.000 12.000 Sleel Beams Doors Paint 5.500 4.500 8.500 40.500 16.000) 34,500 32.850 15,150 7,500 (10,000) 105 106 107 108 Total Materials Available 109 Less Ending Raw Materials 10 Direct Materials Used 11 Direct Labor 12 Manufacturing Overhead Applied 113 Beginning Work in Process 114 Less Ending Work in Process 115 Unadjusted Cost of Goods Sold 16 Underl(Over) Applied 117 Total Cost of Goods Sold 118 119 Gross Profi 120 121 Selling Expenses 122 Administrative Expenses 123 Total Expenses 124 125 Net Income 80.000 (186) 35. 188 8,850 9.675 18.525 16.661 Quality Custom Cabinets Ltd. November 2019 Page 1 of 2 5 Quality was very busy during November of 2019 completing cabinets for 6 their customers in time to be installed before Christmas. 8 The following are expenses and costs incurred during the month: Mfg OH Direct Expenses Selling Expenses Admin Expenses 450 1.180 5.235 3.240 1.260 245 1,155 500 810 325 2.925 4,180 236 2.830 670 975 3.100 1.985 26.935 10 Accounting and Legal Expense 11 Advertising 12 Cabinet Doors 13 Cabinet Hardware 14 Consumable Materials 15 Depreciation - Delivery equipment 16 Depreciation - Office equipment 17 Depreciation - Factory equipment 18 Depreciation - Showroom 19 Donations 20 Employee benefits - Administration 21 Employee benefits - Sales 22 Employee benefits - Factory 23 Finish (Stain & Lacquer) 24 Insurance - Office 25 Insurance - Factory 26 Insurance - Vehicles 27 Interest Expense 28 Labor - Administration 29 Labor. Sales 30 Labor. Factory 31 Office Supplies 32 Payroll taxes - Administration 33 Payroll taxes - Sales 34 Payroll taxes - Factory 35 Rent - Office building 36 Rent - Factory building 37 Rent - Showroom 38 Repairs & maintenance - Office 39 Repairs & maintenance - Factory 40 Repairs & maintenance - Showroom 41 Factory Supplies 42 Small Tools Expense 43 Telephone 44 Truck expense 45 Uniforms Factory 46 Utilities - Office 47 Utilities - Factory 48 Utilities - Showroom 49 Wood 50 51 Total 980 240 180 2.655 1,500 750 260 2.385 880 1,525 1.510 755 2,130 415 155 LA 990 380 10.680 90.295 Quality Custom Cabinets Ltd. November 2019 Page 2 of 2 57 The predetermined overhead allocation rate for the year is based on the following: 59 Estimated total annual manufacturing overhead 60 Estimated total annual direct labor hours 169,576 9,635 63 The Alladena job was started and completed in November 54 65 The job cost card shows the following: 67 Materials 68 Direct Labor hours 69 Direct Labor dollars 70 Manufacturing overhead applied 3,884 190 4.275 72 Required: 73 (1) Compute the Manufacturing overhead applied to the Pinto job 74 75 2) Compute the Gross Profit for the Pinto job id income was 77 3) Complete columns above showing manufacturing overhead, selling expenses and administrative expenses 78 Place each amount in the right column and total the columns You will need these totals for problem 14 & 5 below) 1085 Hours 80 4) Assuming that the total direct labor hours for the month were 81 Compute the overhead variance and state whether it is under applied or over applied 83 5) Prepare November's Income Statement with the information from above and the following: 84 85 Beginning Raw Materials 6,500 86 Ending Raw Materials 4875 87 Beginning Work in Process 8.250 88 Ending Work in Process 10.560 89 Sales 106,000 90 Note: No Finished Goods inventory 91 Use actual manufacturing overhead, not applied. Numbers used in example 10.000 6.000 7,500 10.000 115,000 95 Quality Custom Cabinets Lid. 96 Income Statement 97 For the Month Ended November 30, 2018 Example of Income Statement Imperial Custom Cabinets Ltd. Income Statement For the Month Ended November 30, 2017 115,000 100 Sales 101 102 COGS 103 Beginning Raw Materials 10.000 12.000 Sleel Beams Doors Paint 5.500 4.500 8.500 40.500 16.000) 34,500 32.850 15,150 7,500 (10,000) 105 106 107 108 Total Materials Available 109 Less Ending Raw Materials 10 Direct Materials Used 11 Direct Labor 12 Manufacturing Overhead Applied 113 Beginning Work in Process 114 Less Ending Work in Process 115 Unadjusted Cost of Goods Sold 16 Underl(Over) Applied 117 Total Cost of Goods Sold 118 119 Gross Profi 120 121 Selling Expenses 122 Administrative Expenses 123 Total Expenses 124 125 Net Income 80.000 (186) 35. 188 8,850 9.675 18.525 16.661