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..

User Account

All Pages