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
The allowance for uncollectible accounts currently has a credit balance of $900. After analyzing the accounts in the accounts receivable subsidiary ledger, the company's man
Explain how management determined that only 4.7 million of new options would be granted in exchange for the 14.3 million options tendered. In other words, why might manageme
Journalize the adjusting entries on August 31 for the 3-month period June 1-August 31 - prepare a ledger using the three-column form of account. Enter the trial balance amoun
Process Solutions provides a computer-based document processing service and general Manager has asked for your advice in relation to this disagreement within the management te
Describe how the selected system would work to track the costs of the product - identify the cost driver, and explain the process of tracking the costs and provide examples of
TinCo has product liability problems and has filed for bankruptcy protection in the state court. Currently, its liabilities are $1 million, and its depreciable assets are valu
What would you include in a job description for a new cashier? How about a sales person? What is included on your job description? Are there functions you perform that are n
uppose the company decides that only 1,400 units can be sold at a price of $5,000 and, therefore, the target cost cannot be reached. The company is considering. dropping the