Purchase Solution

Santa Cruz, Inc: Total Manufacturing Costs and Cost of Goods

Not what you're looking for?

Ask Custom Question

Given the following information:

The following information comes from the accounting records for Santa Cruz, Inc., for March:

Direct material inventory, March 1 $ 18,900
Direct material inventory, March 31 15,000
Work-in-process inventory, March 1 8,200
Work-in-process inventory, March 31 6,200
Finished goods inventory, March 1 54,400
Finished goods inventory, March 31 72,600
Direct materials purchased during March 83,100
Direct labor costs, March 60,300
Manufacturing overhead, March 79,000

Compute Total manufacturing costs for the month of March.
Compute Cost of goods manufactured for the month of March
Compute Cost of goods sold for the month of March

Purchase this Solution

Solution Summary

Your tutorial shows you the "model" for the flow of costs among materials, work in process and finished goods. Next, the tutorial populates the model with the amounts given highlighting in yellow the missing amounts. Finally, the tutorial shows you in Excel (click in cells to see formula computation) how to solve the missing pieces in sequence to get the needed amounts. This is now a template for other similar problems. The tutorial uses "beginning, plus and minus monthly activity to get ending" rather that a debit/credit T account presentation. However, this fits nicely with a T account textbook by using debits as positive amounts and credits as negative amounts.

Solution Preview

See tutorial attached in Excel for coaching and computations.

Compute Total manufacturing costs for the month of March. = $226,300

Compute Cost of goods manufactured for the month of March = $235,100

Compute Cost of goods sold for the ...

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
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce