Purchase Solution

Building and Analyzing a Monthly Profit Report

Not what you're looking for?

Ask Custom Question

Background:
Performance Drinks makes four different kinds of sports drinks. Those drinks are as follows:
- Basic
- Hydration
- Intensity
- Post-Workout
You recall from your Management Accounting class that product costs are comprised of:
- Direct Materials
- Direct Labor
- Manufacturing Overhead

That report is following:
(see attached file for data)
Since your primary area of focus is on the indirect costs you compile the following report which further details your overhead charges:

Requirements:
1. Based on all of the date provided, compute the cost driver rates for each of the four activities.
2. Compute the per unit product costs for each of the four products. Compute this cost using ABC allocation for overhead. Show the computation for each per unit product cost in detail.
3. Prepare a "Monthly Profit Report", like the one provided on page 4 of this packet. Create this report using the results of your ABC overhead allocation.
4. Explain why the profit for each product is different when comparing the Traditional report with the ABC report. Explain what the company might consider doing, based on all of this information, to stop the erosion of company profits. Defend your recommendations with data.
Additional Consideration:
If plant capacity was shifted from 20,000 machine-hours a month to 40,000 machine-hours per month!
5. Compute the new cost per unit for each of the products considering the increase in capacity. Show the computation for each per unit product cost in detail.
6. What is the cost of the unused capacity if it is assumed that the company has 40,000 machine-hours of capacity but it using 20,000 machine-hours? Amend your "Management Report" to include a discussion on how to best use the additional capacity.

(see attached file for more detailed information and questions)

Attachments
Purchase this Solution
Solution Summary

The expert builds and analyzes a monthly profit report. Performance drinks for four different kinds of sport drinks are given.

Solution provided by:
Chidi Ngene, M. Sc.
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Operations Management

This quiz tests a student's knowledge about Operations Management

Learning Lean

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

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • 653909 All-Store business analysis All-Store Calculations and Report You need to analyze three areas of the All-Store business: declining sales, reducing staffing, and purchasing the building.

  • Monthly Profit Report

    560140 Monthly Profit Report Requirement #1 Using the data above (attached in Question file), which has also been provided electronically in Excel, run the following regression analyses: • Linear regression analyzing total overhead cost and units sold

  • All-Store Calculations and Report

    657373 All-Store Calculations and Report All-Store Calculations and Report You need to analyze three areas of the All-Store business: declining sales, reducing staffing, and purchasing the building.

  • Projected monthly profit;expected annual return

    On average, the budgeted monthly costs will will be: Wages for labor: $900 Rent on store building: $1500 Utilities: $300 Advertising: $500 Delivery costs: $400 a. What is the projected monthly profit? b.

  • Accounting Costs and Economic Costs

    242126 Accounting Costs and Economic Cost summary Please respond to the following: A company incurs the following monthly costs: Labor $400 Equipment $300 Materials $100 It owns the building (which usually rents for

  • Fixed costs, Equilbrium price and quantity

    Assume instead that Florence does not own a building, and that she will have to rent a building for $1,000 per month (all other estimates remain the same).

  • Statement of Cash Flows, Financial ratios

    Many revenues and expenses result from accruals and allocations that do not affect cash. A company can operate at a profit and continually be short of cash. It can also generate huge inflows of cash from operations and still report a loss.

  • Analyzing Target Corporation

    ( This includes Cash, Inventory and other current Assets) Property and equipment are around $25 billion ( This include Land, Building, Fixtures etc.) Analyzing Target Corporation

  • Scorekeeping, Attention Directing, and Problem Solving

    Explaining the stamping department's performance report. 6. Preparing a monthly statement of European sales for the Ford Motor Company's vice president of marketing. 7.

View More Related Solutions