Fullerton Aggregate processes raw shale into lightweight aggregate material.Fullerton has only one production department. This department heat treats shale and injects it with fly ash as it passes through rotating kilns.The shale both expands and hardens in the process, and is ideally suited to road construction.Fullerton uses the weighted-average process costing method to account for production.The following information is available for a recent period:

• Beginning work in process on September 1 consisted of 75,000 tons that were 80% complete with respect to raw materials and 50% complete with respect to conversion costs.
• Ending work in process on September 30 consisted of 60,000 tons that were 70% complete with respect to raw materials and 40% complete with respect to conversion costs.
• 860,000 tons of material were put into production, and 875,000 tons exited production.There is no spoilage or loss of tonnage in the production process.
• Beginning work in process carried a total cost of $265,000 (direct materials: $106,000, direct labor: $53,000,and factory overhead: $106,000).Additional costs incurred during the month were $3,000,000 (direct materials: $1,500,000, direct labor: $1,000,000, and factory overhead: $500,000).

(a) cost of production report for September. report in tab 2, "Worksheet a" in the attached spreadsheet file.)

(b) Prepare journal entries to reflect the introduction of additional costs during September, as well as the transfer of completed units to finished goods.( report in tab 3, "Worksheet b" in the attached spreadsheet file.)

The specific accounting scenario and posting instructions are also included in the file.Remember to use proper formatting and account titles for all items in the project. Upload your file in Blackboard when you are finished.

** Could someone please help me solve this answer and input into a production cost template like below* It would go in an excel speadsheet*

Fuller Aggregate Step 1: Step 2: Equivalent Units Month-ended September 30 Flow of Production Flow of Physical Units Direct Materials Conversion Costs Total Units to Account for: Beginning WIP, Sept 1 - Started in production - Physical units to account for: - Units accounted for: Completed and transferred - - - Ending WIP, Sept 30 - - - Physical units accounted for - Total Equivalent Units - - Total Costs to account for and Cost per Equivalent Unit Beginning WIP, Sept 1 - - - Costs added - - - Total Costs to account for - - - Cost per equivalent unit Total cost to account for - - Divided by equivalent units - - Cost per equivalent unit #DIV/0! #DIV/0! Assigning Costs Completed and transferred out Equivalent units completed and transferred out - - Multiplied by Cost per equivalent unit #DIV/0! #DIV/0! Cost assigned to completed units #DIV/0! #DIV/0! #DIV/0! Ending WIP Equivalent units in ending WIP - - Multiplied by Cost per equivalent unit #DIV/0! #DIV/0! Cost assigned to units in ending WIP #DIV/0! #DIV/0! #DIV/0! Total costs accounted for #DIV/0!