Determining cost functions for manchester foundry
Course:- Managerial Accounting
Reference No.:- EM1349742

Assignment Help
Assignment Help >> Managerial Accounting

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.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
How does company manage and develop this value (Through advertising/ branding/ innovation/ acquisition of legal rights/takeover activity of competitors in recent years?)
Prepare quarterly manufacturing overhead budgets for Roehler Industrial for 2012 using the production information from Exercise 10-8.Roehler has overhead costs as follows:
Examine and discuss the characteristics of NPV and the role that this method plays in capital investment decision making. In addition, discuss the advantages of using this m
Is the material price variance favorable or unfavorable? What might have caused this variance? Is the material quantity variance favorable or unfavorable? How might it be rela
Should Cristin Madsen go along with the general manager's request to reduce the direct labor-hours in the predetermined overhead rate computation to 105,000 direct labor-hou
Analyze the Walmart's accounting and finance practices. This must be a formal business report which provides both specific processes and strategies involving budgeting, cost
You've been appointed as an executive director of small nonprofit organization. Among your many duties are to estimate an annual budget and develop a fiscal plan for organiz
A strategy map diagrams the relationship across the dimensions of the balanced scorecard. Identify the potential links between the customer and internal processes dimensions y