The computation-based problems

Assignment Help Operation Management
Reference no: EM131144398

Show all your work when answering the computation-based problems. Show screen shots of the spreadsheet you used to get the answer (indicating the answer!) and then Ctrl ~ to get a screen shot of your formulas. 1. 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. 

Reference no: EM131144398

Questions Cloud

Multinational meeting-business cultures and practices : You have been tasked to coordinate a multi-national meeting for your company, Turbine Energy International, with business entities from South Korea and Greece. The purpose of the meeting is to explore creating a partnership with the other two compani..
Benefits and challenges of implementing enterprise systems : What are the benefits and challenges of implementing enterprise systems? What is the impact of the Internet on organizations and the process of management? Data warehouses and data mining are here to stay. Discuss the positive and negative sides of t..
Why decisions concerning data structure have broader impact : Discuss why decisions concerning data structure have a broader impact than decisions concerning hardware and software. Evaluate the assertion that an information system by itself can rarely provide a sustainable competitive advantage. Explain how inf..
The computation-based problems : Show all your work when answering the computation-based problems. Show screen shots of the spreadsheet you used to get the answer (indicating the answer!) and then Ctrl ~ to get a screen shot of your formulas. SCR Manufacturing, LLC makes a variety o..
Rationale behind your approach and the systematic procedures : Think of two creative ideas for services to be provided by the grocery industry. Be very specific in terms of the rationale behind your approach, and the systematic procedures (e.g., questionnaire) you would use to introduce your services to the mark..
In the article creating vision for leadership : In the Article Creating a Vision for Leadership: The University of Missouri and the University of the Western Cape Partnership- What are the main conclusions in this article and If we take this line of reasoning seriously, what are the implications?
Influence the workplace health and wellness of employees : What are the 3 factors that influence the workplace health and wellness of employees? Explain your answers. Can you add to the list? If so, explain each one.
The objective is to increase participation in carpooling : The objective is to increase participation in carpooling and use of mass transit during this special week. A long-term objective, of course, is to increase the number of people who use carpools or mass transit on a regular basis. What methods would y..

Reviews

Write a Review

Operation Management Questions & Answers

  Item of discussion for construction project

Cost, the overall construction budget, is an item of discussion for any construction project. In general, with every project the owner will ask, "what do you think it will cost?"

  What pay level does the efficiency wage predict

What pay level does the efficiency wage predict? Does the theory accurately predict organization behavior? Why or why not?

  A responsive supply chain can be achieved

A responsive supply chain can be achieved by ________.

  Explain social responsibility activities and contributions

Social responsibility activities and contributions are mandated legally for large multinational global corporations by the World Bank and the United Nations.

  Under the securities act-term integration is best described

Which of the following would most accurately represent activity that blue sky laws are designed to protect against? A corporation’s registration statement should include information addressing all of the following, except: Under the Securities Act of..

  Data for the number of defects per spool of cable

Given the following data for the number of defects per spool of cable, using three sigma limits, compute the UCL, LCL, and state if the process is within limits. There are 14 observations where the Number of Defects is (2,3,1,0,1,3,2,0,2,1,3,1,2,0) S..

  Discuss the legal concepts of express and implied

Discuss the legal concepts of "express" and "implied" warranties and relate these concepts to the biblical instructions concerning business responsibility for the performance of, and damages caused by, products sold to the public.

  Effective communication is the most important factor

Some experts say that effective communication is the most important factor in successfully leading change. Do you agree, and can you cite examples that support your view?

  Means work-out plan preparation problem

Mathematically formulate Matt the Mean's work-out plan preparation problem as a mixed-integer-linear programming model.

  What communication model best describes his dance approach

Clampitt presented a communication model for his first 2 approaches to communication as related to managers; Arrow & Circuit. What communication model best describes his Dance Approach? Why? (Must be 200 words)

  Influence tactic is likely to result in target commitment

Which tactic is most likely to increase the target person's perception that a request or proposal is important for the team or organization? Which influence tactic is most likely to result in target commitment? In comparision to first-line supervisor..

  What are advantages and disadvantages of paying tree planter

what are the advantages and disadvantages of paying tree planters on a piece-rate system? on a flat-rate system.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd