PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS

Must be submitted in excel with any math done with formulas within cells.

The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was 18,500 units averaging 45 percent complete. Production data shows 188,400 units were started during the period. Beginning work in process inventory costs totaled $11,282 including $7,296 for conversion costs. For the month of August, additional costs totaling $75,264 for direct materials and $111,034 for conversion costs were added in the production department during the period.

1) Prepare in good form a process report.

2) Prepare the journal entry to move costs to finished goods.

3) Prepare any journal entry, if required, for costs remaining in WIP.