Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started