23: The accountant of Manama Corporation has collected the following data on its copy machine costs for the last six months of the year. Month Number of copies Total copy cost July 3,500 $14,000 August 3,200 13,500 September 4,100 16,000 October 5,100 18,000 November 5,600 18,500 December 4,800 17,500 Requirements : 1- Use the regression analysis method to: a- Estimate the cost function (Y= F+vX). b- What percentage of the copy cost depends on number of copies? What portion of the fluctuation is not explained by that cost driver? You need to perform this using Excel. Submit the excel sheet along with your paper. 2- Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labour hour and Prepare the cost function. 3. What would the total factory copy cost be at a level of 4,600 copies using each method above? 4. Which prediction method is the best method? Why?

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
icon
Concept explainers
Question
23: The accountant of Manama Corporation has collected the following data on its copy
machine costs for the last six months of the year.
Month
Number of copies
Total copy cost
$14,000
July
3,500
August
3,200
13,500
September
4,100
16,000
October
5,100
18,000
November
5,600
18,500
December
4,800
17,500
Requirements :
1- Use the regression analysis method to:
a- Estimate the cost function (Y= F+vX).
b- What percentage of the copy cost depends on number of copies? What portion of the
fluctuation is not explained by that cost driver?
You need to perform this using Excel. Submit the excel sheet along with your paper.
2- Using the high-low method, calculate the total fixed factory overhead cost and the variable
factory overhead cost per direct labour hour and Prepare the
3. What would the total factory copy cost be at a level of 4,600 copies using each method
function.
above?
4. Which prediction method is the best method? Why?
Transcribed Image Text:23: The accountant of Manama Corporation has collected the following data on its copy machine costs for the last six months of the year. Month Number of copies Total copy cost $14,000 July 3,500 August 3,200 13,500 September 4,100 16,000 October 5,100 18,000 November 5,600 18,500 December 4,800 17,500 Requirements : 1- Use the regression analysis method to: a- Estimate the cost function (Y= F+vX). b- What percentage of the copy cost depends on number of copies? What portion of the fluctuation is not explained by that cost driver? You need to perform this using Excel. Submit the excel sheet along with your paper. 2- Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labour hour and Prepare the 3. What would the total factory copy cost be at a level of 4,600 copies using each method function. above? 4. Which prediction method is the best method? Why?
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Conditional Probability, Decision Trees, and Bayes' Theorem
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,