ORIGINAL PROBLIDM DATA $(1$ST Dreel File$)$:

CHDCR DIGURDS: Materials: $$6\mathrm{.}30$ per DU

Conversion: $$26\mathrm{.}90$ per DU

$8/31/2023$ DI: WIP $$8,340$

Odagon Incorporated was founded over $75$ years ago in Rome, GA$.$ Odagon's product is popular in the Rome metropolitan area. The company uses the FIFO method in its process costing system. Production data for the month of August $2023$ appears below:

Production data:

Units in process, August $1($materials $50\%$ complete; conversion $90\%$ complete$)........400$ Units started into production. $........................11,000$ Units in process, August $31($materials $90\%$ complete; conversion $20\%$ complete$)......800$

Cost data:

Work in process inventory, August $1$:

Conversion cost $....................................$ $$,576$

Cost added during the month:

Materials cost $................................$ $$70,056$

Conversion cost $.................................$ $$279,760$

RDOUIRDNINNTS:

Part $1$: Prepare a complete $($including cost reconciliation$)$ FIFO production report using the data from the Data Block. You will need to calculate "Units started and completed". Use the Report Format template file for the structure of the report that is on the "Text FIFO Example" Excel file I have provided.

Part $2$: Complete the "What If Analysis" using the What If Analysis Data on the last page of these instructions.

No Graph is required for this assignment.

NOTV: RDOUIRDD ELEMINNTS:

You must include the required clements listed below for both files or you will receive a MMRO on your assignment.

Data block page

Production Report with cell referencing from data block page and other parts of the Report. Do not type numbers directly into the Report. All amounts in$?$ be supported by cell referencing or formulas using cell referencing.

Submit two files: one with the FIFO production report and data block using the original problem data and one with the FIFO production report and data block using the "What if$"$ analysis data.