An auditor used regression analysis to evaluate the relationship between utility costs and machine hours. The following information was developed using a computer software program: Intercept 2,050 Standard error of estimate 200 Regression 0.825 Number of observations 36 Correlation coefficient 0.800 How much is the utility cost if the company’s 10 machines will use 2,400 hours next month? a. ₱3,830 b. ₱3,970 c. ₱4,030 d. ₱4,050

An auditor used regression analysis to evaluate the relationship between utility costs and machine hours. The following information was developed using a computer software program: Intercept 2,050 Standard error of estimate 200 Regression 0.825 Number of observations 36 Correlation coefficient 0.800 How much is the utility cost if the company’s 10 machines will use 2,400 hours next month? a. ₱3,830 b. ₱3,970 c. ₱4,030 d. ₱4,050

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section: Chapter Questions

Problem 41P: At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 =...

See similar textbooks

Similar questions

At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
5. The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data were collected. Age (years) 4.5 4.5 4.5 4.0 4.0 4.0 5.0 5.0 5.5 Yearly Maintenance Cost ($) 619 1,049 1,033 495 723 681 890 1,522 987 Age (years) Yearly Maintenance Cost ($) 5.0 0.5 0.5 6.0 6.0 1.0 1.0 1.0 1,194 163 182 764 1,373 978 466 549 a. Use linear regression model to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor (use Excel) b. If a section has a three-year old tractor, what is the forecast for the annual maintenance cost?
Chart and Regression analysis : What does the intercept predict? X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) Equation: y=2.9x + 14.5 Slope:2.9 Intercept:14.5 Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?
Estimating a cost function, high-low method. Lacy Dallas is examining customer-service costs in the southern region of Camilla Products. Camilla Products has more than 200 separate electrical products that are sold with a 6-month guarantee of full repair or replacement with a new product. When a product is returned by a customer, a service report is prepared. This service report includes details of the problem and the time and cost of resolving the problem. Weekly data for the most recent 8-week period are as follows: Plot the relationship between customer-service costs and number of service reports. Is the relationship economically plausible? Use the high-low method to compute the cost function relating customer-service costs to the number of service reports. What variables, in addition to number of service reports, might be cost drivers of weekly customer-service costs of Camilla Products?
A Lighting company seeks to study the percentage of the defective glass shells being manufactured. Theoretically, the percentage of defectives is dependent on temperature, humidity, and the level of artisan expertise. Complete historical data are available for the following variables on a daily basis for a year.a. Temperature (high, normal, low)b. Humidity (high, normal, low)c. Artisan expertise (expert, average, mediocre)Some experts feel that defectives also depend on productive supervisors. However, data on supervisors in charge are available for only 242 of the 365 days. How should you conduct this study?
The H.W. Grant Corporation used regression analysis to predict the annual cost of indirect materials. The results were as follows: Indirect Materials Cost Explained by Units Produced Constant $15,675 Standard error of Y estimate $3,500 0.7776 Number of observations 16 X coefficient(s) 10.25 Standard error of coefficient(s) 2.195 What is the cost estimation equation? O A. Y= $12,175 + $10.25X O B. Y= $3,500 + $7.97X O C. Y= $19,175 + $4.67X O D. Y= $15,675 + $10.25X
a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) A detective figures he has a one in nine chance of recovering stolen property. His out-of-pocket expenses for the investigation are $9,000. He is only paid his fee if he recovers the stolen property, what should he charge clients in order to breakeven? c) At races, your horse, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of 1⁄4 in coming 3rd. First place pays $4,500 to the winner, second place $3,500 and third place $1,500.Hence, is it worth entering the race if it costs $799? d) Your company plans to invest in a particular project. There is a 35% chance you will lose $30,000, a 40% chance you will break even, and a 25% chance you will make $65,000. Based solely on this information, what should youdo? e) A manufacturer is considering the production of a new and better mousetrap. She estimates the probability that the new mousetrap is successful is 3⁄4.…
Figure shows summer air visibility measurements for Denver, Colorado. The acceptable visibility standard is 100, with readings above 100 indicating clean air and good visibility, and readings below 100 indicating temperature inversions caused by forest fires, volcanic eruptions, or collisions with comets.a. Is a trend evident in the data? Which time-series techniques might be appropriate for estimating the average of these data?b. A medical center for asthma and respiratory diseases located in Denver has great demand for its services when air quality is poor. If you were in charge of developing a short-term (say, 3-day) forecast of visibility, which causal factor(s) would you analyze? In other words, which external factors hold the potential to significantly affect visibility in the short term?c. Tourism, an important factor in Denver’s economy, is affected by the city’s image. Air quality, as measured by visibility, affects the city’s image. If you were responsible for development of…
The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Yearly Maintenance Yearly Maintenance Age (years) Age (years) Cost ($) Cost (S) 6.5 819 8.0 1,394 5.5 1,249 2.5 363 6.5 1,233 2.5 382 7.0 695 9.0 964 6.0 923 8.0 1,573 6.0 881 3.0 1,178 7.0 1,090 3.0 666 7.0 1,722 3.0 749 7.5 1,187 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 365.727 + 110,721 X where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 four-year-old tractors, what is the forecast for the annual maintenance cost? $ |- (Enter your response rounded to two…
12.2 The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past 8 months. Month 1 2 3 4 5 6 7 8 Demand for Soft Shag Carpet (1000 yd) 5 10 6 8 14 10 9 12 a. Compute a three-month moving average forecast for months 4 through 9.
The number of heart surgeries performed at HeartvilleGeneral Hospital has increased steadily over the past sev-eral years. The hospital’s administration is seeking the bestmethod to forecast the demand for such surgeries in year 6.The data for the past 5 years are shown. The hospital’s administration is considering the followingforecasting methods. Begin error measurement in year 3 soall methods are compared for the same years.i. Exponential smoothing, with a = 0.6. Let the initial fore-cast for year 1 be 45, the same as the actual demand.ii. Exponential smoothing, with a = 0.9. Let the initial fore-cast for year 1 be 45, the same as the actual demand.iii. Trend projection with regression.iv. Two-year moving average.v. Two-year weighted moving average, using weights 0.6 and0.4, with more recent data given more weight.vi. If MAD is the performance criterion chosen by the admin-istration, which forecasting method should it choose?vii. If MSE is the performance criterion chosen by the…
12.2. The manager of the I-85 Carpet Outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlet's many competitors. The manager has collected the following demand data for the past eight months: Demand for Soft Shag Carpet (1000 yd) Month ALE ni bno 1 10 6. 4. 8 14 6. 10 7 9. 8. 12 a. Compute a three-month moving average forecast for months 4 through 9. b. Compute a weighted three-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months in sequence, starting with the most recent month. c. Compare the two forecasts using MAD. Which forecast appears to be more accurate? 3.