Reference no: EM131144410
Use Excel to do this. Please show how it looks like and show the formulas. (You may use Ctrl ~ in Excel to show formulas)
SCR Manufacturing, LLC makes a variety of parts for the Machine Tool Industry. One of these parts (MIR 144) does not seem to be contributing to profits. The selling price of the part is $27.85, the variable cost is $19.00 and the Fixed Cost for this product is $152,000 per year. In the past fiscal year, 14,500 of this product was produced and sold.
A. Construct a correct, flexible and documented spreadsheet model that will allow varying inputs and resulting revenue, costs and profit. Check the base case above to see if the company is losing on this part.
B. Using the model and Goal Seek, find the break even quantity.
C. Construct a data table and chart showing profit vs. quantity.
D. The owner is trying to determine where to put her efforts in attempting to increase the profitability for MIR 144. Should she increase sales volume by 20% or reduce the variable cost by 15%. Using the model, determine which method would increase profitability more. Show your calculations that helps to answer the question.
|
Most companies have some degree of waste
: Most companies have some degree of waste, however that which is AVOIDABLE but allowed to continue unabated is chronic waste. Unfortunately, many organizations have chronic waste which becomes a burden to delivery of customer value. Waste has a cost a..
|
|
Define the terms data-information and knowledge
: Define the terms data, information, and knowledge, and provide examples of each one. What does the following statement mean: “Without networks, the computer on your desk would be merely another productivity tool, just like the typewriter once was”? W..
|
|
Map of the strategic groups making up the rivals
: Define the industry Provide a Map of the Strategic groups making up the Rivals (Appendix 1) Define the major categories or industries (and give some example firms from each) for the New Entrants, Substitutes, Buyers, and Suppliers, for the Porter’s a..
|
|
Passion for managing one career as primary objective
: What is the foremost thing that occupies the attention of you and your fellow associates? Is there a passion for managing one's career as a primary objective, being highly efficient and reducing costs of operation, or is it a focus on the customer?
|
|
Using the model and goal seek-find the break even quantity
: SCR Manufacturing, LLC makes a variety of parts for the Machine Tool Industry. One of these parts (MIR 144) does not seem to be contributing to profits. The selling price of the part is $27.85, the variable cost is $19.00 and the Fixed Cost for this ..
|
|
Discussion of agency law-potential liability
: Read two articles discussing the probation and ultimate firing of former Indiana University basketball coach Bobby Knight. Discuss why the University took the action it did, including a discussion of agency law, potential liability and the rights of ..
|
|
Expected project completion time for the construction
: Using? PERT, Adam Munson was able to determine that the expected project completion time for the construction of a pleasure yacht is 22 ?months, and the project variance is 9. a) The probability that the project will be completed in 13 months? = ?
|
|
Texas legislature just passed the campus-carry bill
: Texas’ Legislature just passed the Campus-Carry bill allowing professors, administrators, and students to carry hand-guns (weapons) on campus in the near future. This will only promote more school shootings and/or violence
|
|
About the verbal discourse of an organization
: What do you notice about the verbal discourse of an organization? What can you discern about the nature of the organization from its discourse? What about the discourse of artifacts and symbols? What added information about the organization do they o..
|