What is the best way to set this up in excel

Assignment Help Operation Management
Reference no: EM13251812

What is the best way to set this up in excel- I do not need someone to do all the work, I would just like to know the setup or any certain equations that might be helpful.

-Application of Risk Analysis Problem: Your group is a decision-making team in your firm and is considering a $10 million expansion project. Estimates of key input factors are as following (all uniformly distributed):

-Market size: 100,000 to 350,000 tons

-Selling price: $375 to $575

-Market growth rate: 0 to 6% per year

-Market share: 3% to 17%

-Total investment required: $7 million to $10.5 million

-Useful life of the new facility: 5 to 15 years

-Residual value of the facility: $3.5 million to $5 million

-Operating costs: $320 to $550 per ton

-Fixed costs: $250,000 to $375,000 per year

Reference no: EM13251812

Questions Cloud

Determine the image distance using the mirror equation : An object 6.0mm high is placed 18cm from a convex mirror of radius of curvature 18cm. Determine the image distance using the mirror equation
Explain lowest energy conformation depicting the c3-c4 bond : Draw the lowest energy conformation of 3-ethyl-2,4,4-trimethylheptane, depicting the C3-C4 bond on a sawhorse.
What are the tradeoffs involved in parallel : what are the tradeoffs involved in parallel, perpendicular , and the diagonal flow within parking lots?
Able to negotiate a price : You are able to negotiate a price for a 2014 Ford Fusion Hybrid including tax, title and registration for $20,000. The dealer is willing to lease the car at $220 per month for 60 months ($3,000 due at signing)
What is the best way to set this up in excel : What is the best way to set this up in excel- I do not need someone to do all the work, I would just like to know the setup or any certain equations that might be helpful.
Find the moment of inertia of the plate : Find the moment of inertia of the plate for an axis that lies in the plane of the plate, passes through the center of the plate, and is perpendicular to the axis in part A
Find the matching circuit consist of ideal capacitor : For a complex load of 100 + 25 j ohm. find the matching circuit consist of ideal capacitor and/or inductor to match the load to 50 ohm impedance at 500MHz. The solution should include circuit schematic and values of each component
Describe neutralize a solution : Are necessary to completely neutralize a solution in which 60.0g of NaOH have been dissolved
How many hours would the average laborer work : If productivity can be increased to 0.11 vans per hour, how many hours would the average laborer work that month ?

Reviews

Write a Review

Operation Management Questions & Answers

  Identify individuals within the buying organization

Identify individuals within the buying organization who fulfil the different roles of the buying center. Identify as many for every role as possible, doing research where necessary.

  How it can improve service delivery to its citizens

Select one best practice from an organization or industry which you are familiar with also then whether which best practice can be implemented into the culture of a governmental entity also describe how it can improve service delivery to its citiz..

  Calculate the expected inventory turnover for next year

The owner of Genuine Reproductions (GR), a company that manufactures reproduction furniture, is interested in measuring inventory effectiveness. Last year the cost of goods sold at GR was $4,500,000. The average inventory in dollars was $500,000.

  What is a non-disclosure agreement

How are service levels established? Recommend why a negotiation strategy to achieve the performance level that was an industry standard versus a corporate standard would be in the best interest of both parties.

  Explain how this affect the subsequent bid

Supposed there was a significant delag between the contracts. During this time, personnel and equipment were reassigned to other projects. Explain how this affect the subsequent bid?

  What is the probability that the next failure

The time between failures for an electrical appliance is exponentially distributed with a mean of 25 months. What is the probability that the next failure won't occur before 30 months have elapsed?

  List one external force from each broad category

list one external force from each broad category of external forces. Explain in detail how each of these forces influences this industry, and propose how the business should respond or react to each force.

  Describe at least one strategic response

Identify five key economic variables that could represent major opportunities or threats to a bank in your town or city. Identify which that you believe to be most important, and describe at least one strategic response.

  The reasonable woman standard recognizes that women

The reasonable woman standard recognizes that women have different ideas than men of what constitutes appropriate behavior.

  Use bayes theorem to find the probability

Compare the result in (a) to the probability that a fatality involved a rollover and comment on whether SUVs, Vans, and pickups are generally more prone to rollover accidents that other vehicles.

  In whose favor is the court most likely to rule

Baby-B-Mine argues that the phrase is not generally assiciated with any particular firm, pointing to other companies that use the same phrase on their labels. In whose favor is the court most likely to rule, and why?

  Calculate the overall proportion of tourists

day one 6, day two 4, day three 5, day four 7, day five 8, day six 3, day seven 4, day eight 5, day nine 3, day ten 11.

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