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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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