Pick 5 business

Each of one need:

1. Explain their revenue stream (type)

2. Explain when the revenue would be recognized ("earned") under the accrual method

3.Will there be a different gross and net sales?

4.Name 1 Cogs, if applicable

5.Name 1 variable operation expenses

6.Name 1 fixed operating expenses

​​​​​​

1. Write a SQL statement to retrieve user account information (username, account_status, default_tablespace, temporary_tablespace, and created date) of your account.

2. Write a SQL statement to retrieve the “USERS” table space information (tablespace name, block_size, initial extent, max_extents).

3. Write a SQL statement to retrieve the physical file information (file name, tablespace name, bytes, blocks, and status).  

In C,

1) Create variables for:

your first and last name

total round trip to school and home (assuming you don't live on campus - make it your hometown).

cost of gas

2) Create a program that will:

output your first name and your total miles driven for the week.

output your last name with the total costs per week

From the following mySql query create a function that returns a n^th value of a table:

SELECT name, (SUM(price * quantity)) AS TotalPrice

FROM Items NATURAL JOIN Inventory

GROUP BY name

ORDER BY (TotalPrice) DESC

LIMIT 1, OFFSET 1;

Shema:

Inventory(name: String,item:String,quantity:integer)

Items(item: String, brand: String, price:double)

How many dollars of sales were generated from every dollar of fixed assets during 2017?

Construct the Operating Activities part ONLY for 2017 from the Statement of Cash Flows based on the information below:

At year-end 2016, a company total assets were $1.8 million, and its accounts payable were $350,000. Sales, which in 2016 were $2.8 million, are expected to increase by 30% in 2017. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Company typically uses no current liabilities other than accounts payable. Common stock amounted to $360,000 in 2016, and retained earnings were $260,000. Company has arranged to sell $120,000 of new common stock in 2017 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2017. Its net profit margin on sales is 8%, and 45% of earnings will be paid out as dividends. How much new long-term debt financing will be needed in 2017?

Misco Speaker Company manufactures portable bluetooth speakers.  The following selected financial information for the fiscal year 2016 is provided: (amounts are in thousands) Item Amount Sales $150,000 Cost of Goods Manufactured 75,650 Direct Material Purchased 36,200 Factory Overhead 10,950 Work in Process - January 1 32,600 Work in Process - December 31 17,420 Direct Material - December 31 12,000 Finished Goods Inventory - December 31 59,000 Net Income 20,670 Direct Materials used 34,500 Cost of Goods Sold 58,000 Use this information to prepared a detailed Schedule of Costs of Goods Manufactured for FY 2016: (Round dollar values & enter as whole dollars only.) Misco Speaker Company Statement of Costs of Goods Manufactured for the year ended December 31, 2016 Direct Materials Direct Material Purchased

2.
One in four Americans (25%) surveyed in a poll in 2016 said that they didn’t read a single book within the last 12 months. When Pew Research surveyed 1,520 adults living in all 50 U.S. states and the District of Columbia in 2016, they learned that the number of respondents that didn’t read a book within the last year did not budge from 2015 figures. A recent sample of 120 people indicated that 41 of them didn’t read a book within the last year.

1. Based on the sample results, construct a 95% confidence interval for the recent population proportion for those who did not read a book within the last year.
2. Based on the sample results, test if the recent population proportion is greater than the population proportion in 2016. Use the critical value approach with the 5% significance level.
3. Repeat the preceding hypothesis test using the p-value approach.