The following data give the average price received by fishermen for several species of fish in 2000 and 2010. The price is in cents per pound.

1. Create a regression equation for the data.
   
   ˆy=y^= Round to 2 decimal places.
   
2. What is the correlation coefficient between the 2000 and 2010 prices.
   
   Round to 2 decimal places.
   
3. If a type of fish was 41.3 cents per pound in 2000, how much would you expect to pay for it in 2010?

1. Which of the following best describes a dimension table in a star schema:

1. Most attributes will likely be text
2. Most attributes will likely be numeric
3. The primary key should be a single integer surrogate key
4. Both a. and c.

2. Which of the following best describes a fact table in a star schema:

1. Most attributes will likely be text
2. Most attributes will likely be numeric
3. The primary key should be a single integer surrogate key
4. Both a. and c.

3. Which of the following best describes an advantage(s) of a snowflake schema:

1. It slows down queries by forcing more joins between dimension tables
2. It allows facts to be stored at different granularities of a dimension in a multi-star schema (e.g. day and month granularities of a date dimension)
3. Facts that are at the lowest level of the dimension can be more easily summarized at higher levels of the dimension than they can with a pure star schema by precomputing aggregates
4. Both b. and c.

Transactions and Recovery:

4. Which of the following best describes the atomicity property in regards to transactions:

1. Either all actions in a transaction are executed or no actions are done
2. The DBMS changes from one consistent state to another consistent state when a transaction completes successfully
3. A transaction executes with the same outcome, without any impact from other transactions executing concurrently
4. The DBMS guarantees that changes are made persistently upon successful completion of a transaction

5. Which of the following statements are true:

1. Verifying transaction consistency is the job of the semantic data controller
2. Managing consistency of transactions operating in parallel is the job of the concurrency controller
3. Both a. and b.
4. Neither a. nor b.

6. Which of the following statements best describes a phantom read:

1. A select from one user calculating a summary or aggregate function (e.g. avg, max, sum, etc.) reads some rows from a table. At the same time another user is updating some of those same rows to contain different values. The first user reads some of the rows before the update changes them and reads some rows after the update changes them.
2. One user reads the same row more than once. Between the reads, an update from another user modifies the row.
3. One user reads a set of rows from a table. Another user inserts a row that matches the where condition read by the first user. The first user reads the same set of rows again getting the new row in addition to the rows that the user read the first time.
4. Two users update the same columns of the same row of the same table at the same time. One update will be overwritten by the other.

1.Budgeted units to be sold for each quarter: 1000, 1200, 1500 and 2000 for the year 2018 and 2019. Assume that company policy requires 20% of the next quarter’s sales in ending inventory and that beginning inventory of t-shirts for the first quarter of the year was 180. The unit selling price of t-shirt is $10.

2. Budgeted units to be produced for each quarter: 1060, 1260, 1600, and 1800. Plain t- shirts cost $3 each, and ink costs $0.20 per ounce. On a per-unit basis, the factory needs one plane t-shirt and five ounces of ink for each logoed t-shirt that the company produces. Lion Inc. is to have 10% of the following quarter’s production needs in ending inventory. The factory has 58 plain t-shirts and 390 ounces of ink on hand on January 1. At the end of the year, the desired ending inventory is 106 plain t- shirts and 530 ounces of ink.

3. Budgeted units to be produced for each quarter are: 1060, 1260, 1600, and 1800. It takes 0.12 hour to produce one t-shirt. The average wage cost per hour is $10.

4. Refer to the direct labor budget. The predetermined overhead rate for variable overhead is $ 5 per direct labor hour. Fixed overhead is budgeted at $1,645 per quarter (this amount include $540 per quarter for depreciation among others). There is no noncash expense items other than depreciation expense.

5. For SG&A expenses: Variable SG&A costs are $0.10 per unit sold. As for fixed SG&A costs, salaries average $1420 per quarter; utilities, $50 per quarter; and depreciation, $150 per quarter. Advertising for quarters 1 through 4 is $100, 200, 800 and 500, respectively. There is no noncash expense items other than depreciation expense. Prepare SG&A Expense Budget.

6. Lion Inc. has provided the following information for preparing a cash budget:

Expected cash balance on 1/1/2018 = $40,000

Information on cash receipts:
(1) From past experience, Lion Inc. expects that, on average, 25% of total sales are cash and 75% of total sales are on credit. Of the credit sales, the company expects that 90% will be paid in cash during the quarter of sale, and the remaining 10% will be paid in the following quarter. Budgeted units to be sold for each quarter: 1000, 1200, 1500 and 2000.
The balance in A/R as of the last quarter of 2017 was $1350. This will be collected in cash during the first quarter of 2018.

a. Calculate cash sales expected in each quarter

b. Prepare a schedule showing cash receipts from sales expected in each quarter of 2018.

(2) In the 1st quarter of 2018, Lion Inc. expects to sell marketable securities that are valued at $5,000.

Information on cash disbursements:
(3) Direct materials are all purchased on credit. Lion Inc. usually pays 80% of its purchases in the same quarter as the purchase and the rest is paid in the following quarter. The company expects to have an accounts payable balance of $1,000 on December 31, 2017; and all outstanding payables are expected to be paid in the first quarter of 2018. Prepare cash disbursement on A/P budget.
(4) All employees – direct laborers, supervisors, S&A staff – are all paid in the quarter in which their services are used.
(5) Overhead costs and S&A expenses are paid in the quarter in which they are incurred.
(6) On April 1, 2018, the company plans to spend $30,000 to buy a high-end knitting machine, which has a 10-year useful life.

Information on financing:
(7) The company plans to borrow $30,000 from the local bank at an annual interest rate of 12%

to fund the purchase of the high-end kitting machine at the beginning of the second quarter. Principal will be due in 1 year and interest will be due every quarter. The company does not expect to issue stock or pay any dividends in 2018. Also, as of 12/31/2018, the company does not have any debt on its balance sheet. The company wants to maintain a minimum cash balance of $15,000.

7. Budgeted Income Statement: The Company calculates the predetermined overhead rate every year using direct labor hours as a cost driver (Round to the nearest cent). Also, when calculating the unit product cost, make sure to include two direct material components (t-shirt and ink).
Put together your master budget for 2018 in the following order:

1. Sales Budget
2. Schedule of Cash Collection
3. Production Budget
3. Direct materials purchase Budget

- one for T-shirt

- one for Ink
4. Schedule of Cash Disbursement

5. Direct Labor Budget
6. Manufacturing Overhead Budget

7. SG&A Budget
8. Cash Budget
9. Budgeted Income Statement.

2. Find each of the following articles online and use it to answer the given questions.

a) https://www.forbes.com/sites/rrapier/2017/11/26/fear-will-drive-oil-prices-in-2018/#762158552a1f

I) In the section The Cycle of Fear, is the description of what is happening more consistent with demand or supply shifts? Draw a picture consistent with your answer and explain why the resulting price change in your picture is consistent with the article. (1 point)

II) Do the same as (I) for the section Enter the Shale Boom (1 point)

III) At the end of the article, they predict higher prices in 2018 from two different factors. Draw a diagrams showing why both of these factors (two different shifts) would cause higher oil prices. (1 point)

b) https://www.marketwatch.com/story/netflix-earnings-analysts-await-update-on-how-price-increases-are-affecting-growth-2018-01-17. Note that diagrams may be helpful, but are not required for this question.

I) For the moment, only consider the information through the 7^th(?) paragraph (which starts “[That] suggests the service …). If we are looking at the market for NETFLIX subscribers, is this part of the article discussing

            i) Demand or Supply?

            ii) A shift or a movement along the curve?

Be sure to explain why you come to these conclusions. (1 point)

II) If we go a few paragraphs further (“While Netflix raised prices …) would that change you answer to either (i) or (ii) above? Why?

c) http://abcnews.go.com/Business/story?id=5017914

i) The 3^rd paragraph talks about causes of increased food prices in the 70’s. Would all of these causes shift the same curve or different curves? Draw a diagram of the food market consistent with your answer to that question.   Be specific about which curve you shifted and why. (1 point)

ii) Four paragraphs later, it lists several reasons for the current increases. This are different than in the 70’s. Does that mean that a different curve is shifting? Draw a diagram and explain.

(1 point)

• Utilizing the information provided in your course textbook(s) or other valid sources, describe the role of the Financial Manager.
• In addition, explain the functions of money.
• Please provide a brief update to the instructor on how you feel you are doing so far this term.  

You are just starting work at a new health department and you have been asked to outline the steps that should be taken to update the department’s preparedness plan for an influenza outbreak. Outline the steps of the report and explain why each is an important component of a preparedness plan.

Question 3. Issue the following statement to create a copy of the d_clients table named d_clients_copy and write ONE statement to update this table. create table d_clients_copy as select * from d_cliens Change the phone number for Hiram Peters to 5551212 and email to [email protected]

You have just been posted to the Office of the Accountant General Expenditure Unit. The Unit is responsible for the consolidation of Government accounts. You have been asked to analyze the information given below in the Trial Balance of the Consolidated Fund for the year ended December 31, 2018.

Additional information:

1. The Current Chart of Accounts based on the GFS 2001 is used to classify revenues and expenditure.
2. VAT of $50m was due to Government but was not received by Government as at December 31, 2018.
3. A grant agreement signed in 2017 by the Government of Zambia and the Swedish Embassy for the purchase of various medical supplies for Kabwata Health Centre was received and paid for in 2018.                                                                     

Required:

1. Define the following terms as used in Public Sector Accounting and give two (2) examples of each classification.

                1. Financial Assets

                2. Non – Financial Liabilities

2. Using the information from the Trial Balance prepare Statement of Financial Performance for the Consolidated Fund for the year ended December 31, 2018.

The annual premium for a $5000 insurance policy against the theft of a painting is $150. If the (empirical) probability that the painting will be stolen during the year is .01, what is your expected return from the insurance company if you take out this insurance and repeat problem from the point of view of the insurance company.

Why do you think the empirical studies about factors affecting equity returns basically showed that domestic factors were more important than international factors, and, secondly, that industrial membership of a firm was of little importance in forecasting the international correlation structure of a set of international stocks?