Purchase Solution

ABC Costing for Sola Systems; profit by product region panel

Not what you're looking for?

Ask Custom Question

Sola Systems, a company focussed on clean, energy products assembles and sells two types of solar panels, Panel A and Panel B. The company's sales occur in two regions - One is called Northern and incorporates Queensland, New South Wales and the Northern Territory. The other is called Southern and incorporates Victoria, Tasmania, South Australia, and Western Australia.

You are Sunny Power and you are to write a report to Ms. Eva Green to assist her in understanding Sola Systems costing systems, problems and alternatives as outlined below.
a) Using the current costing system, calculate the product cost of each panel.
b) Using the current costing system, prepare a classified profit statement by product.
c) Using the current costing system, prepare a classified profit statement by region.
d) Why does Panel A have higher gross and net profit rates than panel B? Make sure to use the case study and your profit statements to support your discussion.
e) Using Activity Based Costing, calculate the product cost of each panel.
f) Using Activity Based Costing, prepare a classified profit statement by product.
g) Using Activity Based Costing, prepare a classified profit statement by region.

Purchase this Solution

Solution Summary

Your tutorial creates six schedules, three for "previous costing method" and three for "activity based costing (in Excel, attached)." ABC is used for product costs only. A separate file shows ABC for period costs for products but not for north/south (you can figure this out for yourself from the work already done). Click in cells to see computations. Your discussion and recommendations are 560 words.

Solution Preview

A - G (see excel, attached)


Ms. Eva Green:

Activity based costing (ABC) is a more accurate cost of the product costs for Panel A and B and better information for decision-making for several reasons.

(1) Resources consumed

ABC allocates indirect product costs based on overhead resources consumed, not labor costs. Since the overhead consumed is not in the same proportion of labor hours, this makes a difference. For batch costs, under ABC, the two product lines share the batch costs evenly. This is a very different "split" of the batch costs than if you allocated based on direct labor hours.

(2) Awareness of costs per activity

ABC produces an "ala carte" charge for overhead uses showing the incremental costs for activity. For instance, the cost per batch is now computed and shared with managers. This creates some sensitivity about whether to start a new batch for low volume uses since the charge is the same ...

Solution provided by:
  • 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
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

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.

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.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Basics of corporate finance

These questions will test you on your knowledge of finance.