I need help with QUESTION 7. How would I make a table and graph for the solutions for problems 3-5 TEAMArkansasLSUFloridaKentuckyTennesseeSouth CarolinaATT.224311296368345323337360VanderbiltAlabamaAuburnGeorgiaTD PASSES1926232723TDS/ATTEMPT11.812.012.913.615.016.221.121.221.431.732.136.2201617257122859Ole Miss2578Mississippi State32693. Mississippi State is last in the conference with a passing touchdown every 36.2attempts. Suppose that Mississippi State goes on a streak so that every passattempt results in a touchdown. How many pass attempts would they needto lower their ratio and overtake Arkansas to be first in the conference in theattempts/TDs ratio?4. Suppose instead that Mississippi State goes on a pace so that for every 3 passattempts they make, they throw for one touchdown. How many attempts wouldMississippi State need in order to overtake Arkansas for the conference lead inattempts/TDs ratio?5. How many pass attempts would Mississippi State need to overtake Arkansasif their pace changed to a touchdown pass for every 5 pass attempts? Every 10pass attempts? Every 25 pass attempts?6. Suppose we state the question in more general terms. Assume Mississippi Statemaintains the pace of a touchdown for every n pass attempts. For what valuesof n will Mississippi State eventually overtake Arkansas?7. Examine your solutions to questions 3-5. Identify your solution strategy foreach question from the list below. Re-answer questions 3-5 using those strate-gies that you have not previously tried.a. Guess-and-check: I basically guessed at a possible answer and then checkedto see if it was correct. If not, I modified my guess and tried again.b. Algebra: I set up an equation with an unknown and used algebra to solvefor the unknown.c. Table: I created a table of values and used the table to identify the solution.d. Graph: I created a graph and used the graph to identify the solution.My answers for questions 3-5. I used guess and check, how would I do the other methods for those?3.They would need 22.4.They would need 78.5.The first part would be 160. The second part would be 1230. The third part would never exist.

Table can also be used to solve the question by tabulating a series of values of Attempts and TD…

Answered: c. Table: I created a table of values…

c. Table: I created a table of values and used the table to identify the solution. d. Graph: I created a graph and used the graph to identify the solution.

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

Requirement: Formulate this problem as a linear programming model and solve it by using the computer.
1. ART Contractors must locate an equipment staging area to serve three construction sites, located at coordinates (2, 2), (1, 4), and (5, 5). Noteshaper Quick Start Question #14) a. If traffic between the staging area and the first two construction sites (2,2) and (1,4) is 50 trips per week and the traffic between the staging area and the construction area at (5,5) is 20 trips per week, what is the best coordinates for theequipment staging area?
(1) Find an optimal assignment of trucks to routes to minimize the total cost (using the Hungarian Method). B C 6 12 15 10 11 7 16 9 Truck / Route 1 2 3 4 Step la: Row subtraction (show your steps, e.g., see cell 1A) Truck / Route B 1 2 3 4 A 10 11 9 14 Step 1b: Column subtraction. Truck / Route 1 2 3 4 A 10-6=4 = = = = = B = с = C Step 2: Testing for optimal solution (show your lines covering the zero entries). What is the minimum number of lines required to cover all zeros? D 8 14 10 13 D = = D =
* (6-7) A construction foreman has three earth moving machine that Machine can be operated by workers Machine 3 A, B, C and D at costs/hours. (in $) as designed in the matrix shown. Find the least cost allocation of workers to machines 1, 2, 3, and 4. 1 2 4 8 4 10 Job 7 11 7 12 10 6. To which machine would you like to assign Job C? 7. Theminimum total cost after assigning jobs to machines is ABCD
Question 3 To keep up with the market demands, Dolphin Technologies allows overtime for each of the two departments. The cost per hour of overtime for the Chip Manufacturing Department is $20, and $12 for Case Fabricating Department. Formulate a linear programming model can be used to determine the optimal production quantities if overtime is made available.
Question 9
L.P. Model: Minimize Subject to: Z = 15X+12Y 7X+11Y288 (C₂) (C₂) 16X+4Y280 X,Y 20 On the graph on right, constraints, C, and C₂ have been drawn. Using the point drawing tool, plot all the corner points for the feasible area. 24- 22- 20- 18- 16- 14- 12- 10 8- 64 4- 2- -N 10 12 14 16 18 20 22 24 X C G
31 please help me please!A company has a factory that is designed so that it is most efficient (average unit cost is minimized) when producing 19,200 units output each month. However, it has an absolute maximum output capability of 23,000 units per month, and can produce as little 7,000 units per month without corporate headquarters shifting production to another plant. If the factory produces 13,280 units ir October, what is the capacity utilization rate in October for this factory? Note: Round your answer to 1 decimal place.
From the Images provided, I need part (e) solved.
If a company wants to have a sports day at the resort where you work, with lunch followed by a dinner and casino night, with whom do they need to coordinate? Question 14 options: a) With the caterer and the sports complex manager. b) With the company contact, resort restaurant, and tennis pro. c) With the sales department, convention services, and banquet manager. d) With caterers, guest services, and the media manager.
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?