Concept explainers
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to
Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations.
Following are definitions of the variables used in the four equations and a statistical summary of these equations:
Required:
- 1. Write Equations 2 and 4 in the form Y = a + bx.
- 2. If actual sales are $1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year?
- 3. Explain why Larry Husky might prefer Equation 3 to Equation 2.
- 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?arrow_forwardMoses Moonrocks Inc. has developed a balanced scorecard with a measure map that suggests that the number of erroneous shipments has a direct effect on operating profit. The company estimates that every shipment error leads to a reduction of revenue by 3,000 and increased costs of about 2,000. If the company has the following budgeted sales and costs for next month (without accounting for any possible shipping errors), determine how many shipping errors the company can afford to have and still break even:arrow_forward
- The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 total purchase orders and 45 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)arrow_forwardRizzo Goal Inc. produces and sells hockey equipment, often custom made for online orders. The company has the following performance metrics on its balanced scorecard: days from ordered to delivered, number of shipping errors, customer retention rate, and market share. A measure map illustrates that the days from ordered to delivered and the number of shipping errors are both expected to directly affect the customer retention rate, which affects market share. Additional internal analysis finds that: Every shipping error over three shipping errors per month reduces the customer retention rate by 1.5%. On average, each day above three days from ordered to delivered yields a reduction in the customer retention rate of 1%. Each day before three days from order to delivery yields an increase in the customer retention rate of 1%, on average. Rizzo Goal Inc.s current customer retention rate is 60%. The company estimates that for every 1% increase or decrease in the customer retention rate, market share changes 0.5% in the same direction. Rizzo Goal Inc.s current market share is 21.4%. Ignoring any other factors, if the company has six shipping errors this month and an average of 3.5 days from ordered to delivered, determine (a) the new customer retention rate and (b) the new market share that Rizzo Goal Inc. expects to have.arrow_forwardGalveston Pump Corporation is considering implementing a JIT production system. The new system would reduce current average inventory levels of $2,000,000 by 75%, but it would require a much greater dependency on the company’s core suppliers for on-time deliveries and high-quality inputs. The company’s operations manager, Frank Griswold, is opposed to the idea of a new JIT system because he is concerned that the new system (a) will be too costly to manage; (b) will result in too many stockouts; and (c) will lead to the layoff of his employees, several of whom are currently managing inventory. He believes that these layoffs will affect the morale of his entire production department. The management accountant, Bonnie Barrett, is in favor of the new system because of its likely cost savings. Frank wants Bonnie to rework the numbers because he is concerned that top management will give more weight to financial factors and not give due consideration to nonfinancial factors such as employee…arrow_forward
- Galveston Pump Corporation is considering implementing a JIT production system. The new system would reduce current average inventory levels of $2,000,000 by 75%, but it would require a much greater dependency on the company’s core suppliers for on-time deliveries and high-quality inputs. The company’s operations manager, Frank Griswold, is opposed to the idea of a new JIT system because he is concerned that the new system (a) will be too costly to manage; (b) will result in too many stockouts; and (c) will lead to the layoff of his employees, several of whom are currently managing inventory. He believes that these layoffs will affect the morale of his entire production department. The management accountant, Bonnie Barrett, is in favor of the new system because of its likely cost savings. Frank wants Bonnie to rework the numbers because he is concerned that top management will give more weight to financial factors and not give due consideration to nonfinancial factors such as employee…arrow_forwardGalveston Pump Corporation is considering implementing a JIT production system. The new system would reduce current average inventory levels of $2,000,000 by 75%, but it would require a much greater dependency on the company’s core suppliers for on-time deliveries and high-quality inputs. The company’s operations manager, Frank Griswold, is opposed to the idea of a new JIT system because he is concerned that the new system (a) will be too costly to manage; (b) will result in too many stockouts; and (c) will lead to the layoff of his employees, several of whom are currently managing inventory. He believes that these layoffs will affect the morale of his entire production department. The management accountant, Bonnie Barrett, is in favor of the new system because of its likely cost savings. Frank wants Bonnie to rework the numbers because he is concerned that top management will give more weight to financial factors and not give due consideration to nonfinancial factors such as employee…arrow_forwardThe production department is proposing the purchase of an automatic insertion machine. It has identified three machines and has asked the accountant to analyze them to determine which one has the best average rate of return. Line Item Description Machine A Machine B Machine C Estimated average income $47,060.44 $72,961.50 $73,785.60 Average investment 336,146.00 243,205.00 491,904.00 a. Machine C b. Machine A c. Machines B and C have the same preferred average rate of return. d. Machine Barrow_forward
- A large brokerage company is assessing the introduction of a new computer system to improve routing and execution of customer orders. The managing director wants to install a new Smart Routing system, whereas another director prefers the Direct Routing system. Each machine provides the same order-execution ability and can satisfy the broker’s obligation to give investors the best possible order execution. The initial cost of each system is $170,000, but because of differing software, maintenance, and processing requirements, estimates of the after-tax costs of operation differ. These are as follows: Period Smart Routing Direct Routing 1 39,000 56,000 2 48,000 61,000 3 48,000 61,000 4…arrow_forwardThe following are some quotes provided by a number of managers at Hawkeye Machining Company regarding the company’s planned move toward a lean manufacturing system: Director of Sales: I’m afraid we’ll miss some sales if we don’t keep a large stock of items on hand just in case demand increases. It only makes sense to me to keep large inventories in order to ensure product availability for our customers.Director of Purchasing: I’m very concerned about moving to a lean system for materials. What would happen if one of our suppliers were unable to make a shipment? A supplier could fall behind in production or have a quality problem. Without some safety stock in our materials, our whole plant would shut down.Director of Manufacturing: If we go to lean manufacturing, I think our factory output will drop. We need in-process inventory in order to “smooth out” the inevitable problems that occur during manufacturing. For example, if a machine that is used to process a product breaks down, it…arrow_forwardPeterson Corporation is considering implementing a JIT production system. The new system would reduce current average inventory levels of $2,000,000 by 75%, but it would require a much greater dependency on the company’s core suppliers for on-time deliveries and high-quality inputs. The company’s operations manager, John Leung, is opposed to the idea of a new JIT system. He is concerned that the new system (a) will be too costly to manage; (b) will result in too many stock outs; and (c) will lead to the layoff of his employees, several of whom are currently managing inventory. He believes that these layoffs will affect the morale of his entire production department. The management accountant, Susan Chow, is in favour of the new system, due to the likely result in cost savings. John wants Susan to revise her cost saving estimation because he is concerned that top management will give more weight to financial factors and not give due consideration to nonfinancial factors such as employee…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning