Make a comparative report on the approved budget of 2018 with the preliminary result of 2019 budget.

• Using the budget information provided in the table , (page-15) make a comparative report on the approved budget of 2018 with the preliminary result of 2019 budget.

Your report must cover the following items:

Sector contribution and its impact on the total revenue. Rationally analyze and comment on the positive indication in the preliminary results of 2019.

Carry out a vertical analysis of the expenditure for both years and judiciously comment on the expenditure of each category on the total expenditure. ( 4 marks)

Can government increase the tax rate and cut government expenditure to address the deficit?

What impact it makes on the economy?   

1.

When specifying a column name inside of a COUNT(), what does the function actually count? (E.g., COUNT(name))

a. The number of rows in the column

b.The number of rows in the table

c.The number of non-null rows

d.The number of non-null columns

3. Which SQL clause is used to sort the output?

a.ORDER BY

b.SORT

c.ORDER

d.SORT BY

Which SQL statement is used to extract data from a database?

a.OPEN

b.SELECT

c.GET

d.EXTRACT

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if All of the conditions listed are true.

a. True

b.False

SAM does not keep a full set of double entry accounts.

Summarised Bank Account:-
Debit entries: Receipts from customers 60500
: Sale of Non current asset 750

Credit entries : Payments to suppliers 34900
: Wages 15000
: Heating 2500
: Drawings   5000
: Purchase of Non current asset 8000
: General Expenses 6000

Additional Information:
1 May 2017 30 April 2018
Bank 100 cr ?
Inventory 5250 11000
Trade Receivables 9750 8400
Trade Payables 10500 9300
Non current assets (book value) 40000 42000
Heating 600 prepaid 250 accrued
6% Bank Loan 20000 20000
Capital 25000 ?

The Non current asset sold during the year had a book value of $1000

Prepare

(i) An Income Statement for the year ended 30 April 2018
(ii) A Statement of Financial Position as at 30 April 2018

c. The standard of living in China is higher than the standard of living in Belgium as the size of China’s real GDP in 2018 (using 2010 constant prices) was USD10,800,568.39 million compared to Belgium’s USD538,738.79 million (figures from the World Development Index Database). Do you agree or disagree with this statement? Refer to the UN Human Development Index to Justify your answer.

The following table is a non-normalized table for a Rental Property Management Database.  Data is included to help you to perform the normalization.  One client may have multiple rental records.

Identify the functional dependencies and normalize the table to 1NF, 2NF, and 3NF respectively. You also need to show the steps to reach normal form and populate each relation with sample data. As a result, you can see that duplicate data will be removed through the normalization process.

CLIENT_RENTAL

ClientNo: Client Number (PK)

ClientName: Client (who rents a property) Name

PropertyNo: Property Number

PropertyAddress: Property Address (Do not need to break this attribute)

RentStart: Rent Start Date

RentEnd: Rent Ended Date

RentFee: Monthly Rental Fee

OwnerNo: Property Owner Number

OwnerName: Property Owner Name

Notes:

1. Can multiple clients rent the same property at the same time? For example, co-signers on a lease.  No
2. Can one client rent multiple properties at the same time? I.e. if he rented a home and an office.  Yes
3. Can one client rent the same property multiple consecutive times, requiring multiple records? For instance, he extends a lease for another year at a different rent.  No
4. A property cannot have multiple owners.
5. The RentFee is not fixed for each property and can change from one Client to the next.
6. A different client can rent the same property for a different time period creating another record for the same property.

Abstract: Using the Stochastic Frontier Approach (SFA), this study investigates the cost and profit efficiency effects of bank mergers on the US banking industry. We also use the non‐parametric technique of Data Envelopment Analysis (DEA) to evaluate the production structure of merged and non‐merged banks. The empirical results indicate that mergers have improved the cost and profit efficiencies of banks. Further, evidence shows that merged banks have lower costs than non‐merged banks because they are using the most efficient technology available (technical efficiency) as well as a cost minimizing input mix (allocative efficiency). The results suggest that there is an economic rational for future mergers in the banking industry. Finally, mergers may allow the banking industry to take advantage of the opportunities created by improved technology.

i need small paraphrase or summary for this abstract

On July 1, 2013, Farm Fresh Industries purchased a specialized delivery truck for $219,000. At the time, Farm Fresh estimated the truck to have a useful life of eight years and a residual value of $27,000. On March 1, 2018, the truck was sold for $88,000. Farm Fresh uses the straight-line depreciation method for all of its plant and equipment. Partial-year depreciation is calculated based on the number of months the asset is in service. Required: 1. Prepare the journal entry to update depreciation in 2018. 2. Prepare the journal entry to record the sale of the truck. 3. Assuming that the truck was sold for $125,000, prepare the journal entry to record the sale.

Problem 5-10 Part 4 4. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)

What is the genetic code? What are the properties of the triplet codons? What does it mean that the code is redundant and what useful purpose does such redundancy serve?

The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms.The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms.

Provide a 1,600-word detailed, statistical report including the following:

• Explain the context of the case
• Provide a research foundation for the topic
• Present graphs
• Explain outliers
• Prepare calculations
• Conduct hypotheses tests
• Discuss inferences you have made from the results

This assignment is broken down into four parts:

• Part 1 - Preliminary Analysis
• Part 2 - Examination of Descriptive Statistics
• Part 3 - Examination of Inferential Statistics
• Part 4 - Conclusion/Recommendations

Part 1 - Preliminary Analysis (3-4 paragraphs)

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective:

• What are the questions you are trying to address?

Describe the population in the study clearly and in sufficient detail:

• What is the sample?

Discuss the types of data and variables:

• Are the data quantitative or qualitative?
• What are levels of measurement for the data?

Part 2 - Descriptive Statistics (3-4 paragraphs)

Examine the given data.

Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary).

Identify any outliers in the data.

Present any graphs or charts you think are appropriate for the data.

Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics (2-3 paragraphs)

Use the Part 3: Inferential Statistics document.

• Create (formulate) hypotheses
• Run formal hypothesis tests
• Make decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations (1-2 paragraphs)

Include the following:

• What are your conclusions?
• What do you infer from the statistical analysis?
• State the interpretations in non-technical terms. What information might lead to a different conclusion?
• Are there any variables missing?
• What additional information would be valuable to help draw a more certain conclusion?