Method of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 147,400 Slope 210 The cost driver used was number of parts inspected. Required: 1.  What is the cost formula? Total cost of receiving = $ + ( $ ×   ) 2.  Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable     Dependent variable     Variable rate per professional hour   per part inspected Fixed cost per month     3.  Using the cost formula, predict the cost of receiving for a month in which 6,800 parts are inspected. Total cost of receiving = $

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 61P: Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a...
icon
Related questions
Question

Method of Least Squares, Developing and Using the Cost Formula

The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received:

Intercept 147,400
Slope 210

The cost driver used was number of parts inspected.

Required:

1.  What is the cost formula?

Total cost of receiving = $ + ( $ ×   )

2.  Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month.

Independent variable    
Dependent variable    
Variable rate per professional hour   per part inspected
Fixed cost per month    

3.  Using the cost formula, predict the cost of receiving for a month in which 6,800 parts are inspected.

Total cost of receiving = $

Identifying the Parts of the Cost Formula; Calculating Monthly, Quarterly, and Yearly Costs Using a Cost Formula Based on Monthly Data

Gordon Company's controller, Eric Junior, estimated the following formula, based on monthly data, for overhead cost:

Overhead Cost = $150,000 + ($52 x Direct Labor Hours)

Required:

1.  Select the term in the right column that corresponds to the term in the left column.

Overhead cost  
$150,000  
$52  
Direct labor hours  

 

2.  If next month's budgeted direct labor hours equal 8,000, what is the budgeted overhead cost?
$

3.  If next quarter's budgeted direct labor hours equal 23,000, what is the budgeted overhead cost?
$

4.  If next year's budgeted direct labor hours equal 99,000, what is the budgeted overhead cost?
$

Inventory Valuation under Absorption Costing

Amiens Company produced 20,000 units during its first year of operations and sold 18,900 at $17 per unit. The company chose practical activity—at 20,000 units—to compute its predetermined overhead rate. Manufacturing costs are as follows:

Direct materials $ 80,000
Direct labor 101,400
Variable overhead 15,600
Fixed overhead 54,600

Required:

1. Calculate the unit cost for each of these four costs. Round your answers to the nearest cent.

Direct Materials Cost $

Direct Labor Cost $

Variable Overhead Cost $

Fixed Overhead Cost $

2. Calculate the cost of one unit of product under absorption costing. Round your answer to the nearest cent.

$

3. How many units are in ending inventory?

$

4. Calculate the cost of ending inventory under absorption costing.

$

 

Inventory Valuation under Variable Costing

Lane Company produced 50,000 units during its first year of operations and sold 47,300 at $12 per unit. The company chose practical activity—at 50,000 units—to compute its predetermined overhead rate. Manufacturing costs are as follows:

Direct materials $123,000
Direct labor 93,000
Variable overhead 65,000
Fixed overhead 51,000

Required:

1. Calculate the cost of one unit of product under variable costing. Round your answer to the nearest cent.

$

2. Calculate the cost of ending inventory under variable costing.

$

Income Statements under Absorption and Variable Costing

In the coming year, Kalling Company expects to sell 28,700 units at $32 each. Kalling’s controller provided the following information for the coming year:

Units production 30,000
Unit direct materials $ 9.95
Unit direct labor $ 2.75
Unit variable overhead $ 1.65
Unit fixed overhead* $ 2.50
Unit selling expense (variable) $ 2.00
Total fixed selling expense $ 65,500
Total fixed administrative expense $231,000

* The unit fixed overhead is based on 30,000 units produced.

Required:

1. Calculate the cost of one unit of product under absorption costing.

$

2. Calculate the cost of one unit of product under variable costing.

$

3. Calculate operating income under absorption costing for next year.

$

4. Calculate operating income under variable costing for next year.

$

 

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cost estimation
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning