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

  Creates non-traditional corporate culture characterized

Free Reach Inc., a company that manufactures exercise equipment, creates a non-traditional corporate culture characterized by "active workstations." it also encourages teams to balance on giant balls during team meeting. It is hurting the productivit..

  The traditional approach to quality management emphasizes

The traditional approach to Quality Management emphasizes defect detection and control.  It has been advanced to its most refined form which we now call Six Sigma.  Explain this tool, its 2 core concepts and the DMAIC process.

  What types of hardware devices

As we are learning, there are a lot of uses for cryptography in information technology, and there are a lot of different algorithms, cryptographic processes, key lengths, implementation methods, and so on. Let's explore the world of cryptographic pro..

  Difference between assertive and aggressive service

Reflect on the difference between assertive and aggressive service. What are differences? Is there a time when one should be used over the other? If so, explain please. Also, if an aggressive service tactic is used and it damages a relationship how m..

  Information technology consulting business

Roberto Frientas and Herman Graham formed an Information Technology (IT) consulting business, which they organized as a limited liability partnership, Accent Pointe LLP. For the most part, each LLP client was assigned either to Frientas or Graham, bu..

  Why might an organizational want to design jobs

Why might an organizational want to design jobs according to the priciples of scientific management?

  The state department of labor investigation found

Martha thought to herself, as she picked up the telephone after she’d been fired that morning and dialed the number of the State Department of Labor. The State Department of Labor investigation found that Chris and Dean had violated several state and..

  How could you have structured the relationship with walker

How could you have structured the relationship with Walker differently in order to avoid a potential lawsuit? Provide a rationale to support your answer. Support your answers with examples and reasoning.

  Explain the primary priority rules for job sequencing

Explain the four primary priority rules for job sequencing. In what instances at the Nissan car manufacturing might each rule be most advantageous? When would each rule be most disadvantageous

  Analyze the impact of increasing l1

To reduce safety stock, should the cross-dock facility be closer to the factory or the retail outlets. For this purpose, analyze the impact of increasing L1 and therefore decreasing L2 on total safety stock.

  Empowerment decreases skill variety

Empowerment does which of the following? Empowerment increases autonomy. Empowerment decreases skill variety. Empowerment increases job rotation. Empowerment increases job specialization.

  What did the individuals you listed do that demonstrated

Provide 2-3 examples of when you witnessed authentic leadership. What did the individuals you listed do that demonstrated authenticity and how does this compare to the findings of this week's journal article?

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