2. An airline that operates seven days a week has time table as shown below. Crews must have a minimum layover of 5 hours between flights. Obtain the pairing of flights that minimizes layover time away from home. For any given pairing, the crew will be based at the city that results in smaller layover. Jaipur - Delhi Arrive Depart 8.00 am 8.00 am 9.00 am 8.30 am 2.30 pm 12.00 noon 7.30 pm 5.30 pm For each pair also mention the town where the crew should be based. Flight no 1 2 3 4 Delhi - Jaipur Depart 7.00 am 8.00 am 1.30 pm 6.30 pm Flight no 101 102 103 104 Arrive 9.15 am 9.45 am 1.15 pm 6.45 pm

2. An airline that operates seven days a week has time table as shown below. Crews must have a minimum layover of 5 hours between flights. Obtain the pairing of flights that minimizes layover time away from home. For any given pairing, the crew will be based at the city that results in smaller layover. Jaipur - Delhi Arrive Depart 8.00 am 8.00 am 9.00 am 8.30 am 2.30 pm 12.00 noon 7.30 pm 5.30 pm For each pair also mention the town where the crew should be based. Flight no 1 2 3 4 Delhi - Jaipur Depart 7.00 am 8.00 am 1.30 pm 6.30 pm Flight no 101 102 103 104 Arrive 9.15 am 9.45 am 1.15 pm 6.45 pm

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Formulate excel template for the above problem.
Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is: PRODUCT A B с APRIL 860 660 760 Objective value MAY 660 760 560 JUNE 860 960 760 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in Inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A, $4 for B, and $5 for C. APRIL 1,560 760 Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour. The number of production hours available for regular…
How do non-linear system models differ from linear models, and what are the challenges associated with analyzing and controlling them?
Ali works as an Uber driver in the gig economy spending most of his days driving others around the city. He loves the freedom his gig offers him. This most likely means that Multiple Choice Ali has been offshored. this reflects indefinite employment. this may be his only source of income. he also has to have another, full-time job.
Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 600 550 350 Outside vendor 900 650 450 Combination 700 600 400 a. If the demand probabilities are 0.4, 0.25, and 0.35, which decision alternative will minimize the expected cost of the data processing operation? Own Staff What is the expected annual cost associated with that recommendation? If required, round your answer to the nearest thousand of dollars. Expected annual cost = $ ___________
Your town is considering updating one of the local parks. They created a linear program that had the following constraints: 1. Spend no more than $100,000 2. Spend no more than $50,000 on new playground equipment 3. Put in at least three basketball courts After running the linear program, the town saw that the program was infeasible. The town has decided to make constraints 1 & 2 goals, instead of hard constraints. How many decision variables would need to be added to the town's linear program, in order to turn it into a goal program with two soft constraints that allow deviation in both directions?
Valencia products makes automobile radar detectors and assembles two models. Laser stop and Speedbuster both models use the same electronic components after reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of Speedbuster models produced. Implement the linear optimization model on a spreadsheet and use. Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints and verify the values of the slack variables . Maximize profit = 123 L + 139 S 19 L + 11 S < 4,000 (availability of component A) 6 L + 9 S < 35000 (availability of component B) L > 0 and S > 0 The optimal solution is to produce how many Laser stop models ? And how many Speedbuster models ? The maximum possible profit is ? Component A is or is not a binding…
Asap ppz Three electricity generating firms are competing in the market with the inverse demand given by P[Q) = 21-Q. All firms have constant marginal costs. Firm 1's marginal cost is MC=5; it has a capacity constraint of K1= 5 units. Firm 2's marginal cost is MC 8; it has a capacity constraint of K2 = 3 units. Firm 3's marginal cost is MC = 10; it has a capacity constraint of K3= 3 units.A. The three firms compete in the style of Cournot. Please compute the Nash equilibrium quantities. Also compute the price in the Nash equilibrium.B. Which of these firms would have produced a larger quantity if it had a larger capacity? Please explain.
The DellaVecchia Garden Center purchases and sells Christmas trees during the holiday season. It purchases the trees for $10 each and sells them for $20 each. Any trees not sold by Christmas day are sold for $2 each to a company that makes wood chips. The garden center estimates that four levels of demand are possible: 100, 200, 500, and 1,000 trees.a. Compute the payoffs for purchasing 100, 200, 500, or1,000 trees for each of the four levels of demand.b. Construct a payoff table, indicating the events and alternative courses of action.c. Construct a decision tree.d. Construct an opportunity loss table. Use the Optimistic (maximax) to choose the best choice.e.Use the Pessimistic (maximin) to choose the best choice.f.Use the Criterion of realism (Hurwicz) to choose the best choice. α = 0.6g.Use the Equally likely (Laplace) to choose the best choice.h.Use the Minimax regret to choose the best choice.i.Use the expected monetary value to make a choice. ( Probability for the four level…
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 123 L+ 139 S 18 L 11 S≤ 3000 5 L+9 S≤2500 L≥ 0 and S≥ 0 (Availability of component A) (Availability of component B) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and possible profit, SpeedBuster models. This solution gives the which is $ (Type integers or decimals…
Scenario You are going to plant a rectangular flower bed consisting of tulips in the middle surrounded by daisies on the outside. You have the same amount of each flower and will need an equal area for each. You want the border of daisies to be uniform around the tulips in the middle, as shown in the diagram below:
Read the following passage and answer the question that follows Quincy Snodgrass Enterprises—Forecasting Quincy Snodgrass is an entrepreneur and a lover of the outdoors. He has worked for various companies since he graduated college with his business administration degree in management. Over the years, he has saved every extra penny and now has the starting capital he needs; consequently, he plans to open his own business. Quincy plans to open a landscaping business. The primary services he’ll offer are grass cutting, edging, and bush trimming. Obviously, this will only provide income in the spring, summer, and early fall. Therefore, he plans to offer snow removal in the winter. His goal is to continue to provide those baseline services and expand into actual landscaping work. Quincy’s initial challenge is to develop a forecast of how many customers he’ll have each month. This is essential to determine if he needs to hire any additional labor throughout the season. Unfortunately, none…