Myopic adopts the cost model for all of its non-current depreciable assets and because it is listed on the Australian Securities Exchange (ASX), it complies with AASB 116 Property, Plant and Equipment and AASB 136 Impairment of Assets. On 1 July 2020, Myopic Ltd purchased plant at a cost of $3,300,000. The plant has an estimated useful life of 10 years, an estimated residual value of zero and will be depreciated using the straight-line method.

For the year ended 30 June 2021, an impairment loss of $90,000 was recognised in relation to the plant.

For the year ended 30 June 2022, there are indicators of impairment/reversal of impairment present and the recoverable amount of the plant is estimated to be $3,000,000.

Required:

Fill in the blanks. The format of your answer to calculations MUST be as follows: $1,000,000. Round to whole numbers.

What is the carrying amount of the equipment at 30 June 2021 after recognising any impairment loss/reversal of impairment and depreciation $_________ _______? (Please add your answer in the blank box).

Which of the following statements is MOST correct for the year ended 30 June 2022 ? Please add your selected answer (A, B, C or D) in the blank box.

A. The carrying amount of the plant reported in Myopic Ltd’s balance sheet after any depreciation, impairment and reversal of impairment is $3,000,000.

B. Myopic Ltd would recognise a revenue item ‘Reversal of Impairment loss’ equal to $440,000.

C. The carrying amount of the plant reported in Myopic Ltd’s balance sheet after any deprecation, impairment and reversal of impairment is $2,560,000.

Myopic Ltd would recognise a revenue item ‘Reversal of Impairment Loss’ equal to $914,909.

D. Myopic Ltd would recognise a revenue item ‘Reversal of Impairment Loss’ equal to $80,000

Use SQL statements to answer any five of the following six exercises. (If you answer all six, one will be discarded at random based on the roll of a six-sided die.) Strive to use fully correct syntax, but you will not be penalized for relatively minor syntax errors. To receive credit for an answer, do not use any features of SQL beyond those covered through Chapter 6 of the textbook. Also do not use implicit join syntax or any features from sections in the textbook that were explicitly excluded in the "Where to Focus" sections of the "Instructor's Notes" provided for Chapters 3-6 (e.g., ROWNUM, the ROLLUP and CUBE operators, or hierarchical queries). Partial credit will be given. If you're not sure how to write a complete query, provide the pieces that you do understand and carefully explain what you're missing to put the pieces together. If you do not believe it is possible to write a particular query using the information provided, subject to the restrictions listed, indicate that as your answer and explain why. 1. (5 pts) Write a SELECT query that lists all students in alphabetical order who are currently enrolled in CISP 350 this semester (Spring 2022). Provide each student's ID number and name formatted as "Last, First". 2. (5 pts) Write a second variation of the query you wrote in the previous question that accomplishes the same result, but is different in some way. (The two queries should be different in a way that would not be considered "gimmicky" by your classmates.) 3. (5 pts) Write a SELECT query that lists all students in alphabetical order who earned a grade of 'C' or better in CISP 301, Section 14040. Provide each student's ID number and name formatted as "Last, First".