You are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history, SIMSOX expects at least a rate of return of 20%. Your financial advisors predict inflation to remain at 3% into the foreseeable future. The information about three projects is given below: Project: Dust Devils Year Investment Revenue Stream 500,000 50,000 250,000 350,000 Project: Ospry Year Investment Revenue Stream 250,000 75,000 75,000 75,000 50,000 Project: Voyagers Year Investment Revenue Stream 75,000 15,000 25,000 50,000 50,000 150,000 Use Excel to apply the Payback Period, Net Present Value and Internal Rate of Return Analysis to the three projects. Copy and paste your Excel spreadsheet below. Project: Dust Devils Discount rate (Rate of return = 20% + inflation rate = 3%) 23% Year Inflow Outflow Net flow Cumulative Netflow Discounted Netflow 500,000.00 -500,000.00 – 500,000.00 – 500,000.00 50,000.00 50,000.00 – 450,000.00 40,650.41 250,000.00 250,000.00 – 200,000.00 165,245.55 350,000.00 350,000.00 150,000.00 188,084.37 – 106,019.67 NPV -106,019.67 IRR 11% PP 2.57 Years Project: Ospry Discount rate (Rate of return = 20% + inflation rate = 3%) 23% Year Inflow Outflow Net flow Cumulative Netflow Discounted Netflow 250,000.00 -250,000.00 – 250,000.00 – 250,000.00 75,000.00 75,000.00 – 175,000.00 60,975.61 75,000.00 75,000.00 – 100,000.00 49,573.67 75,000.00 75,000.00 – 25,000.00 40,303.79 50,000.00 50,000.00 25,000.00 21,844.87 – 77,302.06 NPV – 77,302.06 IRR 4% PP 3.50 Years Project: Voyagers Discount rate (Rate of return = 20% + inflation rate = 3%) 23% Year Inflow Outflow Net flow Cumulative Netflow Discounted Netflow 75,000.00 – 75,000.00 – 75,000.00 – 75,000.00 15,000.00 15,000.00 – 60,000.00 12,195.12 25,000.00 25,000.00 – 35,000.00 16,524.56 50,000.00 50,000.00 15,000.00 26,869.20 50,000.00 50,000.00 65,000.00 21,844.87 150,000.00 150,000.00 215,000.00 53,280.18 55,713.93 NPV 55,713.93 IRR 44% PP 2.70 Years Summarize the results for the three projects in the following table: Dust Devils Ospry Voyagers Payback Period 2.57 3.5 2.7 Net Present Values -106,019.67 – 77,302.06 55,713.93 Internal Rate of Return 11% 4% 44% Which project should be SIMSOX first priority? Give reason for your answer. The first priority project is Voyagers Project because it has the highest internal rate of return (44%) which cover the lowest expected rate plus inflation rate (23%). It also does not get minus value on NPV compare with two others. Should SIMSOX fund any of the other projects? Give reason for your answer. SIMSOX should not invest in others projects because the rest projects do not reach the lowest expected rate of return and get minus value on NPV
Assessment 3 Information Subject Code: ACC304 Subject Name: Taxation Law Assessment Title: Case Studies Assessment Type: Statement of Advice Weighting: 30 % Total Marks: 40 marks Submission: Via Turnitin on MyKBS Your Task Your task is to analyse client information outlined in the three different case studies below and present the findings in three Statement of Advice (approximately 1,500 words). 1) You are required to prepare Lucy’s individual taxation return. 2) You are required to provide recommendations and tax calculations to Susan regarding the taxation implications and tax payable by the trustee for Megan and Isabel, the beneficiaries. 3) You are required to calculate the franking account and tax payable by Otago Pty Ltd. For each question you are expected to: 1) identify the facts and issues for each case 2) apply the relevant legislation and/or case law. Learning Objectives After completing this Individual Assignment, you will be able to: 1) Research information about each question using tax cases and tax legislation. 2) Identify the main issues and make recommendations for each case. 3) Calculate taxes for an individual, a trust and a company. Assessment Instructions Statement of Advice 1 – Prepare a tax return for an individual taxpayer (10 marks for technical and calculation accuracy and relevance and 10 marks for writing style; refer to marking rubric for more guidance) Your client Lucy has attended your office to have her 2021-year tax return prepared. Lucy is 52 years old, single resident taxpayer employed by Burwood Council as a clerk. Lucy is also a friend of yours. She has the following documentation and admits that she is not good at keeping her receipts and invoices: Payment Summary for the period 1 July 2020 to 30 June 2021 from Burwood Council. Gross Wages $56,000 Allowances – Clothing $400 Tax withholding Deducted $12,000 Various receipts Date Paid to Details Amount ($) 30 July 2020 Eastern Clothing Non-compulsory uniform (registered design of Council) $380 1 September 2020 Foodbank Australia Donation $50 1 October 2020 Tax agent 2019 tax return fees $100 1 December 2020 Lim’s Computer Computer (est. 50% work use with 3 years effective life) $1,200 1 February 2021 Corp Bookshop Textbooks for clerical course $500 Other Information 1) Lucy estimated total $490 annual train ticket used to travel to and from work. 2) Lucy advises you she spent $600 on personal grooming which was essential for her job and insists that she claims this amount. 3) Lucy held $2,000 for the whole year in an interest-bearing account but insists that she did not receive any interest during the year. Lucy has not supplied any bank statements. 4) Lucy sold various shares on 20 June 2021 as follows. • Apricot Shares (Australian company): purchased in January 1998 for $20,000 and sold for $55,000. • Pear shares (Italian company): purchased in March 2019 for $7,000 and sold for $5,000. • Cherry shares (Australian company): purchased in May 2021 for $9,000 and sold for $14,000. Required 1) Calculate taxable income for Lucy. As the Tax Agent, what advice would you provide for the best outcomes in relation to depreciation, CGT method and general deductions for Lucy within Australian income tax law? You are required to explain all income & deduction details with section numbers and/or cases in your explanations. 2) Advise Lucy on the CGT consequences of the share sales. You must provide all methods available for her and choose the best method to minimise Lucy’s net capital gains. 3) As the Tax Agent, how would you handle the stance your client has taken in points 2 and 3, Point 2: Lucy advises you she spent $600 on personal grooming which was essential for her job and insists that she claims this amount. Point 3: Lucy held $2,000 for the whole year in an interest-bearing account but insists that she did not receive any interest during the year. Lucy has not supplied any bank statements. You should refer to the Code of Conduct from Tax Practitioners Board. What is the principle involved? What do you recommend in each point? Statement of Advice 2 – Advice on Trust income and distributions (10 marks for technical and calculation accuracy and relevance) Your client Susan has attended your office to have her 2021-year tax return prepared. Susan is the trustee of an Australian resident trust estate created by a Trust Deed. She created the trust for the benefit of her daughters, Megan aged 19 years and Isabel aged 15 years. They are both residents of Australia. The following information indicates the trading activities of the trust for the 2020/21 income tax year. Receipts Net income from trading activities $80,000 Fully franked dividend received $25,000 Proceeds from shares in Hub Ltd on 12 June 2021 $60,000 (the shares were purchased in 2005 at a cost of $20,000) Rental income $65,000 Expenses Expenses incurred in generating rental income $55,000 Other information Megan derived a salary of $17,000 while working casually at McDonalds. Isabel received interest income of $2,000 from her savings account (savings account was established two years ago from $40,000 deposited from her grandfather as a gift). Isabel also received a salary of $9,000 working at Hungry Jacks during school holidays. Required Advise Susan the taxation implications (tax payable by the trustee and/or each beneficiary) under each of the alternatives (1) and (2) below. 1) Susan does not exercise any discretion as to the distribution of income during the year. 2) Susan distributes the trust net income to each beneficiary at 50% each. Statement of Advice 3 – Calculate the franking account and tax payable by Otago Pty Ltd. (10 marks for technical and calculation accuracy; refer to marking rubric for more guidance) Frank is a director of Otago Pty Ltd (Otago), an Australian resident private company, with a corporate tax rate for imputation purposes for the 2020/21 income year of 30%. Frank provided you with the following information regarding the company’s franking account: 1 July 2020: Opening balance $500 credit. 29 July 2020: Paid 2020 tax year fully franked final dividend $7,000 28 February 2021: Paid 2021 tax year 60% franked interim dividend $9,000 30 April 2021: Received fully franked dividend from Australian company $4,500 28 June 2021: PAYG instalment paid relating 2020/21 tax year totalled $1,200 30 June 2021: Declared a fully franked dividend of $10,000 Otago had a taxable income of $16,000 for 2020/21. Required 1) Prepare Otago Pty Ltd’s franking account for the 2020/21 tax year and explain any consequences arising from the franking account balance at 30 June 2021. 2) Calculate net tax payable (refundable) for the company.
Important Study Information Academic Integrity Policy KBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy. • What is academic integrity and misconduct? • What are the penalties for academic misconduct? • What are the late penalties? • How can I appeal my grade? Click here for answers to these questions: http://www.kbs.edu.au/current-students/student-policies/. Study Assistance Students may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Click here for this information. ACC304 Taxation Law Assessment 3 Marking Rubric /40 marks Statement of Advice 1 (10 marks) 0 – 5 6 – 10 Achieved marks ( /10) Has demonstrated limited achievement: Correctly calculated some taxable income and allowable deductions items. Stated some outcomes in relation to depreciation, capital gains tax methods and general deductions. Struggled to articulate the correct capital gains tax consequences of the sale of shares. Failed to address the tax practitioners code of conduct and principles involved. Has achieved all or most of: Correctly calculated the taxable income and allowable deductions. Stated the best outcomes in relation to depreciation, capital gains tax methods and general deductions. Articulated the correct capital gains tax consequences of the share sales. Addressed the tax practitioners code of conduct and principles involved. Statement of Advice 2 (10 marks) 0 – 5 6 – 10 Achieved marks ( /10) Has demonstrated limited achievement: Failed to correctly address the taxation implications of Susan not distributing trustee income for 2020/21. Failed to correctly address the taxation implications of Susan distributing trust net income to each beneficiary at 50% each during 2020/21. Has achieved all or most of: Correctly addressed the taxation implications of Susan not distributing trustee income for 2020/21. Correctly addressed the taxation implications of Susan distributing trust net income to each beneficiary at 50% each during 2020/21. Statement of Advice 3 (10 marks) 0 – 5 6 – 10 Achieved marks ( /10) Has demonstrated limited achievement: Either did not prepare or only partially prepared Otago Pty Ltd franking account for 2020/21. Failed to identify any consequences arising from Otago Pty Ltd franking account balance as at 30th June 2021. Either did not correctly calculate or only partially calculated correctly Otago Pty Ltd net tax payable for 2020/21. Has achieved all or most of: Correctly prepared Otago Pty Ltd franking account for 2020/21. Correctly identified consequences arising from Otago Pty Ltd franking account balance as at 30th June 2021. Correctly calculated Otago Pty Ltd net tax payable for 2020/21. All Statements of Advice Writing Style (10 marks overall) 0 – 5 6 – 10 Achieved marks ( /10) Has demonstrated limited achievement: Some sentences contain grammatical errors and typos, there are noticeable inconsistencies in the formatting, and the syntax makes some of the answers difficult to follow. Has achieved all or most of: The document does not contain any grammatical errors or typos, the formatting is consistent, and the syntax is articulate and legible
Please note carefully the following important corrections in the assignment questions: 1. Question 2b: Missing information: Standard Deviation of risky portfolio is 24.5% 2. Question 2c: You do not need to complete this part. 3. Question 5b: Calculate -Duration- only, you do not need to calculate ‘Convexity’ 4. Question 5cii: Missing information: Convexity of the bond is 10.2977765 Please Note:: i. This Assessment consists of five questions (all problems), some with multiple parts. ii. All questions must be attempted. iii. Solve each problem using the appropriate formula/e, which must be shown at the start of each problem. iv. EXCEL formulae or workings using EXCEL will NOT be accepted. v. Show all calculations Submission requirements details: A. Presentation. – Answers to be typed. Handwritten answers will not be accepted and will not be marked. – Please type each answer after each part question. The Assignment (below) is reproduced on Moodle, with space provided for each answer. If more space is required, then scroll down the page, and extra page(s) automatically will be produced. – Typing should use Arial or Times New Roman or Calibri font (10, 11 or 12 pitch), 1.5 line spacing; and – Left and right margins to be at least 2.5 cms from the edge of the page. B. Research and referencing. – All references sourced should be quoted at the end of the Assignment in a List of References. – Use Harvard referencing. See http://en.wikipedia.orQ/wiki/Harvard referencing – As the questions are calculation problems, there is no need to submit via Turnitin. C. Submission Every page should be clearly numbered. The lodged Assignment must include the following, in order: (a) A KOI Cover Sheet for an Individual Assignment. (b) A title page, which indicates Subject Title, Trimester Number, Assignment Title, Student’s Full Name; KOI Student Number; and Tutor’s name. (c) Assignment Questions and Answers. (d) List of references (using Harvard – Anglia style). (e) A copy of the Assignment Marking rubric (see page XX below). A copy of your Assignment, containing the requirements specified in Items (a) to (e) above, needs to be emailed to your Tutor at ruhina.karim@koi.edu.au by the start of the week 10 tutorial. Late lodgments will be penalised – see Section 3.2 a) below. QUESTION 1. [(CALC’NS a. + b. + c. + d. = 4 + 4 + 4 + 4 = 16 Marks) + (REC’NS e. = 4 Marks)] a. At 15 October, 2020, the share prices of Coal Ltd and Wood Ltd were $30 and $105 respectively. One year later, the respective share prices were $35 and $110. i. Calculate the price-weighted percentage average return for these two stocks over the year to 15 October, 2021. ii. Suppose instead, at 15 October, 2021, the final price of Coal Ltd was $35 (as above), but the price of Wood Ltd had fallen to $95. Calculate the revised price-weighted percentage average return for these two stocks over the year to 15 October, 2021. b. What are both the payoff and the profit or loss per share for an investor in the following two situations? i. Jean buys the June, 2022 expiration Paypal call option for $6.40 with an exercise price of $120, if the Paypal stock price at the expiration date is $132? ii. Joan buys a Paypal put option for $4.50 with the same expiration date and exercise price as Jean’s call option, and the Paypal stock price is also $132 at the expiration date? c. A large investor resident in your country seeks your advice on global investments. i. State briefly two reasons why he/she should include international equities in his or her investment portfolio. ii. Identify two risks which apply to the investor if he/she invests in international equities. d. Two corporate bonds, issued respectively by F Ltd and G Ltd, have the same face value of $10,000 and the same term to maturity of 7 years. F Ltd’s bonds have a coupon rate of 8% per annum, payable half-yearly, and G Ltd’s bonds have a coupon rate of 7.8% per annum, payable bi-monthly (that is, every 2 months). Calculate the effective annual return (EAR) on each bond. [Show each answer as a percentage, correct to 2 decimal places.] e. Asif is a fund manager with a share portfolio currently valued at $1 billion under management. He considers that the share market is much over-priced and fears a sharp downturn of 20% in the market by June, 2022, which will badly affect his share portfolio’s value and performance, which he wishes to protect. He seeks your advice as to whether he should take a short position in futures or buy a put option, each with an exercise price of $1 billion (the current value of his share portfolio). Explain each of the two strategies, and state your recommendation which Asif should follow, with reasons. QUESTION 2. [{CALC’NS a. + b. = (3 + 3) + (2 + 2 + 2+ 2 + 2) = 16 Marks} + {REC’NS c. = 2 Marks}] a. The expected return of the market index over 2022 is 10%. The standard deviation of returns of the market index is expected to remain at its long-term average of 18%. The risk-free rate is 4%. Calculate: i. the degree of risk aversion (commonly denoted by ‘A’) for an investor in the market index. ii. the Sharpe ratio of the market index portfolio. b. The expected return of a risky portfolio in New Zealand over 2022 is 15%, while the risk-free rate is 7%. Terry wishes to set up a complete portfolio, with y (the proportion invested in the risky portfolio) = 0.75. REQUIRED: i. Define a “complete portfolio”. ii. Describe the mix (or asset allocation) of Terry’s complete portfolio, including the percentages of each asset held. iii. What is the expected return of Terry’s complete portfolio? iv. What is the standard deviation of returns for Terry’s complete portfolio? v. What is the Sharpe ratio for Terry’s complete portfolio? c. Mabel is more risk averse than Terry, and her degree of risk aversion, A, is 4.0. Using the data supplied at the beginning of part b. above, calculate the percentages of each asset class you would recommend she should hold in her optimal complete portfolio. [Show percentages correct to 2 decimal places.] QUESTION 3. [{CALC’NS a. + b. + c. = (3 + 3) + (2 + 2 + 4) + 2 = 16 marks} + {REC’NS d. = 2 marks}] a. Historical data for the All Ordinaries Index indicates that: – the standard deviation of returns from the Index has been 17%; and – the degree of risk aversion (A) of an investor in the Index is 3.6. REQUIRED: i. What market risk premium is consistent with the above historical standard deviation? ii. If the market risk premium is 12%, what would be the historical standard deviation? b. The expected return of the market in Iceland is 15%. Stock H has a beta of 1.3 and the risk-free rate is 5%. REQUIRED: i. What is the expected return of Stock H, according to the CAPM? ii. What is the alpha of a stock? (Definition or explanation required.) iii. What is the alpha of Stock H, if Iceland Stockbrokers, investors in – and researchers of – the stock, believe that Stock H will provide a return this year of: I. 20%; or alternatively, if they consider the return this year will be: II. 14%? c. Based on your answers to part b. iii. above, is Stock H over-priced, underpriced or fairly priced in each of the situations I. and IL? Would you recommend that Iceland Brokers buy more of – or sell – or just hold Stock H in each of these situations? d. Jackie, an analyst with Betta Brokers, uses a two-factor (F1 and F2) CAPM index method to evaluate the expected return of stock in Z Ltd. The model uses the following data: E(R) of F1 = 12%; E(R) of F2 = 8%; p (beta) of F1 = 1.3; p (beta) of F2 = 0.4; and Rf (risk-free rate) = 5%. What is the expected return of a share in Z Ltd? QUESTION 4. [{CALC’NS (3 + 2 + 3) + (2 + 2) + (2 + 2) = 16 Marks}] A. The yield curve for Government-guaranteed zero-coupon bonds is based as follows: Term to maturity (years) Yield to maturity (% per annum) 1 8% 2 9% 3 10% REQUIRED: i. What are the implied one-year forward rates for years 1,2 and 3 respectively? ii. If the expectations hypothesis of the term structure of interest rates is correct, in one year’s time, what will be the yield to maturity on a one-year zero-coupon bond? iii. Based on the same hypothesis as in ii. above, in one year’s time, what will be the yield to maturity on a two-year zero-coupon bond? -12- B. On 15 January, 2021, you bought a Government bond, with a face value of $1,000; a term to maturity of 5 years; a coupon rate of 6% per annum payable yearly, and a yield to maturity of 5% per annum. You paid the market price of $1,043.76 for the bond. On 15 January, 2022, you sold the bond to Jill, providing her with a yield to maturity of 4% per annum. [NOTE: You bought and sold the bond immediately after payment of the interest coupon due on 15 January each year- that is, the interest payments due on 15 January in 2021 and 2022 are not included in the bond prices.] REQUIRED: i. What price would Jill have paid for the bond? [Show answer correct to the nearer cent.] ii. What is your holding period return for holding the bond for one year, receiving the January, 2022 interest coupon, then selling the bond? [Show answer as a percentage, correct to 2 decimal places.] C. With the aid of hypothetical illustrative examples, briefly explain each of the Expectations and the Liquidity preference hypotheses relating to the term structure of interest rates. Which of the two hypotheses do you consider to be the more relevant? Why? QUESTION 5. [{CALC’NS a. + b. + c. + d. = (1 + 1 + 1) + (3 + 3) + (2 + 2 + 2) + 1 = 16 Marks} + { REC’NS e. = 2 Marks}] A. Briefly explain the following concepts relating to bond portfolio management. i. Duration. ii. Convexity. iii. Immunisation. B. Illustrate your answer to A. above with the calculation of the duration and convexity of a bond with a face value of $1,000, term to maturity of 3 years, a coupon rate of 6% per annum, payable yearly, and a yield to maturity of 4% per annum. [NOTE: As a by-product of these calculations, you should calculate the current market price of the bond, which price should be used as a base or starting point to your answers required in C. i. and C. ii. below.] C. Calculate the expected price of the bond described in B. above, if the yield to maturity fell immediately to 3% per annum, by each of the following 3 methods. i. The duration adjustment method. ii. The duration-with-convexity adjustment method. iii. The present value of future cash flows method. D. Which of the methods listed in C. above is most accurate? Why? E. Explain how a pension fund can use zero-coupon bonds to immunize its obligation to pay out $10 million a year in pensions in perpetuity, if the forecast long-term interest / discount rate is 5% a year forever. LIST OF REFERENCES USED (Student to complete) IMPORTANT DECLARATION: “By uploading / submitting this Assignment, I declare that the Assignment answers are my own work and I have not sought or obtained help.” END OF ASSIGNMENT MARKING GUIDE: Marks will be awarded as follows: Element Marks Calculations, including research and analysis (as above) 80 Recommendations and Conclusions (REC’NS above) 10 Presentation 10 TOTAL 100 The TOTAL will be converted to a mark (correct to the nearer whole number) out of 30%
ASSESSMENT 2 BRIEF Subject Code and Title MIS602 Data Modelling and Database Design Assessment Database Implementation Individual/Group Individual Length N/A Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: b) Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders. Weighting 35% Total Marks 100 Marks Task Summary In this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests from an existing database and develop appropriate SQL statements to satisfy those requirements. Context Being able to query a database is a fundamental skill that is required by all information systems professionals who work with relational databases. In this assessment, you will utilize the basic query skills that are typically used to extract information for analysis, reporting and data cleansing in a data management setting. Timely provisioning of key business information promotes effective communication and enhanced solution delivery. Task Instructions
Please read the attached MIS602_Assessment 2_Data Implementation_ Case study.
Examine the relational model and ER diagram and derive the SQL queries to return the required information.
Provide SQL statements and the query output for the following:
List all the customers who live in any part of CAULFIELD. List only the Customer ID, full name, date of birth and suburb (5 marks)
List all of the active staff. Show their Staff ID, full name and weekly salary assuming that they work a 38 hour week (3 marks)
Which plan has the most expensive contract to break? (5 marks)
Which brands of mobile phone does this company sell? List only the unique brand names (3 marks)
Which customer is not able to purchase a phone? Use a query to explain why. Hint: Review the customer data (3 marks)
How many of each phone plan have been sold? (5 marks)
What is the average age of an Apple phone user? (8 marks)
What are the first and most recent mobile phone purchases? (3 marks)
i. For calls made in 2018 how many calls were made on the weekend? (5 marks) ii. For calls made in 2018 how many calls were made on each day of the weekend? (3 marks) MIS602_Assessment _2_Brief_Database Implementation_Module 4.2 Page 1 of 3
Provide a listing of the utilization of each tower and its location i.e. how busy each tower is based on the number of connections. Put the busiest tower at the top of the list (3 marks)
Did any users on the ‘Large’ plan exceed their monthly allowance during August 2018? (8 marks)
The company is upgrading all their 3G towers from to 5G. i. How many towers will be upgraded? (1 mark) ii. what SQL will be needed to update the database to reflect the upgrades? (2 marks)
i. List the full name, join date, resigned date of each staff member and name, join date and resigned date of their manager (3 marks) ii. What do you observe with the data? (2 marks)
How much revenue was generated in 2017 by each plan from call charges. Format the output as currency i.e. $123.45 (8 marks)
List the customers who made phone calls longer than 200 minutes (5 marks)
Which customers have more than one mobile phone? List the customer name, suburb and state. Order by the customer name (8 marks)
Are there any mobile phone plans that are currently unused? This can be obtained a number of ways. Demonstrate this by using the following two query types i. Nested subquery (3 marks) ii. Outer join (3 marks)
List the oldest and the youngest customers in the postcodes 3000 and 3102. Show the customer full name age and suburb details (3 marks)
i. Create a view that shows the popularity of each phone colour (1 mark) ii. Use this view in a query to determine the least popular phone colour (2 marks)
The billing team is getting returned mail because of bad customer addresses. This is causing a loss in revenue. i. Review the customer data and find at least 3 issues (3 marks) ii. Provide the SQL statements to correct the data problems (2 marks) Total 100 marks
The database used for this assignment is available in ‘MIS602_Assessment 2_Database SQL Files’ folder. Please download the files from this folder.
All statements and first 10 lines of output need to be neatly presented. Please save all your SQL statements and output into a single word document and submit it via the Assessment link in the main navigation menu. Referencing It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing Submission Instructions Submit Assessment 2 via the Assessment link in the main navigation menu in MIS602 Database Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades. Academic Integrity Declaration I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly. MIS602_Assessment 2_Brief_Database Implementation_Module 4.2 Page 2 of 3 Assessment Rubric Assessment Criteria Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% ? Correct and complete queries ? Display only required information ? Demonstration of additional AQL knowledge 100% Queries are incorrectly answered with marks only sufficient to attain a F(ail). Queries correctly answered with sufficient marks to attain a (P)ass Queries correctly answered with sufficient marks to attain a (C)redit. Display only required information. Queries correctly answered with sufficient marks to attain a (D)istinction. Display only required information Display additional SQL knowledge such as column formatting, table alias, additional calculations etc Queries correctly answered with sufficient marks to attain a (HD) High Distinction. Display only required information. Display additional SQL knowledge. Well formatted queries. Results returned in a meaningful order. MIS602_Assessment 2_Brief_Data Implementation Module 4.1 Page 3 of 3
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Examine the relational model and ER diagram and derive the SQL queries to return the required information
The organizational structure, via at least two networks, influence the moves of organizations. First, a shape can affect overall performance metrics inside the organization, such as profitability or velocity in imposing innovations that enhance productivity. These performance traits, in turn, have an effect on movements either because they conflict with administration strategies and estimates or because aggressive choice forces behave in another way on businesses based totally on their performance. Second, the company’s structure may provide advice on the humans or purposeful units that the organization includes. (DeCanio,2020).
The organization will go underneath specific changes that It’s fundamental for the wants of the organization.
in reason to enhance the effectiveness of work and the business enterprise results growing groups to expand the productivity and fine of work and enhance professional work, sharing knowledge, capabilities , additionally to expanded commitment. In the benefits of discovering new possibilities to the corporation Implementing Authorization, it grew to be particularly important to be in this business enterprise to achieves many dreams in less time.
Furthermore, more essential points will be listed down in this memo.
Teams and Delegating tasks
Delegating the tasks and improve teamwork are very wished in this organization.
As delegating tasks will help in :
– Achieves the organization’s higher return with little expense.
– Saves time at all ranges of management.
– Speed in the overall performance of administrative work
– Flexibility in management, adoption of a variety of circumstances.
– Preparing future leaders to inspire workers to critically reason.
– Enables employee-building opportunities and alternate leadership and organizational management skills. (Al-Jammal, H. R., 2015).
When crew individuals count number on one every other to attain The work completed, crew morale and effectiveness have a tendency to be high. The participants depend on one another. Also, make bigger confide in one another. Together, Participants operate higher than individuals. When team individuals execute Better as a crew than alone, collective performance is more significant than man or woman performance. (Olden, P. 2019)
Teams and processes of teamwork are pretty important, for some motives :
– Enable the employees to share competencies, knowledge.
– Improve issues solving and decision making.
– Expand the thoughts and making plans.
– Growing of work and try new rules. (Olden, P. 2019)
A NEW STRUCTURE OF ORGANIZATION
In order to gain the best output and to reap basic organization goals, agency structure should be change. The organizational structure describes formal members of the family and organizational reporting and indicates the number of degrees in the hierarchy, and determines the diploma of managers’ power. The organizational structure describes the role of persons in a unit as operating in a crew and separates the units in the organization. (Ahmady, G, 2016)
A divisional shape of separate functional constructions that file to a central core is a multidivisional structure. The management of everyday operations is responsible for each purposeful structure. The central group of workers is responsible for monitoring and keeping the relationship between agencies and the community and policy. Divisional structure, which will help in quicker choice making , and limit the centralization, Also to reveal the surroundings and expand the customer satisfaction. In this shape, we will have an exceptional vice president to each department connected to the president immediately. The reporting relationship will be vertically in this structure. (Ahmady, G, 2016)
Vice Presidents serve as the team coaches and trainers for the Directors assigned to their areas. The Vice-Presidents should act as group coaches, get to know contributors of their team, and comprehend Why they want to be engaged, and pay attention to their suggestions. Vice Presidents ought go-to songs and evaluation their programming on an ongoing basis, and make adjustments as appropriate. It collaborates with other companions Executive Team (Chairman, different vice-chairmen, And the Chairman of the Board) to make sure that it is sufficient. There are sources available, such as workers, funds, and time, to execute scheduled tasks and accomplish predetermined objectives. The Vice Presidents are at the cost of the administration of the workflows in their respective regions. As the layout is completed, the roles of the assignment should be break up among the Managers. Vice Presidents must continue to be in close contact with every other, Assisting the administrators with their recruitment, And Chair coaching each time needed. (The book: Chapter officers,2017)
Vice-Presidents need to keep and beautify the Contact traces in the section with:
• External corporations / individuals.
• Other Vice Presidents
• Director. (The book: Chapter officers,2017)
Individual Development VP
Suggested location of accountability for opportunities: Life Improvement, Chapter Management (Training and Correspondence for officers and members), Member Services (orientation and triggering). (The book: Chapter officers,2017)
Community VP:
area of duties Community work, fundraising by means of the Community, Political participation, State and Junior National Chamber participation, Recruitment of membership. (The book: Chapter officers,2017)
Management VP:
area of duties Management (planning and assessment) Financial management, activities, and public Relationships. (The book: Chapter officers,2017)
Business VP:
Company Chances, Leadership Growth. (The book: Chapter officers,2017)
Marketing VP:
Sales administration of the direct sales channels, sales planning, manage human beings and align man or woman and team goals with corporate goals
Human recourses VP:
HR Ensuring the HR group meets key KPIs, normal HR operations, such as administrations, recruitments, personnel interviews, and evaluations.
Reporting and conversation will be in vertical lines as company new chart; hence, every VP will be reporting to the line above, every director will file to the VP, CEO will record to VP.
A new Organization chart will be bought to Explain the reporting relationships and chains of command within the group. Each division features notably autonomously. Top managers as VP Responsible for the organization’s well-being and results. They set desires or performance targets to guide all the activities that have to be carried out if the organization is to accomplish its purpose.
(Skripak, S. J. 2016).
DECENTRALIZATION
Decentralization capability dispersal of authority among the lower stages of the administrative system. (Marume, S. B,2016).
Decentralization mechanism can be reinforced by the reality that decentralization provides a countervailing strength to central decision-making, thereby creating a manipulate and stable situation that reduces the possibility of uninformed and impractical central-level policies. Performance advantages can also be provided by way of decentralization insurance policies to lower the probability of bottlenecks at the central level, accordingly growing the overall machine throughput power. Decentralization, as described above, can be related to enhancing output performance by way of improving each enter and throughput performance. (Saltman, R, 2006).
The organizational performance is more robust via putting off delays and helping quicker Operation. It decreases the workload of the headquarters and thereby permits the best levels to the center of attention on critical issues—problems such as the components of legislation, the analysis of the principal difficulties. Minimizing paperwork at both higher and lower levels relieves the point of contact fatigue in the company. Experiments in decision-making and execution utilizing multiple devices make it possible without involving the complete employer in an unproven direction of action. (Marume, S. B,2016).
In different hand, we are taking some risk in decentralization As some disadvantages :
– the hazard of sub-optimality as decentralized businesses concentrate on their very own consequences rather than the business enterprise as a whole.
– lack of geared-up steering impulses.
– inadequate diversity of practices and standards, especially in personnel management.
– decreased comparability and predictability at the device level. (Marume, S. B,2016).
References
– Skripak, S. J. (2016). Fundamentals of business. Virginia Tech.
– Saltman, R., Busse, R., & Figueras, J. (2016). Decentralization in health care: strategies and outcomes. McGraw-hill education (UK).
– Ahmady, G. A., Mehrpour, M., & Nikooravesh, A. (2016, September 12). Organizational Structure.ResearchGate.https://www.researchgate.net/publication/308736877_Organizational_Structure
– DeCanio, S. J., Dibble, C., & Amir-Atefi, K. (2020). The importance of organizational structure for the adoption of innovations. Management science, 46(10), 1285-1299.
– Al-Jammal, H. R., Al-Khasawneh, A. L., & Hamadat, M. H. (2015). The impact of the delegation of authority on employees’ performance at great Irbid municipality: case study. International Journal of Human Resource Studies, 5(3), 48-69.
– Olden, P. (2019). Management of Healthcare Organizations: An Introduction, Third Edition (Gateway to Healthcare Management) (None ed.). Health Administration Press
Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service? film dealing with the march on Washington on August 28, 1963
Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. Achieves the organization’s higher return with little expense.
Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services.