Prepare a cost formula for the receiving activity

Assignment Help Financial Accounting

Reference no: EM13940573

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

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?

Reference no: EM13940573

Questions Cloud

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

Write a test application named simpledatetest : Write a test application named SimpleDateTest that demonstrates class SimpleDate's capabilities

Explaining the concepts of efficiency and effectiveness : What political consequences might result from an unfavorable opinion of your department? Describe how the Sheriff's department would measure efficiency and effectiveness.

User Account

All Pages