Question: please help The following data from the just completed year are taken from the accounting records of Fatimah Company (in dollars): Instructions. Please prepare the





The following data from the just completed year are taken from the accounting records of Fatimah Company (in dollars): Instructions. Please prepare the following reports in the assigned tabs of the excel file: Sheet 1. Calculate POHR, overhead applied and under- or overapplied overhead Sheet 2. Prepare a schedule of cost of goods manufactured. Sheet 3. Prepare a schedule of cost of goods sold; Sheet 4. Prepare a traditional format income statement; Sheet 5. Prepare a contribution format income statement. \begin{tabular}{|l|c|c|} \hline \multicolumn{1}{|c|}{} & A & B \\ \hline & & \\ \hline Data & & \\ \hline Allocation base & Machine-hours \\ \hline Estimated manufacturing overhead cost & $300,000 \\ \hline Estimated total amount of the allocation base & 75,000 & machine-hours \\ \hline Actual manufacturing overhead cost & $290,000 \\ \hline Actual total amount of the allocation base & 68,000 machine-hours \\ \hline \end{tabular} Enter a formula into each of the cells marked with a ? below \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Schedule of Cost of Goods Manufactured } \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} A B Schedule of Cost of Goods Sold B Traditional Format Income Statement Contribution Format Income Statement
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
