MANGERIAL ACC.(LOOSE)W/CONNECT CUST.>IC
16th Edition
ISBN: 9781260636864
Author: Garrison
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter IE, Problem 12IE
INTEGRATION EXERCISE 12 Cost-Volume-Profit Relationships, Variable Costing LO1-4, LO5-1, LO5-5,LO5-7, LO5-8, L06-1, LO6-2, LO6-3
Refer to the information pertaining to Endless Mountain Company that is provided in Integration Exercise 9. In addition to the budget schedules that you prepared in Integration Exercise 9, insert two new tabs in your Microsoft Excel worksheet titled “CVP Analysis”and “Variable Costing.”
Required(For all questions, be sure to use formulas that link to the other tabs in your Microsoft Excel worksheet when performing your calculations):
- Calculate the following budgeted figures for 2017:
- The total fixed cost.
- The variable cost per unit sold.
- The contribution margin per unit sold
- The break-even point in unit sales and dollar sales.
- The margin of safety.
- The degree of operating leverage
- Calculate the following budgeted figures for 2017:
- A variable costing income statement. Stop your computations at net operating income.
- A reconciliation that explains the difference in the absorption costing and variable costing net operating incomes.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
1. Assign Overhead Costs to Activity Cost Pools
国日
First-Stage Allocation to Activity Cost Pools - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
-A A
10
Paste
BIU
- A -
Alignment Number
Conditional Format as
Cell
Cells
Formatting - Table - Styles -
Clipboard
Font
Styles
A1
fx
A
C
E
F
G
1
==
2 Total costs and distribution of resource consumption across activity cost pools:
3
4
Activity Cost Pools
Customer
Product
Customer
Total Cost
Orders
Development
Relations
Other
Total
6 Production Department:
7
Indirect factory wages
$
400,000
50%
30%
15%
5% 100%
Factory equipment depreciation
Factory utilities
10 Factory property taxes and insurance
8
150,000
55%
30%
0%
15% 100%
9
120,000
59%
34%
0%
7%
100%
75,000
57%
33%
0%
10%
100%
11
12 General Administrative Department:
Administrative wages and salaries
Office equipment depreciation
13
275,000
20%
10%
40%
30% 100%
14
40,000
32%
16%
15%
37%
100%
15
Administrative property taxes and insurance
60,000
0%
0%
0%
100%…
ezto.mheducation.com
Homework: Cost Management and Allocation Assignment
Question 7- Homework: Cost Management and Allocation Assignment- Connect
Homework: Cost Management and Allocation Assignm... i
Saved
Help
Save & Exit
Submit
Check my work
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments
(Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the
year ended December 31 follows.
4.
points
Administration Communications
Facilities
Deposits
$8,320,000 $4,600,000
447, 000
Loans
Direct costs
$200,000
24,000
$290,000
31,000
$253,000
20,500
Employee hours
Number of employees
Square footage occupied
Skipped
360,000
8.
14
6.
230
130
4,600
13,800
5,100
244, 100
203,300
The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number
of employees; and Facilities, square…
ABSORPTION COSTING VERSUS THROUGHPUT COSTING
The book The Goal illustrates the concept of throughput costing. For the problem below
prepare all journal entries and determine the impact on the income statement of the
differences between absorption costing (normal accounting) and throughput costing.
HINT: pay very careful attention to definitions of throughput, inventory and operating
expense from the book
BUDGETED MANUFACTURING COSTS
DIRECT MATERIAL
$20
PER UNIT
DIRECT LABOR
$2
PER UNIT
VARIABLE OVERHEAD
$10
PER UNIT
FIXED OVERHEAD
$150,000
YEAR 1
NO BEGINNING INVENTORY
ACTUAL COSTS OF PRODUCTION EQUALS ABOVE MANUFACTURING COSTS
PURCHASE DIRECT MATERAILS OF
$200,000
INCUR SELLING AND ADMIN COSTS OF
$80,000
#UNITS PRODUCED
10,000
# UNITS SOLD
9,000
SALES PRICE OF UNITS SOLD
$100
YEAR 2
THERE…
Chapter IE Solutions
MANGERIAL ACC.(LOOSE)W/CONNECT CUST.>IC
Ch. IE - Prob. 10IECh. IE -
INTEGRATION EXERCISE 11 Financial Statement Ratio...Ch. IE - INTEGRATION EXERCISE 12 Cost-Volume-Profit...Ch. IE - INTEGRATION EXERCISE 13 Master Budgeting,...Ch. IE - Prob. 1IECh. IE - Prob. 2IECh. IE - INTEGRATION EXERCISE 3 Absorption Costing....Ch. IE - Prob. 4IECh. IE - Prob. 5IECh. IE - Prob. 6IE
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
- Activity Clerical support Facility services Client consultations Activity usage for each service follows. Activity Cost Driver Documents Billable hours Court dates Budgeted Cost Required 1 Required 2 $ 57,600 20,160 72,800 Activity Clerical support Facility services Client consultations Budgeted Activity Usage 360 documents 2,520 billable hours 28 court dates Activity Usage Litigation 210 920 20 Mediation 150 1,600 8 Required: 1. Compute an activity rate for each activity using activity-based costing. 2. Compute overhead cost per unit (case) for both litigation and mediation using activity-based Total 360 2,520 28 Complete this question by entering your answers in the tabs below. Compute an activity rate for each activity using activity-based costing. (Round "Activity rate" to 2 c Budgeted Cost Budgeted Activity Usage Activity Ratearrow_forwardnline Services v OS Ticket system My Dispense Academic Calendar My courses Activity-based costing (ABC) LO#5 Activity-based costing (ABC) is a costing model that identifies activities in an organization and assigns the cost of each activity resource to all products and services according to the actual consumption by each: it assigns more indirect costs (overhead) into direct costs. In this way an organization can precisely estimate the cost of its individual products and services for the purposes of identifying and eliminating those which are unprofitable and lowering the prices of those which are overpriced. In a business organization, the ABC methodology assigns an organization's resource costs through activities to the products and services provided to its customers. It is generally used as a tool for understanding product and customer cost and profitability. As such, ABC has predominantly been used to support strategic decisions such as pricing, outsourcing and identification and…arrow_forwardChapter 2 (Continued): Basic Cost Management Concepts College offers students a number of different majors and disciplines. These majors and disciplines have department chairpersons who are responsible for the department budget preparation. Please define direct costs and indirect costs and then prepare a list of three direct and three indirect costs for the Accounting Department at College. Hint: See Exercise 10 in Chapter 2 of your eText.arrow_forward
- Zeus Industries manufactures two types of electrical power units, custom and standard, which involve four factory overhead activities-production setup, procurement, quality control, and materials management. An activity analysis of the overhead revealed the following estimated activity costs and activity bases for these activities: Activity Activity Cost Activity Base Production setup $ 97,500 Number of setups Procurement 137,500 Number of purchase orders (PO) Quality control 187,500 Number of inspections Materials management 100,000 Number of components Total $522,500 The activity-base usage quantities for each product are as follows: Purchase Setups Inspections Components Unit Volume Orders Custom 500 1,150 2,300 300 1,000 Standard 250 100 200 200 1,000 Total 750 1,250 2,500 500 2,000 a. Determine an activity rate for each activity. Activity Rates Production Setup Procurement Quality Control Materials Management Activity cost - Activity base Activity rate $4 /setup /PO $ /inspection…arrow_forwardExcel SIM: Process Costing using the Weighted-Average Method 1. Compute the equivalent units of production using the weighted average method. 2. Compute the cost per equivalent unit using the weighted average method. 3. Assign costs to units using the weighted average method. 4. Prepare a cost reconciliation report. 国日ら Process Costing using the Weighted-Average Method - Excel FILE НОМЕ INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 -A A % Paste BIU- Alignment Number Conditional Format as Cell Cells Formatting - Table Styles Clipboard Font Styles A11 fe Units started into production during the period A B C E 1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: Units in process 5 300 Percent completed with respect to materials Percent completed with respect to conversion Cost in the beginning inventory: 60% 7…arrow_forwardService Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $103,360 3,200 Network center Number of devices monitored 634,375 8,750 Electronic mail Number of user accounts 78,100 7,100 Smartphone support Number of smartphones issued 144,320 8,200 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: • The sector has 3,000 employees,…arrow_forward
- Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $133,760 3,200 Network center Number of devices monitored 748,250 10,250 Electronic mail Number of user accounts 70,950 6,450 Handheld technology support Number of handheld devices issued 168,960 9,600 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…arrow_forwardService Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $160,000 3,200 Network center Number of devices monitored 735,000 9,800 Electronic mail Number of user accounts 100,000 10,000 Handheld Technology support Number of handheld devices issued 124,600 8,900 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…arrow_forwardService Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $160,000 3,200 Network center Number of devices monitored 735,000 9,800 Electronic mail Number of user accounts 100,000 10,000 Handheld Technology support Number of handheld devices issued 124,600 8,900 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…arrow_forward
- Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $164,650 3,700 Network center Number of devices monitored 607,950 9,650 Electronic mail Number of user accounts 51,750 5,750 Smartphone support Number of smartphones issued 131,040 9,100 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: • The sector has 2,000 employees,…arrow_forwardService Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $160,000 3,200 Network center Number of devices monitored 735,000 9,800 Electronic mail Number of user accounts 100,000 10,000 Handheld Technology support Number of handheld devices issued 124,600 8,900 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…arrow_forwardService Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $160,000 3,200 Network center Number of devices monitored 735,000 9,800 Electronic mail Number of user accounts 100,000 10,000 Handheld Technology support Number of handheld devices issued 124,600 8,900 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY