Question

In: Math

A budget is an expression of management's expectations and goals concerning future revenues and costs. To...

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 estimate the relationship between overhead (y) and the level of production (x) 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 $1000): 13 11.4 14 15 15.6 15.2 17.6

(a) Test the hypotheses H0: β1 = 0 versus  Ha: β1 ≠ 0 at the 5% level of significance.

State the decision rule. (Which Option below should we use)

1. Reject H0 if p value > 0.025.
2. Do not reject H0 if p value ≤ 0.025.Reject H0 if p value > 0.05.
3. Do not reject H0 if p value ≤ 0.05.    Reject H0 if p value < 0.025.
4. Do not reject H0 if p value ≥ 0.025.Reject H0 if p value < 0.05.
5. Do not reject H0 if p value ≥ 0.05.


State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter your degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places).

(Choose: (x, ,z p, t, G)) ( _______  ) = ___________  , p (Choose: (≥, >, <, ≤, = )) ___________

State your decision. Are production and overhead costs linearly related?

1.) Reject the null hypothesis: Yes, production and overhead costs appear to be linearly related

2.) Reject the null hypothesis: No, production and overhead costs do not appear to be linearly related.

3.) Do not reject the null hypothesis: Yes, production and overhead costs appear to be linearly related.

4.) Do not reject the null hypothesis: No, production and overhead costs do not appear to be linearly related.



(b) Test the hypotheses  H0: β1 = 1 versus  Ha: β1 ≠ 1 at the 5% level of significance.

State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter your degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places).

(Choose: (x, t, p, G, z)) (________  ) = __________ , p (Choose:(= ≥ > ≤ < )) _____________

State your decision. Choose one of the following:

1.) Do not reject the null hypothesis: The slope of the line representing the relationship between overhead costs and production is not significantly different from 1.

2.) Do not reject the null hypothesis: The slope of the line representing the relationship between overhead costs and production is significantly different from 1.

3.) Reject the null hypothesis: The slope of the line representing the relationship between overhead costs and production is not significantly different from 1.

4.) Reject the null hypothesis: The slope of the line representing the relationship between overhead costs and production is significantly different from 1.

Solutions

Expert Solution

Finding the regression equation
Step 1 : Put the data in excel as shown.


Step 2 : Go to Data -> Data Analysis -> Regression


Step 3 : Input the values as shown.


Step 4 : The output will be generated as follows.

State the decision rule. (Which Option below should we use)
Do not reject H0 if p value ≥ 0.05.

State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter your degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places).


t = 4.45281
pvalue = 0.006685
pvalue < 0.05

State your decision. Are production and overhead costs linearly related?

1.) Reject the null hypothesis: Yes, production and overhead costs appear to be linearly related


Related Solutions

Goals and Benefits for the EHR What is the importance of establishing goals and benefits expectations...
Goals and Benefits for the EHR What is the importance of establishing goals and benefits expectations for the EHR? Your post must use at least one scholarly or health care industry-recognized resource, and include an in-text citation and its related reference, following current APA format guidelines.
A flexible budget provides estimates of what revenues and costs “should be”. If we are trying...
A flexible budget provides estimates of what revenues and costs “should be”. If we are trying to compare actual costs to “budgeted” costs, why is comparing actual costs to the flexible budget better than comparing them to the static/planning budget? 2)Explain why a business could have a favorable material price variance but an unfavorable material quantity variance. Don’t just explain the math. Provide a real world scenario. 3Simply looking at overall spending variances tells us what’s different. Why is it...
Describe the expectations and objectives of a client that can fulfil clients’ goals.
Describe the expectations and objectives of a client that can fulfil clients’ goals.
COSTS AND REVENUES FOR URGENT CARE CENTER COSTS: Urgent Care Center All costs and revenues are...
COSTS AND REVENUES FOR URGENT CARE CENTER COSTS: Urgent Care Center All costs and revenues are per year * Labor Cost 5 Primary Care Physicians                   Salary $150,000            $   750,000 8 RN/BSN Salary                                  Salary $ 64,000              $   512,000 Payroll Taxes (all employees)                                                    $   327,400 Benefits (all employees)                                                            $1,893,000                                                                                                          * Other Variable Costs Supplies & Misc. Overhead                                                        $    102,400 Advertising                                                                                 $      35,000       TOTAL VARIABLE COST        $3,619,800 * Capital Cost Annualized Building Cost                                                           $    465,403...
The budget is the difference between revenues and expenses. For the government, the revenues are relative...
The budget is the difference between revenues and expenses. For the government, the revenues are relative to the Gross Domestic Product (GDP) and expenses are defined as the government’s expenditure (G). Having that in mind, assume the following shock in the economy: Due to poor working conditions, workers are leaving the labor force and retire. a) Explain the consequences of the above shock on inflation and GDP by using the AS/AD model (draw the graph, label the axis, show the...
Address how a strong operating and capital budget process would assist achieving future financial goals (what...
Address how a strong operating and capital budget process would assist achieving future financial goals (what tools might you employ?). Explain why accurate cost allocation is important. What would be the priorities for capital budgets (in general, not specifically)?
Suppose the markets change their expectations of the future value of the dollar, such that they...
Suppose the markets change their expectations of the future value of the dollar, such that they expect it to be stronger at that time in the future than their expectation was previously (i.e., Ee decreases). a) How would this change in expectations affect spot exchange rates assuming interest rates stay constant? b) What would the central bank have to do to keep the spot rate from changing in the manner you described in part (a)?
Suppose the markets change their expectations of the future value of the dollar, such that they...
Suppose the markets change their expectations of the future value of the dollar, such that they expect it to be stronger at that time in the future than their expectation was previously (i.e., Ee decreases). How would this change in expectations affect spot exchange rates assuming interest rates stay constant? What would the central bank have to do to keep the spot rate from changing in the manner you described in part (a)?
Meeting the expectations of stakeholders and being socially responsible are generally important goals for the modern...
Meeting the expectations of stakeholders and being socially responsible are generally important goals for the modern organization. However, as stated in our text on pages 96-97, some economists argue that social responsibility should not be part of the strategic decision-making process. Do you agree or disagree?
4. If sellers of a product in a perfectly competitive market change their expectations of future...
4. If sellers of a product in a perfectly competitive market change their expectations of future prices and now believe that prices will be higher than their previous expectations, which of the following happens to the equilibrium price of the product today? a)The price increases. b)The price decreases. c)The price will not change. 5. Crude oil prices reached a high of $147.30 (2008 dollars) a barrel in July 2008. The spike in crude oil prices in the late 2000s led...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT