Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve question 4 and 5 E10-32 (similar to) Maureen Baker is the new manager of the materials stonenoom for Keller Manufacturing Maureen has been asked

Solve question 4 and 5
image text in transcribed
E10-32 (similar to) Maureen Baker is the new manager of the materials stonenoom for Keller Manufacturing Maureen has been asked to estimate Auture data for the past 9 months as folows EEB (Click the loon to view the data for the past 9 months Estimated monthly purchases for this part based on expected demand of the two products for the rest of he year are as follows EEB (Click the icon to view the expected demand for the rest of the year) monthiy purchase costs for part 9096, used in two of Kaler's products. Maureen has purchase cost and quante Read the cequirements Requirements Data Table -X0 Data Table 1. The computer in Maureens office is down, and Maureen has been asked to Purchase Quantity Expected Cost of Purchase Quantity Purchased immediately provide an equation to estimate the future purchase cost for part #696 Maureen grabs a calculator and uses te highHow method to estimate a cost equation. What equation does she get? 2.890 parts 3.340 pars 3,760 3,100 12.880 2,830 74714,10 purchase costs for each of the last 3 months of the year 023 3,758 13,170 .6 3. Aher a few hours Maureens computer is fxed Maureen uses the frst 9 months of data and regression analysis to estimabe the relationship between the quantity purchased and purchase costs of pert 8696. The regression line Maureen obtains is as follows Print Done 3,.9003.343 15,278 3600 10,1152.262 14,900 $2.0579 3.71x and 1 Stat for the XValable 1 statistics.(Enter the R Square and t Evaluane the regression line using the criteria of economic plausbiny goodness of fit. and signficance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a beter fi? Why? 4 Use the regression resuits to calculate the expected purchase costs for Print Done October, November, and December Compare the expected purchase costs to the expected purchase costs caloulaned using the high-low method requirement 2. Comment on your

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

Financial Accounting An Introduction To Concepts Methods And Uses

Authors: Clyde P. Stickney, Roman L. Weil

8th Edition

0030182689, 978-0030182686

More Books

Students also viewed these Accounting questions

Question

4 What are the main practices associated with SHRM?

Answered: 1 week ago