Reference no: EM13940575
SCATTERGRAPH, HIGH-LOW METHOD, AND PREDICTING COST FOR A DIFFERENT TIME PERIOD FROM THE ONE USED TO DEVELOP A COST FORMULA
Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
|
Month
|
Receiving Orders
|
Receiving Cost ($)
|
|
1
|
1,000
|
18,000
|
|
2
|
700
|
15,000
|
|
3
|
1,500
|
28,000
|
|
4
|
1,200
|
17,000
|
|
5
|
1,300
|
25,000
|
|
6
|
1,100
|
21,000
|
|
7
|
1,600
|
29,000
|
|
8
|
1,400
|
24,000
|
|
9
|
1,700
|
27,000
|
|
10
|
900
|
16,000
|
METHOD OF LEAST SQUARES
Refer to the above Farnsworth Company information for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered two more months of data:
|
Month
|
Receiving Orders
|
Receiving Cost
|
|
11
|
1,200
|
$28,000
|
|
12
|
950
|
$17,500
|
For the following requirements, round the intercept terms to the nearest dollar and round the variable rates to the nearest cent.
Required:
1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results.
2. Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during month 11 that required extensive repairs to the receiving area-including major repairs on a forklift. These expenses, included in month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares?
3. Rerun the method of least squares, using all the data except for month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.
|
Problem regarding the enterprise resource planning
: Traditionally, Enterprise Resource Planning (ERP) systems are adopted by the manufacturing organisations; however, ERP vendors developed several modules to support organisations in different industries. As a result almost all the bigger organisat..
|
|
Explain why venue may be easily change within federal system
: A court must have jurisdiction to hear and decide a case. Venue is the particular location or area in which a court with geographical jurisdiction may hear a case. Explain why venue may be easily changed within the federal system and reasons why c..
|
|
Valued at the current unit manufacturing cost
: The Shim Refrigerator Co. shows the following records for the period ended December 31, 19A:Materials purchased
|
|
Determine the changes in the prime rate that have occurred
: Review a current issue of the Federal Reserve Bulletin, or review of copy from the Fed's Web site (www.federalreserve.gov) or the St. Louis Fed's Web site (www.stlouisfed.org). And Determine the changes in the prime rate that have occurred since the ..
|
|
Prepare a scattergraph using all twelve months of data
: Prepare a scattergraph using all 12 months of data. What step might Tracy, using her judgment, take to amend the results from the method of least squares?
|
|
Develop a powerpoint presentation on the bernie madoff
: Assume you are an instructor presenting an unethical case study to your graduate students. Develop a PowerPoint presentation on the Bernie Madoff. Be certain to address the following key components for your student audience:
|
|
Prepare a cost formula for the receiving activity
: Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed?
|
|
Explain eventhandling concepts in java
: Enhance the ButtonViewer program so that it prints the time at which the button was clicked.Please provide the ClickListener class in your solution.
|
|
Provide a background of the firm industry economy
: Provide a background of the firm, industry, economy, and outlook for the future Analyze the short term liquidity of the firm Analyze the operating efficiency of the firm Analyze the capital structure of the firm Analyze the profitability of the firm ..
|