Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For requirement 1, the first and 4th blank in the equations dropdown choices are 1. number of months (X), Purchase costs (y), Quantity purchased (X).

For requirement 1, the first and 4th blank in the equations dropdown choices are 1. number of months (X), Purchase costs (y), Quantity purchased (X).
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
for requirement 3, the 6th blank choice is nonplausable or plausable and the 7th and 8th choice is insignificant or significant.
for requirement 4, the 4th drop down choices are
image text in transcribed
the 5th is "somewhat similar or drastically different"
the 6th is a reasonable or not a reasonable.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Question Help Mindy Blackwell is the new manager of the materials storeroom for Keller Manufacturing. Mindy has been asked to estimate future monthly purchase costs for part 2006, used in two of Keller's products. Mindy has purchase cost and quantity data for the past 9 months as follows: m (Click the icon 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 the year are as follows: (Click the icon to view the expected demand for the rest of the year) Read the requirements Requirement 1. The computer in Mindy's office is down, and Mindy has been asked to immediately provide an equation to estimate the future purchase cost for part 006. Mindy grabs a calculator and uses the high-low method to estimate a cost equation. What equation does she get? - Requirement 2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last 3 months of the year High-Low Method Month Purchase Quantity Expected Expected Cost October 3,300 parts November 3,750 parts December 3.050 parts Requirement 3. After a few hours Mindy's computer is feed. Mindy uses the first months of data and regression analysis to estimate the relationship between the quality purchased and purchase costs of pet 806 The regression line Mindy obtains is as follows: y = $2,094.636X Run a regression on the 9 months of data using Microsoft Excel to determine the Square and that for the X Variable statistics (Enter the Square and Sulamours XC) Regression Statistics Choose from any list or enter any number in the input fields and then continue to the need question corpored in two of Kader's products. Mindy has purchase cost and quantity data for the past months as follows: Click the loon to view the data for the past months) Estimated monthly purchases for this part based on expected demand of the two products for the rest of the your are as follows: III (Click the icon to view the expected demand for the rest of the year.) Read the revirements Requirement 3. her a few hours Mindy's computer is fund. Mindy uses the first month of data and regression analysis to estimate the ship between the quality purchased and cool part The regression line Mindy obtains is as follows y$2,094.8 +300X Run a regression on the months of data using Microsoft Excel to determine the square and that for the X Variable 1 stuttan (Enter the sort und but court to wax tacimal places, X.000) Regression Statistics RS X Variable Ette the regression in using the reconomic plasty,goodness of it, and sign of the independente Economie plausibly Goodness of Significance of independent variable Compare the regionegution to the custon based on the method which is why! Choose from any list or enter any number in the input fields and the continue to the next save for Later Hep May Blackwell is the new manager of the materials storeroom for Keller Manufacturing. Mindy has been asked to estimate future monthly purchase costs for part096,used in two of Keller's products. Mindy has purchase cost and quantity data for the past 9 months as follows: (Click the icon 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 the year are as follows: II (Click the icon to view the expected demand for the rest of the year) Read the requirements Significance of independent variable Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why? is a better fit and more accurate estimate because it uses while the other method only relies on ortant information contained in the other data data points and may therefore is some Requirement 4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase costs calculated using the high-low method in requirement 2. Comment on your results. Begin by using the regression results to calculate the expected purchase costs for October November, and December (Use amounts as given in the information to two decimal places. Do not round interim caloulotion, but then do round your final answers expected cost amounts to the nearest whole dollar) Regression Equation Month Purchase Quantity Expected Expected Cost October 3,300 parts November 3.750 parts December 1 3,050 parts Compare the expected purchase costs to the expected purchase costs olulated using the high low method in requirement Comment on your Choose from any list or enter any number in the input fields and then continue to the next question Save for Later 8 6 asked to me four monthly purchases for parted in two le's gadis indys months as follows: M(Click the loon to view the data for the post 9 months) Estimated monthly purchases for this part based on speed domand of the two products for the rest of the your was folio (Click the foon to view the expedied demand for the rest of the year) Read the remonts The is a better fit and more courte estimate because it while the other method only on important information contained in the other data data points and may there some Requirement 4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase cous couted using the high-low method in requirement 2. Comment on your results by using the regression results to colate the expected purchase costs for October November, and December (Use amounts es van in the information to two decimal place. Do not round var stions, but then do round your final answers (expected cost amounts to the nearest whole dollar) Regression Equation Month Purchase antity Expected Expected Cost October 3,300 parts November 3,750 parts December 3,050 parts Compare the expected purchase costs to the expected purchase costs colated using the high low method in requirement 2. Comment on your results within the relevant range they give Although the two equations are the dates are representation of the total set of points within the relevage Choose from any for enter any number in the input fields and then continue to the next Gestion Save for Later 6 R 2. Comment on your results. results to calculate the expected purchase costs for October, November, ar your final answers (expected cost amounts) to the nearest whole dollar.) Regression Equation ase different in both fixed element and variable rate the same for the fixed element, but different for the variable rate the same for the variable rate, but different for the fixed element urchase the same in both fixed element and variable rate 1od ir within the re ons are representation of the total set of points within the relevant range. tor enter any number in the input fields and then continue to the next question. F3 FA FS The Reward Plus Company manufactures windows. Its manufacturing planthus the capacity to produce 20,000 windows each month. Current production and sales are 15,000 windows per month. The company normally charges $150 per window. Costinformation for the current activity level is as follows: Click the loon to view the cost information) Click the loon to view the special order information) Read the girement Requirement 1. Should Reward Plus accept this special order? Show your calculations Begin by completing an analysis, and start by showing the computation of the company's operating income without the special order. Nettoperating income with the corner, and then the differences between the two columns (Complete all input fields. For mounts with no change, make sure to enter in the appropriate cole of the Difference column) Without With One-Time Only One-Time Only Special Order Special Order Difference 15.000 Windows 20.000 Windows 5,000 Windows Revenues Variable costs Direct materials Direct malacturing labor Balch manufacturing costs Fixed costs Fwd mandachting con Freed marketing costs Choose from any list or enter any number in the input fields and then continue to the nation Save for later Ils manufacturing plant has the capacity to produce 20,000 windows each month. Cument production and sales are 15,000 windows per month. The company normally charges $150 per window Cost information for the current activity level is as follow Click the icon to view the cost formation) Click the icon to view the special order information) Read the womens Fixed costs: Fixed manufacturing costs Food marketing costs Total costs Operating inoch Based on the above calculations, Reward Plus should the one time only special order has no long-term Implications because scoping the order operating income by Requirement 2. Suppose plant capacity were only 17,500 windows instead of 20.000 windows each month. The special order must her be taken in fullorbered completely should word as the special order? Show your calculations Complete the analysis below to determine Reward Plus should accept the special order under the With One-Time Only Special Order Under Reduced Plant Capacity Choose from any list of enter any number in the input fields and then continue to the next question Save for at S 4 5 3 Y R E . lab S D A $150 per window windows per month. The company hormation for the current activity level is as follows T! (Click the icon to view the cost information) (Click the icon to view the special order information) Read the requirements With One-Time Only Special Order Under Reduced Plant Capacity 17,500 Windows Revenues Variable costs: Direct materials Direct manufacturing labor Batch manufacturing costs Fixed costs: Fixed manufacturing costs Fixed marketing costs Total costs Operating income Choose from any list or enter any number in the input fields and then continue to the next question Save for Later MacBOOK FS # por window de 15.000 windows per month. The company Cost Information for the current divity level is as follows. H(Click the icon to view the cost information) (Click the loon to view the special order information) PIRMS Read the remot Fored marketing costs Total costs Operating income Based on the calculations under this scenario, Reward Plus should the one time only special order under the reduced capacity because accepting the order operating income by Requirement 3. As in requirement 1, assume that monthly capacity is 20,000 windows. Reward Plus is concerned that it cops the special order, its existing customers will immediately demand a price decourt of $19 in the month in which the special order is being filled. They would argue that Reward Plus's capacity costs are now being spread over more units and trang customers should get the best of these costs. Should Reward Plus accept the special order under these conditions Show your calculations Select the labels and then enter the amounts to calculate the net effect on operating income from accepting the special order under his scenario. (Use a minu vign or parentheses to show are decrease operating Income from accepting the special order. Abbreviations used: Operating income Special order 10) Not increase (decrease) in Ol from scoping 30 Reward Plus should the one-time-only special order under this scenario because accepting the order operating income Choose from any list or enter any number in the input fields and then continue to the next question Save for Later % 5 # 3 6 4 R W E TO THIS special order information) Read the Fixed marketing costs Total cos Data Table Operat More Info Based reduce Requirt Reward Plus has just received a special one-time-only order for 5,000 windows at $125 per window. Accepting the special order would not affect the company's regular business or its faced costs. Reward Plus makes windows for its existing customers in batch sizes of 50 windows (300 batches 50 windows per batch 15,000 windows). The special order requires Reward Plus to make the windows in 100 batches of 50 windows. Variable costs that vary with number of units produced Direct materials $ 300,000 Direct manufacturing labor 450.000 Variable costs for setups, materials handling, quality control, and so on) that vary with number of batches, 300 batches $1.250 per batch 375.000 Fixed manufacturing costs 200.000 55,000 Fixed marketing costs $ 80.000 Total costs scount of Select Income operating Print Done Print Done Reward Plus should the one-time-only special order under this scenario because accepting the order operating income Choose from any list or enter any number in the input fields and then continue to the next question Sve for Later Macle FI % B. 7 3 2 W R E Question Help Mindy Blackwell is the new manager of the materials storeroom for Keller Manufacturing. Mindy has been asked to estimate future monthly purchase costs for part 2006, used in two of Keller's products. Mindy has purchase cost and quantity data for the past 9 months as follows: m (Click the icon 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 the year are as follows: (Click the icon to view the expected demand for the rest of the year) Read the requirements Requirement 1. The computer in Mindy's office is down, and Mindy has been asked to immediately provide an equation to estimate the future purchase cost for part 006. Mindy grabs a calculator and uses the high-low method to estimate a cost equation. What equation does she get? - Requirement 2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last 3 months of the year High-Low Method Month Purchase Quantity Expected Expected Cost October 3,300 parts November 3,750 parts December 3.050 parts Requirement 3. After a few hours Mindy's computer is feed. Mindy uses the first months of data and regression analysis to estimate the relationship between the quality purchased and purchase costs of pet 806 The regression line Mindy obtains is as follows: y = $2,094.636X Run a regression on the 9 months of data using Microsoft Excel to determine the Square and that for the X Variable statistics (Enter the Square and Sulamours XC) Regression Statistics Choose from any list or enter any number in the input fields and then continue to the need question corpored in two of Kader's products. Mindy has purchase cost and quantity data for the past months as follows: Click the loon to view the data for the past months) Estimated monthly purchases for this part based on expected demand of the two products for the rest of the your are as follows: III (Click the icon to view the expected demand for the rest of the year.) Read the revirements Requirement 3. her a few hours Mindy's computer is fund. Mindy uses the first month of data and regression analysis to estimate the ship between the quality purchased and cool part The regression line Mindy obtains is as follows y$2,094.8 +300X Run a regression on the months of data using Microsoft Excel to determine the square and that for the X Variable 1 stuttan (Enter the sort und but court to wax tacimal places, X.000) Regression Statistics RS X Variable Ette the regression in using the reconomic plasty,goodness of it, and sign of the independente Economie plausibly Goodness of Significance of independent variable Compare the regionegution to the custon based on the method which is why! Choose from any list or enter any number in the input fields and the continue to the next save for Later Hep May Blackwell is the new manager of the materials storeroom for Keller Manufacturing. Mindy has been asked to estimate future monthly purchase costs for part096,used in two of Keller's products. Mindy has purchase cost and quantity data for the past 9 months as follows: (Click the icon 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 the year are as follows: II (Click the icon to view the expected demand for the rest of the year) Read the requirements Significance of independent variable Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why? is a better fit and more accurate estimate because it uses while the other method only relies on ortant information contained in the other data data points and may therefore is some Requirement 4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase costs calculated using the high-low method in requirement 2. Comment on your results. Begin by using the regression results to calculate the expected purchase costs for October November, and December (Use amounts as given in the information to two decimal places. Do not round interim caloulotion, but then do round your final answers expected cost amounts to the nearest whole dollar) Regression Equation Month Purchase Quantity Expected Expected Cost October 3,300 parts November 3.750 parts December 1 3,050 parts Compare the expected purchase costs to the expected purchase costs olulated using the high low method in requirement Comment on your Choose from any list or enter any number in the input fields and then continue to the next question Save for Later 8 6 asked to me four monthly purchases for parted in two le's gadis indys months as follows: M(Click the loon to view the data for the post 9 months) Estimated monthly purchases for this part based on speed domand of the two products for the rest of the your was folio (Click the foon to view the expedied demand for the rest of the year) Read the remonts The is a better fit and more courte estimate because it while the other method only on important information contained in the other data data points and may there some Requirement 4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase cous couted using the high-low method in requirement 2. Comment on your results by using the regression results to colate the expected purchase costs for October November, and December (Use amounts es van in the information to two decimal place. Do not round var stions, but then do round your final answers (expected cost amounts to the nearest whole dollar) Regression Equation Month Purchase antity Expected Expected Cost October 3,300 parts November 3,750 parts December 3,050 parts Compare the expected purchase costs to the expected purchase costs colated using the high low method in requirement 2. Comment on your results within the relevant range they give Although the two equations are the dates are representation of the total set of points within the relevage Choose from any for enter any number in the input fields and then continue to the next Gestion Save for Later 6 R 2. Comment on your results. results to calculate the expected purchase costs for October, November, ar your final answers (expected cost amounts) to the nearest whole dollar.) Regression Equation ase different in both fixed element and variable rate the same for the fixed element, but different for the variable rate the same for the variable rate, but different for the fixed element urchase the same in both fixed element and variable rate 1od ir within the re ons are representation of the total set of points within the relevant range. tor enter any number in the input fields and then continue to the next question. F3 FA FS The Reward Plus Company manufactures windows. Its manufacturing planthus the capacity to produce 20,000 windows each month. Current production and sales are 15,000 windows per month. The company normally charges $150 per window. Costinformation for the current activity level is as follows: Click the loon to view the cost information) Click the loon to view the special order information) Read the girement Requirement 1. Should Reward Plus accept this special order? Show your calculations Begin by completing an analysis, and start by showing the computation of the company's operating income without the special order. Nettoperating income with the corner, and then the differences between the two columns (Complete all input fields. For mounts with no change, make sure to enter in the appropriate cole of the Difference column) Without With One-Time Only One-Time Only Special Order Special Order Difference 15.000 Windows 20.000 Windows 5,000 Windows Revenues Variable costs Direct materials Direct malacturing labor Balch manufacturing costs Fixed costs Fwd mandachting con Freed marketing costs Choose from any list or enter any number in the input fields and then continue to the nation Save for later Ils manufacturing plant has the capacity to produce 20,000 windows each month. Cument production and sales are 15,000 windows per month. The company normally charges $150 per window Cost information for the current activity level is as follow Click the icon to view the cost formation) Click the icon to view the special order information) Read the womens Fixed costs: Fixed manufacturing costs Food marketing costs Total costs Operating inoch Based on the above calculations, Reward Plus should the one time only special order has no long-term Implications because scoping the order operating income by Requirement 2. Suppose plant capacity were only 17,500 windows instead of 20.000 windows each month. The special order must her be taken in fullorbered completely should word as the special order? Show your calculations Complete the analysis below to determine Reward Plus should accept the special order under the With One-Time Only Special Order Under Reduced Plant Capacity Choose from any list of enter any number in the input fields and then continue to the next question Save for at S 4 5 3 Y R E . lab S D A $150 per window windows per month. The company hormation for the current activity level is as follows T! (Click the icon to view the cost information) (Click the icon to view the special order information) Read the requirements With One-Time Only Special Order Under Reduced Plant Capacity 17,500 Windows Revenues Variable costs: Direct materials Direct manufacturing labor Batch manufacturing costs Fixed costs: Fixed manufacturing costs Fixed marketing costs Total costs Operating income Choose from any list or enter any number in the input fields and then continue to the next question Save for Later MacBOOK FS # por window de 15.000 windows per month. The company Cost Information for the current divity level is as follows. H(Click the icon to view the cost information) (Click the loon to view the special order information) PIRMS Read the remot Fored marketing costs Total costs Operating income Based on the calculations under this scenario, Reward Plus should the one time only special order under the reduced capacity because accepting the order operating income by Requirement 3. As in requirement 1, assume that monthly capacity is 20,000 windows. Reward Plus is concerned that it cops the special order, its existing customers will immediately demand a price decourt of $19 in the month in which the special order is being filled. They would argue that Reward Plus's capacity costs are now being spread over more units and trang customers should get the best of these costs. Should Reward Plus accept the special order under these conditions Show your calculations Select the labels and then enter the amounts to calculate the net effect on operating income from accepting the special order under his scenario. (Use a minu vign or parentheses to show are decrease operating Income from accepting the special order. Abbreviations used: Operating income Special order 10) Not increase (decrease) in Ol from scoping 30 Reward Plus should the one-time-only special order under this scenario because accepting the order operating income Choose from any list or enter any number in the input fields and then continue to the next question Save for Later % 5 # 3 6 4 R W E TO THIS special order information) Read the Fixed marketing costs Total cos Data Table Operat More Info Based reduce Requirt Reward Plus has just received a special one-time-only order for 5,000 windows at $125 per window. Accepting the special order would not affect the company's regular business or its faced costs. Reward Plus makes windows for its existing customers in batch sizes of 50 windows (300 batches 50 windows per batch 15,000 windows). The special order requires Reward Plus to make the windows in 100 batches of 50 windows. Variable costs that vary with number of units produced Direct materials $ 300,000 Direct manufacturing labor 450.000 Variable costs for setups, materials handling, quality control, and so on) that vary with number of batches, 300 batches $1.250 per batch 375.000 Fixed manufacturing costs 200.000 55,000 Fixed marketing costs $ 80.000 Total costs scount of Select Income operating Print Done Print Done Reward Plus should the one-time-only special order under this scenario because accepting the order operating income Choose from any list or enter any number in the input fields and then continue to the next question Sve for Later Macle FI % B. 7 3 2 W R E

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

More Books

Students also viewed these Accounting questions

Question

What stereotypes are associated with lesbians and gay men?

Answered: 1 week ago