\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Chapter 3: Applying Excel & & & & & \\ \hline \multicolumn{7}{|l|}{2} \\ \hline 3 & Data & & & & & \\ \hline 4 & Allocation base & \multicolumn{2}{|l|}{ Machine-hours } & & & \\ \hline 5 & Estimated manufacturing overhead cost & $300,000 & & & & \\ \hline 6 & Estimated total amount of the allocation base & 75,000 & machine-hours & & & \\ \hline 7 & Actual manufacturing overhead cost & $290,000 & & & & \\ \hline 8 & Actual total amount of the allocation base & 68,000 & machine-hours & & & \\ \hline \multicolumn{7}{|l|}{9} \\ \hline 10 & Enter a formula into each of the cells marked with a ? below & & & & & \\ \hline \multicolumn{7}{|l|}{11} \\ \hline 12 & Computation of the predetermined overhead rate & & & & & \\ \hline 13 & Estimated manufacturing overhead cost & ? & & & & \\ \hline 14 & Estimated total amount of the allocation base & ? & machine-hours & & & \\ \hline 15 & Predetermined overhead rate & ? & per machine-hour & & & \\ \hline \multicolumn{7}{|l|}{16} \\ \hline 17 & Computation of underapplied or overapplied manufacturing overhead & & & & & \\ \hline 18 & Actual manufacturing overhead cost & ? & & & & \\ \hline 19 & Manufacturing overhead cost applied to Work in Process during the year: & & & & & \\ \hline 20 & Predetermined overhead rate & ? & per machine-hour & & & \\ \hline 21 & Actual total amount of the allocation base & ? & machine-hours & & & \\ \hline 22 & Manufacturing overhead applied & ? & & & & \\ \hline 23 & Underapplied (overapplied) manufacturing overhead & ? & & & & \\ \hline 24 & & & & & & \\ \hline 25 & & & & & & \\ \hline \end{tabular} 2. Change all of the numbers in the data area of your worksheet so that it looks like this: If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) (b) By how much is the manufacturing overhead underapplied or overapplied