You have been requested by your boss to provide a regression analysis. Upon presentation your boss is unhappy with your work. You are instructed to do more work and return when you have lower cost estimates for labor hours. Your initial analysis covered a 3 year period and by dropping 3 of months from the middle of the analysis period you are able to reduce labor hours to a “boss acceptable” amount. Did you do something unethical?

You have been requested by your boss to provide a regression analysis. Upon presentation your boss is unhappy with your work. You are instructed to do more work and return when you have lower cost estimates for labor hours. Your initial analysis covered a 3 year period and by dropping 3 of months from the middle of the analysis period you are able to reduce labor hours to a “boss acceptable” amount. Did you do something unethical?

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?
Using multiple regression, you have identified P12,000 of unit level costs for 3,000 units, P1,000 of product level costs for 40 products, and P3,500 of customer-level costs for ten customers. The cost of Job 002 which used 800 unit level activities, 4 product level activities, and one customer-level activities amounts to * A. P3,650 B. P3,250 C. P3,050 D. P2,950
Facts: A Chicago area manufacturing company (“JKL”) has 2 unrelated owners. The CPA firm (“Flexible”) for the manufacturing company prepares annual compiled financial statements and corporate tax returns (1120S). In addition, Flexible prepares the personal income tax returns for one of the owners – a different tax accountant prepares the personal income tax returns for the other owner. The Company has a December 31st year end. Toward the end of February each year, there is an annual meeting in the western suburbs, with the following in attendance: the 2 owners of JKL, Flexible’s CPA Partner, the tax accountant for the other owner, and pension consultants. In anticipation of the meeting, Flexible prepares and distributes draft financial statements, and a year to date General Ledger; everything is complete except the amount of any pension accrual and the final amount of inventory. The purposes of the meeting are to determine: the pension accrual the desired taxable income for the…
The least squares regression method question - rounds your answer to two decimal points.please find the solution and provide me with detailed step by step instructins, I am completely lost.
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Overhead Cost Billable Hours $ 365,000.00 3000 $ 400,000.00 4000 $ 430,000.00 5000 $ 477,000.00 6000 $ 560,000.00 7000 $ 587,000.00 8000 a) Develop a trendline to identify the relationship between billable hours and overhead costs. b) Interpret the coefficients of your regression model. Specifically, what does the fixed component of the model mean to the consulting firm? c) If a special job requiring 1000 billable hours that would contribute a margin of $38,000 before overhead was available, would the job be attractive?
Aqua Man Company manufactures and sells a single product. Planned and actual production in its first year of operation was 100,000 units. Planned and actual costs for the year were as follows: Manufacturing Non-manufacturing Variable P600,000 P500,000 Fixed P400,000 P300,000 The company sold 85,000 units of product at a selling price of P30 per unit. Using absorption costing, the company’s operating profit was Select one: a. P1,020,000 b. P975,000 c. P900,000 d. P750,000
Write a 1000 words report on a case study. You have recently started a new job as a junior operations manager at Pet Kingdom, a petsupplies retailer. You are writing these reports to your line manager, Ms Lionheart, so theappearance and language of your reports need to be professional. CASE STUDY - Forecasting Your line manager, Ms Lionheart, has collected and scrutinised performance data for thecompany. She was concerned that the inventories were high for certain products which hadresulted in significant price reductions and losses for the company. At the same time, thecompany had run out of stock for other items early in the season resulting in unsatisfiedcustomers and lost sales. Ms Lionheart has concluded that the problem was not with thespecific products carried in the stock, but with the quantities ordered by the procurementdepartment for two popular products; Dog Ball Launcher and Lightweight Dog Lead.Dog Ball Launcher is a product carried by the company for the past four…
Interpret the coefficients of your regression model. Specifically, what does the fixed component of the model mean to the consulting firm? Interpret the fixed term, b 0b0, if appropriate. Choose the correct answer below. A. It is not appropriate to interpret b 0b0, because its value is the predicted billable hours for overhead costs of 0 dollars, but the firm cannot have overhead costs of 0 dollars associated with a client. B. The value of b 0b0 is the predicted overhead costs for 0 billable hours. C. It is not appropriate to interpret b 0b0, because its value is the predicted overhead costs for 0 billable hours, but someone with 0 billable hours would not actually be a client of the firm. D. For each increase of 1 unit in billable hours, the predicted overhead costs are estimated to increase by b 0b0. E. The value of b 0b0 is the predicted billable hours for an overhead cost of 0 dollars. F. For each increase of 1 unit in…
All patients admitted to a particular hospital can be released on the same day or kept overnight forobservation. In a sample of 2550 patients, 1020 were kept overnight for observationa) What is the point estimate ?̂for the proportion of all patients kept overnight forobservation? [1]b) Construct a 99% confidence interval for the proportion of all patients kept overnight forobservation.
Job Evaluation for Managerial Positions The Chairman of the board of directors of Jonadel Corporation has proposed that all managerial positions be included in the corporate job evaluating program. The idea came from several friends in other companies of the Chamber of Commerce and Industries where he is a member of the board of directors. The inclusion of the managerial positions in other company's job evaluation program has been found to be successful and helpful. There are differences in the pay systems based on the job evaluation and these companies and the chairman is convinced that these will work also with the company where the chairman is and has the greatest shares of stocks. tudy. In one of the special meetings of the Board of Directors, he proposed the idea to the chief operating officer. The chief operating officer said that the programs be held in abeyance until he had consulted his line and operating managers who will be affected by the changes due to job evaluation…
Can you please give step by step how to do regression including the Text and charts in Excel for the 2 problems attahced
What is the difference between linear and multiple regression?