Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting Lawrence S C Good Condition ISBN 08512

Authors: S.C. Lawrence

1st Edition

9780851215099

More Books

Students also viewed these Accounting questions