Managerial Essay

Problems Chapter 4Problem 4-26Moravia Company fulfilles and packages plane cheese. The following data have been compiled for the month of April. vicissitude activity occurs uniformly end-to-end the production cover. 1) Analysis of physical stop of social social units.2) Calculation of equivalent units.3) Computation of unit costs.4) Analysis of total costs.5) Build a Spreadsheet Construct an Excel spreadsheet to solve exclusively of the preceding requirements. Show how the solution volition counterchange if the following data change the April 1 urinate in process costs were $27,000 for direct material and $5,000 for conversion.1. somatogenicUnits dress in process, April 1 10,000 Units started during April 100,000 native units to account for 110,000 Units finish and transferred come forward during April 80,000 mesh in process, April 30 30,000 sum of money units accounted for 110,0002. somatogenetic Units Percentage of Completion with Respect to regeneratio nEquivalent Units transmit visibleConversion Work in process, April 1 10,000 20% Units started during April 100,000 Total units to account for 110,000 Units completed andtransferredout during April80,000100%80,00080,000 Work in process, April 30 30,000 33.33% 30,000 9,900 Total units accounted for 110,000 Total equivalent units 110,000 89,9003. broadcast Material Conversion Total Work in process, April 1 $22,000 $4,500 $26,500 be incurred during April 198,000 158,400 356,400 Total costs to account for $220,000 $162,900 $382,900 Equivalent units 110,000 89,900 constitutes per equivalent unit $2.00 $1.81 $3.814. Cost of goods completed and transferred out during April (Units Transferred) *(Total Cost per equiv. unit) = 80,000$3.81 $304,961 Cost rest in April 30 work-in-process inventory mastermind material ( of equivalent units of Direct Material ) * ( Cost per Equivalent Unit of Direct Material) = 30,000$2.00 $60,000 Convers ion ( of equivalent units of conversion) * (Cost per equivalent unit of conversion) = 9,900$1.81 17,939 Total cost of April 30 work in process $77,919 Check Cost of goods completed and transferred out $304,961 Cost of April 30 work-in-process inventory 17,939 Total costs accounted for $382,900 5Build a Spreadsheet Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution testament change if the following data change the April 1 work in process costs were $27,000 for direct material and $5,000 for conversion.