10.The distribution of vehicles sales in the United States in the year 2000 was the following:

Type of car Small Midsize Large Luxury

% 32.8 44.8 9.4 3.0

A simple random sample of 500 vehicles sales was taken this year and the Distribution is as follow:

Type of car Small Midsize Large Luxury

% 133 249 47 71

At the 5% significant level, do the data provides sufficient evidence to conclude that the distribution of vehicle sales this year has changed from the 2000 distribution?

9.   Find the equations for Demand and Supply, and determine the market equilibrium price and quantity. (P is the y variable, and the QS and QD are x variables).

•   Demand equation: P = _______________________

•   Supply equation: P = ________________________

•   Market equilibrium price: ______________

•   Market equilibrium quantity: ___________
P    QS   QD
400   1600   3000
450   1800   2500
500   2000   2000
550   2200   1500
600   2400   1000

•   Find the numerical value of price elasticity of demand where P = 600.

Four unbiased coins, a quarter (25 cent coin), a dime (10 cents coin) and two different nickles (5 cent coins, one minted before year 2000 and other after Year 2000) are tossed simultaneously. If a head shows up on any coin, you are paid the amount on the coin but for tail, you are paid no money for that coin. Find the probability that upon a single simultaneous toss of all four coins, you are paid a total of 35 cents or more

A. Caspian Sea Drinks is considering the purchase of a new water filtration system produced by Rube Goldberg Machines. This new equipment, the RGM-7000, will allow Caspian Sea Drinks to expand production. It will cost $12.00 million fully installed and will be fully depreciated over a 20 year life, then removed for no cost. The RGM-7000 will result in additional revenues of $2.72 million per year and increased operating costs of $644,288.00 per year. Caspian Sea Drinks' marginal tax rate is 32.00%. If Caspian Sea Drinks uses a 9.00% discount rate, then the net present value of the RGM-7000 is _____.

B. Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make and sell more product. The machine cost $1.66 million and create incremental cash flows of $532,580.00 each year for the next five years. The cost of capital is 11.13%. What is the internal rate of return for the J-Mix 2000?

C. Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make and sell more product. The machine cost $1.90 million and create incremental cash flows of $642,799.00 each year for the next five years. The cost of capital is 11.97%. What is the profitability index for the J-Mix 2000?

1.) Company Zeta bought new office furniture in the year 2000. The purchase cost was 62426 dollars and in addition it had to spend 14941 dollars for installation. The furniture has been in use since April 21st, 2000. Zeta forecasted that in 2015 the office furniture would have a net salvage value of $1000. Using the US Accelerated Depreciation Schedule, estimate the value of depreciation recorded in the accounting books in the year 2004 if the company decided to sell the furniture on June 5th (of 2004). (note: round your answer to the nearest cent and do not include spaces, currency signs, or commas)

ANSWER: 3454.44

2.) Company Omega bought new petroleum refining equipment in the year 2000. The purchase cost was 174324 dollars and in addition it had to spend 14582 dollars for installation. The refining equipment has been in use since February 1st, 2000. Omega forecasted that in 2030 the equipment would have a net salvage value of $10,000. Using the US Straight Line Depreciation Schedule, estimate the value of depreciation recorded in the accounting books in the year 2004 if the company decided to sell the equipment on August 5th (of 2004). (note: round your answer to the nearest cent and do not include spaces, currency signs, or commas)

ANSWER: 9445.3

1. Consider each of the following scenarios for profit maximizing firms operating in perfectly competitive markets. For each firm, state whether the firm should produce nothing, or increase, decrease, or maintain its output level.
   1. XYZ Corp. has output of 2000 units, market price = $64, average total cost = $62, average variable cost = $48, and marginal cost = $67.
   2. XYZ Corp. has output of 2000 units, market price = $64, average total cost = $70, average variable cost = $66, and marginal cost = $64.
   3. XYZ Corp. has output of 2000 units, market price = $64, average total cost = $64, average variable cost = $62, and marginal cost = $64.
   4. XYZ Corp. has output of 2000 units, market price = $64, average total cost = $62, average variable cost = $48, and marginal cost = $67.
   5. UVW Corp. has output of 6000 units, market price = $10, total costs = $72 000, total variable costs = $66 000, and marginal cost = $9.
   6. UVW Corp. has output of 10 000 units, market price = $4, total costs = $50 000, total variable costs = $30 000, and marginal cost = $4.

Cowboys Copies, Inc., wants to upgrade its copy machines. Its last update was 2 years ago, when it spent $1,150 on equipment with an assumed life of 5 years and. The firm uses MACRS depreciation. The old equipment can be sold today for $800. A new system can be installed today for $1,500. This will have a 3 year life and will be depreciated under MACRS 3 year schedule. At the end of 3 years, the new equipment will be worthless (therefore, market value of zero).
The company projects unit sales associated with the new equipment as follows:

Investment in net working capital will be 20 percent of the sales for the following year.
Therefore, total net working capital for year 0 would be 20 percent of the sales in year 1 and for year 1, you will need total net working capital amounting to 20 percent of the sales for year 2 in dollar values (not in units). The production costs are $15 per unit, and the units are priced at $40 each. The firm is in the 40 percent marginal tax bracket and required rate of return is 12%.

MACRS Schedule

a. What are the operating cash flows for Years 1 to 3?

b. what are the cash flows from net working capital for years 1 to 3?

c. what is the cash flow from the sales of the od equipment at year 3?

d. what is the NPV of this project? would you accept this project?

e. what is the IRR of this project? would you accept this project?

update I have finished 1-5 6-9 are stumping me

"Durham Police is to become the first force in the country (UK) to introduce a scheme in which users are treated with diamorphine - medical grade heroin.
Ron Hogg, County Durham's Police, Crime and Victims' Commissioner, says such treatment lowers offending levels.
Opponents claim trials have not shown significant benefits.
Mr Hogg told BBC Newcastle existing national policies had not been effective and pointed to six-year trials in Darlington, London and Brighton which he said had helped wean users off the drug.
Addicts were given the opiate in consumption rooms, often referred to as "shooting galleries", supervised by medical professionals.
"It got them back into a normal life and it cut crime," he said.
"We saw health benefits for the individuals, we saw needles being taken off the street, so there's an awful lot of evidence both in the UK and across the world that such schemes do actually work.
"All police and crime commissioners spend a lot of money on what we call diversionary work - community projects and youth offending schemes - because we know this will stop people committing crime.
"This is just an extension of that rationale. The controversiality is because it's drugs."
'Not unusual'
Mr Hogg said the UK had the highest rate of heroin, cocaine and ecstasy use across the European Union with drug-induced deaths totalling 45 people per million compared with 17 per million in the EU.
Aiming to introduce the scheme "by the end of this year", he added the force's public health partners were working out the cost of administering the drug to users twice-daily.
He previously mooted such a move in 2013.

"If we go back to the 1960s, doctors used to prescribe heroin as a means of treating someone back to recovery. It's not that unusual," he said.
"We've got to consider the Misuse of Drugs Act has been in since 1971 and we haven't arrested the way out of the problem, have we?"
A Home Office spokesman said there was evidence "supervised use of [diamorphine] in a medical environment as part of a treatment plan can help keep patients in treatment and out of criminal behaviour".
However, David Raynes of the National Drug Prevention Alliance, warned the move "will not stop addicts being addicts".
"It doesn't stop people using street drugs," he said.
"It may reduce crime marginally, but it doesn't reduce crime permanently."

Working together as a group, design a study to address whether this method is effective or not in reducing crime due to heroin addiction. Ron Hogg of County Durham's Police believes it works while David Raynes of the National Drug Prevention Alliance is skeptical. Your job is to help settle the argument using a statistical study. You will need to address the following in your write up:

1 What is the population of interest?

2 What are the null and alternate hypotheses of your study?

3 What data type will you be collecting in this study (numerical or categorical)?

4 How would you collect the data needed to decide which hypothesis to support?

5 How would you make sure the data collected is representative of the population of interest and not biased?

6 Specifically, what tools would you use to analyze the data? You need to give the names of any plots/graphs that would be useful and the type of hypothesis test that would be used to settle the argument between Mr. Hogg and Mr. Raynes.

7 Based on what hypothesis test you selected in part 6, what assumptions need to be check prior to using said test?

8 Let's assume your study resulted in the data being statistically significant. Which hypotheses would have been supported? Give a possible p-value for this result. If an error had occurred, which type (Type I or Type II) could it have been?

9 Let's assume your study resulted in the data NOT being statistically significant. Which hypotheses would have been supported? Give a possible p -value for this result. If an error had occurred, which type (Type I or Type II) could it have been?

1. Update status for employee '100' to 'Temporary'.

2. Add a new attribute (field) status varchar(6) to the EMP table.

3. Using EXCEPT show the codes of the vendors who did not supply any products.

The SQL Code:

-- Creating Tables
.headers on
.mode column
.separator ,

DROP TABLE IF EXISTS vendor;
CREATE TABLE VENDOR (
V_CODE int,
V_NAME varchar(15),
V_CONTACT varchar(50),
V_AREACODE varchar(3),
V_PHONE varchar(8),
V_STATE varchar(2),
V_ORDER varchar(1)
);
INSERT INTO VENDOR VALUES('21225','Bryson, Inc.','Smithson','615','223-3234','TN','Y');
INSERT INTO VENDOR VALUES('21226','SuperLoo, Inc.','Flushing','904','215-8995','FL','N');
INSERT INTO VENDOR VALUES('21231','D&E Supply','Singh','615','228-3245','TN','Y');
INSERT INTO VENDOR VALUES('21344','Gomez Bros.','Ortega','615','889-2546','KY','N');
INSERT INTO VENDOR VALUES('22567','Dome Supply','Smith','901','678-1419','GA','N');
INSERT INTO VENDOR VALUES('23119','Randsets Ltd.','Anderson','901','678-3998','GA','Y');
INSERT INTO VENDOR VALUES('24004','Brackman Bros.','Browning','615','228-1410','TN','N');
INSERT INTO VENDOR VALUES('24288','ORDVA, Inc.','Hakford','615','898-1234','TN','Y');
INSERT INTO VENDOR VALUES('25443','B&K, Inc.','Smith','904','227-0093',null ,'N');
INSERT INTO VENDOR VALUES('25501','Damal Supplies','Smythe','615','890-3529','TN','N');
INSERT INTO VENDOR VALUES('25595','Rubicon Systems','Orton','904','456-0092','FL','Y');


DROP TABLE IF EXISTS product;
CREATE TABLE PRODUCT (
P_CODE varchar(10),
P_DESCRIPT varchar(35),
P_INDATE datetime,
P_QOH int,
P_MIN int,
P_PRICE float(8),
P_DISCOUNT float(8),
V_CODE int
);
INSERT INTO PRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle','11/3/2007','8','5','109.98999786377','0','25595');
INSERT INTO PRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade','12/13/2007','32','15','14.9899997711182','0.05','21344');
INSERT INTO PRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade','11/13/2007','18','12','17.4899997711182','0','21344');
INSERT INTO PRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50','1/15/2008','15','8','39.9500007629395','0','23119');
INSERT INTO PRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50','1/15/2008','23','5','43.9900016784668','0','23119');
INSERT INTO PRODUCT VALUES('2232/QTY','B&D jigsaw, 12-in. blade','12/30/2007','8','5','109.919998168945','0.05','24288');
INSERT INTO PRODUCT VALUES('2232/QWE','B&D jigsaw, 8-in. blade','12/24/2007','6','5','99.870002746582','0.05','24288');
INSERT INTO PRODUCT VALUES('2238/QPD','B&D cordless drill, 1/2-in.','1/20/2008','12','5','38.9500007629395','0.05','25595');
INSERT INTO PRODUCT VALUES('23109-HB','Claw hammer','1/20/2008','23','10','9.94999980926514','0.1','21225');
INSERT INTO PRODUCT VALUES('23114-AA','Sledge hammer, 12 lb.','1/2/2008','8','5','14.3999996185303','0.05','');
INSERT INTO PRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine','12/15/2007','43','20','4.98999977111816','0','21344');
INSERT INTO PRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.','2/7/2008','11','5','256.989990234375','0.05','24288');
INSERT INTO PRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft','2/20/2008','188','75','5.86999988555908','0','');
INSERT INTO PRODUCT VALUES('SM-18277','1.25-in. metal screw, 25','3/1/2008','172','75','6.98999977111816','0','21225');
INSERT INTO PRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50','2/24/2008','237','100','8.44999980926514','0','21231');
INSERT INTO PRODUCT VALUES('WR3/TT3','Steel matting, 4''x8''x1/6", .5" mesh','1/17/2008','18','5','119.949996948242','0.1','25595');

DROP TABLE IF EXISTS CUSTOMER;
CREATE TABLE CUSTOMER (
CUS_CODE int,
CUS_LNAME varchar(15),
CUS_FNAME varchar(15),
CUS_INITIAL varchar(1),
CUS_AREACODE varchar(3),
CUS_PHONE varchar(8),
CUS_BALANCE float(8)
);
INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0');
INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','0');
INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','345.859985351562');
INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','536.75');
INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','0');
INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','0');
INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','221.190002441406');
INSERT INTO CUSTOMER VALUES('10017','Williams','George','','615','290-2556','768.929992675781');
INSERT INTO CUSTOMER VALUES('10018','Farriss','Anne','G','713','382-7185','216.550003051758');
INSERT INTO CUSTOMER VALUES('10019','Smith','Olette','K','615','297-3809','0');

DROP TABLE IF EXISTS invoice;
CREATE TABLE INVOICE (
INV_NUMBER int,
CUS_CODE int,
INV_DATE datetime,
INV_SUBTOTAL float(8),
INV_TAX float(8),
INV_TOTAL float(8)
);
INSERT INTO INVOICE VALUES('1001','10014','1/16/2008','24.8999996185303','1.99000000953674','26.8899993896484');
INSERT INTO INVOICE VALUES('1002','10011','1/16/2008','9.97999954223633','0.800000011920929','10.7799997329712');
INSERT INTO INVOICE VALUES('1003','10012','1/16/2008','153.850006103516','12.3100004196167','166.160003662109');
INSERT INTO INVOICE VALUES('1004','10011','1/17/2008','34.9700012207031','2.79999995231628','37.7700004577637');
INSERT INTO INVOICE VALUES('1005','10018','1/17/2008','70.4400024414062','5.6399998664856','76.0800018310547');
INSERT INTO INVOICE VALUES('1006','10014','1/17/2008','397.829986572266','31.8299999237061','429.660003662109');
INSERT INTO INVOICE VALUES('1007','10015','1/17/2008','34.9700012207031','2.79999995231628','37.7700004577637');
INSERT INTO INVOICE VALUES('1008','10011','1/17/2008','399.149993896484','31.9300003051758','431.079986572266');
INSERT INTO INVOICE VALUES('1009','10011','1/17/2008','399.149993896484','31.9300003051758','432.079986572266');


DROP TABLE IF EXISTS line;
CREATE TABLE LINE (
INV_NUMBER int,
LINE_NUMBER int,
P_CODE varchar(10),
LINE_UNITS float(8),
LINE_PRICE float(8),
LINE_TOTAL float(8)
);
INSERT INTO LINE VALUES('1001','1','13-Q2/P2','1','14.9899997711182','14.9899997711182');
INSERT INTO LINE VALUES('1001','2','23109-HB','1','9.94999980926514','9.94999980926514');
INSERT INTO LINE VALUES('1002','1','54778-2T','2','4.98999977111816','9.97999954223633');
INSERT INTO LINE VALUES('1003','1','2238/QPD','1','38.9500007629395','38.9500007629395');
INSERT INTO LINE VALUES('1003','2','1546-QQ2','1','39.9500007629395','39.9500007629395');
INSERT INTO LINE VALUES('1003','3','13-Q2/P2','5','14.9899997711182','74.9499969482422');
INSERT INTO LINE VALUES('1004','1','54778-2T','3','4.98999977111816','14.9700002670288');
INSERT INTO LINE VALUES('1004','2','23109-HB','2','9.94999980926514','19.8999996185303');
INSERT INTO LINE VALUES('1005','1','PVC23DRT','12','5.86999988555908','70.4400024414062');
INSERT INTO LINE VALUES('1006','1','SM-18277','3','6.98999977111816','20.9699993133545');
INSERT INTO LINE VALUES('1006','2','2232/QTY','1','109.919998168945','109.919998168945');
INSERT INTO LINE VALUES('1006','3','23109-HB','1','9.94999980926514','9.94999980926514');
INSERT INTO LINE VALUES('1006','4','89-WRE-Q','1','256.989990234375','256.989990234375');
INSERT INTO LINE VALUES('1007','1','13-Q2/P2','2','14.9899997711182','29.9799995422363');
INSERT INTO LINE VALUES('1007','2','54778-2T','1','4.98999977111816','4.98999977111816');
INSERT INTO LINE VALUES('1008','1','PVC23DRT','5','5.86999988555908','29.3500003814697');
INSERT INTO LINE VALUES('1008','2','WR3/TT3','3','119.949996948242','359.850006103516');
INSERT INTO LINE VALUES('1008','3','23109-HB','1','9.94999980926514','9.94999980926514');

DROP TABLE IF EXISTS EMP;
CREATE TABLE EMP (
EMP_NUM int,
EMP_TITLE varchar(4),
EMP_LNAME varchar(15),
EMP_FNAME varchar(15),
EMP_INITIAL varchar(1),
EMP_DOB datetime,
EMP_HIRE_DATE datetime,
EMP_AREACODE varchar(3),
EMP_PHONE varchar(8),
EMP_MGR int
);
INSERT INTO EMP VALUES('100','Mr.','Kolmycz','George','D','6/15/1942','3/15/1985','615','324-5456','');
INSERT INTO EMP VALUES('101','Ms.','Lewis','Rhonda','G','3/19/1965','4/25/1986','615','324-4472','100');
INSERT INTO EMP VALUES('102','Mr.','VanDam','Rhett','','11/14/1958','12/20/1990','901','675-8993','100');
INSERT INTO EMP VALUES('103','Ms.','Jones','Anne','M','10/16/1974','8/28/1994','615','898-3456','100');
INSERT INTO EMP VALUES('104','Mr.','Lange','John','P','11/8/1971','10/20/1994','901','504-4430','105');
INSERT INTO EMP VALUES('105','Mr.','Williams','Robert','D','3/14/1975','11/8/1998','615','890-3220','');
INSERT INTO EMP VALUES('106','Mrs.','Smith','Jeanine','K','2/12/1968','1/5/1989','615','324-7883','105');
INSERT INTO EMP VALUES('107','Mr.','Diante','Jorge','D','8/21/1974','7/2/1994','615','890-4567','105');
INSERT INTO EMP VALUES('108','Mr.','Wiesenbach','Paul','R','2/14/1966','11/18/1992','615','897-4358','');
INSERT INTO EMP VALUES('109','Mr.','Smith','George','K','6/18/1961','4/14/1989','901','504-3339','108');
INSERT INTO EMP VALUES('110','Mrs.','Genkazi','Leighla','W','5/19/1970','12/1/1990','901','569-0093','108');
INSERT INTO EMP VALUES('111','Mr.','Washington','Rupert','E','1/3/1966','6/21/1993','615','890-4925','105');
INSERT INTO EMP VALUES('112','Mr.','Johnson','Edward','E','5/14/1961','12/1/1983','615','898-4387','100');
INSERT INTO EMP VALUES('113','Ms.','Smythe','Melanie','P','9/15/1970','5/11/1999','615','324-9006','105');
INSERT INTO EMP VALUES('114','Ms.','Brandon','Marie','G','11/2/1956','11/15/1979','901','882-0845','108');
INSERT INTO EMP VALUES('115','Mrs.','Saranda','Hermine','R','7/25/1972','4/23/1993','615','324-5505','105');
INSERT INTO EMP VALUES('116','Mr.','Smith','George','A','11/8/1965','12/10/1988','615','890-2984','108');


select * from VENDOR;
select * from Product;
select * from customer;
select * from invoice;
select * from line;
select * from EMP;