Purchase Solution

Cost Reconciliation Schedule: Maple Inc.

Not what you're looking for?

Ask Custom Question

Maple, Inc. manufactures syrup that goes through three processing stages prior to completion. Information on work in the first department, Blending, is given below for August:

Production data:
Pounds in process, August 1; materials 100% complete; conversion 70% complete 3,000
Pounds started into production during August 85,000
Pounds completed and transferred out ?
Pounds in process, August 31; materials 80% complete; conversion 30% complete 6,000
Cost data:
Work in process inventory, August 1:
Materials cost $900
Conversion cost $5,900
Cost added during May:
Materials cost $151,000
Conversion cost $161,700

The company uses the weighted-average method.

Submit an Excel document which each tab labeled by item number in good form that demonstrates the following:
Compute the equivalent units of production.
Compute the costs per equivalent unit for the month.
Determine the cost of ending work in process inventory and of the units transferred out to the next department.
Prepare a cost reconciliation schedule for the month.

Purchase this Solution

Solution Summary

Your tutorial is in Excel, attached. The process is shown with labels and computations to assist. Click in cells to see computation. This is now a template you can use for other similar problems.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)