+1-415-670-9189
info@expertsmind.com
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
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Prepare the operating activities section of the statement of cash flows for 2011 using the indirect method. Note that there is no difference between the two methods for the in
Assignment - Excel Workbook Assignment MFE 6100 and Create the amortization schedule for this note in proper format. Label your spreadsheet cell that shows your TVM calcu
Use the following information to complete Paul and Judy Vance's 2014 federal income tax return. If information is missing, use reasonable assumptions to fill in the gaps.
Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional
Assume that a commercial airplane manufacturing company's annual fixed costs for the widebody passenger jet are $1,425 million, and its variable cost per airplane is $90 mil
Yummy-Pop Ltd makes lollipops in two sizes, large and giant. The company sells these lollipops to convenience stores, fairs, schools for fundraisers, and in bulk on the In
The five managerial characteristics needed by administrators are technical competence, resource management, communication, leadership and innovation.
Cash receipts from customers should improve given anticipated improvements in economic conditions. Company has also committed extra resources to the credit function, in orde