Find the optimal solution using solver

Assignment Help Basic Statistics
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:

Reviews

Write a Review

Basic Statistics Questions & Answers

  Finding mean-variance by creating probability distribution

Use frequency distribution to create a probability distribution, determine the (b) mean,(c) variance and (d) standard deviation of probability distribution and (e) interpret results in context of real life situation.

  Probability of randomly selecting a male

What is the probability of randomly selecting a male from this group?

  Margin of error of the proportion of voters

Based on our poll what is the margin of error of the proportion of voters favoring the incumbent?

  Claiming the population mean of all bear weights

Assuming that the standard deviation is known to be 121.8Ib use 0.05 significance level to test the claim that the population mean of all such bear weights is greater than 150 Ib

  Expected return on a stock purchase

An investor estimates that there is a 1 in 10 chance that a stock purchase will lose 20% of its value, a 2 in 10 chance it will break even, a 4 in 10 chance it will gain 15% and 3 in 10 chance it will gain 30%. What is the expected return.

  Random variable that represents a test score

In a recent year, 11th grade New York public school students taking an English test produced test scores that were normally distributed with a mean of 81 and a standard deviation of 6. Let x be a random variable that represents a test score.

  Average time spent per customer

What is the probability that the average time spent per customer will be at least 3 minutes?

  Correlation analysis of wal-mart-sears

Using Microsoft Excel, create a correlation analysis of Wal-Mart's annual net income over the past 10 years compared with Sears's annual net income over the past 10 years and interpret the results.

  Probability of getting repeat customers

In a market study for Target, a researcher found that 70% of customers are repeat customers. If 14 customers are selected at random, find the probability of getting.

  Random selection from the sophomores

Mr. Connors philosophy class has 99 students, classified by academic year and gender, as illustrated in the table below. Mr. Connor randomly chooses one student to collect yesterday's work. What is the probability that he selects a male, given tha..

  Slope of the regression model

Use the t test to determine whether the slope of the regression model is significant at α = 0.05.

  Difference between correlation and regression

When is it best to use either of them? What types of variables can you apply them to, how many variables can each encompass, and which can be employed for a prediction of a new observation?

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