4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor: a. The IF function should determine if the value in the Age column is greater than or equal to 21 AND the value in the student's Post-Secondary Years column is greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. b. Fill the formula into the range 13:131. if necessary. Create a formula using a function. In the Student Representatives worksheet, the formula in cell L2 should use a structured reference to the Post-Secondary Years value in the logical2 argument of the AND function. × Copy a formula into a range. In the Student Representatives worksheet, cell L2 contains an incorrect formula.

4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor: a. The IF function should determine if the value in the Age column is greater than or equal to 21 AND the value in the student's Post-Secondary Years column is greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. b. Fill the formula into the range 13:131. if necessary. Create a formula using a function. In the Student Representatives worksheet, the formula in cell L2 should use a structured reference to the Post-Secondary Years value in the logical2 argument of the AND function. × Copy a formula into a range. In the Student Representatives worksheet, cell L2 contains an incorrect formula.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 34P

See similar textbooks

Similar questions

Long-Life Insurance has developed a linear model that it uses to determine the amount of term life insurance a family of four should have, based on the current age of the head of the household. The equation is:y = 850 − .1xwherey = Insurance needed ($000)x = Current age of head of household a. Plot the relationship on a graph. b. Use the equation to determine the amount of term life insurance to recommend for a family of four if the head of the household is 30 years old.
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $12 $13 2 $9 $10 $9 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 500 900 700 If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many units of each…
Pls help ASAP for both
Using the grid technique to determine the least-cost location (warehouse) for this problem: Tons Rate X - Coordinates Y – Coordinates S1 200 0.5 2 14 S2 300 0.6 6 10 M1 100 1 2 2 M2 100 2 10 14 M3 100 1 14 18 M4 100 2 14 6 The Grid center coordination is ____ and _____ (round the results to 1 decimal place) Group of answer choices (9.9; 7.8) (5.5; 6.9) (8.7; 10.5) (10.5; 6.4) (9.9; 8.9)
A4 Answer b&c
The director of cooperative education at a state college wants to examine the effect of cooperative education job experience on marketability in the work place. She takes a random sample of 4 students. For these 4, she finds out how many times each had a cooperative education job and how many job offers they received upon graduation. These data are presented in the table below. Student CoopJobs JobOffer 1 1 4 2 2 6 3 1 3 4 0 1
1. Problem 13-14 (Algorithmic)The following profit payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature:State of NatureDecision Alternative S1 S2 S3d1 200 150 75d2 250 150 50The probabilities for the states of nature are P(s1) = 0.5, P(s2) = 0.3 and P(s3) = 0.2.a. What is the optimal decision strategy if perfect information was available? S1 : d2 S2 : d1 or d2 S3 : d1 b. c. What is the expected value for the decision strategy developed in part (a)? If required, round your answer to one decimal place. d. Using the expected value approach, what is the recommended decision without perfect information? d2 What is its expected value? If required, round your answer to one decimal place. e. What is the expected value of perfect information? If required, round your answer to one decimal place.
(a) Mohawk Valley Furniture Warehouse has purchased a retail outlet with six departments (A, B, C, D, E, and F), as shown below. The anticipated number of customers that move between the departments each week is given as follows: 70 and 50 customers move from department A to department B and F respectively; 100 customersmove from department B to department E; 70 customers move from department C to department B; 80 customers move from department D to department C; 40 and 30 customers move from department E to departments A and F respectively; and 60 and 100 customers move from department F to departments B and E respectively. The initial layout is given in the matrix below. (i) Construct the load summary chart for Mohawk's layout.) (ii) Evaluate the current layout in terms of non-adjacent loads.
Please solve
Amy plans to start at least two different business activities after she graduates from college: − One business involves using various forms of social media to promote her skills and experience as a volleyball player to help younger players develop their skills She plans to generate income from advertising on her social media sites − She will also use her artistic and marketing talents to find work using several web platforms, like Upwork and Freelancer Although still in college, she has signed a “name, image, and likeness (N I L)” contract with several volleyball-related businesses. Amy also plays for U.S.A. Volleyball and was a member of the 2021 U.S.A. Olympic team Based on what she has read on websites and heard from friends, Amy is wondering if she should form a corporation or a limited liability company for these pursuits, or just be a sole proprietor. Also she is also curious whether, for tax and legal purposes, she has one business or two? Question: After reading this…
10 Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fokh each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: ! 1 F1 A 1 option Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and the robbery rate is (round your responses to three decimal places): ŷ=0+0x N @ 2 W S X command A where y Number of Patients and x = Robbery Rate. In year 11, if the robbery rate increases to 133.40, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). In year 11, if the robbery rate decreases to 90.6, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). #3 80 F3 E D $ 4 C 888…
Calculating outcomes as equally likely would BEST describe: O a. Maximax criterion O b. Laplace criterion O c. Regret criterion Od. Maximin criterion Determining the average payoff for each alternative and choosing the one with the BEST payoff is the approach called: ea, maximax O b. minimax regret O c. laplace Od maximin 2