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

How many workers will lackey need to add

If the bakery makes 1,500 loaves per month with a labor productivity of 2.344 loaves per labor hour, how many workers will Lackey need to add ? Hint: Each woker works 160 ho

Schedule jesses staff with the minimum number of barbers

Jesse's Barber Shop at O'Hare Airport is open 7 days a week but has fluctuating demand. Jesse is interested in treating his barbers as well as he can with steady work and pr

Who do you want to be on this task force

As the company's sales are coming down unexpectedly, the president asks you to chair a task force with the objectives of developing solutions to correct the situation. Who d

What is the capacity of the process

What batch size would you choose in order to minimize the inventory without reducing the process capacity? Assuming that all units of a batch have to be processed before the

What is the capacity of the process

What batch size would you choose in order to minimize the inventory without reducing the process capacity? Assuming that all units of a batch have to be processed before the

How many miles of pipeline arctic oil must install

Create a spreadsheet model to determine how many miles of pipeline Arctic Oil must install if it runs separate pipelines from each oil well to the T&R center. How much pipe

What is the process specification

Studies on a bottle filling machine indicates it fill bottles to a mean of 16 ounces with a standard deviation of 0.10 ounces. What is the process specification, assuming th

Which one does a project manager have least control over

Which metric does a project manager have most control over: cost variance, schedule variance, cost performance index, and schedule performance index? Explain how so. Which o

Reviews

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