Answered step by step
Verified Expert Solution
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.
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 CostStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started