+1-415-670-9189
info@expertsmind.com
Determining cost functions for manchester foundry
Course:- Managerial Accounting
Reference No.:- EM1349742




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
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
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Calculating Return on Investment for this new low calorie product. You have the master budget, cash budget, Cash flow info with NPV. Based on the information provided can th
Peoria Implements Company produces farm implements. Peoria is in the process of measuring its manufacturing costs and is particularly interested in the costs of the manufact
What is the incremental benefit (cost) to the company of sugar-coating the peels rather than selling them in their condition at the split-off point and What is the increment
Compute the overhead cost rate that should be used for each of the appraisers to ensure that the total expected operating costs for the year will be recovered from clients.
Explain to the General Manager what the learning curve is? In your explanation make reference to the two variant methods. Include in your response the conditions under which
ACC518 - Current Developments in Accounting Thought - Additional Assignment Explains the decision made by the regulators in terms of public interest theory - Explain the decis
Corresponds to CLO 4(b) Ferguson Molding Company produces custom bottle caps and jar covers for large cosmetic companies. Each customer owns the custom-made molds that are u
Is Mary's behavior regarding the cost information she provided to Susanna ethical? Support your answer by reference to the Institute of Management Accountant's Statement of