Find the optimal solution using solver

Reference no: EM13102260

"A forest fire is burning down a narrow valley 3 miles wide at a speed of 40 feet per minute. The fire can be contained by cutting a fire break through the forest across the valley. It takes 30 seconds for one person to clear one foot of the firebreak. The value of lost timber is $4000 per square mile. Each person hired is paid $12 per hour, and it costs $30 to transport and supply each person with the appropriate equipment. Develop a model to determine:

a. How many people should be sent to contain the fire.

b. The best location for the firebreak.

Implement your model on a spreadsheet and find the optimal solution using Solver."

Reference no: EM13102260

Questions Cloud

Determining expected value of a random variable : Suppose you want to sell your house and you have decided to accept the first offer exceeding M dollars, say. Assume that the offers are i.i.d. with common distribution F. Find the expected number of offers received before selling the house.

Explain types of contributions must get biggest rewards : What types of contributions must get biggest rewards? Will compensation changes Brainard is initiating probable to undermine firms strengths? What does this case say about performance pay?

Calculating probabilities-dallas cowboys : The odds of the Dallas Cowboys winning this year's Super Bowl are 3 to 1. Compute the probability of the Cowboys winning

Determine the tension in the threads : Two identical small insulating balls are suspended by separate 0.22-m threads that are attached to a common point on the ceiling. Each ball has a mass of 8.10 10-4 kg.

Find the optimal solution using solver : Implement your model on a spreadsheet and find the optimal solution using Solver.

Combinations and bernoulli process : An investment counselor would like to meet with 14 of his clients on Wednesday, but he only has time for 10 appointments. How many different combinations of the clients could be considered for inclusion into his limited schedule for that day?

Major flaws of the situation : It was reported that 20 readers responded and 87% said "no" whiles 13% said "yes". Identify four major flaws of the situation. Explain why you chose them.

Explain linguistic political-social-economic-hispanic groups : Write down 1,050- to 1,400-word research paper in which you recognize linguistic, political, social, economic, religious, and familial conventions or statuses of four Hispanic groups living in United States.

Description of statistics-probabilities : Approximately 14 percent of the population of Arizona is 65 years or older. A random sample of five persons from this population is taken. The probability that less than 2 of the 5 are 65 years or older is:

User Account

All Pages