Use excel to do this please show how it looks like and show, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91899896

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 discuss an example of a situation involving conflict

1. Discuss an example of a situation involving conflict between two employees or an employee and management, and discuss the methods used to resolve it, and whether they were successful. 2. Explain how individuals naviga ...

1 who in your organization is a good motivator does

1. Who in your organization is a good motivator? Does motivation have to come from a person, or can an organization in itself be a motivating factor? Explain with reasoning. 2. What is the importance of emotional intelli ...

1 as you wrote your rough draft last week and have been

1. As you wrote your rough draft last week and have been revising it, what difficulties did you have with incorporating sources and their information into your writing? (Give specific examples, actually quoting from your ...

1 describe some examples of leadership team activity that

1. Describe some examples of leadership team activity that you get your class involved with when having a presentation of the book Things Fall apart by China Achebe 2. What are the 4 steps to creating an accurate, predic ...

Process improvement and qualitycase m- the piney woods

Process Improvement and Quality Case M- The Piney Woods Hospital Emergency Department By Julie Anstine and Kyle Dorsey Instructions Before submitting your Assessment, carefully review the rubric. This is the same rubric ...

1 take an existing productbrand and critically evaluate the

1. Take an existing product/brand and critically evaluate the marketing strategy (including the current advertisement) for that product/brand using the tools and concepts learnt in the course. 2. Develop a better marketi ...

Consider the following case you are steve style a

Consider the following case: You are Steve Style, a programming director in a large city’s data-processing department. You manage five sections of computer program- mers, each made up of a senior programmer and three to ...

Discusses five leadership styles laissez-faire leader

Discusses five leadership styles: laissez-faire leader, autocrat, participative leader, transactional leader, and transformational leader, and several key leadership traits. In 375-450 words select a leader of a nation, ...

1 what is the impact of technology on the practices of hr

1. What is the impact of technology on the practices of HR in an organization? 2. Do a McDonald's international Organization Structure layout for global business. 3. How would managers work to improve the employee perfor ...

Timing scheduling1 what does it mean to allocate

Timing + Scheduling 1. What does it mean to allocate advertising dollars throughout the year in relation to sales? What are the advantages and disadvantages of this strategy? 2. How can competitive advertising levels aff ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert