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
Use the following format to classify each cost as a product cost or a general, selling, and administrative (G,S,A) cost. Also indicate whether the cost would be recorded as
Prepare a contribution format income statement segmented by divisions, as desired by the president and would you recommend the increased advertising? Show computations to supp
Prepare separate journal entries for each type of manufacturing cost - During January, its first month of operations, Knox Company accumulated the following manufacturing co
1.Verdi Company produces sporting equipment, including leather footballs. Identify each of the following costs as direct or indirect if the cost object is a football produced
Prepare a contribution margin income statement separating all variable and fixed costs into their own categories and determine the breakeven point in units and dollars. Also,
What are the expected benefits of the implementation of an effective system of internal controls for an organization - Calculate the expected cash balance at the end of April,
Give five disadvantages to using an activity-based costing system: Based on these answers, why would a company who only makes a few products not want to use such a system?
Use a process costing system. 2,000 units were in process at the beginning of the period, 60% complete. 20,000 units were started into production during the period; 1,000 we