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

Benefits of developing and writing effective business plan

Why do so many small businesses fail before they reach their tenth year? What are the benefits of developing and writing an effective business plan? Describe how local governm

Define the term categorical imperative

Define the term categorical imperative and give at least three examples of categorical imperatives that you believe in. Why is it important for you and others to adhere to tho

Husband promptly closed their joint bank account

Judith and Donald Eckstein were married in 1968. They had two daughters. In 1975, Judith fled their home in their jointly-owned 1973 Volkswagen with only the clothes on her ba

Having studied employee-benefit practices

Having studied employee-benefit practices in this book, do you believe that treatment of executives is fair compared to that of employees of lesser ranks? Explain your answer.

Appropriate reorder point

A newspaper publisher uses roughly 810 feet of baling wire each day to secure bundles of newspapers while they are being distributed to carriers. The paper is published Monday

Make sure the integrated program management report

Which of the following describes the purpose of data validation checks? To make sure the Integrated Program Management Report (IPMR) data do not contain anomalies that would m

Sweatshops in underdeveloped nations

Can an argument be made that even underpaid and exploited workers in so-called sweatshops in underdeveloped nations are better off than if no such sweatshops existed? Please c

Evaluated by the environmental protection agency

You are the administrator of a multispecialty medical group composed o thirty physicians. A hazardous waste disposal site in the community has recently been evaluated by the E


Write a Review

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