Question: Time Period from the One Used to Develop a Cost Formula Refer the information for Farnsworth Company above. Required: 1. Prepare a scattergraph based on

Time Period from the One Used to Develop a Cost Formula Refer the information for Farnsworth Company above.

Required:
1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear?
2. 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?
3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated?
Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?

Month Roceiving Orders Recaiving Cost 1,000 700 1,500 1,200 1,300 1,100 1,600 1,400 1,700 900 $18,000 15,000 28,000 17,000 25,000 21,000 29,000 24,000 27,000 16,000 10

Step by Step Solution

★★★★★

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style43 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style45 msonumberformat00220022 00000220022 ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

563-B-C-A-C-B-M (375).xlsx

300 KBs Excel File

Students Have Also Explored These Related Cost Accounting Questions!

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...

Refer to the information for Farnsworth Company above. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Intercept ............

Refer to the information for Farnsworth Company for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered two more months of data: Required: 1. Run...

VE 3 Problem 3-60 Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the...

Use the following mformation Jer Problems 3-45 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...

Prepare a scatter graph based on 10 months of data. Please show work. Use the following information for Problems 3-43 and 3-44 Farnsworth Company has gathered data on its overhead activities and...

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...

Below data is GCD data. Time(s) Time(s) 0 257.618 0.001 257.619 10.001 267.619 20.001 277.619 30.001 287.619 40.001 297.619 50.001 307.619 60.001 317.619 70.001 327.619 80.001 337.619 90.001 347.619...

Arbitration will be the prevalent form of dispute resolution for international business in the 21st century?

1 : 4 4 : 2 0 remaining Page 2 2 of 2 6 Question 2 1 ( 4 points ) Listen If 1 0 - year T - bonds have a yield of 6 . 2 % , 1 0 - year corporate bonds yield 7 . 9 % , the maturity risk premium on all...

Experts have commented that one of the reasons for the success of the Enron task force is that it worked its way up through employees in the company. That is, it got plea agreements and information...

Taylor Jenkins jumped out of his chair. Harrington Chemicals, a sales lead that Taylor had been working on for six months, had just placed its first order for 8,000 bottles of Omnigar. To get the...

At the monthly management meeting, Leslie Smith, president of Mama Fran's Fantastic Foods, was reviewing the April budget report with some satisfaction. "Our actual results are never exactly what we...

Blake field, Inc. has grown significantly over the past decade through innovation and acquisition. Information on several of its divisions follows. The OlliePods division sells children's...

x Y Z Corporation is considering acquiring ABC Company. x Y Z estimates that the acquisition will generate additional free cash flows of 1 . 2 million dollars per year, in perpetuity. XYZ...

Jasper Furnishings has $350 million in sales. The company expects that its sales will increase 13% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level...

SOLVE EXCEL PLEASE 2. Brandon buys a piece of equipment for $15,000. He pays $5,000 for upgrades in year 1 and the equipment generates $2,000 in cash flow for year 1 . In year 2 the equipment...