7. Atheena, controller for the Malabon plant of Zalucki, Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800, in increments of 100) and the total cost of moving materials at those levels of moves. Number of Moves Total Cost P 300 465 340 10 20 30 40 50 850 1000 60 70 80 1260 1360 1420 REQUIRED: a. Compute the cost formula for moving materials using the high-low method. Calculate the predicted cost per month with 55 moves using the high-low formula. b. Compute the cost formula for moving materials using the method of least squares. Using the regression cost formula, what is the predicted cost for a month with 55 moves? c. Using the method of least squares cost formula, prepare a flexible budget with separate variable and fixed categories for the costs of moving materials at 25, 45, and 75 moves.

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 69P: (Appendix 3A) Separating Fixed and Variable Costs, Service Setting Louise McDermott, controller for...
icon
Related questions
icon
Concept explainers
Topic Video
Question
7. Atheena, controller for the Malabon plant of Zalucki, Ic., wanted to determine the cost behavior
of moving materials throughout the plant. She accumulated the following data on the number
of moves (from 100 to 800, in increments of 100) and the total cost of moving materials at those
levels of moves.
Number of Moves
10
Total Cost
P 300
465
340
850
20
30
40
50
60
70
1000
1260
1360
80
1420
REQUIRED:
a. Compute the cost formula for moving materials using the high-low method. Calculate
the predicted cost per month with 55 moves using the high-low formula.
b. Compute the cost formula for moving materials using the method of least squares.
Using the regression cost formula, what is the predicted cost for a month with 55
moves?
c. Using the method of least squares cost formula, prepare a flexible budget with
separate variable and fixed categories for the costs of moving materials at 25, 45, and
75 moves.
Transcribed Image Text:7. Atheena, controller for the Malabon plant of Zalucki, Ic., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800, in increments of 100) and the total cost of moving materials at those levels of moves. Number of Moves 10 Total Cost P 300 465 340 850 20 30 40 50 60 70 1000 1260 1360 80 1420 REQUIRED: a. Compute the cost formula for moving materials using the high-low method. Calculate the predicted cost per month with 55 moves using the high-low formula. b. Compute the cost formula for moving materials using the method of least squares. Using the regression cost formula, what is the predicted cost for a month with 55 moves? c. Using the method of least squares cost formula, prepare a flexible budget with separate variable and fixed categories for the costs of moving materials at 25, 45, and 75 moves.
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Costing Systems
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning