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
Stang Sports Equipment Company made 40,000 basketballs in a given year. Its manufacturing costs were $288,000 variable and $95,000 fixed. Suppose that no price changes will
Customers owe the shop $3,200 for services already performed and the workers were hired this year and are owed $550 at the end of the year for work in December.
Calculate the amount of fixed manufacturing overhead that would be included in ending inventory under full costing and reconcile it to the difference between parts a and b.
Which of the following would not be a component of cash flows from investing activities? a. Sale of land. b. Purchase of securities. c. Purchase of equipment. d. Dividends pai
Why does the statement of cash flows include "unearned revenue" as an addition to net income in the operations section? Why is "recognition of unearned revenue" included as a
At the beginning of the year, Shults Company had the following standard cost sheet for one of its plastic products. Compute price and usage variances for materials. Compute th
Compute the budgeted fixed cost per labor hour for the fixed overhead separately for each plant and compute the variable overhead spending variance and the variable overhead e
ACC/ACF2200 Introduction to Management Accounting Assignment. Using the detail in the case, describe how your chosen method of calculating product cost will be beneficial wit