Question

Required information Chapter 3: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L under Course Administration. Step 2: Then enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "=B5". Step 3: Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Step 4: Proceed to the requirements below only after completing your worksheet as it will be used to answer the following questions. Chapter 3: Applying Excel: Exercise 2. Change all of the numbers in the data area of your worksheet so that it looks like this: B с A Chapter 3: Applying Excel 1 2 3 Data 4 5 6 7 Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base Machine-hours $ 215,600 44,000 machine-hours $ 220,900 48,000 machine-hours 8

Answer 1

Machine Hours 215600 44000 Machine Hours 220900 48000 Machine Hours 1 Chapter 3; Applying Excel 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 amount of the allocation base 9 10 Predetermined Overhead rate 11 12 Formulas used 13 14 b) 15 Applied Overheads 16 Actual Manufacturing Overhead Cost 17 Overapplied Overheads by 18 4.90 Per Machine Hour B5/B6 Formulas used 235200 B8*B10 220900 B7 14300 B15-B16 19

20 Chapter 3; Applying Excel 21 22 Data 23 Allocation Base Machine Hours 24 Estimated Manufacturing Overhead Cost 215600 25 Estimated total amount of the allocation base 49000 Machine Hours 26 Actual Manufacturing Overhead Cost 220900 27 Actual amount of the allocation base 48000 Machine Hours 28 29 Predetermined Overhead rate 4.40 Per Machine Hour 30 31 Formulas used B24/B25 32 33 b) Formulas used 34 Actual Manufacturing Overhead Cost 220900 B26 35 Applied Overheads 211200 B27*B29 36 Underapplied Overheads by 9700 B34-B35 37 38 b) 39 The change in the estimated total amount of the allocation base affected the Predetermined overhead rate 40 The change in the estimated total amount of the allocation base affected the amount of manufacturing overhead applied. 41

42 4) 43 Chapter 3; Applying Excel 44 45 Data 46 Allocation Base Machine Hours 47 Estimated Manufacturing Overhead Cost 215600 48 Estimated total amount of the allocation base 44000 Machine Hours 49 Actual Manufacturing Overhead Cost 215100 50 Actual amount of the allocation base 48000 Machine Hours 51 52 Predetermined Overhead rate 4.90 Per Machine Hour 53 54 Formulas used B47/B48 55 56 b) Formulas used 57 Applied Overheads 235200 B50*B52 58 Actual Manufacturing Overhead Cost 215100 B49 59 Overapplied Overheads by 20100 B57-158 60 61 Note; 62 As per HOMEWORKLIB POLICY we are allowed to answer first question if there are multiple questions. 63 and I have answered first questions with all the parts.