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
Your company has developed the drug called Matrox that is an effective treatment for migraine headaches. You have just discovered that it can also be employed for organ tran
Grebe becomes insolvent in the current year and is adjudged bankrupt. Karen was the president of Grebe Corporation and was paid an annual salary of $50,000 for the past three
Management reports have been a prominent topic the past few years. The term "Management Reports" can be understood in a variety of different contexts and applications. A man
What is the difference between an Associate and a Subsidiary and and what is Goodwill and when is that applied - Prepare all journal entries assuming all application monies r
Boyer Corp. has outstanding borrowings. One of these borrowings is nonconvertible preferred stock (cumulative) with a par value of $75 and an annual dividend rate of 8.25%. Th
Prepare an income statement for Marwick’s Pianos, Inc., for August. Use the traditional format, with costs organized by function. (A "Net operating loss" should be entered as
Compute the following for Iguana, Inc., for the second quarter (April, May, and June). 1. Budgeted production in units 2. budgeted cost of raw materials posted 3. budgeted dir
Determine Nongoma Ltds after-tax weighted average cost of capital, based on the current market values of its sources of capital and Calculate the total current market values