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

 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 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
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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!