Purchase Solution

Gourmet Specialty Coffee Company -Activity based costing

Not what you're looking for?

Ask Custom Question

See attached file.

Budgeted sales ............................................................................... 2,000 lb. 100,000 lb.
Batch size ...................................................................................... 500 lb. 20,000 lb.
Setups ........................................................................................... 3 per batch 3 per batch
Purchase order size ........................................................................ 500 lb. 50,000 lb.
Roasting time ................................................................................. 1 hr. per 200 lb. 1 hr. per 200 lb.
Blending time ................................................................................. .5 hr. per 200 lb. .5 hr. per 200 lb.
Packaging time ............................................................................... .1 hr. per 200 lb. .1 hr. per 200 lb.

Required:

1. Using GSCC's current product-costing system:
a. Determine the company's predetermined overhead rate using direct-labor cost as the single
cost driver.
b. Determine the full product costs and selling prices of one pound of Jamaican coffee and one
pound of Colombian coffee.

2. Develop a new product cost, using an activity-based costing approach, for one pound of Jamaican
coffee and one pound of Colombian coffee.

3. What are the implications of the activity-based costing system with respect to:
a. The use of direct labor as a basis for applying overhead to products?
b. The use of the existing product-costing system as the basis for pricing?

Attachments
Purchase this Solution

Solution Summary

I have computed the required amounts in Excel (click on cells to see computation) so you can have a template for other similar problems. You have to compute the number of batches and hours for each product in order to apply overhead so this is an added step that you usually don't need with ABC problems. So, you compute rate, activity for the sales levels and then you can apply overhead. Implications of using ABC versus traditional are given (few sentences).

Solution Preview

See attached Excel file.

I have computed the required amounts in Excel (click on cells to see computation) so you can ...

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
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

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Lean your Process

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

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.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.