In order to receive credit for this exam, you must agree to abide by the following honor code. While taking this exam, you are allowed to use a non-CAS calculator (graphing or scientific). You are expected to use the techniques you learned in class to solve problems, writing your solutions legibly, and labeling each solution with the problem number. You may use a 3×5 index card for formulas that we have used in this course. It must be handwritten and may not include any worked-out examples. You are NOT allowed: To use videos, books, or other materials from class. To get help from others or give help to others. No collaboration is permitted. to use other websites or phone apps.  I agree to follow the exam policy stated above. All of the work I submit will be my own. (T/F)

If you use TVMSolver to solve these questions, be sure and show your inputs in your written work so you can get full credit. State your answers to the nearest cent. Sara has created a budget for her retirement and would like to have a retirement income of $3500 per month. She is hoping to live for 30 years in retirement. Her 401K earns 7.5% per year compounded monthly. A) How much money will she need to have in her account at retirement? [PV] B) If she is planning on working for 25 years before retiring, how much must she put into her account each month to make sure she reaches her goal? [PMT]

The manager of Bill’s Bicycles has found that he can sell 100 bicycles if he sets the price at $125 and he can sell 200 bicycles if he sets the price at $100. (A) Write the linear demand function for the bicycle shop. q = [demand] (B) Interpret the slope of the demand function:      “For each [inc1] increase in price, the demand (increases/decreases) [delta] by [q] bicycles.” (C) If the supply function is

If you use TVMSolver to solve these questions, be sure and show your inputs in your written work so you can get full credit. State your answers to the nearest cent. You decide to take out a 30-year fixed rate mortgage to buy your new home. You are going to borrow $400,000 at an interest rate of 2.25%. (A) Calculate your monthly payment. $ [pmt] (B) How much total interest will you pay over the life of the loan? $ [int] 

Grab your mirror and reflect your workspace, keyboard, left side, right side, and in front of your keyboard using your mirror.  Spend no more than 30 seconds here but make sure that the reflection is clear and hits the target areas.  Do NOT move anything else other than the mirror Do NOT leave the view of the camera or lean out of view Once done, place the mirror back down, click ‘Mirror reflection is complete’ and go to the NEXT question.  

 employee_id |    date    | job_title_id | salary ————-+————+————–+——–           1 | 2020-01-01 |            1 |  50000           1 | 2020-06-01 |            2 |  45000           2 | 2020-01-01 |            1 |  50000           3 | 2020-01-01 |            1 |  50000           4 | 2020-01-01 |            2 |  45000           5 | 2020-01-01 |            2 |  45000(6 rows) Assume that the two following transactions are happening concurrently on the above table called employee_salary in Postgres. What is the output of “SELECT date FROM employee_salary WHERE employee_id = 2;” in (7), if each statement is performed in the order in the parenthesis?   BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; –(2)SELECT * FROM employee_salary; –(3)UPDATE  employee_salary SET date = ‘2020-03-01’ WHERE employee_id = 2; –(5)SELECT date FROM employee_salary WHERE employee_id = 2; –(7)COMMIT; –(8) BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; ; –(1)UPDATE employee_salary SET date = ‘2020-02-01’ WHERE employee_id = 2; –(4)COMMIT; –(6)

CREATE TABLE employee_salary (     employee_id NUMERIC,    date DATE,    job_title_id NUMERIC,    salary NUMERIC,    PRIMARY KEY (employee_id, date)); employee_id |    date    | job_title_id | salary ————-+————+————–+——–           1 | 2020-01-01 |            1 |  50000           1 | 2020-06-01 |            2 |  45000           2 | 2020-01-01 |            1 |  50000           3 | 2020-01-01 |            1 |  50000           4 | 2020-01-01 |            2 |  45000           5 | 2020-01-01 |            2 |  45000(6 rows) For the above table definition, what is the output of the last query, “SELECT COUNT(*) FROM employee_salary WHERE employee_id = 2; ” in the following transaction? BEGIN;INSERT INTO employee_salary VALUES (2, ‘2020-01-01’, 2,45000);COMMIT;SELECT COUNT(*) FROM employee_salary WHERE employee_id = 2;

 employee_id |    date    | job_title_id | salary ————-+————+————–+——–           1 | 2020-01-01 |            1 |  50000           1 | 2020-06-01 |            2 |  45000           2 | 2020-01-01 |            1 |  50000           3 | 2020-01-01 |            1 |  50000           4 | 2020-01-01 |            2 |  45000           5 | 2020-01-01 |            2 |  45000(6 rows) Assume that the two following transactions are happening concurrently on the above table called employee_salary in Postgres. What is the output of “SELECT date FROM employee_salary WHERE employee_id = 2;” in (7), if each statement is performed in the order in the parenthesis?   BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; –(2)SELECT * FROM employee_salary; –(3)UPDATE  employee_salary SET date = ‘2020-03-01’ WHERE employee_id = 2; –(5)SELECT date FROM employee_salary WHERE employee_id = 2; –(7)COMMIT; –(8) BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; ; –(1)UPDATE employee_salary SET date = ‘2020-02-01’ WHERE employee_id = 2; –(4)COMMIT; –(6)

There are two tellers at a bank. Customers come into the bank randomly starting at 8am. As customers enter, they will wait in a queue if the tellers are busy (following a first-come first-serve discipline). The manager of the bank decides to the operations for 60 minutes one morning (8:00 – 9:00am) and recorded the events that happened during that time period.  Just Finished Event Variables Statistical Accumulators [EntityID,Time,Event] Q(t) B(t) Ʃ TS ∫Q(t) ∫B(t) [-, 0, Init] – – – – – [1, 0, Arr] 0 1 – – – [2, 8, Arr] 0 2 – – 8 [1, 15, Dep] 0 1 15 –  14 [3, 20, Arr] 0 2 – – 5 [4, 30, Arr] 1 2 – – 20 [2, 32, Dep] 0 2 24 2 [a5] [5, 42, Arr] 1 2 – – [a6] [6, 54, Arr] 2 2 – 12 [a7] [3, 55, Dep] 1 2 [a1]   [a3] [a8] [4, 56, Dep] 0 2 [a2]   [a4] [a9] [7, 60, Arr] 1 2 – – 8 [-, 60, End] 0 2 – – [a10]

What is an appropriate expression to use in Simio to model the interarrival time from 2-5pm?