Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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

Management And Cost Accounting

Authors: Alnoor Bhimani, Srikant M. Datar, Charles T. Horngren, Madhav V. Rajan

7th Edition

1292232668, 978-1292232669

More Books

Students also viewed these Accounting questions

Question

Is Abandoned Spouse one of the filing statuses? Explain.

Answered: 1 week ago