Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave OOD R E xcelTemplateAssignment Ch03 (1) Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED

image text in transcribed
image text in transcribed
AutoSave OOD R E xcelTemplateAssignment Ch03 (1) Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing X R E3-7 Prepare a production report A ABCD 1 E3-7\Prepare a production report 2 The Sanding Department of Quik Furniture Company has the following production and manufacturing cost 3 data for March 2017, the first month of operation. Production: 7,000 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs. Manufacturing costs: Materials $33,000, labor $21,000, overhead $36,000, 8 Instructions 9 Prepare a production cost report. 10 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". QUIK FURNITURE COMPANY Sanding Department Production Cost Report For the Month ended March 31, 2017 Equivalent Units Physical Conversion 19 Quantities Units Materials Costs 20 Units to be accounted for 21 Work in process, March 1 22 Started into production 23 Total units Valde Value Value 25 Units accounted for Transferred out 27 Work in process, March 31 28 Total units Value Value Value Value D- 703-1100 Enable Ed AutoSave O R Excel TemplateAssignment_Ch03 (1) . Protected View Excel Search File Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View AI . : X fi E3-7 Prepare a production report A B C D Conversion 31 Costs Materials Costs Total 32 Unit costs 33 Total cost(a) Equivalent units (b) Value Value 35 Unit costs (a) + (b) 34 For Value Value 37 Costs to be accounted for 38 Work in process, March 1 39 Started into production 40 Total costs 41 42 Cost Reconciliation Schedule 43 Cost accounted for 44 Transferred out 45 Work in Process, March 31 Materials 47 Conversion costs 48 Total costs Value Value Value 52 A or you have completed the requiroments of E3-7, consider this addicional question 531. Assume that 9,000 units were completed and transferred out. Show the impact of this change on the calculation of equivalent units, unit cost, and on the cost reconciliation schedule. 01- 7 03-11 C031 - Type here to search 011 M e w @eleman

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

How To Audit Anything The Pink Book Of Auditing Any Process

Authors: R. Alakbarov

1st Edition

1520195575, 978-1520195575

More Books

Students also viewed these Accounting questions