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
Advise the management about the right choice of an alternative so as to maximize profits - The machines for both the products are common. However, cream is produced on a spec
What is a cash budget -How it is useful in managerial decision making - pprepare a statement of source and uses of working capital (funds) (b) a schedule of changes in working
You are well aware of the importance of budgeting in managing a business enterprise successfully. Consequently, you have decided to prepare an operating budget for the Bann
Prepare an incremental analysis for the 4 years showing whether Shellhammer should keep the existing machine or buy the new machine and calculate the annual rate of return f
Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional
Prepare a contribution margin income statement separating all variable and fixed costs into their own categories - product to manufacture and to describe the manufacturing pro
Explain the difference between variable costing and absorption costing net operating income in year 1. Also, explain why the two net operating incomes differ in year 2.
Now combine the setup and packing activities into one cost pool and repeat the assignment using the number of setups as the driver. Explain why the cost assigned to each pro