Managerial Accounting
17th Edition
ISBN: 9781260247787
Author: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7, Problem 3AE
The Excel worksheet form that appears below is to be used to recreate the Renew Problem pertaining to Ferris Corporation. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
| Required: |
3. Using the data you entered in part (2), change the percentage of selling and administrative |
| Assembling | Processing | Supporting | Other | |
| Units | Orders | Customers | ||
| Manufacturing overhead | 50% | 35% | 5% | 10% |
| Selling and administrative overhead.... | 10% | 30% | 40% | 20% |
| Total activity | 1,000 | 250 | 100 | |
| units | orders | customers |
| Relative to the results from part (2), what has happened to the customer margin under activity-based costing? Why? |
| Relative to the results from part (2), what has happened to the product margin under the traditional cost system? Why? |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Convert the accompanying database to an Excel table to find:
a.The total cost of all orders.
b.Thetotal quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Question content area bottom
Part 1
a. The total cost of all orders is
$?????? enter your response here.
Build a spreadsheet: Construct and excel spreadsheet to solve all of the preceding
requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.
Houstin Partners provides management consulting services to government and corporate clients. Houstin has two support
departments-administrative services (AS) and information systems (IS)-and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the first
quarter of 2017, Houstin's cost records indicate the following:
E (Click the icon to view the cost records.)
Read the requirements.
.....
intermediary calculations and round your final answers
balances.)
Data table
SUPPORT
OPERATING
AS
IS
GOVT
CORP
Total
Budgeted overhead costs before any
interdepartment cost allocations
Support work supplied by AS
(budgeted head count)
Support work supplied by IS
(budgeted computer time)
$
390,000 $ 2,100,000 $ 7,500,000 $ 12,420,000 $ 22,410,000
25%
45%
30%
100%
10%
36%
54%
100%
Requirements
Print
Done
1. Allocate the two support departments' costs to the two operating departments
using the following methods:
а.
Direct method
b.
Step-down method (Allocate AS…
Chapter 7 Solutions
Managerial Accounting
Ch. 7.A - EXERCISE 7A-1 Time-Driven Activity-Based Costing...Ch. 7.A -
EXERCISE 7A-2 Time-Driven Activity-Based Costing...Ch. 7.A - EXERCISE 7A-3 Time-Driven Activity-Based Costing...Ch. 7.A - PROBLEM 7A-4 Time-Driven Activity-Based Costing LO...Ch. 7.A - PROBLEM 7A-5 Time-Driven Activity-Based Costing LO...Ch. 7 - Prob. 1QCh. 7 - Prob. 2QCh. 7 - Prob. 3QCh. 7 - What are unit-level, batch-level, product-level,...Ch. 7 - What types of costs should not be assigned to...
Ch. 7 - What are the two stages off allocation in...Ch. 7 - Why is the first stage of the allocation process...Ch. 7 - When activity-based costing is used, why do...Ch. 7 - Prob. 9QCh. 7 - Why is the form of activity-based costing...Ch. 7 - The Excel worksheet form that appears below is to...Ch. 7 - Prob. 2AECh. 7 - The Excel worksheet form that appears below is to...Ch. 7 - Prob. 1F15Ch. 7 - Prob. 2F15Ch. 7 - Prob. 3F15Ch. 7 - Prob. 4F15Ch. 7 - Prob. 5F15Ch. 7 - Prob. 6F15Ch. 7 - Prob. 7F15Ch. 7 - Prob. 8F15Ch. 7 - Prob. 9F15Ch. 7 - Prob. 10F15Ch. 7 - Prob. 11F15Ch. 7 - Prob. 12F15Ch. 7 - Prob. 13F15Ch. 7 - Prob. 14F15Ch. 7 - Prob. 15F15Ch. 7 - Prob. 1ECh. 7 - Prob. 2ECh. 7 - Prob. 3ECh. 7 - Prob. 4ECh. 7 - Prob. 5ECh. 7 - Prob. 6ECh. 7 - EXERCISE 7-7 First-Stage Allocations LO7-2
The...Ch. 7 - Prob. 8ECh. 7 - Prob. 9ECh. 7 - Prob. 10ECh. 7 - Prob. 11ECh. 7 - Prob. 12ECh. 7 - EXERCISE 7-13 Computing ABC Product Costs LO7-3,...Ch. 7 - Prob. 14ECh. 7 - Prob. 15ECh. 7 - Prob. 16PCh. 7 - Prob. 17PCh. 7 - Prob. 18PCh. 7 - Prob. 19PCh. 7 -
PROBLEM 7-20 Evaluating the Profitability of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Marketing system provides some useful insights regarding the sales order. Different departmentsuse this information. For instance, the production process uses this information to forecast theexpected sale for next month. The production clerk uses this to create an online productionschedule. From this schedule, the system automatically prepares weekly online work orders to beused by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, thesupervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based job…arrow_forwardneed answers for 1,2,3 and 4 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.arrow_forwardThe Chapter 6 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. 2. Change all of the numbers in the data area of your worksheet so that it looks like this: If your formulas are correct, you should get the correct answers to the following questions. (a) What is the net operating income (loss) in Year 1 under absorption costing? (b) What is the net operating income (loss) in Year 2 under absorption costing? (c) What is the net operating income (loss) in Year 1 under variable costing? (d) What is the net operating income (loss) in Year 2 under variable costing? (e) The net operating income (loss) under absorption costing is less than the net operating income (loss) under variable costing in Year 2 because: (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.…arrow_forward
- Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…arrow_forwardMarketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…arrow_forwardMarketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department.The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions.Work centre employees record their work hours on paper-based…arrow_forward
- Display Design Incorporated (DDI) is a new company that creates display cases for various types of collectibles. DDI has hired you as an accountant to help measure and evaluate costs. Your first day on the job, they provide you with the following interactive dashboard concerning the prior month's costs.arrow_forwardThe managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs +(9) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) X Monthly Overhead Costs and Billable Hours Data Overhead Costs Billable Hours $315,000 3,000 $360,000 4,000 $385,000 5,000 $438,000 6,000 $520,000 7,000 $540,000 8,000 D Print Donearrow_forwardSimkin Corporation keeps careful track of the time required to fill orders. Data concerning a particular order appear below: Wait time Process time Inspection time Move time. Queue time The manufacturing cycle efficiency (MCE) was closest to: (Round your intermediate calculations to 1 decimal place.) Multiple Choice O 0.51 O 0.10 0.15 Hours 20.8 2.5 0.3 2.9 5.0 O 0.23arrow_forward
- Please show your computations using good accounting form through excel. Thank you! Problem: Average to FIFO With the beginning work in process consisting of 5,000 units, 1/5 done, what should be the equivalent production under FIFO?arrow_forwardMatch each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Purchase of raw materials 2. Advertising 3. Salary of research scientists 4. Delivery expenses 5. Reengineering of product assembly process 6. Replacement labor expense for warranty repairs 7. Manufacturing supplies 8. Sales salaries 9. Purchase of CAD (computer-aided design) software 10. Salary of website manager Business Functionarrow_forwardThe controller of the Blade Company wants you to estimate a cost function from the following two observations in a general ledger account called Maintenance: (Click to view the information.) Required 1. Estimate the cost function for maintenance. 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. Requirement 1. Estimate the cost function for maintenance. (Round your answers to the nearest cent as needed.) Maintenance costs = Maintenance costs = +( +( X X Requirement 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. the relevant range, not at cost levels the relevant range. If there are no months with zero The cost function in requirement 1 is an estimate of how costs behave machine-hours represented in the maintenance account, data in that account function provides the best available starting point for a straight line that approximates how a cost behaves be used to…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License