If neither "Gaia Theory" nor "Earth System Theory" is a good name for communicating with the non-scientific community, then what IS a good name/ theory we can use?

Using the HotelDB tables, provide the following result as a screen image.

WRITE SQL to retrieve rows from any hotel with Family room types and price less than $150.

use hoteldb;
CREATE TABLE HOTEL
( hotelNo numeric primary key
, name varchar(40)
, address varchar(40)
, city varchar(200)
);
CREATE TABLE ROOM
( roomNo numeric Primary Key
, hotelNo numeric References HOTEL
, type varchar(20)
, price dec(9,2)
);

CREATE TABLE GUEST
( guestNo numeric primary key
, name varchar(40)
, address varchar(40)
);

CREATE TABLE BOOKING
( hotelNo numeric REFERENCES Hotel
, guestNo numeric REFERENCES Guest
, dateFrom date NOT NULL
, dateTo date
, roomNo numeric REFERENCES ROOM
);

INSERT INTO HOTEL VALUES (1,'Hilton Hotel','123 Main st','New Jersey');
INSERT INTO HOTEL VALUES (2,'Holiday Inn','50 3rd Ave.', 'New York');
INSERT INTO HOTEL VALUES (3,'Governor Hotel','8243 Berkley Sq.','London');
INSERT INTO HOTEL VALUES (4,'New World Hotel','30 East River Rd', 'Hong Kong');
INSERT INTO HOTEL VALUES (5,'Santos Hotel','15 Main Rd', 'Philippines');

insert into room values (1,1,'Family',200);
insert into room values (2,1,'Family',200);
insert into room values (3,1,'Single',100);
insert into room values (4,1,'Single',100);
insert into room values (5,2,'Family',80);
insert into room values (6,2,'Family',85);
insert into room values (7,2,'Family',80);
insert into room values (8,3,'Single',35);
insert into room values (9,3,'Double',115);
insert into room values (10,3,'Double',115);
insert into room values (11,3,'Family',150);
insert into room values (12,4,'Single',30);
insert into room values (13,4,'Single',30);
insert into room values (14,4,'Single',30);
insert into room values (15,4,'Double',90);
insert into room values (16,4,'Double',90);
insert into room values (17,4,'Double',90);
insert into room values (18,4,'Family',110);
insert into room values (19,4,'Family',110);
insert into room values (20,5,'Double',38);
insert into room values (21,5,'Double',38);
insert into room values (22,5,'Single',32);
insert into room values (23,5,'Single',32);

insert into guest values (1,'John Doe','Los Angeles');
insert into guest values (2,'Mary Jane','New York');
insert into guest values (3,'Hank Kim','London');
insert into guest values (4,'Bob Jones','London');
insert into guest values (5,'Paul John','New York');
insert into guest values (6,'Ann Smith','New York');
insert into guest values (7,'James Mann','London');
insert into guest values (8,'Mary Mann','London');
insert into guest values (9,'Jim Jones','New York');
insert into guest values (10,'Tom Jones','Los Angeles');
insert into guest values (11,'Jimmy Johnson','Boston');
insert into guest values (12,'Harry Coleman','Dallas');
insert into guest values (13,'Bob James','Los Angeles');
insert into guest values (18,'John Mary','London');
insert into guest values (21,'Jeff Bridges','London');
insert into guest values (23,'Larry Cohen','New York');

A business analyst believes that December holiday sales in 2016 are a good predictor of December holiday sales in 2017. A random sample of 8 toys stores produced the following data where x is the amount of December holiday sales in 2016 and y is the amount of December sales in 2017, in dollars.

Show work method/steps, Computations, Calculations, Explain, list any applicable source/web applets, etc...

(a)   Find an equation of the least squares regression line. Round the slope and y-intercept value to two decimal places. Describe method for obtaining results.
(b)   Based on the equation from part (a), what is the predicted 2017 December holiday sales if the 2016 December holiday sales is 6,000 dollars? Show all work and justify your answer.
(c)   Based on the equation from part (a), what is the predicted 2017 December holiday sales if the 2016 December holiday sales is 20,000 dollars? Show all work and justify your answer.
(d)   Which predicted 2017 holiday sales that you calculated for (b) and (c) do you think is closer to the true predicted 2017 holiday sales and why?

Financial Reporting (Answer is require on immegiate basis)

Q.No.5: The financial statements of AGS Batteries Ltd. are showing 250,000 outstanding ordinary shares of Rs. 10 each as at June 30, 2016. The company issued following convertible preference shares on July 1, 2015:                                                                          (Marks 10)

• 12%, 25,000 preference shares of Rs. 100 each convertible in three years' time, with following conversion rights:
  • 3 ordinary shares for each convertible preference share by June 30, 2016
  • 2 ordinary shares for each convertible preference share by June 30, 2017
  • 1 ordinary share for each convertible preference share by June 30, 2018

• 8%, 200,000 preference shares of Rs. 50 each convertible in one year's time at the rate of 2 ordinary shares for each convertible preference share.

During the year, the company also issued options to offer 50,000 shares for Rs. 15 each. The average fair value of the share is Rs. 20 per share. Profit attributable to ordinary shareholders is Rs. 625,000 for the year ended June 30, 2016. The rate of income tax is 33%.

Required:

1. Calculate basic and diluted earnings per share (EPS) for the year ended June 30, 2016.
2. Which of the above preference shares are dilutive?

Results of Discontinued Operations

During December 2016, Smythe Company decides to sell Division F (a component of the company). On December 31, 2016, the company classifies Division F as held for sale. On that date, the book values of Division F's assets and liabilities are $950,000 and $600,000, respectively. Smythe expects to sell Division F in 2017 and estimates that the fair value of Division F is $250,000. During 2016, Division F earned revenues of $1,000,000 and incurred expenses of $1,300,000. Smythe is subject to a 30% income tax rate.

Required:

1. Compute the following for Division F of Smythe Company:

2. Prepare the results from discontinued operations section of Smythe income statement for 2016.

After the 2016 presidential election, Gallup collected a random sample of 1,021 Americans and estimated that 47% of Americans wanted to keep the electoral college. One month before the election, in October 2016, another random poll of 1,100 Americans estimated that 52% wanted to keep the Electoral College. Statistically speaking, we can look at whether or not we can be sure that there was a change in opinions about keeping the Electoral College between October of 2016 and November of 2016.

(a) What is the point estimate for the November poll?

(b) What is the point estimate for the October poll?

(c) Are these point estimates statistics or parameters? Explain why or why not.

(d) Report and interpret the difference between the two point estimates.

(e) Compute the estimated standard error for the difference between two estimates. Show your work.

(f) Construct and interpret the difference between these groups at the 95% level. Show your work. 1 Now we can also perform a significance test.

(g) State the null hypothesis.

(h) State an alternative hypothesis.

(i) The test statistic z=-2.3012 and its associated p-value is approximately 0.021 for a two-tailed test at the 5% significance level. Interpret this result in regards to the hypotheses you stated above.

22) Use the information about Billy's Burgers to answer the following question(s):

                                   Billy's Burgers

a) Using the percent of sales method, and assuming 20% growth in sales, estimate Billy's Burgers' depreciation for 2016.

b) Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' pretax income for 2016.

c) Using the percent of sales method, and assuming 20% growth in sales and no change in interest expense, estimate Billy's Burgers' net income for 2016.

d) Using the percent of sales method, and assuming 20% growth in sales, estimate Billy's Burgers' accounts receivable for 2016.

Computing and Assessing Plant Asset Impairment

Zeibart Company purchases equipment for $225,000 on July 1, 2012, with an estimated useful life of 10 years and expected salvage value of $25,000. Straight-line depreciation is used. On July 1, 2016, economic factors cause the market value of the equipment to decline to $90,000. On this date, Zeibart examines the equipment for impairment and estimates $125,000 in future cash inflows related to use of this equipment.

a. Is the equipment impaired at July 1, 2016?
AnswerYesNo

b. If the equipment is impaired on July 1, 2016, compute the impairment loss and prepare a journal entry to record the loss.

c. What amount of depreciation expense would Zeibart record for the 12 months from July 1, 2016 through June 30, 2017? Prepare a journal entry to record this depreciation expense. Round to the nearest dollar. (Hint: Assume no change in salvage value.)

d. Using the financial statement effects template, show how the entries in parts b and c affect Zeibart Company’s balance sheet and income statement.

Dowell Company produces a single product. Its income statements under absorption costing for its first two years of operation follow. 2016 2017 Sales ($46 per unit) $ 1,150,000 $ 2,070,000 Cost of goods sold ($31 per unit) 775,000 1,395,000 Gross margin 375,000 675,000 Selling and administrative expenses 288,750 323,750 Net income $ 86,250 $ 351,250 Additional Information Sales and production data for these first two years follow. 2016 2017 Units produced 35,000 35,000 Units sold 25,000 45,000 Variable cost per unit and total fixed costs are unchanged during 2016 and 2017. The company's $31 per unit product cost consists of the following. Direct materials $ 5 Direct labor 8 Variable overhead 8 Fixed overhead ($350,000/35,000 units) 10 Total product cost per unit $ 31 Selling and administrative expenses consist of the following. 2016 2017 Variable selling and administrative expenses ($1.75 per unit) $ 43,750 $ 78,750 Fixed selling and administrative expenses 245,000 245,000 Total selling and administrative expenses $ 288,750 $ 323,750 2. What are the differences between the absorption costing income and the variable costing income for these two years? (Loss amounts should be entered with a minus sign.)