Assign CPT and ICD-10-CM codes to this Surgery Musculoskeletal System Service.

LOCATION: Inpatient, Hospital

PATIENT: Debbie Pedersen

PRIMARY CARE PHYSICIAN: Frank Gaul, MD

SURGEON: Mohomad Almaz, MD

DIAGNOSIS: Left type II closed supracondylar humerus fracture, posterior lateral displacement, after fall from playground equipment.

INDICATIONS: Debbie is an 8-year-old girl who fell today from the playground and suffered a type II closed supracondylar humerus fracture with posterior lateral displacement. I have spoken with her parents and reviewed the intended procedure, risks, and potential complications. Her parents have agreed with the treatment plan and wish to proceed.

PROCEDURE PERFORMED: Closed reduction initially, followed by open treatment of supracondylar fracture.

ANESTHESIA: General

PROCEDURE: Debbie was brought to the operating room. She fell from playground equipment today. She was placed under general anesthesia. She was transferred to the operating room table. Prior to prepping and draping her left upper extremity, I was able to again obtain pulses. I did initially bring in the mini C-arm. A closed reduction was performed initially by milking the brachialis primarily laterally. While this was being done, I did apply extension, felt a reduction. I then subsequently flexed the elbow with pressure on the posterior aspect of the distal humerus. After the elbow was flexed, I subsequently externally rotated and pronated the forearm. Overall, I actually had a very reasonable reduction. After this was performed, I felt that I could repeat this, so her left arm was prepped and draped in the usual sterile manner. Starting laterally, a small incision was made over the lateral epicondyle. Blunt dissection was taken down to the bone. One 0.064 mm K-wire was placed through the lateral epicondyle, across the fracture, engaging the medial column and medial cortex. Its position was confirmed on AP and lateral radiographs. A second K-wire was placed just posterior to this, extending proximally into the lateral column. This did also penetrate just to the anterior cortex. Position was confirmed on AP and lateral radiographs and had acceptable position, alignment and reduction. After this was performed, the arm was again fully externally rotated. The medial epicondyle was felt. I did feel the proximal location of the ulnar nerve. An incision was taken through the skin. Blunt dissection was taken through subcutaneous tissue. I actually was able to find the nerve in this, so subsequently retracted posteriorly. Blunt dissection was made directly to the medial epicondyle. Under direct visualization, the K-wire was placed through the medial epicondyle, across the fracture and through the lateral column of the humeral metaphysis. Overall alignment and position were deemed acceptable. No tourniquet was used. With the arm under live fluoroscopy, I did extend the elbow to approximately 90 degrees. Of note, to maintain the reduction, I did hold her arm in full flexion and pronation and subsequently Cobaned her arm in this position. Again, the Coban was released, the arm was taken to 90 degrees, and her fingers were pink, warm, with brisk refill. I utilized a Doppler and was able to get good Doppler radial and ulnar pulses. I was able to palpate a radial pulse. Medially, the wound was irrigated. The skin was closed with nylon sutures. Laterally, I did have to release the pin site and one suture was used to reapproximate the incision. Xeroform was placed. The pins were cut and bent. Soft roll was placed. She was placed in the posterior splint with reinforcement medially. She was awakened, extubated, and taken to recovery uneventfully. Her fingers again, after the splint was placed, were pink and demonstrated brisk capillary refill.

PLAN: We will keep her overnight. I did inject her incision and pin sites both medially and laterally with a total of 12 cc of 0.25% Marcaine without epinephrine. We likely will be able to dismiss her tomorrow to go home. She tolerated the above operative procedure with no known complications.

Additional information:

(a)

Prepare a statement of cash flows using the indirect method for cash flows from operating activities.

Additional information:

(a)

Prepare a statement of cash flows using the indirect method for cash flows from operating activities.

Problem 3: A firm has the following production function: ?(?1, ?2 ) = ?1 + 4?2 A)  Does this firm’s technology exhibit constant, increasing, or decreasing returns to scale? B) Suppose the firm wants to produce exactly ? units and that input 1 costs $?1 per unit and input 2 costs $?2 per unit. What are the firm’s conditional input demand functions? C) Write down the formula for the firm’s total cost function as a function of ?1, ?2, and ?. D) If ?1 = 1, ?2 = 2, what is the cost minimizing choice of ?1 and ?2 for Bob to produce 100 units of output? E) If ?1 = 1, ?2 = 2, what is the minimum cost of producing one unit of output?

Problem 4: A firm has the following production function: ?(?1, ?2 ) = ?1 1/3 ?2 4/3 A) Does this firm’s technology exhibit constant, increasing, or decreasing returns to scale? B) What is the firm’s Technical Rate of Substitution? What is the optimality condition that determines the firm’s optimal level of inputs? C) Is the marginal product of input 1 increasing, constant, or decreasing in ?1. Is the marginal product of input 2 increasing, constant, or decreasing in ?2? D) Suppose the firm wants to produce exactly ? units and that input 1 costs $?1 per unit and input 2 costs $?2 per unit. What are the firm’s conditional input demand functions? (Your solution should be functions of ?1, ?2, and ? for each input). E) Using the information from part D), write down the firm’s total cost function as a function of ?1, ?2, and ?.

Problem 5: A firm has total cost function: ?(?) = 50? 2 + 40? + 30 A) What is the total fixed cost? B) What is the average fixed cost? C) What is the total variable cost? D) What is the average variable cost? E) What is the marginal cost? F) What is the average total cost? For parts G) and H), suppose the firm is in a competitive market. G) what is the lowest price at which the firm will supply a positive quantity in long-run equilibrium? H) What price maximizes the firm’s profit? I) How much would the firm supply at the price in part H) J) At what quantity is the firm’s marginal cost equal to its average cost?

6. List the players that have either won more than 2 matches or lost more than 2 matches. List the player number, name, initials, won, and lost. Insert your snip here.

7. Which players are captains of a team and have ever served as a committee members? Display the player number, player name, initials, team number, and committee member position. This will require 3 tables. Insert your snip here.

8. Using a subquery, have any other players been penalized the same amount as player 8? Let MySQL do the work for you. Do not explicitly query for $25. Display the player number, player name, initials, and amount. Insert your snip here.

9. Who has played more than 2 matches? Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, and the number of matches played as ‘Number of Matches’. Insert your snip here.

10. Sum the number of match wins and losses by player number. Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, wins as ‘Total Wins’, and losses and ‘Total Losses’. Insert your snip here.

***********************************************************************************************************************************************

***********************************************************************************************************************************************

***********************************************************************************************************************************************

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players
(
playerno   int       not null    primary key,
name       varchar(15)   not null,
initials   varchar(3),
birth_date   date,
gender       char(1),
joined       int   not null,
street       varchar(15)   not null,
houseno       varchar(4),
zip       char(6),
town       varchar(10)   not null,
phoneno       char(10),
leagueno   char(4)
);

Insert into players values
(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),
(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),
(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),
(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),
(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),
(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),
(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),
(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),
(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),
(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),
(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),
(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),
(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),
(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members
(
playerno   int   not null,
begin_date   date   not null,
end_date   date,
position   varchar(20),
primary key(playerno, begin_date)
);

Insert into committee_members values
(2,'2010-01-01','2012-12-31','Chairman'),
(2,'2014-01-01',Null,'General Member'),
(6,'2010-01-01','2010-12-31','Secretary'),
(6,'2011-01-01','2012-12-31','General Member'),
(6,'2012-01-01','2013-12-31','Treasurer'),
(6,'2013-01-01',Null,'Chairman'),
(8,'2010-01-01','2010-12-31','Treasurer'),
(8,'2011-01-01','2011-12-31','Secretary'),
(8,'2013-01-01','2013-12-31','General Member'),
(8,'2014-01-01',Null,'General Member'),
(27,'2010-01-01','2010-12-31','General Member'),
(27,'2011-01-01','2011-12-31','Treasurer'),
(27,'2013-01-01','2013-12-31','Treasurer'),
(57,'2012-01-01','2012-12-31','Secretary'),
(94,'2014-01-01',Null,'Treasurer'),
(112,'2012-01-01','2012-12-31','General Member'),
(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches
(
matchno       int   not null   Primary Key,
teamno       int   not null   references teams(teamno),
playerno   int   not null   references players(playerno),
won       int,
lost       int
);

Insert into matches values
(1,1,6,3,1),
(2,1,6,2,3),
(3,1,6,3,0),
(4,1,44,3,2),
(5,1,83,0,3),
(6,1,2,1,3),
(7,1,57,3,0),
(8,1,8,0,3),
(9,2,27,3,2),
(10,2,104,3,2),
(11,2,112,2,3),
(12,2,112,1,3),
(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties
(
paymentno   int   not null   Primary Key,
playerno   int   not null   references players(playerno),
payment_Date   date   not null,
amount   decimal(10,2)   not null
);

Insert into Penalties values
(1,6,'2010-12-08',100.00),
(2,44,'2011-05-05',75.00),
(3,27,'2013-09-10',100.00),
(4,104,'2014-07-08',50.00),
(5,44,'2010-12-08',25.00),
(6,8,'2010-12-08' ,25.00),
(7,44,'2012-12-30',30.00),
(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams
(
teamno   int   Primary Key   Not Null,
playerno   int   Not Null   references players(playerno),
division   varchar(6)
);

Insert into teams values
(1,6,'first'),
(2,27,'second');

/* ********************************************************************************************
End of loading the database
******************************************************************************************** */

1.Which players have lost more matches than the average number of losses?   No duplicates should be listed.   Order by player number.   Insert your screen shot here.

2.How many players from each town served on the committee in any capacity? Display the town as ‘Town’ and the number served as ‘Committee Service’.   Insert your screenshot here.

3.How many members come from each town? Display the town as ‘Town’ and the number of members as ‘Number’. Insert your screenshot here.

4.Who has served on the committee more than once? Display the player number as ‘Number’, concatenate the player initial and name as ‘Name’, town as ‘Town’, and number served as ‘Terms’. Insert your screenshot here.

Below I will include the tennis database

* *******************************************************************

CREATE and OPEN the TENNIS Base

******************************************************************* */

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players

(

playerno              int                         not null                primary key,

name                    varchar(15)         not null,

initials   varchar(3),

birth_date           date,

gender                 char(1),

joined                   int          not null,

street                   varchar(15)         not null,

houseno                             varchar(4),

zip                         char(6),

town                     varchar(10)         not null,

phoneno                             char(10),

leagueno             char(4)

);

Insert into players values

(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),

(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),

(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),

(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),

(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),

(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),

(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),

(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),

(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),

(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),

(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),

(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),

(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),

(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members

(

playerno              int          not null,

begin_date          date       not null,

end_date             date,

position               varchar(20),

primary key(playerno, begin_date)

);

Insert into committee_members values

(2,'2010-01-01','2012-12-31','Chairman'),

(2,'2014-01-01',Null,'General Member'),

(6,'2010-01-01','2010-12-31','Secretary'),

(6,'2011-01-01','2012-12-31','General Member'),

(6,'2012-01-01','2013-12-31','Treasurer'),

(6,'2013-01-01',Null,'Chairman'),

(8,'2010-01-01','2010-12-31','Treasurer'),

(8,'2011-01-01','2011-12-31','Secretary'),

(8,'2013-01-01','2013-12-31','General Member'),

(8,'2014-01-01',Null,'General Member'),

(27,'2010-01-01','2010-12-31','General Member'),

(27,'2011-01-01','2011-12-31','Treasurer'),

(27,'2013-01-01','2013-12-31','Treasurer'),

(57,'2012-01-01','2012-12-31','Secretary'),

(94,'2014-01-01',Null,'Treasurer'),

(112,'2012-01-01','2012-12-31','General Member'),

(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches

(

matchno                             int          not null Primary Key,

teamno                int          not null references teams(teamno),

playerno              int          not null references players(playerno),

won                      int,

lost                       int

);

Insert into matches values

(1,1,6,3,1),

(2,1,6,2,3),

(3,1,6,3,0),

(4,1,44,3,2),

(5,1,83,0,3),

(6,1,2,1,3),

(7,1,57,3,0),

(8,1,8,0,3),

(9,2,27,3,2),

(10,2,104,3,2),

(11,2,112,2,3),

(12,2,112,1,3),

(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties

(

paymentno         int          not null Primary Key,

playerno              int          not null references players(playerno),

payment_Date   date       not null,

amount decimal(10,2)     not null

);

Insert into Penalties values

(1,6,'2010-12-08',100.00),

(2,44,'2011-05-05',75.00),

(3,27,'2013-09-10',100.00),

(4,104,'2014-07-08',50.00),

(5,44,'2010-12-08',25.00),

(6,8,'2010-12-08' ,25.00),

(7,44,'2012-12-30',30.00),

(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams

(

teamno int          Primary Key        Not Null,

playerno              int          Not Null               references players(playerno),

division varchar(6)

);

Insert into teams values

(1,6,'first'),

(2,27,'second');

/* ********************************************************************************************

End of loading the database

******************************************************************************************** */

Q1. Which of the following is directly included in the U.S. GDP for 2020?

i. 2020 Cadillac Escalade produced and sold as a new car in the United States in 2020

ii. tires produced in the United States, purchased by General Motors, and installed on a new Cadillac Escalade sold in 2020

iii. General Motors cars produced in Canada because General Motors is an American corporation.

Q2. As more women decide to work outside the home and therefore hire others to work around their home, GDP will increase by

a. only the value of the output produced by the newly working women.

b. only the value of the household work they are now hiring someone to perform.

c. the value of the output produced by the newly working women plus the value of any household work they are now hiring someone to perform.

d. the value of the output produced by the newly working women minus the value of the household work they were previously performing.

Q3. The base year is 2018. A country only produces Blu-ray players. The price of a Blu-ray player in 2018 was $100. The price of a Blu-ray player was $90 in 2019. The quantity of Blu-ray players produced in 2018 was 10,000 units and in 2019 was 10,500 units. Nominal GDP in 2018 was____, real GDP in 2018 was, nominal GDP in 2019 was _____and real GDP in 2019 equals_____.

Group of answer choices

a. $1,000,000; $1,000,000; $945,000; $1,050,000

b. $1,050,000; $1,000,000; $900,000; $945,000

c. $945,000; $900,000; $1,000,000; $1,050,000

d. $900,000; $945,000; $1,050,000; $1,000,000

Open Air_Traffic data. SETUP: It is believed that in July, as years go by we see higher and higher traffic. Given the data your job is to confirm or disprove this assertion.

4. What test/procedure did you perform? (4 points)

• a. Regression
• b. Two sided t-test
• c. One sided t-test
• d. Confidence Interval

5. What is the statistical interpretation? (4 points)

• a. Average of data is inconsistent with the claim
• b. P-value is too large to have a conclusive answer
• c. P-value is smaller than 5% thus we are confident to say that the slope is not zero.
• d. P-value is smaller than 5% thus we are confident that the averages are different.
• e. None of these

6. What is the conclusion? (4 points)

• a. We cannot claim that in July, as years go by we see higher and higher traffic.
• b. We can claim that in July, as years go by we see higher and higher traffic.
• c. None of these

The following information relates to SFS Co . for the year 2020. SFS, Capital, January 1, 2020……. $ 48,000

Advertising expense.. $ 1,800

SFS, Drawings, during 2020………… 7,000

Rent expense ………12,000

Service revenue …………………………………67,000 ………

Utilities expense……. 3,100

Salaries expense…………………………………. 30,000

Instructions After analyzing the data, prepare an income statement and an owner’s equity statement for the year ending December 31, 2020.

During 2020, Vaughn Manufacturing incurred weighted-average accumulated expenditures of $1730000 during construction of assets that qualified for capitalization of interest. The only debt outstanding during 2020 was a $2000000, 12%, 5-year note payable dated January 1, 2020.

What is the amount of interest that should be capitalized by Vaughn during 2020? Question 10 options: a) $240,000 b) $207,600 c) $0 d) $32,400