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

Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
The maintenance department's costs are allocated to other departments based on the number of hours of maintenance use by each department. The maintenance department has fixed
You have a project with the following cash flow stream (assume a 10% discount rate).  What is the profitability index of the project?  Is it acceptable? Calculate the profit
Cyclone anticipates borrowing $ 25,000 in May and paying for a piece of equipment costing $ 7,600. Given these expectations, what is May's budgeted ending cash balance?
Identify your problem statement and complete a root-cause analysis. Identify which quality tools you used to identify and vet the problem - Explain the quantitative and quali
Milan Machining Company has identified the following overhead activities, costs, and activity drivers for the coming year. Determine the cost of the Receiving activity. Assign
Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: the standard direct labor rate is
federal and state income taxes withheld were $2,000, union dues were $150 and state umployment taxes (employer tax) were $450 for that payroll. Prepare any journal entries n
Draw conclusions regarding the nature of the problem and possible solutions, and develop recommendations for the managers in question and write a memorandum to the organizat