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

  Applying sound ethical principles in marketing situations

Applying sound ethical principles in marketing situations: a.is a losing battle. b.must be a continuous process. c.requires a major competitive fight.

  What will be the average number of jobs in the system

Job E has a processing time of 5 days and is due in 12 days. Using the shortest processing (operating) time priority rule, what will be the average number of jobs in the system?

  This should be an enjoyable activity and help you realize

This should be an enjoyable activity and help you realize the wide number of factors in the retail store that are used to motivate your buying behavior.

  The ordering cost per order and the annual demand

The ordering cost is $30 per order and the annual demand is 7,500 units. The holding cost is 10 percent of the purchase cost.

  Identify some of the key processes that need improvement

Identify some of the key processes that need improvement in your organization associated with the following: sales, marketing, customer service, supply chain management, human resources, manufacturing, etc.

  Cooperation with the organization''s other disciplines

Human resources has been asked to put a plan together in cooperation with the organization's other disciplines (finance or accounting, administration, operations, customer service, marketing, and so on) for a four percent staff reduction.

  Creating linear series of numbers

Create a procedure in VBA to do the following actions: Create a linear series of numbers starting at 1 (e.g. 1, 2, 3, ...) -Display a Message Box asking if you'd like to calculate another number.

  Calculate the cost per hire

Calculate the cost per hire for the following scenario. Show your calculation for partial credit. If you only provide one number, and it is incorrect, I will not know how close you were to getting it right.

  Explain how could the internet be helpful to managers

Should ethical considerations be included in analyses of an organization's internal also external environments. Explain why or explain why not.

  Formal company e-mails to employees

Acting as supervisor for a company of your choice, draft two examples of formal company e-mails to employees.

  Devise the operaional definitions you would need

Devise the operaional definitions you would need.What would you say in your instructions to the observers you plan to use?. How might you sample this shopper traffic?

  Establish five key objectives for wal-mart encompassing

Establish five key objectives for Wal-Mart encompassing operational, financial also human resource aspects of business.

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