Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

No work needed, just the answers, the choices in the parenthesis are to be bolded to complete the sentence. Use the Graphs to answer the

No work needed, just the answers, the choices in the parenthesis are to be bolded to complete the sentence.

image text in transcribed Use the Graphs to answer the following questions: Month January February March April May June July August September Month October November December Cost of purchase 21000 17000 25500 15000 18000 16000 11000 9000 13000 Quantity Purchased 3300 parts 2700 4500 2400 2800 3000 1600 1500 2000 Purchase Quantity Expected 2940 parts 2410 2780 1. The computer in Trent's office is down and Trent has been asked to immediately provide an equation to estimate the future purchase for part 18. Trent grabs a calculator and uses the high-low method to estimate the cost equation. (Enter amounts to nearest cent) 2. Using the equation from number 1 calculate the future expected purchase costs for each of the last 3 months of the year Month October November December Purchase Quantity Expected 2940 parts 2410 2780 Expected Cost 3. The regression line Trent obtains is y= 2112.20 + 5.31 X Let's start with evaluating the regression line using the criteria of economic plausibility a. The quantity purchased (is highly, is not) likely to be an economically plausible cost driver for estimating the total cost of a part purchased. b. (enter the r^2 amount as a decimal to three decimal places) Using excel to run a regression, the regression equation of y= 2112.20 + 5.31 X yields an r^2 of = The means that the regression line (does not fit very well, fits the data well) 4. Compare the expected purchase costs to the expected purchase costs calculated using the high-low method in number 2. Start by using the regression results to calculate the expected purchase costs for October, November, and December (Use interim amounts to the nearest cent and round final answers to the nearest whole dollar. Month October November December Purchase Quantity Expected 2940 parts 2410 2780 Expected Cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Law

Authors: Henry Cheeseman

10th Edition

0134728785, 978-0134728780

More Books

Students also viewed these Accounting questions

Question

The background knowledge of the interpreter

Answered: 1 week ago