Develop three separate models in your spreadsheet

Assignment Help Operation Management

Reference no: EM132221109

A manager is trying to determine which of three production processes to implement to produce a component for a new product line. Process A would entail a variable cost of $17 per unit and an annual fixed cost of $150,000. Process B would entail a variable cost of $11 per unit and an annual fixed cost of $250,000. Process C would entail a variable cost of $20 per unit and an annual fixed cost of $180,000.

a. Develop three separate models in your spreadsheet to calculate Total cost for each process.

The models must be flexible and able to calculate Total cost for any Quantity produced.

b. Create a Cost-Volume graph that shows total cost lines for all three options.

(Volume should range from 0 to 30,000)

c. Write an interpretation of your graph

Reference no: EM132221109

Questions Cloud

Desperately needs strategic plan : Management of Johnson & Johnson desperately needs a strategic plan to save its Tylenol[1]business, but first some background.

Different type of physical barriers-external to organization : There are many different types of physical barriers, internal and external to an organization or facility.

Identity authentication and account recovery : In this week's reading, we looked at accounts, identity, authentication, and account recovery.

Advertising campaign praising trump tax policies : You can donate $5 million directly to Trump’s presidential campaign and use $5 million to run an independent advertising campaign praising Trump’s tax policies.

Develop three separate models in your spreadsheet : Develop three separate models in your spreadsheet to calculate Total cost for each process.

How does this help writer build credibility : What are some of the reasons why it is important to cite your sources? How does this help a writer build credibility?

What are strengths that you can attribute to birth order : What are your strengths that you can attribute to your birth order? What are your weaknesses that you can attribute to your birth order?

What wrong with the team : What’s wrong with the team? Nichole Dyer’s words repeated over and over in Henry Rankin’s mind as he boarded the plane from Los Angeles to Chicago.

Examine the topic of mandatory paid parental leave : Examine the topic of mandatory paid parental leave in the USA.

User Account

All Pages