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
For financial accounting purposes, what is the total amount of product costs incurred to make 10,000 units and what total incremental costs will Martinez incur if it increases
Suppose that the company decided to assign the accounting costs directly to the product lines using the number of transactions as the activity driver. What is the accounting
During the year, the company purchased $100,000 of raw material and spent $340,000 on direct labor. Other data: Manufacturing overhead incurred $450,000; sales, $1,560,000;
Is the direct or indirect method used to report operating activities? What is the largest adjustment to net income in reconciling net income and cash flows from operations in
Literature synthesis with gaps and research opportunities (The literature synthesis must not lack specificity and theoretical debate). Please research more to bring out m
Advanced Corporate Reporting (FIN4033) - Discuss the professional and ethical duties of the CFO/accountant. Evaluate the financial reporting framework and advise on and report
Both interest expense on borrowing and dividends on common stock reduce net assets and reduce shareholders' equity.- Explain the rationale for this apparent inconsistency.
There are different views of how quality can be managed. While a certain level of quality may be accepted, there is an argument to aim for the highest level of quality. Di