Data for Oriole Corporation's maintenance costs is shown below.JulyAugustSeptemberOctoberNovemberDecemberIntercept $UnitsProducedSlope15,84028,16031,68019,360The cost equation is: $35,20033,440Compute the variable- and fixed-cost elements using the regression analysis. Present your solution in the form ofa cost equation. (We recommend that you use the Intercept and Slope functions in Excel.) (Round intercept to 2decimal places e.g. 1.25 and slope to 5 decimal places e.g. 1.25125.)Total Cost$28,16042,24048,40033,44058,16854,560+$per unit produced = Total cost

Answered: Image /qna-images/answer/4657f34f-1a3c-4947-ad4c-b1dbd4374725.jpg

Answered: Compute the variable- and fixed-cost…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
In the table below ratings data on x = the quality of the speed of execution and y = overall satisfaction with electronic trades provided the estimated regression equation ŷ = 0.3402 +0.8922x. Brokerage Speed Satisfaction Scottrade, Inc. 3.5 3.4 Charles Schwab 3.0 3.1 Fidelity Brokerage Services 3.3 3.2 TD Ameritrade 3.6 3.5 E*Trade Financial 3.4 3.7 Vanguard Brokerage Services 3.8 3.6 USAA Brokerage Services 3.3 2.9 Thinkorswim 3.1 3.6 Wells Fargo Investments 2.4 2.4 Interactive Brokers 2.6 2.2 Zecco.com 2.7 3.1 At the 0.05 level of significance, test whether speed of execution and overall satisfaction are related. Show the ANOVA table. What is your conclusion? Source Sum of Squares Degrees Mean Square F (to 2 decimals) of Variation (to 4 decimals) of Freedom (to 4 decimals) Regression Error Total P-value is - Select your answer - We Select your answer - V reject Ho : B1 = 0, we conclude that speed of execution and overall satisfaction Select your answer - V related.
Curry Rubber manufactures rubber bands for retail compaies. The accounting manager has performed a regression analysis of past data. You notice that the formula has an R-squared of .6, at-valueof 2.3, and a standard error of the estimate of $200,000. The estimate for next quarter costs is $2,584,072. What do these statistics tell you about the reliability and precision of his regression analysis?
The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 166.125 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year Year Seasonal Year 1 Year 2 Average 4 Index Quarter 205 211 182 1.1768 1 Quarter 152 170 158 156 2 Quarter 182 190 198 193 3 Quarter 128 112 113 0.7178 4
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the exponential smoothing method to forecast the number of sales to expect next month. Use the following value of alpha: 0.2. Month Demand Forecast 1 308 349.2 388 340.9 3 344 350.3 4 400 349.1 341 359.3
Use the below formula to calculate the CLV for the following: A manager of a cable company wants to determine if it is strategic to acquire the Brett family, by estimating their household-level CLV. The manager estimates that it will cost the company $80 (A) to get the Bretts’ to switch, and the Bretts’ will generate $150 profit each year (M), with a $30 annual marketing cost to retain them (C). The estimated retention rate (r) is 65%, and the current discount rate is 5%.(d) i) CLV= ii) Based on your calculation, are the Brett’s profitable to the cable company?
The following data describes weekly gross revenue ($1000s), television advertising expenditures ($1000s), and newspaper advertising expenditures ($1000s) for Showtime Movie Theaters. × Weekly Gross + Revenue ($1000s) 99 90 95 92 95 94 94 94 a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals). 2.84 Television Advertising ($1000s) 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 Revenue = 81.73 1.29 News Adv TV Adv + b. Choose the correct plot of the standardized residuals against ĝ. Newspaper Advertising ($1000s) 1.5 2.0 1.5 2.5 3.3 2.3 4.2 2.5
A business conducted a linear regression to estimate its demand function and obtain the following demand function Q = 200 - 1.5P + 0.55A - 2.8Py + 0.05Inc, where P is price and A is advertising. When P = $21. A = $30 and Quantity = 160, find the profit-maximizing advertising-to-sales ratio (hint: first find the price and advertising elasticities). Type as either a decimal out two spaces, like 0.10 OR as a percentage like 10%. %3! %3! Question 17 During recessions, people's reservation price (aka reserve price) searching. which results in O drops; less O rises; more drops; more O rises; less
Year Quarter Sales Isolated trend 2016 1 18 2016 2 28 2016 12 2016 4 8 2017 1 16 2017 2 38 2017 3 24 2017 4 17 2018 1 34 A 2018 2 40 2018 29 2018 4 26 2019 1 42 2019 2 52 2019 40 2019 4 34 43.75 2020 1 46 2020 2 58 The table contains decomposition figures of the quarterly sales in millions of Rands for a large store. The value of A is
Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1770 2 1880 3 1070 4 1420 5 1540 6 2000 7 1910 8 1360 9 1400 10 1500 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your final answer to 3 decimal places.) What is your forecast for next year’s sales? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializesin the purchase, renovation, and resale of older homes. Mac employs several carpenters and paintersto do the work for him. It is essential for him to have accurate cost estimates so he can determinetotal renovation costs before he purchases a piece of property. If estimated renovation costs plus thepurchase price of a house are higher than the house’s estimated resale value, it is not a worthwhileinvestment.Mac has been using the home’s interior square feet for his exterior paint cost estimations. Recentlyhe decided to include the number of external openings—the total number of doors and windows ina house—as a cost driver. Their cost is significant because they require time-consuming preparatorywork and careful brushwork. The rest of the house usually is painted either by rollers or spray guns,which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of theseexterior…
The number of patients coming to the Healthy Start Maternity clinic has been increasing steadily over the past eight months. You are provided with some historical data as follows:Month Clinic attendance (in thousands) 1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7a. Identify and give a brief explanation of the:-i. Dependent variableii. Independent variable b. Use simple linear regression to forecast annual demand for months 9 and 10 by using the tabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation.iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

Compute the variable- and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation. (We recommend that you use the Intercept and Slope functions in Excel.) (Round intercept to 2 decimal places e.g. 1.25 and slope to 5 decimal places e.g. 1.25125.)