(a) On 1 July 2018, Zahid rented out his properties as follows:
(i) An apartment was rented to Abdul Qadir at a monthly rent of Rs. 40,000. Zahid received a non-adjustable security deposit of Rs. 300,000 which was partly used to repay the non-adjustable security deposit amounting to Rs. 175,000 received from the previous tenant in July 2013. He also spent Rs. 20,000 on repairs of the apartment in February 2019.
(ii) A bungalow was rented to a bank. Zahid and his younger brother are joint owners of the bungalow in the ratio of 60:40 respectively. The annual rent agreed with the bank was Rs. 6,000,000 which is inclusive of Rs. 100,000 per month for utilities, cleaning and security. Zahid paid Rs. 35,000 per month for providing these services. Required: Under the provisions of Income Tax Ordinance, 2001 compute total and taxable income of Zahid for the tax year 2019 under appropriate heads of income. (07)
(b) Identify due date of filing of tax return in each of the following cases, under the provisions of the Income Tax Ordinance, 2001:
(i) An individual who’s entire income falls under final tax regime (0.5)
(ii) An individual who derives his income from business which falls under normal tax regime. (0.5)
(iii) An individual filing return in response to a notice received from the Commissioner who believes that he is likely to discontinue his business. (01)
(iv) An individual filing return in response to a notice received from the Commissioner for not filing return of income of the previous tax year. (01)

(kindly solve in the context of pakistan and please do it in typed form)

One of the major problems with front office accounting at the Royal Crest Hotel is monitoring guest and non-guest accounts using their manual system. Management has always extended local businesses and government officials charge privileges, the idea being that, with the convenience of deferred payments, local patrons would be more likely to dine and/or host clients at the hotel. This program has proved to be highly successful. The volume of purchases charged to such non-guest accounts now approximates the level of sales incurred by registered guests. Unsure if this is a good or bad situation, Mr. Osei, the front office manager, requests the front office accounting staff to study the problem and to report its findings at next week's front office meeting. At the weekly front office meeting, the hotel's accountant, Ms. Pokua, reports that there are at least three problems related to the hotel's non- guest charge purchasing policies: its impact on the daily hotel audit, the billing procedures to collect payment, and the number of applications for additional non-guest accounts. When asked to be more specific, she begins with a review of the daily hotel audit. She states that since the front office receives charge vouchers from the hotel's revenue centers, it is the front desk agent's responsibility to separate guest from non-guest accounts. Since registered guest charges are posted by room number, one would think it easy to sort those charges from the others. Unfortunately, both the hotel's guest account numbers and the non-guest account numbers are three digits, thereby making the sorting more time-consuming. Mr. Osei asks if it is really necessary to separate the charges. Ms. Pokua explains that it is, since the hotel must maintain accurate guest folio Page 2 of 1 G. N. Baah balances. She further states that the non-guest vouchers are accumulated and posted on Saturday afternoons, when the hotel's business is less hectic. The billing procedures to collect non-guest account balances are tricky, Ms. Pokua said. Since the hotel bills non-guest accounts on the last day of each month, some charges occurring in a particular month may not be posted in time to appear on that month's bill. In addition, non-guest accounts usually are not paid in time. In fact, 47 percent of last month's non-guest account balances remain unpaid and tomorrow is the date of the next billing cycle. Mr. Osei explains that the local customers are important to the hotel and suggests that maybe Ms. Pokua is over-sensitive to the billing problems. Lastly, Ms. Pokua relates the fact that there are at least ten new applications for non-guest accounts. She has instructed her staff not to authorize any new non-guest accounts without her written approval. She further states that she is reluctant to authorize any additional non-guest accounts, and looks to Mr. Osei for advice. Convinced of the positive aspects of such business, Mr. Osei directs her to approve the requests and to assign account numbers effective the first day of next month. Ms. Pokua so instructs her staff. a. What ideas (any two) would you suggest to facilitate a more effective processing of guest and non- guest charge vouchers? b. How might the daily audit be aided by such changes? c. Is the accumulated-postings routine for non-guest accounts an effective plan? Explain your response. d. What could be done to improve the hotel's billing of non-guest accounts? e. What could be done to improve collection of outstanding balances? State any four (4). f. What are the two (2) advantages and two (2) disadvantages to having a high volume of non- guest accounts? NOTE; PLEASE I NEED DIFFERENT ANSWERS.

12) Why are non-point sources of water pollution harder to control then point sources? Give an example of a point and a non-point source.

Explain what non-recourse finance is and explain when it might be applicable. What are some potential risks associated with non-recourse funding?

'driver', 'car', 'accident' and 'report' are names of some tables in the insurance database system. These tables were created by executing the following SQL creation statements.

CREATE TABLE driver( driverID INT NOT NULL PRIMARY KEY, name VARCHAR(30) NOT NULL, cityAddress VARCHAR(25) );

CREATE TABLE car( plateID INT NOT NULL PRIMARY KEY, model VARCHAR(20) NOT NULL, year YEAR(4) NOT NULL );

CREATE TABLE accident( reportNumber INT NOT NULL PRIMARY KEY, date Date NOT NULL, location VARCHAR(20) NOT NULL );

CREATE TABLE report ( reportNumber INT NOT NULL, plateID INT NOT NULL, driverID INT NOT NULL, damageAmount DOUBLE );

Based on the previous SQL creation statements, you are required to write each of the following queries in SQL.

1- List the models of all cars which were not involved in any accident.

2- List the names and addresses of all drivers who were not involved in any accident.

A database needs to be developed that supports a supermarket.

(i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements.

1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records how many items of each product are currently on stock.

2. A product can be on special offer. A special offer is valid for a period, which has a start date and an end date. A special offer refers to exactly one product. Two special offers for the same product cannot have overlapping periods. A special offer for a product specifies that a certain number of items of that product are sold at a certain price (e.g., 2 items for $1.99).

3. There is a card scheme for which customers can register. A registered customer holds a customer card. Each registered customer has a customer number, which is unique. For each registered customer the supermarket records the name and the address of the customer and the day when the customer joined the card scheme.

4. When a customer buys one or more items and pays for them, a purchase is being completed. A purchase is uniquely identified by the number of the checkout where the customer pays, together with the date and the time when the purchase is made.

5. Some purchases are made by registered customers.

6. A purchase consists of one or more line items. Within a given purchase, each line item is uniquely identified by its line number. Each line item refers to a unique product. (In fact, the line items correspond to the items of the purchase). Some line items have an additional comment, which is a string. (The comment may say that a special price applies to the product item because it is part of a special offer.)

[20]

Use the “Consumer Food” Database on “Excel Databses.xls”. As the researcher you are interested in predicting the annual food spending according to annual household income as well as a qualitative variable: location or region.

Link to data: https://drive.google.com/file/d/1YMYMy7H0sLRZJzXwFKMrANuAGxmp-z9I/view?usp=sharing

Please use excel and post step by step

Construct two regression models to predict annual food spending:

• Model 1: Food = b₀ + b₁Income + b₂Metro
• Model 2: Food = b₀ + b₁Income + b₂NE + b₃MW+ b₄S

NOTES:

• DO NOT: Print the data.
• DO: Only print the results of each model from Excel (i.e. Print the Summary Output, ANOVA, and Table of Coefficients from each model
• DO NOT: Include the residual output to turn in.

Must complete all the parts to this problem:

• PART 1: Output the results from Excel for Model 1.
• PART 2: Output the results from Excel for Model 2.
• PART 3: Write the model (estimated regression equation) using your output for Model 1. Then calculate the predicted annual food spending for a household outside the metro area that has $60,000 income.
• PART 4: Write the model using your output for Model 2. Then calculate the predicted annual food spending for a household that has a $35,000 income and is located in the South.