PROBLEM 2: In municipal water supply systems, engineers must calculate flow rates in interconnected pipes to ensure adequate pressure and delivery. Consider a pipe network with four interconnected pipes with unknown flow rates Q1, Q2, Q3, and Q4. Conservation of mass and conservation of energy principles enforce the water supply system to satisfy the following set of linear equations: Use Excel to write the coefficient matrix and right hand side vector for these set of linear equations. Determine the inverse of the coefficient matrix. Find the solution for the flowrates Q1, Q2, Q3, and Q4 that satisfy the equations using the inverse matrix method. Use Solver to find the solution for the flowrates Q1, Q2, Q3, and Q4 that satisfy the equations. Select the last equation as Objective and the other three equations as constraints. Compare your solution to the one in part C. SAVE YOUR EXCEL FILE AND CONTINUE TO THE NEXT PROBLEM

Boudreaux and Thibodeaux have decided to merge their poboy shop and bakery businesses and opened a restaurant. They sell the following items at the following prices: King Cake Slice: $4.95 Croissant: $3.95 Catfish Po-boy: $14.95 Roast Beef Po-boy: $13.95 Sausage Po-boy: $12.95 Gumbo: $5.95 Crawfish Pie: $3.65 per slice or $22 for a pie (8 slices) They need a point of sale (POS) system that will take in item orders and quantities until the user has completed the order and accumulate the subtotal before calculating the total (including sales tax). However, for crawfish pie the POS system can only process number of slices so the system needs to be able to calculate how many whole pies and slices left over in an order based entirely on the number of slices ordered (e.g. if a user orders 9 slices, they should be charged $22 for a pie and $3.65 for the remaining slice.) The POS system should also use functions You will write a program that does the following (highlighted are the newest requirments as much of this was asked in the Bakery program you coded previously): prints out to the screen the menu items when the program launches after an item is successfully added to the order, the menu should print out to the screen prompts the user for the item the user wishes to order prompts the user for how many of that item the user wishes to order confirms to the user the result of their input (i.e. how many of what item at what base price was ordered)  continues to prompt the user for item choice and quantity until the user types DONE if the user orders crawfish pie, the user can ONLY order by the slice — the program MUST calculate how many whole pies, if any, and remaining slices, if any, the user orders based on number of slices ordered and calculate the subtotal price accordingly calculates the user’s total due based on the subtotal of items they’ve ordered with sales tax prints out to the screen the user’s total due defines at least 2 functions and uses them throughout handles unexpected user input gracefully without terminating program (either using exceptions or handling input) Below is an example output showing the menu, prompt, user input, and output based on that input: Boudreaux & Thibodeaux’s Restaurant————————————1. Croissant: $3.952. King Cake Slice: $4.953. Crawfish Pie (By the Slice): $3.654. Catfish Poboy: $14.955. Roast Beef Poboy: $13.956. Sausage Poboy: $12.957. Gumbo: $5.95————————————-What would you like to order? Type the appropriate number of the menu item: 3Quantity: 10Item added: 2 x Crawfish Slice – $7.30Item added: 1 x Crawfish Pie – $22.00What would you like to order? Type the appropriate number of the menu item or DONE when order is complete:4Quantity: 1Item added: 1 x Catfish Poboy – $14.95 eachWhat would you like to order? Type the appropriate number of the menu item or DONE when order is complete:done————————Your total is $48.43

PROBLEM 1: Transportation engineers analyze population growth trends separately for a city and its adjacent suburb to plan future infrastructure projects, such as roads and public transit. You have been given population data for the city and suburbs from 2000 to 2025 at five-year intervals.   Year City Population (thousands) Suburb Population (thousands) 2000 450 150 2005 490 180 2010 520 220 2015 540 280 2020 560 340 2025 590 420 Create a chart in Excel comparing the population trends of the city and suburb from 2000 to 2025. Include axis labels, a title, and a legend identifying the two data sets. Add a trendline to each set of data, select the equation that in your opinion is the best fit for each set. Use the equations to predict future populations, as an example forecast the population in 2030. If current trends continue, in what year will the suburb’s population surpass the city’s population? SAVE YOUR EXCEL FILE AND CONTINUE TO THE NEXT PROBLEM

BCH4024 070125 OC Su25 E2 Q39: Estrogen binding to the estrogen nuclear hormone receptor stimulates cells to proliferate (grow and divide). Tamoxifen is a drug that was developed to treat breast cancer. It acts by binding the estrogen nuclear hormone receptor as an antagonist. How does tamoxifen alter gene expression in breast cancer cells?

BCH4024 070125 OC Su25 E2 Q15: After an action potential reaches the synaptic terminal of a neuron, what is the immediate consequence in the post-synaptic muscle cell?

BCH4024 070125 OC Su25 E2 Q49: During fasting, which hepatic enzymes are typically phosphorylated? 

BCH4024 070125 OC Su25 E2 Q38: Suppose you discovered a mutant yeast whose glycolytic pathway was shorter because of a new enzyme bypassing the following step: What would be the consequence of bypassing this step? 

BCH4024 070125 OC Su25 E2 Q21: A female patient presents for evaluation with fatigue and mild jaundice. Red blood cells from the patient have very low levels of reduced glutathione. What enzyme deficiency is most likely associated with her condition? 

BCH4024 070125 OC Su25 E2 Q43: Consequences of liver phosphoenolpyruvate carboxykinase deficiency include:

BCH4024 070125 OC Su25 E2 Q2: What structural adjustment in the lipid bilayer improves membrane fluidity at lower temperatures?