Question: Hello. Can this answer be shown in excel with formulas? Thank you in advance Excel Assignment # 3 - Production Cost Report Summer Because most

Hello. Can this answer be shown in excel with formulas? Thank you in advance

Hello. Can this answer be shown in excel with formulas? Thank you

Excel Assignment # 3 - Production Cost Report Summer Because most of the parts for its irrigation systems are standard, Northern Illinois Manufacturing handles the majority of its manufacturing as a process cost system. There are multiple process departments. Three of these departments are the Molding, Welding, and Assembly departments. All items eventually end up in the Packaging Department which prepares items for sale in kits or individually. The following information is available for the Molding Department for January: Work in process beginning: Units in process 24,000 Stage of completion for materials 80% Stage of completion for labor and overhead 30% Costs in work in process inventory: Materials $172.460 Labor 68.900 Overhead 141.300 Total costs in beginning work in process $382.660 Units started into production in January 71.000 Costs added to production: Materials $378.605 Labor 690.080 Overhead 1383,160 Total cots added into production in January $2.451.845 Work in process ending Units in process 21.000 Stage of completion for materials 75% Stage of completion for labor and overhead 20% Instructions: Prepare a production cost report for Northern Illinois Manufacturing using the weighted-average method and then show the journal entry for transferring the units from Molding to the Welding Department

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!