### 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

#### 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