expalin how u found over head applied

Data Allocation base Estimated manufacturing overhead cost Machine-hours Estimated total amount of the allocation base $300000 Actual manufacturing overhead cost 75000 machine-hours Actual total amount of the allocation base $290000 68000 machine-hours Enter a formula into each of the cells marked with a ? below Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost 14 Estimated total amount of the allocation base ? 15 |Predetermined overhead rate ? machine-hours 16 ? per machine-hour Computation of underapplied or overapplied manufacturing overhead 18 Actual manufacturing overhead cost Manufacturing overhead cost applied to Work in Process during the year: 3 20 Predetermined overhead rate 21 Actual total amount of the allocation base ? per machine-hour 22 Manufacturing overhead applied ? machine-hours Underapplied (overapplied) manufacturing overhead 24 ?? A B C Schedule of Cost of Goods Manufactured Schedule of Cost of Goods Sold 1 Traditional Format Income Statement \begin{tabular}{|l|l|l|} \hline & Traditional format income Statement \\ \hline 2 & \\ \hline 3 & \\ \hline 4 & \\ \hline 5 & \\ \hline 6 & & \\ \hline \end{tabular} 1 Contribution Format Income Statement \begin{tabular}{|l|l|l|} \hline 2 & & \\ \hline 3 & & \\ \hline & \multicolumn{1}{|c|}{} & \\ \hline 4 & & \\ \cline { 2 - 4 } & \multicolumn{1}{|c|}{} \\ \hline & & \\ \hline & & \\ \hline 7 & & \\ \hline 8 & & \\ \hline \end{tabular} The following data from the just completed year are taken from the accounting records of Nouf Company (in dollars): Sbeet 1. Calculate POHR overhe fowing reports in the assigned tabs of the excel file: Sheet 2. Prepare a schedule of costied and under- or overapplied overhead Sheet 3. Prepare a seliedule of cost of goods manufactured. Sheet 4. Prepare a tradice of cost of goods sold; Calculate Adjusted COGS. Sheet 5. Prepare a fontribul format income statement