Explore BrainMass
Share

Estimating Cost Functions for Manchester Foundry

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

a. Manchester Foundry produced 45,000 tons of steel in March at a cost of £1,150,000. In April, the foundry produced 35,000 tons at a cost of £950,000. Using only these two data points, determine the cost function for Manchester following the instruction in my post in Materials.

b. Use Excel's "scatter plot" graphing function to plot the two points and the "trendline" option to determine the equation of interest. Does it match what you did manually? What is the interpretation of the equation and graph?

c. You obtain new data, 30,000 tons and a cost of 600,000. How do those values match the equation you came up with by hand? Put the point into your Excel spreadsheet and create the scatter plot and trendline. Describe the output.

© BrainMass Inc. brainmass.com October 25, 2018, 12:36 am ad1c9bdddf
https://brainmass.com/business/management-accounting/estimating-cost-functions-for-manchester-foundry-233852

Solution Preview

Please refer attached file for complete solution. Graphs are missing here.

Solution:
a. Manchester Foundry produced 45,000 tons of steel in March at a cost of £1,150,000. In April,  the foundry produced 35,000 tons at a cost of £950,000. Using only these two data points, determine the cost function for Manchester
following the instruction in my post in Materials.

There are two method by which, we can determine equation
Set of simultaneous equations:
Let x represents variable cost per unit
y represents fixed cost per unit
45000 tons of steel is produced at a cost of 1150000 pounds, it gives following equation
1150000=y+45000x ---------------(1)
35000 tons of steel is produced at a cost of 950000 pounds, it gives following equation
950000=y+35000x -------------------(2)
on subtracting eqn 2 from eqn 1 we ...

Solution Summary

This solution describes the steps for developing cost function for Manchester Foundary. The equation is developed by two methods. It also discusses why new data is so different from what we got from the equation developed earlier.

$2.19
See Also This Related BrainMass Solution

Regression and Cost Functions

Chapter: 1, exercise 18

18. Refer to the Wage data, which reports information on annual wages for a sample of 100workers. Also included are variables relating to industry, years of education, and gender for each worker.

a. Which of the 12 variables are qualitative and which are quantitative?
b. Determine the level of measurement for each variable.

Chapter 13, exercise 14

14. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and the Y column shows the value of sales ($ thousands) last month for each client sampled.

a. Determine the regression equation.
b. Determine the estimated sales if 40 contacts are made.

Chapter 3, problem 3-41

High-Low Method
Manchester Foundry produced 45,000 tons of steel in March at a cost of £1,150,000. In April, the foundry produced 35,000 tons at a cost of £950,000. Using only these two data points, determine the cost function for Manchester.

View Full Posting Details