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
Dubois Inc. loans money to John Kruk Corporation in the amount of $864,000. Dubois accepts an 8% note due in 6 years with interest payable semiannually. After 2 years (and rec
Given that each of the three corporate transportation alternatives covers a different length of time, what time period should be used to compare these options - how each of
Journalize the withdrawal of Carl if the partnership agrees to pay Carl $200,000 cash - journalize the withdrawal of Carl if the partnership agrees to pay Carl $140,000 cash.
Discuss the way in which BHP Billiton has demonstrated its social and environmental accountability and discuss the stance and initiatives of the Australian accounting profess
Prepare a differential analysis report, dated April 21 of the current year, on the proposal to sell at the special price and prepare a differential analysis report, dated Marc
To succeed in a competitive environment, the capital cycle must be competently managed. The long-term success of any organization depends on its ability to make capital invest
Ahron Company makes 76,000 units per year of a part it uses in the products it manufactures. The unit product cost of this part is computed as follows:
Four Oaks Miniature Golf and Driving Range Inc. was opened on March 1 by Tiger Woodley. These selected events and transactions occurred during March - Journalize the March t