Purchase Solution

activity-based costing data

Not what you're looking for?

Ask Custom Question

The New Millenium Manufacturing Company produces two products. One is a millenium surf kit. The other product is a professional surf-board (short board) used in world class surfing competition. Most of the sales come from the millenium surf product, but recently sales of professional boards have been increasing. The following information relates to the products for the most recent fiscal year:
Millenium Surf Kit Professional Board
Sales (units) 1,500 500
Selling price per unit $980 $650
Direct labor hours required to produce one unit 6 9
Machine hours required to produce one unit 5 8
Direct material costs per unit $212 $265
Direct labor costs per unit $85 $85
Management is concerned about the current system's effectiveness in allocating overhead and in computing the production costs of the two products. Consequently, Millenium Manufacturing hires a consultant to analyze the overhead costs and assist the company in creating an activity-based costing system. The consultant breaks down the total overhead costs into four categories and measured the activity levels for those same categories as shown below:
Cost Pool
Description Cost Driver
Millenium Surf Kit
Level of Activity Professional Board
Level of Activity Total Costs
Incurred
Equipment Machine hours 7,500 4,000 $90,000
Material Orders Number of orders 150 475 33,000
Machine Setups Number of setups 70 216 30,600
Quality Control Direct labor hours 5 25 58,000
Total $211,600
Required:
1. Calculate the manufacturing overhead rate based on labor hours and machine hours (two separate computations).
2. Determine the cost to manufacturing one unit of each model using two different traditional approaches; direct labor hours and machine hours.
3. Determine the cost to manufacturing one unit of each model using the activity-based costing data presented above.
4. Is the millenium surf kit as profitable as the company may think it is based on its present system?
5. What should Millenium Manufacturing Company do to improve its profitability?

Purchase this Solution
Solution Summary

Calculate the manufacturing overhead rate based on labor hours and machine hours in this case.

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
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Income Streams

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

View More Free Quizzes
Related BrainMass Solutions

  • Article Relevant to Activity-Based Costing (ABC), Job Costing, or Process Costing

    Therefore, there is a need for the construction industry to devise efficient and effective data gathering processes for its activity-based costing system. Remember that any inventory costing method is only as accurate as the data fed to the system.

  • Traditional Costing vs. Activity Based Costing

    Determine the unit product cost of the Deluxe and Standard products under the activity based costing system. Please see the attachment The solution explains how to calculate the product cost using traditional costing and activity based costing

  • identified data for a typical month

    When developing your activity-based costing rates, be sure to show the activity/resource, cost, volume, and rate per unit of measure. b.

  • Practice exam questions, managerial accounting

    Dilloo Company uses an activity-based costing system with three activity cost pools.

  • Activity-based costing system.

    458068 Activity-based costing system. Murri Corporation has an activity-based costing system with three activity cost pools-Processing, Setting Up, and Other.

  • Average cost of product

    Ravelo Corporation has provided the following data from its activity-based costing system: Activity Cost Pool Total Cost Total Activity Assembly 498,520 44,000 machine-hours Processing orders 54,263 1,100 orders Inspection 77,589 1,110

  • Compare ABC to department-based costing system; advantages o

    -In your opinion, what are the advantages/disadvantages of activity and department costing systems? Explain how activity-based costing system is different from department-based costing system.

  • Activity-based costing of customers

    471779 Activity-based costing of customers Please see the attachment for the formatted question. 10-23. Activity-Based Costing of Customers Marvin's Kitchen Supply delivers restaurant supplies throughout the city.

  • Activity-Based Costing vs. Traditional

    Data for this proposed activity-based costing system appear below: Activities and Activity Measures Estimated Overhead Cost Assembling products (DLHs) $ 140,000 Preparing batches (batches) 241,150 Axial milling (MHs) 766,500

  • Activity based vs. traditional costing

    209590 Activity based vs. traditional costing ABC currently uses traditional costing procedures, applying $410,000 of overhead to products X and Y on the basis of direct labor hours.

View More Related Solutions