Question: (APPENDIX) METHOD OF LEAST SQUARES USING COMPUTER SPREADSHEET PROGRAM The controller for Beckham Company believes that the number of direct labor hours is associated with

(APPENDIX) METHOD OF LEAST SQUARES USING COMPUTER SPREADSHEET PROGRAM The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the following data on the number of direct labor hours and associated factory overhead cost for the months of January through August.

Month Number of Direct Labor Hours Overhead Cost ($)
January 689 5,550 February 700 5,590 March 720 5,650 April 690 5,570 May 680 5,570 June 590 5,410 July 750 5,720 August 675 5,608 Required:
. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.
. Using your results from Requirement 1, write the cost formula for overhead cost.
(You may round the fixed cost to the nearest dollar and the variable rate to the nearest cent.)
. What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of factory overhead cost?
. Assuming that expected September direct labor hours are 700, what is expected factory overhead cost using the cost formula in Requirement 2?
Exercise

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Introductory Financial Accounting Questions!

Method of Least Squares Using Computer Spreadsheet Program The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the...

d. Use the Susan Lewis florist shop data for Number of Deliveries and Delivery Cost in Exercise 3-56 in your textbook on page 137 to run a Regression on Excel WITH THE FOLLOWING NUMBER ADJUSTMENTS:...

Run a regression on Excel 1 How much is the fixed cost of labor per month? #2 How much is the variable rate per delivery? #3 What would the cost formula be to use to predict future delivery cost? #4...

The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the following data on the number of direct labor hours and associated...

Using Computer Spreadsheet Program OBJECTIVE 5 The controller for Beckham Company believes that the number of direct labour hours is associated with overhead cost. He collected the following data on...

In Chapter 3, you were introduced to 3 types of costs associated with a manufactured product ? direct materials, direct labor, and manufacturing overhead. Explain how these costs are associated with...

The controller for Beckham Company believes that the number of direct labour hours is associated with overhead cost. He collected the following data on the number of direct labour hours and...

Find and sketch the trajectory of the particle in Ex. 5.2, if it starts at the origin with velocity (a) v(0) = (E/B)y, (b) v(0) = (E/2B)y, (c) v(0) = (E/B)(y + z).

Refrigerant-134a enters an adiabatic compressor at 15 psia and 20°F with a volume flow rate of 10 ft3/s and leaves at a pressure of 100 psia. The power input to the compressor is 45 hp. Find (a)...

TX bought a machine on 1 October 20X2 for $600,000. The machine attracted writing down tax allowances at 25% on a reducing balance basis. Depreciation was 10% on a straight-line basis. Assuming a...

Riffle shuffle. Compose a program to rearrange a deck of n cards using the GilbertShannonReeds model of a riffle shuffle. First, generate a random integer r according to a binomial distribution: flip...

From the following General Ledger sheet of a Hotel, prepare two schedules, namely Rooms and Food and Beverage, as per AHMA pattern and arrive at the departmental income Additional Information:...

From the following Particulars extracted from the books of Oasis Restaurant prepare Trading and Profit and Loss A/c and Balance Sheet as on 31st Dec. 2002. Adjustments: 1. Stock on hand on...

From the following Trial balance of Coolwell Hotel, prepare a Trading and Profit and Loss A/c for the year ended 31st December 2002 and a Balance Sheet as on that date: Adjustments: 1. Closing stock...

Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $600 and the variable cost per cup of coffee served is $0.27....

5 of 10 View Policies Current Attempt in Progress The following information relates to the operations of Waterway.Company Finished Goods Inventory, beginning $ 28,000 Finished Goods Inventory, endi...

15 According to the standard unmodified audit report, a Critical Audit Matter is: 1. Only required when the auditor has resigned from the engagement. 2. A basis for a disclaimer of opinion. 3....