Question

Budget Analysis I: A budget is an expression of management's expectations and goals concerning future revenues and costs. To increase their effectiveness, many budgets are flexible, including allowances for the effect of variation in uncontrolled variables. For example, the costs and revenues of many production plants are greatly affected by the number of units produced by the plant during the budget period, and this may be beyond a plant manager's control. Standard cost-accounting procedures can be used to adjust the direct-cost parts of the budget for the level of production, but it is often more difficult to handle overhead. In many cases, statistical methods are used to predict or forecast overhead from the level of production using historical data. As a simple example, consider the historical data for a certain plant. Enter the data into EXCEL and analyze it to answer the following items. Production (in 10,000) units: 5 6 7 8 9 10 11 Overhead costs (in $1,000): 12 11.1 12 11.1 14 16 15.7 15.2 17.7 (a) Construct a scatterplot of y versus x. y 18 17! у 18 17 16 WebAssign Plot 16 15 15 14 14 13 13 12 . 12 11 11 . х 56 7 8 9 10 11 5 6 7 8 9 10 11 y у 18 18/ 17 16 17 16 15 15

**Just need help with one I got wrong** Thank you

Answer 1

y^ = 6.8143 + 0.9643x

d) When x = 50000

y^ = 6.8143 + 0.9643*50000 = 48221.81

Residual = 12000-48221.81 = -36221.81

e) When x = 110000

y^ = 6.8143 + 0.9643*110000 = 106079.81

Residual = 17700-106079.81 = -88379.81