Determining cost functions for manchester foundry

Assignment Help Managerial Accounting

Reference no: EM1349742

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.

Reference no: EM1349742

Questions Cloud

Explain organizational culture : Explain Organizational culture is the culture that exists in an organization something akin to a societal culture

Show the clevelands conflict : Cleveland really admired Babe Reilly, the new pitcher for the city's professional baseball team. Reilly was just 19 years old, yet he was the team's number-one pick.

Calculate the mechanical work done by the sprinter : How much would a 80.0 kg person weight on Mars, where the acceleration of gravity is 3.93 m/s^2, and on Earths Moon, where the acceleration of gravity is 1.63 m/s^2.

Elucidate how many units bonus will be paid : The distribution of the weekly production is approximately normally distributed with a standard deviation of 60 units. If the bonus is paid on the upper 5 percent of production, the bonus will be paid on how many units or more.

Determining cost functions for manchester foundry : 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 instruc..

Relvant cost of making versus buying : James Co. has two divisions,A and B,each operate as a profit center.A charges B $35 per unit for each unit transferred to B. Other data for A are below:

Conflict mangagement in a small work space : Conflict mangagement in a small work space - Can you please recall and list instances of conflicts that took place during any team project?

Security measures currently in place give adequate security : Explain in scholarly detail on whether you believe security measures currently in place give adequate security as well as privacy, or do you believe these issues being emphasized are at the expense of the other?

How much charge is on the positive plate : A student yells across a street at a concrete wall. The student hears an echo 0.500 seconds later. If the speed of sound in air is 343 m/s, what is distance from the student to the wall only.

User Account

All Pages