Monthly Archives: January 2017

ITECH 1006 – Database Management Systems

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

ITECH 1006 – Database Management Systems
Assignment 1
Overview
You are to create an ER diagram, and a relational schema for a small business. You need to provide a discussion of normalisation including the normal form that each entity is in, a list of relationships with all table names, primary and foreign keys, and attributes indicating their type and purpose.
Timelines and Expectations
Percentage Value of Task: 20%
Due: 5pm Thursday the 5th January, 2017 (week 7)
Minimum time expectation: 12 hours
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
• K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation
• K5. describe relational algebra and its relationship to Structured Query Language (SQL);
• A1. design and implement a relational database using a database management system;
Project Specification
You have been commissioned to create a database for ArtScapes, a new company that runs exhibitions in different locations in Australia. Their goal is to sell tickets to these art exhibitions to the public, promote featured artists and help them sell works of art during the exhibitions.
All ArtScape exhibitions are organised and run from the company’s head office in Sydney, but exhibitions can be in any city or town. It is company policy to only run one exhibition at any one time, and to supply their own staff. Each exhibition has a name and a theme. Artists and their works are chosen for each theme and invited to participate. Artists are not paid for participating, but they receive the proceeds (if any) from sales of their artwork. Artscape receive a 10% commission from these art sales and the admission fees from exhibition visitors. They pride themselves for showing outstanding pieces of art from known artists and promising new ones.
The following business rules and information gathered about the current business activities will allow you to derive entities. Your submission is not expected to have many to many relationships left unresolved. You may add entities or attributes as you see fit. Assumptions can be made to include further entities and their relationships, but referential integrity and normalisation processes must be adhered to. Reasons should be given for any relation that is not maintained in 3NF.
• Exhibitions (run by ArtScape) are referenced by a unique exhibition number, they have a name, a theme, a location, a website address, and start and end dates for the exhibition.
• ArtScape employs many staff members, keeping track of their unique IDs, names and contact details, as well as tax number, job title and daily rate of pay. Most staff members are assigned to a supervisor, who is a member of staff as well.
• Several staff members are assigned to every exhibition. ArtScape ensures that at least some experienced staff are assigned to every exhibition, so it must keep a record of staff assignments with the role that the staff member had during the assignment. Staff may be assigned to an exhibition for all or part of its duration, so the assignment start and end dates need to be recorded for payroll purposes.
• To assist in staff training, every staff role has a name and detailed task description.
• When visiting an exhibition, visitors must supply first name, last name, email, phone number and address. ArtScape records these details for each visitor, together with a unique number, to allow notification of future exhibitions.
• Each visitor can belong to one of several visitor types, such as: Junior, Standard, Concession Card etc. Each unique visitor type has a name, description and the entry fee.
• ArtScape has a registry of artists. For every artist, there is a unique number, first name, last name, date of birth, address, phone number and email address, as well as a biography for the artist and the artist’s website address. Artists have the option of supplying an artist name.
• Every exhibition has many artworks. Every artwork in this inventory has a unique number. Every piece is produced by only one artist, and has a title and description. There are three types of artworks: photographs, sculptures and paintings.
• For all exhibited sculptures, height, width and length is recorded, as well as the weight.
• For paintings, the width, height and artist medium is recorded.
• For photographs, there must be a record of the camera used and the location where the photo was taken.
• Some artworks are for sale, so inventory items have a forsale attribute. If an item is for sale, this must be marked with “Y” and a sale price is supplied by the artist
• Visitors can purchase works marked for sale during the exhibition. ArtScape records sales invoices. Each invoice can have one or more purchases. Most artworks are unique (for example most paintings), but some photographic prints have multiple numbers, so the quantity as well as the inventory number must be recorded.
Submission
Your submission should include:
• An ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated. All many to many relationships should be resolved.
• A discussion of normalisation including the normal form that each entity is in and why that is optimal. Also a discussion of how normalisation was achieved for that entity.
• A list of relationships with all table names, attributes, primary and foreign keys indicated as per the conventions given in the lecture slides (ie entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics.)
• A database schema indicating the type and purpose of all attributes.
The assignment is to be submitted via the Assignment 1 submission box in Moodle. This is to be found in the Assessments section of the course Moodle shell.
Marking Criteria/Rubric
Assessment Criteria and Marking Overview Tasks Marks
1. Presentation
• Cover page indicating student name and number and tutor name.
• Page numbers included in report
• Index giving page numbers of various sections
• Overall presentation of the report
• Full APA referencing of all materials used and full disclosure of assistance fro sources including tutors and other students. 2
2
2
2 m all
2 10
2. E-R diagram
• Completeness of diagram
• Correct notation and convention used
• All assumptions clearly noted
• Primary and foreign keys
• Resolution of many to many relationships 12
8 8
10
12 50
3. Normalization
• All entities and relationship in appropriate normal form
• Discussion of normalisation for all entities and relationships
• Appropriate interpretation of each normal form, arguments for leaving the s in the normal form you consider optimal. 10
5
chema
5 20
4. Conversion of E-R diagram to relational schema
• Correct standards, conventions and notation used
• Primary keys used
• Foreign keys correctly identified including parent entity
• Schema is a correct translation of the E-R diagram submitted with appropriate tables, columns, primary keys, and foreign keys.
• Types and restrictions on attributes given 2 2
6
6 4 20
Total 100
Feedback
Feedback will be provided via the marked rubric with comments handed out in the tutorial 2 weeks after the submission date. The marks will also be available on FDL Marks at this time.
Plagiarism:
Plagiarism is the presentation of the expressed thought or work of another person as though it is one’s own without properly acknowledging that person. You must not allow other students to copy your work and must take care to safeguard against this happening. More information about the plagiarism policy and procedure for the university can be found at http://federation.edu.au/students/learning-andstudy/online-help-with/plagiarism.

 



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

This Assignment Must Be Your Own Work. It Is Acceptable To Discuss Course Content With Others To Improve Your Understanding And Clarify Requirements, But Solutions To Assignment Questions Must Be Done On Your Own.

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

Assignment 2
Decision Support System (DSS)
Description Marks out of Wtg(%) Due date
ASSIGNMENT 2 100.00 25.00 18 Jan 2017
This assignment must be your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own. You must not copy from anyone, including tutors and fellow students, nor allow others to copy your work. All Assignments will be checked using collusion monitoring tools to ensure that each assignment is the original work of the submitting student. Assignments that do not adhere to this requirement will be deemed as being the result of collusion or plagiarism. This may lead to severe academic penalties as outlined in USQ Policy Library: Academic Integrity Policy and Procedure. It is your own responsibility to ensure the integrity of your work. Refer to the USQ Policy Library for more details:
• Academic Integrity Policy
• Academic Integrity Procedure
In completing this assignment, you are expected to use available resources such as the practical activities in the study modules, the Course Study Desk – especially the Discussion Forums (click the Study Desk link on UConnect – http://uconnect.usq.edu.au ), as well as exploring and experimenting on your own.
Applicable course objective:
• demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications).
• demonstrate written communication skills by understanding basic information, communication and technology (ICT) terminology for effective communication and applying it within a business environment.
Applicable graduate qualities and skills gained from this assessment instrument:
• Problem Solving (Skill U2)
• Written & Oral Communication (Skill U4)
This assignment is quite complex, and exposes you to many different components in Microsoft Excel (any version from Excel 2007 to current), some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skills sections at the end of each Module in the Study Materials, the SAM online tutorial activities and the course discussion forums, as well as exploring and experimenting on your own.
Preamble
Dr Rod N Berry was extremely impressed with our computing firm Klingon Systems after the successful development of The Borg Collective’s Database Management System (DBMS) using Microsoft Access (Assignment 1). The business has further contracted our firm to assist in setting up more information systems for the business.
The next information system that the business is interested in is a Decision Support System (DSS) using Microsoft Excel (any version from Excel 2007 to current). The DSS will be used to analyse sales trends for the business to determine future courses of action for the business.
Dr Rod N Berry would like the information in the Database Management System (DBMS) (Assignment 1) imported into Microsoft Excel (any version from Excel 2007 to current) so that the information can be summarised as a report and future analysis of sales trends could be performed on the basis of the suppliers used by the business, sourcing items from either Luxembourg (LU) or Tuvalu (TV). The DSS should allow the business to select suppliers from either of these two regions on an ad-hoc basic depending on the most favourable exchange rate at the time of analysis.
Dr Rod N Berry has noted that a number of the business’s competitors are providing a discount to their customers who place large orders. The business would like to see the impact of adopting a similar policy on its profitability. The business has also noted a growing number of online companies are starting to provide free order deliveries to encourage more online sales. The business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination if they were to adopt a similar policy on order deliveries.
All phases in this project must be developed with professionalism and user-friendliness in mind.

www.startrek.com, ™ & © CBS Studios Inc.
Decision Support System Design
Mrs Augusta Lanvele, your manager, has set up the following tasks for you to complete for this phase of the project:
1. Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets
2. Data Validation Check
3. Create an Index Worksheet
4. Create a Data Input Worksheet Template for later use
5. Create a Calculations Worksheet Template for later use
6. Create Name Ranges for the Customers, Items, and Suppliers data
7. Create a Report Worksheet and set up the column headings
8. Modify the Report Worksheet by Cell Referencing all the Orders Table data
9. Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data
10. Modify the Data Input Worksheet to include extra data needed for tasks 11 to 15
11. Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU)
12. Modify the Report Worksheet by using a Nested IF to calculate Selling Price
13. Modify the Report Worksheet by using a Nested IF to calculate Freight Cost
14. Modify the Report Worksheet by using a AND / IF to calculate Item Discount
15. Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount
16. Modify the Data Input Worksheet to include extra data needed for tasks 18 to 22
17. Modify the Calculations Worksheet by using simple formulas
18. Modify the Data Input Worksheet by Cell Referencing all the Calculations data
19. Create eight (8) Scenarios on the Data Input Worksheet
20. Create a Scenario Summary of the eight (8) Scenarios
21. Create an Documentation Worksheet
22. Create an Analytical Essay to describe the findings made using the Spreadsheet
Task 1: Create and Import
Open a single new Excel (any version from Excel 2007 to current) spreadsheet and name the file – ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number]’ (eg. genrichr_0050051005_CIS5100_assign2.xlsx).
Import the following four (4) database tables from your Assignment 1 Microsoft Access (any version from Access 2007 to current) Database File and into Microsoft Excel (any version from Excel 2007 to current) (tblCustomers, tblItems, tblSuppliers, tblOrders). The easiest and quickest way to import data from Access (any version from Access 2007 to current) into Excel (any version from Excel 2007 to current) is by using the “Import From Access” Wizard. The following steps will assist you with this process:
1) Select the first unused tab at the bottom of the Spreadsheet, right click on it and rename it “CustomersTable”.

2) Put a heading at the top of the worksheet in cell A1 called “Customers Table”.
3) Go to the Data Icon Ribbon (see below)

4) Click on the From Access option in the Get External Data icon area.
5) In the Get External Data – From Access wizard popup, browse to find your Assignment 1 Access Database file and select the – then click Open.
6) In the Select Table wizard popup, select tblCustomers – click OK.
7) In the Import Data wizard popup, select Table and Existing Worksheet $A$3 as the location to Import the place to put the data.
8) Left click anywhere on the imported data in worksheet then go to the Design Icon Ribbon and select Convert to Range then click OK.
9) Check that the data has correctly been imported correctly into this worksheet.
10) Modify the layout of the data to a professional level of presentation, making sure that the headings are renamed properly (Customer ID not CustID).
Use bold, italics, font size, font colours, shading, lines and borders.
Repeat the above 10 steps for the rest of the Access Database tables naming each worksheet as follows:
Database Table Worksheet Name Worksheet Title (Cell A1)
tblItems ItemsTable Items Table
tblSuppliers SuppliersTable Suppliers Table
tblOrders OrdersTable Orders Table
Task 2: Data Validation Check
Check the imported data in the CustomersTable, ItemsTable, SuppliersTable and OrdersTable to ensure that:
1. The column headings are displayed correctly
2. The content of each column displays in a format that appears valid for that type of data (apply appropriate formatting if required).
3. The content of each column contains complete and accurate data values (eg. Phone numbers are not truncated).
4. The content of each column contains reasonable data values for the use of this business.
If you discover that the data imported in any of your 4 table worksheets contains missing or inaccurate values, please contact the CIS5100 course team immediately. You will be issued with a new copy of the Assignment 1 Access Database file (containing the 4 Database Tables) to restart Task 1.
Task 3: Index Worksheet
Add a worksheet labelled Index before the four tables from Task 1. Put a heading at the top of the worksheet in cell A1 called Index Worksheet. Ensure that it contains all the recommended data for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 4: Data Input Worksheet Template
Add a worksheet labelled DataInput after the Index worksheet from Task 2 (but before the four tables from Task 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Data Input Worksheet and then input the following template in the exact cells shown below onto this worksheet:
A B C D
3 Changing Cells:
4 Recommended MarkUp Type [Insert Markup Type here]
5 Recommended Freight Type [Insert Freight Type here]
6 Store Recommended MarkUp % [Insert Standard Markup % here]
7 Recommended Exchange Rate Type [Insert Exchange Rate Type here]
8 Exchange Rate (LU to AU) [Insert LU to AU Exchange Rate here]
9 Exchange Rate (TV to AU) [Insert TV to AU Exchange Rate here]
10
11 Quarterly Income:
12 Total Sales [Insert Cell Reference here]
13
14 Quarterly Fixed Expenses:
15 Bank Charges [Insert Bank Charges Expense here]
16 Electricity Expenses [Insert Electricity Expense here]
17 Freight Inwards Expenses [Insert Freight Inwards Expense here]
18 Internet Expenses [Insert Internet Expense here]
19 Telephone Expenses [Insert Telephone Expense here]
20 Wages Expenses [Insert Wages Expense here]
21
22 Total Quarterly Fixed Expenses [Insert Cell Reference here]
23
24 Quarterly Variable Expenses:
25 Total Purchases Expenses [Insert Cell Reference here]
26 Total Freight Outwards Expenses [Insert Cell Reference here]
27
28 Total Quarterly Variable Expenses [Insert Cell Reference here]
29
30 Total Profit: [Insert Cell Reference here]
31 Total Discount for Orders: [Insert Cell Reference here]
32 No. Orders Discount Applied: [Insert Cell Reference here]
* This template will be modified with correct number, formula and function in tasks 10 onwards.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 5: Calculations Worksheet Template
Add a worksheet labelled Calculations after the DataInput worksheet from Task 4 (but before the four tables from Task 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Calculations Worksheet and then input the following template in the exact cells shown below onto this worksheet:
A B C D
3 Quarterly Income
4 Total Sales: [Insert Formula here]
5
6 Quarterly Expenses
7 Total Quarterly Fixed Expenses: [Insert Formula here]
8
9 Total Quarterly Variable Expenses
10 Total Purchases Expenses [Insert Formula here]
11 Total Freight Outwards Expenses [Insert Formula here]
12
13 Total Quarterly Variable Expenses: [Insert Formula here]
14
15 Total Profit: [Insert Formula here]
16 Total Discount for Orders: [Insert Formula here]
17 No. Orders Discount Applied: [Insert Formula here]
* This template will be modified with correct number, formula and function in tasks 10 onwards.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 6: Name Ranges
On the CustomersTable, ItemsTable and SuppliersTable worksheets set the following Cell Range Names:
• Cust – on all the data (not headings) in the CustomersTable worksheet
• Itms – on all the data (not headings) in the ItemsTable worksheet
• Supp – on all the data (not headings) in the SuppliersTable worksheet
Note: You must only create the three name ranges listed in this task, any other name ranges used may result in loss of marks.

Task 7: Report Worksheet Headings
Add a worksheet labelled Report after the Calculations worksheet from Task 5 (but before the four tables from Task 1) that conforms to the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Report Worksheet and then type the following column headings, starting in cell A3:
• Customer ID, Title, Family Name, Given Names, Address, City, State, Postcode, Distance (km), Item ID, Type, Description, Size, Freight Weight (Kg), Supplier ID, Supplier Name, Supplier Recommended Markup (%), Order Date, Order Qty, Cost Price (LU), Cost Price (TV), Cost Price (AU), Selling Price, Purchases, Item Discount, Sales, Freight Cost, Order Discount.
Modify the Report worksheets to a professional level of presentation, making sure that the headings are renamed properly (Customer ID not CustID). Use bold, italics, font size, font colours, shading, lines and borders.
Task 8: Report Worksheet Cell Reference
On the Report worksheet, Use the Cell References formula, to obtain all 1000 rows of data from the OrdersTable worksheet for the following:
• Customer ID, Item ID, Order Date, Order Qty.
(For example, type =OrdersTable!A4 to reference data in cell A4 of the OrdersTable worksheet.)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Modify the Summary worksheets to a professional level of presentation, making sure that the data is formatted correctly.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column.
Task 9: Report Worksheet VLOOKUP
On the Report worksheet use the VLOOKUP function with the Cell Range Names (Task 2), obtain all 1000 rows of data from the CustomersTable, ItemsTable and SuppliersTable worksheets for the following:
• Customers Worksheet:
o Title, Family Name, Given Names, Address, City, State, Postcode, Freight Distance (km)
• Items Worksheet:
o Type, Description, Size, Freight Weight (kg), Supplier ID, Cost Price (LU),
Cost Price (TV)
• Suppliers Worksheet:
o Supplier Name, Recommended Markup (%)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
See the Beskeen Excel Unit H and the Videos provided in the Course Content section for more details on creating VLOOKUP functions
Task 10: Modify Data Input Worksheet
On the DataInput worksheet perform the following:
• type Store into the cell containing the phrase: [Insert Markup Type here],
• type 116.20% into the cell containing the phrase: [Insert Standard MarkUp % here],
• type LU into the cell containing the phrase: [Insert Exchange Rate Type here],
• type 1.35486 into the cell containing the phrase: [Insert LU to AU Exchange Rate here],
• type 0.91342 into the cell containing the phrase: [Insert TV to AU Exchange Rate here].
Task 11: Report Worksheet Cost Price (AU) Nested IF
On the Report worksheet:
1. Develop an IF function using the new Recommended Exchange Rate Type value (from the DataInput worksheet to calculate the Cost Price (AU) (in the Cost Price (AU) column) using the following criteria:
• If the Exchange Rate Type is LU then the Cost Price (AU) is calculated by multiplying the Cost Price (LU) by the Exchange Rate (LU to AU) cell on the DataInput worksheet.
Hint:
Cost Price (LU) x Exchange Rate (LU to AU)
• If the Exchange Rate Type is TV then the Cost Price (AU) is calculated by multiplying the Cost Price (TV) by the Exchange Rate (TV to AU) cell on the DataInput worksheet.
Hint:
Cost Price (TV) x Exchange Rate (TV to AU)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Cost Price (AU) IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type TV into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) have changed.
• On the DataInput worksheet, type GIGO into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) now displays an error message.
Task 12: Report Worksheet Selling Price Nested IF
On the Report worksheet:
1. Develop an IF function using the new Recommended MarkUp Type value (from the DataInput worksheet) to calculate the Selling Price (in the Selling Price column) using the following criteria:
• If the MarkUp Type is Store then the Selling Price is calculated by increasing Cost Price by the Store’s Recommended MarkUp % from the DataInput worksheet
Hint:
Cost Price (AU) + Cost Price (AU) x Store Recommended MarkUp
• If the MarkUp Type is Supplier then the Selling Price is calculated by increasing Cost Price by the Supplier’s Recommended MarkUp
Hint:
Cost Price (AU) + Cost Price (AU) x Supplier Recommended MarkUp
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Selling Price IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type Supplier into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices have changed.
• On the DataInput worksheet, type GIGO into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices now displays an error message.
Task 13: Report Worksheet Freight Cost Nested IF
1. On the DataInput worksheet, type Rana Sons Freight into the cell containing the phrase: [Insert Freight Type here].
2. On the Report worksheet develop an IF function using the new Recommended Freight Type value (from the DataInput worksheet to calculate the Freight Cost (in the Freight Cost column) using the following criteria:
• If the Freight Type is Rana Sons Freight then the Freight Cost is calculated at eighty cents ($0.80) per kilogram of the item’s freight weight and a cent ($0.01) per kilometre (Distance) if over 400 km for each item quantity ordered (Order Qty).
Hint:
($0.80 x Item Weight + IF(Distance 400 km, $0.01 x Distance, 0)) x OrderQty
• If the Freight Type is Vicky Run Transport then the Freight Cost is calculated at a dollar and fifty cents ($1.50) for the first three kilograms (3 kg) and then at a ninety cents ($0.90) per kilogram of the item’s additional freight weight, i.e. over three kilograms (3 kg) for each item quantity ordered (Order Qty).
Hint:
($1.50 + IF(Item Weight 3 kg, (Item Weight – 3kg) x $0.90, 0)) x OrderQty
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
3. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.

Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
4. Test the IF function: Once you have completed the Freight Cost IF function, perform the following three tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type Vicky Run Transport into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs have changed.
• On the DataInput worksheet, type GIGO into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs now displays an error message.
Task 14: Report Worksheet IF / AND: Item Discount
1. On the Report worksheet develop an IF / AND function to calculate the amount of Item Discount given to an individual item on an order (in the Item Discount column) using the following criteria:
• If the OrderQty is greater than or equal to five (5) of the same item in any single order AND the Selling Price for that item is greater than $45.00, then the Item Discount is calculated at 3% of the Selling Price for that item, otherwise the Item Discount is zero.
Hint:
=IF (AND (OrderQty = 5, Selling Price $45), Selling Price x 3%, 0)
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF / AND function.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these IF / AND functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Item Discount IF / AND function and filled it down the column, review the values to ensure that it is working correctly in the following situations:
• OrderQty is less than five (5) and Selling Price is less than or equal to $45, should result in $0.00 Item Discount.
• OrderQty is less than five (5) and Selling Price is greater than $45, should result in $0.00 Item Discount.
• OrderQty is greater than or equal to five (5) and Selling Price is less than or equal to $45, should result in $0.00 Item Discount.
• OrderQty is greater than or equal to seven (5) and Selling Price is greater than $45, should result in a calculated value of Item Discount.
Task 15: Report Worksheet Purchases, Sales and Order Discount Formulas
On the Report worksheet calculate the following three simple formulas:
1. Purchases by multiplying Order Qty with Cost Price (AU).
2. Sales by multiplying Order Qty by the difference of Selling Price less the Item Discount amount.
Hint:
= (Selling Price – Item Discount) x Order Qty
3. Order Discount by multiplying Order Qty with Item Discount.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
You must remove any reference to the prefix Report! from these formulae to reduce complexity and redundancy of code. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Task 16: Modify Data Input Worksheet
On the DataInput worksheet:
1. Replace the phrase “[Insert Bank Charges Expenses here]” in cell D15 with $7,386.50
2. Replace the phrase “[Insert Electricity Expenses here]” in cell D16 with $6,995.45
3. Replace the phrase “ [Insert Freight Inwards Expense here] ” in cell D17 with $88,300.34
4. Replace the phrase “ [Insert Internet Expense here] ” in cell D18 with $4,721.50
5. Replace the phrase “[Insert Telephone Expenses here]” in cell D19 with $6,700.56
6. Replace the phrase “[Insert Wages Expenses here]” in cell D20 with $223,784.66
Task 17: Calculations Worksheet Formulas
On the Calculations worksheet calculate the following four simple formula:
1. Replace the phrase in D4 “[Insert Formula here]” with a function to calculate the Total Sales by adding all the Sales in the Sales column on the Reports worksheet.
2. Replace the phrase in D7 “[Insert Formula here]” with a function to calculate the Total Quarterly Fixed Expenses by adding all the Quarterly Fixed Expenses on the DataInput worksheet.
3. Replace the phrase in D10 “[Insert Formula here]” with a function to calculate the Total Purchases by adding all the Purchases in the Purchases column on the Reports worksheet.
4. Replace the phrase in D11 “[Insert Formula here]” with a function to calculate the Total Freight by adding all the Freight Costs in the Freight Cost column on the Reports worksheet.
5. Replace the phrase in D13 “[Insert Formula here]” with a formula to calculate the Total Quarterly Variable Expenses by adding all the Quarterly Variable Expenses on the Calculations worksheet.
6. Replace the phrase in D15 “[Insert Formula here]” with a formula to calculate the Total Profit by subtracting the Total Quarterly Fixed and Total Quarterly Variable Expenses from the Total Sales on the Calculations worksheet.
7. Replace the phrase in D16 “[Insert Formula here]” with a function to calculate the Total Discount for Orders by using the SUMIF() function to add up all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.
8. Replace the phrase in D17 “[Insert Formula here]” with a function to calculate the Number of Orders where a Discount was Applied by using the COUNTIF() function to count all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.
Hint: For details on SUMIF and COUNTIF usage see Beskeen Unit E.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Task 18: Data Input Cell References
On the DataInput worksheet:
1. Replace the phrase “[Insert Cell Reference Here]” in cell D12 with a cell reference to the Total Sales amount on the Calculations worksheet.
2. Replace the phrase “[Insert Cell Reference Here]” in cell D22 with a cell reference to the Total Quarterly Fixed Expenses amount on the Calculations worksheet.
3. Replace the phrase “[Insert Cell Reference Here]” in cell D25 with a cell reference to the Total Purchases Expenses amount on the Calculations worksheet.
4. Replace the phrase “[Insert Cell Reference Here]” in cell D26 with a cell reference to the Total Freight Outwards Expenses amount on the Calculations worksheet.
5. Replace the phrase “[Insert Cell Reference Here]” in cell D28 with a cell reference to the Total Quarterly Variable Expenses amount on the Calculations worksheet.
6. Replace the phrase “[Insert Cell Reference Here]” in cell D30 with a cell reference to the Total Profit amount on the Calculations worksheet.
7. Replace the phrase “[Insert Cell Reference Here]” in cell D31 with a cell reference to the Total Discount for Orders amount on the Calculations worksheet.
8. Replace the phrase “[Insert Cell Reference Here]” in cell D32 with a cell reference to the No. Orders Discount Applied amount on the Calculations worksheet.
Note: Ensure that you only use cell referencing for the Totals data.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Modify the CustomerTable, ItemTable, OrdersTable, SuppliersTable, DataInput, Calculations and Report worksheets to a professional level of presentation, making sure that the data is formatted correctly. Use bold, italics, font size, font colours, shading, lines and borders.
Task 19: Scenarios
Using the Scenario Manager in Excel create and check the following eight (8) Scenarios using the Changing Cells of D4, D5 and D7 on the DataInput worksheet:
Scenario Markup Type Freight Type Exchange Rate Type
1 Store Rana Sons Freight LU
2 Store Rana Sons Freight TV
3 Store Vicky Run Transport LU
4 Store Vicky Run Transport TV
5 Supplier Rana Sons Freight LU
6 Supplier Rana Sons Freight TV
7 Supplier Vicky Run Transport LU
8 Supplier Vicky Run Transport TV
Note: Ensure you have a suitable scenario name for each scenario, eg. Scenario 1, Scenario 2 …
See the Beskeen Excel Unit K and the Videos provided in the Course Content section for more details on creating Scenarios.
Task 20: Scenario Summary
Using the Scenario Manager in Excel create a Scenario Summary worksheet from the DataInput worksheet based on the eight (8) Scenarios from Task 20 and focusing on the Result cells D12, D22, D25, D26, D28, D30, D31 and D32 on the DataInput worksheet.
Place the Scenario Summary worksheet between the Calculations and Report worksheets.
Note: Format your Scenario Summary worksheet to look professional as follows:
• Modify the heading of the Scenario Summary
• Remove the Current Value and Notes
• Label the Changing Cells and Results Cells
See the Beskeen Excel Unit K and the Videos provided in the Course Content section for more details on creating Scenarios.
Task 21: Documentation Worksheet
Add a Documentation worksheet after the four tables from Task 1. Put a heading at the top of the worksheet in cell A1 called Documentation. Ensure that contains all the recommended information for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations.
The Documentation Worksheet must demonstrate the following:
• A statement outlining the purpose of the Spreadsheet:
Purpose should outline why the Spreadsheet was created including – discussion about the Markup Type, Exchange Rate and Freight Type.
• A statement about the protection level that should be used on each Worksheet.
Protection should look at all 10 Worksheets and outline whether each sheet should contain protection and why.
DO NOT actually apply protection to your Spreadsheet – this will result in it being unable to be marked.
• A statement about how the user can access and use the Worksheets.
User Notes should provide a step by step guide for a new user to use the Spreadsheet from changing the values on the DataInput Worksheet to observing the outcome of these changes on both DataInput and Report Worksheets.
• A statement about what calculations have been used in the development of this Spreadsheet.
Calculations Notes should provide a brief description of each calculation found on the Calculations and Report Worksheets (does not need to discuss individual Cell References and VLOOKUPs – these can be discussed generally as a single calculation type).
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 22: Analytical Essay
Mrs Augusta Lanvele has asked you to write an analytical essay (between 750 and 1000 words in length) to the client, Dr Rod N Berry outlining the major issues that the Decision Support System’s results have highlighted. Create a Word 2007 to current version document and name it ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number’
(eg. genrichr_0050051005_CIS5100_assign2.docx).
Essays have a particular structure – An introduction, a body (where you write your answer in a number of paragraphs, usually one for each idea or topic) and a conclusion. The conclusion is where you sum up your ‘argument’. Essays normally do not have headings.
The information at the following URL may be useful:
http://www.usq.edu.au/learningcentre/assignment-skills/writing-assignments/essay-writing
The body of your essay should consider the following issues:
• Define what a Decision Support System is.
• Explain why a Decision Support System is the appropriate tool for this project.
• From the results of the Decision Support System results discuss the following (keeping in mind the information provided in the preamble on page 2):
1. Which Mark-up Type would be most appropriate for the business? Why?
2. How would the choice of the Mark-up Type impact on the customer’s decision to purchase from the company? Why?
3. What would be the impact on the business’s profit if the plan to provide a discount to large orders was implemented? Why?
4. Which Recommended Freight Type would be most appropriate for the business? Why?
5. What would be the impact that the different Recommended Freight Types would have on the business’s profit if the cost was transferred to the business instead of the customer (as discussed in the preamble)? Why?
6. Which country would be most appropriate for the business to import from at the moment? Why?
7. What issues could cause the business to rethink its choice of country of import? Why?
The essay should be using a proportional font (eg. Arial, Times New Roman etc.), with a font size of 11 or 12, and be laid out using 1 ½ line spacing.
Note: It is expected that you will use the Baltzan et al and Beskeen et al textbooks to answer the topics Mrs Augusta Lanvele has given you for the essay, as well as reputable online sources of information. You need to include a brief Bibliography formatted using the Harvard AGPS style on a separate page (see the following USQ website for referencing help: http://www.usq.edu.au/library/referencing/harvard-agps-referencing-guide.
Submission Guidelines
Attach the Excel (any version from Excel 2007 to current) & Word (any version from Word 2007 to current) files using the naming convention below, to your online assignment submission in the Assignment 1 area on the CIS5100 StudyDesk before midnight Australian Eastern Standard Time (AEST) on the day the assignment is due.
1. [lastname] [initial] _ [student number] _ [course code] _ assign2.xlsx (eg. genrichr_0050051005_CIS5100_assign2.xlsx).
2. [lastname] [initial] _ [student number] _ [course code] _ assign2.docx (eg. genrichr_0050051005_CIS5100_assign2.docx).
Note: Simply changing the file extension to .xlsx or .docx on an Excel 2003 or Word 2003 file will not result in a suitable submission. If the assignment files cannot be opened by the marker, it may be treated as late until a suitable replacement is received.
Upon completion of the submission process, check your uConnect email account for an automatically generated confirmation email (if you do not have an email account, print out the Submission Complete screen before exiting the Submission System). You must check that the file name and file size are listed correctly, if there is a problem with either, please email the course leader immediately.
If you have difficulties submitting through the StudyDesk Assignments submission tool, please review the Student Instructions document listed also on the CIS5100 StudyDesk. As a last resort only, email the course leader for instructions on an alternative course of action.
Please note that:
• The following is the USQ Assessment – Assignment (Late Submission) and Compassionate and Compelling Circumstances procedure that relate to Extensions and Late Assignments. They can be found under the following links:
? Assessment – Assignment (Late Submission) Procedure: http://policy.usq.edu.au/documents.php?id=14749PL#4.2_Assignments
? Assessment of Compassionate and Compelling Circumstances Procedures: http://policy.usq.edu.au/documents.php?id=131150PL
• Students seeking extensions for any Assignment work must provide appropriate documentation to support their request before the due date of the assignment (see points 4.3 and 4.4 in the Assessment of Compassionate and Compelling Circumstances Procedures above to see what is considered as Compassionate and Compelling reason for an extension and the level of documentation that will be needed).
• An Assignment submitted after the due date without an approved extension of time will be penalised. The penalty for late submission is a reduction by five percent (5%) of the maximum Mark applicable for the Assignment, for each University Business Day or part Business Day that the Assignment is late. An Assignment submitted more than ten (10) University Business Days after the due date will have a Mark of zero recorded for that Assignment.
? The StudyDesk Assignments submission toolwill accept late assignments up until 23:55pm on the 10th University Business Day after the due date.



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

CLWM4000 Business & Corporations Law Assignment

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

CLWM4000 Business & Corporations Law Assignment
A 1,200 (+- 10%) word individual assignment on a problem question to be submitted electronically via Turnitin
Assignment Question
Linyu wants to buy a car. She inspects several different vehicles advertised as brand new at a car dealership owned by Yuan. She likes the look of a black Mitsubishi Pajero with leather seats and price of $44,990. Yuan convinces her that it is a great deal even though he knows the car has a defective gear box. He can tell Linyu doesn’t understand English very well so he inserts a clause into the purchase agreement waiving her protection under the Australian Consumer Law statutory guarantees.
One week later the car breaks down. Linyu has it towed to a Mandarin speaking mechanic who explains the car has travelled over 7,000kms and has a defective gear box.
Yuan refuses to refund Linyu her money. He points out she agreed to waive her protection under the statutory guarantees when she signed the purchase agreement and claims she is not a consumer under the Australian Consumer Law anyway because the car cost more than $40,000.
Advise Linyu of her rights under the Australian Consumer Law.
Introduction:
Write follow: IRAC
I (Issue)
R (Rule)
A (Application)
C (Conclusion)

 



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

Show All Steps In Problem Solving To Receive Full Marks. X EACH Question Is Worth 5 Marks.

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

SSIGNMENT 2 DUE: 6th Jan 2017 at 2pm
x Attach an assessment cover sheet x Late assignments: 10% will be deducted for each day assignment is late.
x If you copy or let other students copy any answers from your assignment, you will receive no marks.
x Show all steps in problem solving to receive full marks. x EACH question is worth 5 marks.
Question 1:
A drum of 50 cm radius is rolling along the ground at a speed of 8.5 m/s.
a) What is the rotational speed of the cylinder about its axis?
b) What is the magnitude and direction of acceleration of a point on the drum’s surface?
c) At the instant when the certain point on the drum’s surface is at the top of the drum, what is the velocity of the point?
d) At the instant when the certain point on the drum’s surface is at the top of the drum, what is the velocity of the point?
Question 2:
Two thin hoops with masses m1 and m2 with radii r1 and r2 are mounted rigidly on a frame of negligible mass. Find the moment of inertia of the system about an axis perpendicular to the page and through the centre of the hoops.
Question 3:
The lower (orange) disk is coasting with angular speed ?1. The combined moment of inertia of the disk and the axle is I1. A second disk (grey) with moment of inertia I2 is dropped onto the first disk and rotates with the first disk. Find the angular velocity of the combined disks when the original angular velocity of the grey disk was:
a) ?2 = 0
b) ?2 = 2 ?1 and is in the same direction as ?1
c) ?2 = 1.2 ?1 and is in the opposite direction as ?1
Question4:
The equation of motion of a simple pendulum is given by:
Find the: a) amplitude, b) frequency, c) period d) phase change in degrees and e) length, L of the pendulum
Question 5:
A 0.45 m long string oscillates in five segments when a frequency of 250 Hz is used to drive it. What is the: a) wavelength, b) speed of the wave, c) what frequency will cause the string to vibrate in the fundamental harmonic?
Question 6:
A police car chases a speeding car along a straight road. Both vehicles move at 120 km/hr. The police car siren has a frequency of 510 Hz. What is the Doppler shift in the frequency heard by the speeding car?
Question 7:
The shear modulus for a metal is 5.5 x1010 Nm-2. A shear force of 250 N is applied to the upper surface of a cube of this metal. The cube measures 5cm along each edge. How far will the top surface be displaced?
Question 8:
The pipe near the lower end of a large water storage tank springs a small leak, and a stream of water shoots out. If the top of the water in the tank is 15 m above the leak, at what speed does the stream of water travel out of the hole? If the hole has an area of 1.5 x 10-6 m-2, how much water flows out in 5 s?
Question 9:
The density of ice is 917 kgm-3 and the approximate density of the seawater in which an iceberg floats is 1050 kgm-3. What fraction of the iceberg is beneath the surface of the water?
Question 10:
A small glass sphere has a radius of 0.25 mm and a density of 2500 kgm-3 . The sphere is dropped in a vat of oil (? = 920 kgm-3, ? = 0.23 PI). Find a) the buoyant force on the sphere, b) the gravitational force on the sphere, c) use Stokes law to find the terminal speed of the sphere as it falls through the oil.
Question11:
A uniform solid brass sphere of radius, r, and mass, m, is set spinning with angular speed ? about an axis through the diameter of the sphere. If the temperature is increased from room temperature, 25oC, to 95oC without disturbing the sphere, determine a) the angular speed and b) the rotational kinetic energy at 95oC.



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

CLWM4000 Business & Corporations Law Assignment

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

CLWM4000 Business & Corporations Law Assignment
A 1,200 (+- 10%) word individual assignment on a problem question to be submitted electronically via Turnitin
Assignment Question
Linyu wants to buy a car. She inspects several different vehicles advertised as brand new at a car dealership owned by Yuan. She likes the look of a black Mitsubishi Pajero with leather seats and price of $44,990. Yuan convinces her that it is a great deal even though he knows the car has a defective gear box. He can tell Linyu doesn’t understand English very well so he inserts a clause into the purchase agreement waiving her protection under the Australian Consumer Law statutory guarantees.
One week later the car breaks down. Linyu has it towed to a Mandarin speaking mechanic who explains the car has travelled over 7,000kms and has a defective gear box.
Yuan refuses to refund Linyu her money. He points out she agreed to waive her protection under the statutory guarantees when she signed the purchase agreement and claims she is not a consumer under the Australian Consumer Law anyway because the car cost more than $40,000.
Advise Linyu of her rights under the Australian Consumer Law.
Introduction:
Write follow: IRAC
I (Issue)
R (Rule)
A (Application)
C (Conclusion)



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

Task 2 Covers The Study Schedule Weeks 5-12 Inclusive And Includes The Application Of Conceptual And Technical Aspects Of Accounting And The Preparation Of Business Financial Statements

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

Submission method options
Alternative submission method
Task
Task 2 covers the study schedule weeks 5-12 inclusive and includes the application of conceptual and technical aspects of accounting and the preparation of business financial statements, the appraisal of the use of information technology including spreadsheet software, to demonstrate business communication skills including report writing, to contextualise and evaluate accounting information for decision making, to explain the importance of ethics in accounting.
In today’s business environment we need verbal skills, writing skills, numeracy skills AND digital literacy skills. All of these skills are assessed throughout this subject. The early questions in this assignment are designed to assess your digital literacy in a business/accounting environment. It is suggested that you attempt the assignment questions week by week.
Presentation
Please read this in conjunction with the assignment requirements below.
• Single spacing and small margins are welcome to save paper.
• For any business report style questions a report structure is expected.
• Provide references throughout your assignment including page references to texts, articles and URL’s of websites.
• APA is the referencing style used by the Faculty of Business. Acknowledge ALL sources used.
• At the end of your assignment include a complete Bibliography (Reference List) of resources actually used including the Internet, textbook, Interact resources, software help files and videos supporting this subject.
The work you submit must be your own. In the past a few students have received heavy penalties for submitting assignments which were not entirely their own work.
1. Submit your assignment via Turnitin. Your Turnitin submission will consist of two files – a Word file and an Excel file.
2. The first page of your assignment Word document should consist of the following parts:
• subject code and name;
• your name and student ID number;
• assignment task number;
• a list of questions attempted and a list of questions not attempted;
• an academic integrity statement that the work submitted is your own and that all sources used have been acknowledged.
• dates and details of any extension granted; usually include a copy of the approval email;
• an acknowledgement of all your sources, and
• The following statement can be used: THE WORK IN THIS ASSIGNMENT IS MY OWN WORK, AND HAS NOT BEEN PLAGIARISED.
3. Record your name, student number and page number as a footer on every page of your Word document.
4. Present assignment solutions in your Word document in the same sequence as the questions. Provide references throughout (question by question if appropriate) and include a bibliography of all sources used including internet resources, at the end of your assignment. If using internet resources, include the URL and date of access. Use APA 6th style.
5. Please check for viruses. Do not use macros in your spreadsheet files.
Spreadsheet requirements
1. For every question with a spreadsheet solution, paste in the Word document displaying row and column headings, the spreadsheet solutions normal view and a formula view of each spreadsheet,
Thus your Word file will provide a complete answer to every question.
The pasted formula view may need to have adjusted column widths to display formulas correctly. Use portrait orientation wherever possible. The separate Excel file will provide a clear demonstration of correct spreadsheet structures. You may need to break up your report/solution into separate images.
2. For good spreadsheet design it is very important that you have completely separate data entry and solution/report areas. A good spreadsheet solution format is to key in the question in a structure which allows the solution to be completely formula driven. There should be no data in the report/solution area.
3. Create all spreadsheets solutions as separate spreadsheets in one workbook. Name the tags at the bottom of the computer screen with the question number, and sub-section as appropriate. See examples in the Spreadsheet Advice PDF in Interact Resources.
4. Save your workbook with the cursor in cell A1 of the first spreadsheet.
5. Where appropriate, use the IF function to provide built in checks of balances, net income/net loss, favourable/unfavourable variances etc.
6. How can you display negative numbers in brackets? Google the question! Hint. Format / Cells / Number and select Custom. Enter this: #,##0;(#,##0);0.
7. We have provided spreadsheet examples to guide you in the Spreadsheet Advice PDF in Interact2 Resources – it is important that you study these examples. Also consider using the spreadsheet templates available with your text and other online spreadsheet resources but note that the text templates do not necessarily comply with the subject spreadsheet requirements.
Solutions to questions should vary in length according to the nature of the question. Solutions to exercises and problem questions should be in a similar form to that demonstrated in the text.
Submit your work electronically through Turnitin.
The work you submit must be your own. In the recent past a few students have received heavy penalties for submitting assignments which were not entirely their own work.
Some questions require a spreadsheet. Check the Assignment and Spreadsheet Requirements above
AND the Spreadsheet Advice PDF. Also check the interactive videos.
Present your solutions in exactly the same sequence as specified in this Subject Outline.
Students should normally submit the assignment only once. Multiple copies received by the
University can result in unnecessary delays.

Q2-1 Naming cells in spreadsheets
In a spreadsheet why replace cell references with names? Paste a simple example of a formula using names rather than cell references. For example Sales less Expenses = Net Profit. Create your own example.
Q2-2 Negative numbers
How can negative numbers be displayed in brackets; in red? Paste a simple spreadsheet example.
Q2-3 Separation of data and report areas
Evaluate why an accountant should design spreadsheets with a completely separate data entry area and a separate report area? Paste a simple spreadsheet example.
Q2-4 IF functions
What is an ‘IF’ statement (function)? Provide a spreadsheeted accounting example.
Q2-5 Spreadsheet apps
Microsoft Excel is an example of spreadsheet software. List four further examples of spreadsheet software. Evaluate the importance of spreadsheet software to computer development. Hint. Google VisiCalc.
This group of questions above can be answered from any source including internet resources.
Q2-6 Perpetual versus Periodic systems
Explain the essential differences between perpetual and periodic inventory systems. Give examples of products/situations suited to each. (Watch the 3 videos on Inventory in Interact2 Resources).
Q2-7 Journal entries
Show the journal entries for perpetual inventory and periodic inventory systems for the purchase and sale of inventory. (Watch the 3 videos on Inventory in Interact2 Resources).
Q2-8 Worksheet and financial reports
Watch the Foot Worksheet movie in Interact2 resources. Download the relevant doc file also on Interact2 resources. This doc file has a template of the example below.
Examine the original data from the video. Create a new report/solution and change every number and enhance/improve the example to prepare a ten column spreadsheeted worksheet and the Financial Reports. Do not create journal entries or ledger accounts. Ensure your trial balance still balances after your data changes. The changes should be your personal choice. So your solution will be unique.
Follow the spreadsheet requirements including a separate data entry and report area and implement IF functions wherever appropriate. As usual, paste the normal view and the formula view.
Write a business report evaluating spreadsheets as a tool for accounting. You may wish to search the Internet with terms such as “advantages of spreadsheets”. Use the following resource to help you prepare and format your report: http://bit.ly/FoBAcademic-Writing-Skills
Q2-9 Accounting principles
List and explain two accounting principles or concepts relevant to inventory. Give your own examples.
Q2-10 Inventory flow assumptions
List and explain the three major inventory costing (flow) methods.
Q2-11 Application of Inventory flow assumptions.
Create a well-designed spreadsheet to solve the following assuming periodic inventory. Make several of your own changes to the original data and create a new solution. Paste the two solutions and one formula view. Highlight your changes.

Q2-12 Thinking about internal control issues.
How is the separation of duties an example of internal control? Give two examples.
Q2-13 Bank Reconciliation
A. Write a brief introductory scenario and create your own bank reconciliation spreadsheet. You may choose to use a text example as a template but use your own numbers. Your spreadsheet will demonstrate all the usual spreadsheet requirements and will include an IF function.
B. Why do firms construct bank reconciliation statements on a regular basis?
Q2-14 Journalising accounts receivable entries.
Using your text as a resource, show the T accounts needed to show sales on credit, the collection of part of the amount owing, the write off of accounts receivable, the reinstatement of an amount written off and the collection in full of the amount owing. Create your own numbers. A spreadsheet is not required.
Q2-15 Estimating bad debts
Contrast two different methods of estimating bad debts. Create simple examples.
Q2-16 Evaluation of a firm’s financial position
How can we use receivables to evaluate a firm’s financial position?
Q2-17 Percentage of sales method
Spreadsheet required.
Following are some selected transactions of David Jones (DJ) during 2015 and 2016. Reporting date is 31 December. DJ uses the allowance method and makes adjusting and closing entries on reporting date.
2015
31 December DJ estimated that bad debt expense for the year was 5% on credit sales of $1,500,00 and recorded that amount as expense.
31 December Made the closing entry for bad debt expense.
10 January DJ sold $8,000 of inventory to Mills & Brown (MB) on account
2016
20 June DJ wrote off the receivable from MB after repeated efforts to collect.
25 July DJ also failed to collect $13,000 receivables from BK and $10,000 from MM with no hope to collect them in future.
15 August DJ received an apology letter for paying late and $8,000 from MB.
31 December DJ estimated that bad debt expense for the year was 4% on credit sales of $2,000,000 and recorded that amount as expense.
31 December Made the closing entry for bad debt expense.
Required:
1. Record the transactions in the general journal and post to the two ledger accounts.
2. Open general ledger T accounts for Allowance for doubtful debts and Bad debt expense. All accounts begin with a zero balance.
3. The 31 December 2016 balance of Accounts receivable is $500,000. Show how Accounts receivable would be reported on the balance sheet at that date.
Q2-18 Dishonour of a note receivable
Write a scenario which includes a credit sale, a conversion to a Note receivable, the dishonour of the note and subsequent delayed payment. Show the T accounts. Create your own simple numbers.
Q2-19 Account classification
What kind of account is Goodwill, Allowance for bad debts, Accumulated depreciation? Explain. Refer to the P A L E R mnemonic.
Q2-20
Work Integrated Assessment case study
Qantas Annual Report
Learning Objectives: The subject you are studying is vocational. It is designed with the workplace in
mind. Work integrated assessment provides opportunities for students to link theory and skills learned
in a subject to a real work context. Students can use these opportunities to develop and practice the
professional and academic skills they learn about in a subject or through the online environment and
then be assessed on their capabilities in these simulated authentic environments. Work integrated
assessment allows students to simulate and situate their learning in an authentic workplace that
encourages them to explore their knowledge and apply it to practice. Integrating real world, authentic
assessment tasks allows students to learn about the particular environments and culture of their chosen
professions, while at the same time absorbing and practicing the skills they need to succeed. Doing
these tasks can help students develop skills that can help their employability.
Resources for this task include the 2015 Annual Report for Qantas.
Your friend Bob is studying architecture at another University and knows very little about accounting
and annual reports. Bob’s uncle gave him $30,000 recently to invest. Bob knows you have begun
studying accounting and is considering buying Qantas shares. Bob has some questions for you.
Present your answers concisely in a business report format.
Bob’s questions:
1. What is the Balanced Scorecard and how is this relevant to Qantas?
2. In summary, how much were the Executives paid in 2015?
3. What expertise does Todd Sampson bring to the Board of Directors?
4. Explain Revenue Seat Factor, EBITDA, Revenue received in advance and Retained Earnings.
5. Calculate and comment on the Working Capital ratio.
6. Create a two charts in Excel from any data in the Qantas report showing 3D columns and a pie chart. Paste the spreadsheet graphs in your assignment. Show the data area.
7. Summarise your advice to Bob re the investment decision.
Find the Qantas 2015 Annual Report on the web.

Rationale
Assessment task 2 is designed to give you further opportunity to demonstrate knowledge and skills in more in-depth aspects of accounting and information systems including bank reconciliation, inventory systems, financial reports, accounting for bad debts and notes receivable, as well as concepts and the application of spreadsheet software to the presentation and solution of accounting problems.
Marking criteria
Your assignment will be marked as a whole with recognition being given to demonstration of knowledge, quality thinking, application of skills and critical thinking.
For some questions you have a chance to demonstrate some creativity, or provide your own examples or give evidence of wider reading or to structure a spreadsheet in an innovative manner. You also need to avoid the snowballing effects of cumulative errors – that is, an error early in a practical question which carries through. Full marks are a possibility for well structured, complete, quality answers.
You will be provided with a mark based on the work submitted and you will also be provided with suggested solutions or guidelines. Feedback will normally consist of the mark, specific comments and guideline solutions.
High Distinction. To meet this level, you will attain a cumulative mark between 85%-100%. A mark in this range indicates that you have met the learning outcomes for this task to an exceptional level, including skilfully applying correct analytical methods and techniques, deconstructing information and reflecting on different accounting and financial management ideas and interpretative techniques applied in management decision making and efficient allocation of business resources, and creating professional reports and spreadsheets that can be used in management decision making.
This mark also indicates your assignment will:
• be professionally presented with correct spelling and grammar
• be the result of your original work
• include complete references and acknowledgment of all sources used according to APA 6th style
• be complete without any omissions
• be correct
• evaluate comprehensively the issues raised in the questions
• provide examples where appropriate, and
• comply with all spreadsheet requirements.
Distinction. To meet this level, you will attain a cumulative mark between 75%-84%. A mark in this range indicates that you have comprehensively met the learning outcomes for this task, including competently applying correct analytical methods and techniques, judging between different accounting and financial management ideas and interpretative techniques in management decision making and efficient allocation of business resources and designing reports and spreadsheets for effective use in management decision making.
This mark also indicates your assignment will:
• be neatly presented with very few spelling and grammatical errors,
• be the result of your original work,
• include references, acknowledging all sources used according to APA 6th style
• be mostly complete
• evaluate many of the issues raised in questions
• provide examples where appropriate, and
• comply with most spreadsheet requirements.
Credit. To meet this level, you will attain a cumulative mark between 65%-74%. A mark in this range indicates that you have thoroughly met the learning outcomes for this task, including differentiating between different analytical methods and techniques to be applied, determining a course of action using accounting and financial management ideas and interpretative techniques for management decision making and efficient allocation of business resources, and assembling reports and spreadsheets for use in management decision making.
This mark also indicates your assignment will:
• be neatly presented with few spelling and grammatical errors
• be the result of your original work
• include references, acknowledging sources used according to APA 6th style
• be mostly complete
• be mostly correct with only a few errors
• evaluate many of the issues raised in questions
• provide some examples where appropriate, and
• comply with most spreadsheet requirements.
Pass. To meet this level, you will attain a cumulative mark between 50%-64%.
A mark in this range indicates that you have met the learning outcomes for this task to a basic level, including responding to questions with limited options for applying analytical methods and techniques, selecting accounting and financial management ideas and interpretative techniques for management decision making and efficient allocation of business resources, and generating basic reports and spreadsheets that could be used for management decision making.
This mark also indicates your assignment will:
• be neatly presented,
• be the result of your original work,
• include some references and acknowledge sources used according to APA 6th style,
• be mostly complete without too many omissions,
• be mostly correct with some errors
• evaluate some of the issues raised in questions
• provide some examples where appropriate, and
• comply with most spreadsheet requirements
Your assignment consists of different question styles including discussion questions, reports, exercises, problem questions and spreadsheet questions.
The marking criteria for your assignments will be based on the content of the subject as identified by the learning objectives of the various topics. Good computer spreadsheet models will comply with the spreadsheet requirements.
Normal distribution curves for grades are not utilised in this subject. Penalties will apply for late submission at 10% of the total mark available per day. It is important that submitted assignments are complete; omitted answers will result in mark deductions. Refer to the University regulations contained in the CSU online handbook for matters pertaining to special consideration, misadventure and extenuating circumstances, academic misconduct, code of conduct for users of electronic facilities, assessment regulation, grading scale, progression and academic performance, grade point average, examination regulations and other matters pertaining to assessment. The regulations can be found at the University’s web site: http://www.csu.edu.au
Any assignments with significant evidence of plagiarism may be referred to the university’s academic misconduct processes and will receive a grade of zero.
An example of marking criteria for an essay/business report follows. Some of the same criteria apply to larger discussion style questions and case studies and business reports.
Example criteria used in marking essays/discussion questions/case studies/business reports
While there is no particular format required for these answers, the following criteria are likely to be used. Note that business reports are normally more structured than essays.
Criteria
• Relevance of the answer. Are the important issues raised in the question identified? Did the student answer the question?
• Critical capacity. Has reference material been carefully analysed or critically accepted?
• Structure of the answer. Is the answer well-structured and the argument logically developed?
• Writing style. Is the style concise and lucid or confused, making it difficult for the reader to get the point?
• Scope of reading. Does the answer indicate a satisfactory coverage of literature relevant to the questions?
Answers should:
• be well planned with arguments flowing logically;
• use correct sentence structure, punctuation and spelling;
• present original ideas where appropriate;
• and present a justified conclusion and acknowledge all sources.
Normal distribution curves for grades are not utilised in this subject. Penalties will apply for late submission at 10% of the total mark available per day. It is important that submitted assignments are complete. Omitted answers will result in mark deductions. Refer to the University regulations contained in the CSU online handbook for matters pertaining to special consideration, misadventure and extenuating circumstances, academic misconduct, code of conduct for users of electronic facilities, assessment regulation, grading scale, progression and academic performance, grade point average, examination regulations and other matters pertaining to assessment. The regulations can be found at the University’s web site: http://www.csu.edu.au
Assessment item 4



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

HI6007 Assessment One Business Research Report Proposal: Initial Research Proposal

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

HOLMES INSTITUTE
FACULTY OF HIGHER EDUCATION
HI6007 Assessment One
Business Research Report Proposal: Initial Research Proposal
Due Friday Week 06
1500 words worth 20%
The initial research proposal will consist of the following SIX (6) items:
1. Identify a business research topic
2. Define the research questions for the identified problem or opportunity
3. Select the appropriate research methodologies and techniques to use for the research project
4. Describe the research process
5. Describe data collection and analysis methods
6. Describe expected research outcomes
Material on Research Methods will be presented in class from week 4 to 6.
Initial Research Proposal due at the end of Week 6
Here are some questions to help you develop your business research proposal:
PROBLEM STATEMENT:
What exactly do I want to find out?
What is a researchable problem?
THEORY, ASSUMPTIONS, BACKGROUND LITERATURE:
What does the relevant literature in the field indicate about this problem?
VARIABLES AND HYPOTHESES:
What will I take as given in the environment i.e. what is the starting point? Which are the independent and which are the dependent variables?
OPERATIONAL DEFINITIONS AND MEASUREMENT
Does the problem need scoping/simplifying to make it achievable?
What and how will the variables be measured?
What degree of error in the findings is tolerable?
RESEARCH DESIGN AND METHODOLOGY
What is my overall strategy for doing this research?
Will this design permit me to answer the research question? What constraints will the approach place on the work?
INSTRUMENTATION/SAMPLING
How will I get the data I need to test my hypothesis?
What tools or devices will I use to make or record observations?
How will I choose the sample?
What degree of accuracy or level of confidence can I guarantee?
DATA ANALYSIS
What combinations of analytical and statistical process will be applied to the data? Which of these will allow me to accept or reject my hypotheses?
CONCLUSIONS, INTERPRETATIONS, RECOMMENDATIONS
Was my initial hypothesis supported or rejected? Why?
What are the implications of my findings for the theory base, for the background assumptions, or relevant literature?
What recommendations result from the work?
What suggestions can I make for further research on this topic?
MARKING SCHEME
Identify business research topic and
Define the research questions for the identified problem or opportunity.
Excellent
8-10
Good
6-7 Average
5 Not adequate 3-4 Poor 0-2
Clearly justified topic
Well defined questions
Importance and value of research topic and problem
Well referenced literature to research topic
Comments: /40%
Select the appropriate research methodologies and techniques to use for the research project Describe the research process
Excellent 8-10 Good
6-7 Average
5 Not adequate 3-4 Poor 0-2
Selection of suitable research method
Steps of research process described
References used to justify choices
Comments: /30%
Describe data collection and analysis methods
Describe expected research
outcomes
Excellent 8-10 Good
6-7 Average
5 Not adequate 3-4 Poor 0-2
Suitable data collection method
Description of data analysis to be done
Description of expected results
Comments: /30%
Overall Comments TOTAL /100%

 



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

AF314 Corporate Accounting

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

AF314 Corporate Accounting
Flexi-School – 2016
Individual Assignment (20%)
1. Due Date: Thursday 5th January (by 4pm) at the SOAF office. Penalty at 10% per day.
2. Must be word-processed, not hand written, word size 12 with ‘Times new roman’ font type and double-spacing.
3. Each answer must be clearly marked by the designated question to which it corresponds.
4. Please list any references (books, articles, web-based material) you use at the end of your assignment in alphabetical order, using the referencing style seen in academic articles (i.e. with in text references and bibliography, as in the Harvard referencing style).
Background Information
On 1 August 2015, you have recently been appointed as the new financial accountant of Perpetual Pty Limited (“the company”), a large proprietary company that is incorporated in Australia. The company has a year end of 30 June. The current year (June 2015) draft financial statements are attached as Appendix B and are due for issue on 30 September 2015.
The company has been in operation for approximately Sixty years and has acquired an entity during the year ended 30 June 2015 to help diversify its operations, as the market in which they operate is becoming stagnant. The acquired entity is a holiday resort, offering hotel accommodation, food and beverage and entertainment. The name of this entity is Hotelier Pty Limited, and its acquisition date was 31 August 2014. The entity is 100% controlled by Perpetual Pty Limited.
The Financial Controller, Karen Grant, your boss has recently been appointed to Perpetual Pty Limited and wants to ensure that the reporting and disclosure in the financial statements is accurate and reflects what best practice is for a mature large proprietary company. She has heard that you are a recently qualified CPA and would like to enlist your expertise to ensure some areas that are new for the current year’s financial statements are reflected correctly.
She is seeking the following information from you in a report:
1. Identification of the impact(s) of the five key items identified in Appendix A by the Financial Controller on the June 2015 financial statements. You should also clearly outline all aspects of the disclosure required in the financial report, as appropriate. Explain your decision with reference to the current financial reporting framework, citing relevant accounting standard references where appropriate;
2. A review of the attached draft June 2015 financial statements (Appendix B), highlighting five key financial reporting and disclosure issues that are missing and/or incomplete, other than the five items identified in point 1 above. The report should clearly highlight the issue(s), the impact on the financial statements and the additional information required with reference to the relevant accounting standards, as well as the recommendation to the Financial Controller on how to resolve the issue(s). When referring to the standards, do not quote directly; you should summarise the important points to show your understanding; and
3. Identification and brief discussion of three key financial reporting challenges in the preparation of the completed financial report for June 2015, given the changing nature of the company in the current year.
Appendix A
Five Key Items Identified by the Financial Controller
Your new boss, Karen Grant, has noted the following five key items that have arisen in this current financial year that still need to be resolved from a reporting and disclosure viewpoint. These items are yet to be reflected in the draft financial statements attached as Appendix B:
1. The following two events have taken place during the year:
(a) Hotelier Pty Limited has been involved in a dispute with a customer who had food poisoning while dining in the restaurant. The incident occurred on 25th June. Hotelier Pty Limited has obtained legal advice that the company was to be responsible for the incident and damages could amount to $250,000.
(b) On the 31 July 2015, Hotelier Pty Limited received notification that a customer owing $85,000 had gone into liquidation. The liquidator advised that unsecured creditors are likely to receive a distribution only 15c in the dollar. The liquidation was caused by a flood in Apr 2015.
2. Hotelier Pty Limited purchased an investment on 1 July 2014 for the value of $1.5 million. The investment is in a property trust fund and, although not highly liquid, the fair value of the shares as at 30 June 2015 was $1.1 million.
3. Hotelier Pty Limited acquisition generated a goodwill value of $350,000. What is the impact of this goodwill on the balance sheet as at 30 June 2015 and what are the tax consequences relating to this goodwill value?
4. During the preparation of Perpetual Pty Limited financial statement for the year ended 30 June 2015 it was discovered that a fraud has taken place in the previous financial year. An employee who left in May 2014 has taken $10 million from the business to his offshore bank account when making online global payments.
5. Perpetual acquires loan stock in another entity on 1 October 2014 and is entitled to receive fixed interest annually until the loan stock is redeemed in 5 years time. It is the intention of the company to hold this investment for the full 5 year term.
Appendix B – Financial Statements of Perpetual Pty Limited 30 June 2015
Financial Statements – Perpetual Pty Limited
Income Statement as at 30 June 2015
Note 2015 2014
A$’000 A$’000
Accommodation revenue 109,294 83,455
Flights and other revenue 9,526 5,589
Interest received and receivable 2,486 4,952
Total revenue 121,306 93,996
Advertising and marketing expenses 11,670 9,986
Business development expenses 10,758 5,751
Operations and administration expenses 36,686 29,306
Total expenses 59,114 45,043
Profit before income tax 62,192 48,953
Income tax expense 2 18,665 14,501
Net Profit 43,527 34,452
Total Other Comprehensive Income – –
Total Comprehensive Income 43,527 34,452
The accompanying notes form part of these financial statements.
Financial Statements
Balance Sheet as at 30 June 2015
Note 2015 2014
A$’000 A$’000
Current Assets
Cash and cash equivalents 4 101,761 57,197
Bank term deposits 5 0 2,962
Trade and other receivables 6 4,276 5,206
Total Current Assets 106,037 65,365
Non-Current Assets
Deferred income tax asset 9,623 8,321
Other receivables 134 107
Available for sale investment 939 833
Property, plant and equipment 9,157 629
Intangible assets and goodwill 87,825 87,284
Total Non-Current Assets 107,678 103,898
Total Assets 213,715 169,263
Current Liabilities
Trade and other payables 7 134,385 103,874
Interest bearing liabilities 105 109
Income tax payable 3,745 5,119
Provisions 8 1,125 1,051
Total Current Liabilities 139,360 110,153
Non-Current Liabilities
Interest bearing liabilities 146 233
Deferred income tax liabilities 2,678 2,678
Provisions 364 233
Total Non-Current Liabilities 3,188 3,144
Total Liabilities 142,548 113,297
Net Assets 71,167 55,966
Equity
Contributed Equity 9 22,890 22,321
Retained Earnings 43,531 32,270
Reserves 4,746 1,375
Total Equity 71,167 55,966
The accompanying notes form part of these financial statements.
Financial Statements
Cash Flow Statement as at 30 June 2015
Note 2015 2014
A$’000 A$’000
Cash Flow from Operating Activities
Receipts from Customers 1,083,717 811,716
Payments to Suppliers and Employees (984,427) (755,962)
Interest Received 2,480 5,035
Income Taxes Paid (20,318) (14,510)
Borrowing costs (41) 0
Net cash flow from operating activities 81,411 46,279
Cash Flow from Investing Activities
Payments for plant and equipment (3,631) (2,242)
Payment for intangibles (38) 0
Purchase of investment (7,403) 0
Secured loan advanced 0 (55,849)
Secured loan repayment received 0 257
Net cash flow from investing activities (11,072) (61,739)
Cash Flow from Financing Activities
Proceeds from share issue 569 916
Dividends paid (32,266) (28,731)
Proceeds from borrowings 0 94
Lease payments (109) (61)
Net cash flow from financing activities (31,806) (27,782)
Net increase in cash held 38,533 (43,242)
Cash and cash equivalents at beginning of year 60,159 104,363
Net foreign exchange differences 3,069 (962)
Cash and cash equivalents at end of year 101,761 60,159
The accompanying notes form part of these financial statements.
Financial Statements
Notes to the Financial Statements As at 30 June 2015
Perpetual Pty Limited is a company limited by shares incorporated in Australia. The Company’s operations and principal activity is the provision of accommodation and travel services.
Note 1 – Summary of Significant Accounting Policies (a) Basis of Accounting
The Financial Report is a general purpose financial report, which has been prepared in accordance with the requirements of the Corporations Act 2001 and applicable Australian Accounting Standards and other mandatory professional requirements. It has been prepared on a historical cost basis, except for available-for-sale investments, which have been measured at fair value. The Financial Report is presented in Australian dollars and all values are rounded to the nearest thousand dollars (A$’000) unless otherwise stated under the option available to the Company under ASIC Class Order 98/0100. The Company is an entity to which the Class Order applies.
(b) Statement of Compliance
The Financial Report complies with Australian Accounting Standards, which include Australian equivalents to International Financial Reporting Standards (AIFRS). Compliance with AIFRS ensures that the Financial Report, comprising the financial statements and notes thereto, complies with International Financial Reporting Standards (IFRS).
(c) Revenue Recognition
The principal business of the Company is the earning of a margin from the sale of accommodation and travel services. When travel bookings are made they are paid for immediately by customers using their credit cards as verified by an online merchant facility. The Company recognises the revenue when customers have commenced their travel.
(d) Intangible Assets
IT development costs that relate to the acquisition of an asset to the extent that they represent probable future economic benefits controlled by the Company that can be reliably measured, are capitalised and amortised within the period of expected benefit, usually within 3 years. In the reporting period, all IT Development Costs have been capitalised and amortised within the reporting year.
IT costs incurred on research, advertising, marketing management, maintenance, and day-to-day enhancements of all IT applications are charged as an expense in the period that they are incurred.
Financial Statements – Perpetual Pty Limited
Notes to the Financial Statements As at 30 June 2015 (cont’d)
(e) Taxation
i. Income tax
Deferred income tax is provided on all temporary differences at the balance sheet date between the tax bases of assets and liabilities and their carrying amounts for financial reporting purposes.
Deferred income tax liabilities are recognised for all taxable temporary differences except:
• where the deferred income tax liability arises from the initial recognition of an asset or liability in a transaction that is not a business combination and, at the time of the transaction, affects neither the accounting profit nor taxable profit or loss; and
• in respect of deductible temporary differences associated with investments in subsidiaries, associates and interests in joint ventures, where deferred tax assets are only recognised to the extent that it is probable that the temporary differences will reverse in the foreseeable future and taxable profit will be available against which the temporary differences can be utilised.
The carrying amount of deferred income tax assets is reviewed at each balance sheet date and reduced to the extent that it is no longer probable that sufficient taxable profit will be available to allow all or part of the deferred income tax asset to be utilised.
Deferred income tax assets and liabilities are measured at the tax rates that are expected to apply to the year when the asset is realised or the liability is settled, based on tax rates (and tax laws) that have been enacted or substantively enacted at the balance sheet date.
Income taxes relating to items recognised directly in equity are recognised in equity and not in the income statement.
ii. Other taxes
Revenues, expenses and assets are recognised net of the amount of GST/VAT except where:
• the GST/VAT incurred on a purchase of goods and services is not recoverable from the taxation authority, in which case the GST/VAT is recognised as part of the cost of acquisition of the asset or as part of the expense item as applicable; and
• receivables and payables are stated with the amount of GST/VAT included.
The net amount of GST/VAT recoverable from, or payable to, the taxation authority is included as part of receivables or payables in the balance sheet.
Cash flows are included in the Cash Flow Statement on a gross basis and the GST/VAT component of cash flows arising from investing and financing activities which is recoverable from, or payable to, the taxation authority is classified as operating cash flows.
Commitments and contingencies are disclosed net of the amount of GST/VAT recoverable from, or payable to, the taxation authority.
Financial Statements – Perpetual Pty Limited
Notes to the Financial Statements As at 30 June 2015 (cont’d)
(f) Property, Plant and Equipment
Plant and equipment is stated at cost less accumulated depreciation and any impairment in value.
Depreciation is calculated on a straight-line basis over the estimated useful life of the asset as follows:
Plant and equipment – over 5 to 15 years
Impairment
The carrying values of plant and equipment are reviewed for impairment when events or changes in circumstances indicate the carrying value may not be recoverable.
For an asset that does not generate largely independent cash inflows, the recoverable amount is determined for the cash-generating unit to which the asset belongs.
If any such indication exists and where the carrying values exceed the estimated recoverable amount, the assets or cash-generating units are written down to their recoverable amount.
The recoverable amount of plant and equipment is the greater of fair value less costs to sell and value in use. In assessing value in use, the estimated future cash flows are discounted to their present value using a pre-tax discount rate that reflects current market assessments of the time value of money and the risks specific to the asset.
(g) Employee Benefits
A provision is made for employee entitlement benefits accumulated as a result of employees rendering services up to the reporting date. These benefits include wages and salaries and annual leave.
Liabilities arising in respect of wages and salaries, annual leave and any other employee entitlements expected to be settled within 12 months of the reporting date are measured at their nominal amounts.
Employee entitlement expenses arising in respect of the following categories:
• wages and salaries, non-monetary benefits, annual leave, sick leave and other leave entitlements; and
• other types of employee entitlements, are recognised against profit on a net basis in their respective categories.
Financial Statements – Perpetual Pty Limited
Notes to the Financial Statements As at 30 June 2015 (cont’d)
(h) Investments
All investments are initially recognised at cost, being the fair value of the consideration given and including acquisition charges associated with the investment.
After initial recognition, investments which are classified as available-for-sale are measured at fair value.
Gains or losses on available-for-sale investments are recognised as a separate component of equity until the investment is sold, collected or otherwise disposed of, or until the investment is determined to be impaired, at which time the cumulative gain or loss previously reported in equity is included in the Income Statement.
Investments in equity instruments that do not have a quoted market price in an active market and whose fair value cannot be reliably measured (and linked derivatives) are measured at cost.
For investments carried at amortised cost, gains and losses are recognised in income when the investments are de-recognised or impaired, as well as through the amortisation process.
For investments where there is no quoted market price, fair value is determined by reference to the current market value of another instrument that is substantially the same or is calculated based on the expected cash flows of the underlying net asset of the investment.
(i) Cash and Cash Equivalents
Cash and short-term deposits in the Balance Sheet comprise cash at bank and in hand and shortterm deposits with a maturity of 3 months or less.
For the purpose of the Cash Flow Statement, cash and cash equivalents consist of cash and cash equivalents as defined in the paragraph above.
(j) Provisions
i. Provision for dividends
A provision for dividends is not recognised as a liability unless the dividends are declared and determined on or before the reporting date.
ii. Provisions – general
Provisions are recognised when there is a present obligation (legal or constructive) as a result of a past event, it is probable that an outflow of resources embodying economic benefits will be required to settle the obligation and a reliable estimate can be made of the amount of the obligation.
(k) Contributed Equity
Issued and paid up capital is recognised at the fair value of the consideration received by the Company.
(l) Comparative Information
Where necessary, comparatives have been reclassified and repositioned for consistency with current year disclosures.
Financial Statements – Perpetual Pty Limited
Notes to the Financial Statements As at 30 June 2015 (cont’d)
(m) Recoverable Amount of Assets
The Company assesses at each reporting date whether there is an indication that an asset may be impaired. If any such indication exists, or when annual impairment testing for an asset is required, the Company makes an estimate of the asset’s recoverable amount. An asset’s recoverable amount is the higher of its fair value less costs to sell and its value in use and is determined for an individual asset, unless the asset does not generate cash inflows that are largely independent of those from other assets or groups of assets and the asset’s value in use cannot be estimated to be close to its fair value. In such cases the asset is tested for impairment as part of the cash-generating unit to which it belongs. When the carrying amount of an asset or cash-generating unit exceeds its recoverable amount, the asset or cash-generating unit is considered impaired and is written down to its recoverable amount.
In assessing value in use, the estimated future cash flows are discounted to their present value using a pre-tax discount rate that reflects current market assessments of the time value of money and the risks specific to the asset. Impairment losses relating to continuing operations are recognised in those expense categories consistent with the function of the impaired asset unless the assets are carried at revalued amount (in which case the impairment loss is treated as a revaluation decrease).
(n) Trade and Other Receivables
Trade and Other trade receivables are recognised and carried at the original invoice amount.
An estimate for doubtful debts is made when there is objective evidence that the Company will not be able to collect the debts. Bad debts are written off when identified.
(o) Trade and Other Payables
Trade payables and other payables are carried at amortised costs and represent liabilities for goods and services provided to the Company prior to the end of the reporting period that are unpaid and arise when the Company becomes obliged to make future payments in respect of the purchase of these goods and services.
(p) Significant Accounting Judgment Estimates and Assumptions i. Significant accounting judgments
In the process of applying the Company’s accounting policies, management has considered if there are judgments, apart from estimates, which will have a significant effect on the amount recognised in the financial statements and management has concluded there was one significant judgment made.
ii Significant accounting estimates and assumptions
There was a change in accounting estimate for the amortization period of the IT Development Costs. In the prior year the amortization period was 5 years.
Note 2015 2014
A$’000 A$’000
2. Income Tax
The major components of income tax expense are:
Income Statement
Current Income Tax
– Current income tax charge 19,184 14,514
– Adjustments in respect of current income tax of previous year (54) (67)
Deferred Income Tax
– Relating to origination and reversal of temporary differences (465) 54
Income tax expense reported in the income statement 18,665 14,501
Note 2015 2014
A$’000 A$’000
3. Dividends Paid or Provided
Dividend Paid
Fully franked dividend paid 32,266 28,731
Franking Account Balance
The amount of franking credits available for the subsequent financial year are:
– franking account balance as at the end of the financial year at 30% 13,807 8,647
– franking that will arise from the payment of income tax as at the end of the period
3,856
4,216
17,663 12,863
No dividends have been proposed for 2015
4. Cash and Cash Equivalents
Cash at Bank 81,839 47,952
Bank Term Deposit at Call 2,480 0
Client funds account 17,442 9,245
101,761 57,197
5. Bank Term Deposits – Current
Bank term deposit maturing after 3 months and within 6 months 0
2,962
6. Trade and Other Receivables
Trade debtors 3,591 4,562
Prepayments 685 644
4,276 5,206
Note 2015 2014
A$’000 A$’000
7. Trade and Other Payables – Current
Deferred Revenue 81,297 71,983
Trade creditors and accruals 53,088 31,891
134,385 103,874
8. Provisions
Employee benefits 1,125 1,051
9. Contributed Equity
20,000,000 fully paid shares 22,890 22,321
Notes to the Financial Statements As at 30 June 2015 (cont’d)
Note 2015 2014
A$ A$
10. Segment Information
The company operates in one business segment, being that of accommodation and travel services. For the purposes of the segment information revenue is determined by the location of the accommodation and travel destination rather than the residency of the customer. Expenses are determined by the location in which they are incurred. The Company operates in numerous geographical locations.
11. Auditors’ Remuneration
Amounts received or due and receivable by the auditors: 60,000 39,000
– an audit of the financial statements of the entity
– other services provided by the audit firm 11,665 25,744
71,665 64,744
12. Contingent Liabilities
At balance date the Company had bank guarantees of A$ 2,500,000 in respect of banking arrangements.
2015 2014
A$000 A$000
13. Commitments for Expenditure
The Company has a lease commitment with an unrelated party expiring on 31 August 2015.
Remuneration commitments for the payment of salaries and other remuneration under long-term employment contracts in existence at the reporting date, but not recognized as liabilities, payable as follows:
– Total 2,600 1,000
14. Events After Balance Date
On 28 July 2015, the Company entered into an exclusivity agreement with a travel provider, Happy Holidays.
Notes to the Financial Statements As at 30 June 2015 (cont’d)
15. Financial Risk Management Objectives and Policies
Interest rate risk:
The Company’s exposure to the risk of changes in market interest rates relates primarily to its’ cash at bank and short term deposits. The Board has resolved that the risk of the rate change should not be hedged.
Foreign currency risk:
The Company has transactional currency exposure. This exposure arises from the margin achieved on sales in currencies other than the Company’s functional currency being Australian dollars. This risk is not considered to be material. The Board has resolved that the risk of exchange rate risk should not be hedged.
Credit risk:
The Company trades only with recognized, credit worthy third parties. The principal trade receivables are amounts owing from credit card companies, which typically settle within 5 days. Receivables balances are monitored on an ongoing basis with the result that the Company’s exposure to bad debts is not considered to be significant.
There are no significant concentrations of credit risk within the Company.
The fair value does not differ from the carrying amount of assets and liabilities within the Company.



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

BSBDIV501 MANAGE DIVERSITY IN THE WORKPLACE

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

BSBDIV501
MANAGE DIVERSITY IN THE WORKPLACE
(Electronic copy of Participant guide questions)
Student Name:
Date of Submission:
Course: Diploma in Leadership and Management
Formative Assessment
Activity 1:
1. Use the internet to research the diversity policy for an organisation of your choice. Review the policy for compliance with relevant legislation and quality of information including: reliability, accuracy and currency. Prepare a brief report on the effectiveness of the policy and include recommendations for improvements where appropriate.
(750 words)
2. What is the relationship between legislation and workplace policies and procedures? How do policies and procedures contribute to managing regulatory compliance?
(250 words)
Activity 2:
1. What is a diversity strategy?
(60 words)
2. Why are objectives an important part of a diversity strategy?
(75 words)
3. Identify three key results areas relating to an organisation’s diversity strategy and explain how the organisation might establish whether the result is being achieved.
(120 words)
4. Use the internet to research the equal opportunity policy of an organisation of your choice. Determine specific ways in which components of the policy could be applied in the workplace.
(250 words)
Activity 3:
1. List three reasons why an organisation should communicate their diversity strategy.
2. What method/s could managers use to communicate their organisation’s diversity strategy to new employees? Explain why you would recommend these methods.
(160 words)
3. You work for an organisation whose workforce has traditionally been males between the ages of 30-50 of Anglo-Saxon descent. The organisation realises the need to create and implement a diversity strategy and they have created a guide to communicate the organisation’s new diversity strategy. You have read the guide and found that whilst it is informative it does not promote the strategy. What would you say/do?
(250 words)
Activity 4:
1. Describe how you could monitor a diversity strategy that was implemented in an organisation to increase the number of women in management positions.
(150 words)
2. You have evaluated the progress of diversity strategies within an organisation relating to the number of employees with an intellectual disability which the organisation hires. You find that the organisation has not met its goals. What would you do to determine why these goals were not met?
(160 words)
3. You have been asked to review your organisation’s diversity strategy for its impact on the overall effectiveness of the organisation. What would you do?
(150 words)
4. After reviewing the organisation’s diversity strategy you believe that there are some enhancements that could be made to it. Management has asked you to submit a report outlining the enhancements. What would you include in the report?
(120 words)
Activity 5:
1. What is respect for diversity?
(60 words)
2. Why is it important to suspend your own cultural assumptions when working with diversity?
(120 words)
3. You are applying for a job as a manager in an organisation that has an extremely diverse workforce. What would you tell the selection panel about your leadership style and how you would employ it to facilitate intercultural management and to manage diverse teams?
(250 words)
Activity 6:
1. Develop a guide for managers involved in the recruitment and selection process that outlines how to conduct a culturally inclusive recruitment and selection process.
(1000 words)
2. You are a member of a selection panel interviewing candidates for a position as an accounts payable officer for the organisation. The person who is recruited will be responsible for payments of invoices to respective suppliers, monthly and weekly reconciliations, responding to simple queries and end of month reconciliations. You have narrowed the candidates down to two. The panel agrees that one of these workers has more experience; however, they speak with a very strong Indian accent. One of the panel members says that for this reason the other candidate should be hired. What would you tell them?
(75 words)
Activity 7:
1. Give one example for each of these elements of diversity training:
a. Awareness raising
b. Preventative training programs
c. Legal compliance programs
d. Intervention training
e. Counselling
f. Specific culture training
2. An organisation has employed its first group of Indigenous employees. Some of these workers are going to be involved in administration duties and others will work in the housekeeping department. None of the current employees in the organisation have ever worked with Indigenous people. What type of diversity training or awareness programs should the organisation provide and why?
(80 words)
3. What should diversity training focus on?
(120 words)
4. Use the internet to research training providers specialising in diversity training. Select one provider and prepare an overview of their areas of expertise, training methodologies etc.
(250 words)
Activity 8:
1. Research the culture of Indigenous Australia. What possible areas of tension or conflict might occur in the workplace due to cultural misunderstandings and how can these be avoided?
(180 words)
2. What role do effective communication skills play in managing tension and encouraging collaboration and respect between staff who struggle to work effectively with diversity?
(350 words)
Activity 9:
Conduct research on the benefits of diversity in support of this statement:
‘Companies perform better when they have genuine diversity in their brains trust: people from different backgrounds providing fresh perspectives, insights and expertise. Diversity isn’t about ticking boxes or being politically correct – it’s about building an organisation that avoids a herd mentality and delivers better business outcomes.’ (Mercer 2012)
Produce a brief information session for operational staff in an industry of your choice to assist them to see that working effectively with a difference is a strength that can improve the organisation’s products, services and customer relations.
(750 words)
Activity 10:
1. Use the internet to research harassment and discrimination policies and procedures for two Australian organisations.
Identify commonalities between the two organisations with regard to how complaints are managed. Are formal and informal procedures available? Are there options for external resolution? What is the legislative framework for the policy/ procedure?
(500 words)
2. How can managers facilitate the resolution of allegations of harassment in the workplace?
(250 words)
Activity 11:
1. What are the benefits of a diverse workforce in an organisation that services a community that is multicultural?
(75 words)
2. Use the internet to research an organisation’s workplace plan or strategy. Identify how that organisation plans to promote its workforce diversity in internal and external forums to enhance the organisation’s image and reputation.
(200 words)
Activity 12:
1. How can managers foster collaborative relations that capture ideas and information from the diversity in the workforce and contribute to competitive advantage?
(120 words)
2. One way managers can support organisational efforts to value diversity is by supporting employees seeking work/life balance. What could managers do to demonstrate this support? What implications does supporting employees to achieve their work/life balance have on the business?
(200 words)
Summative Assessment 1
Question 1:
Explain the fundamental difference between formal and informal complaints procedures.
Question 2:
Choose three pieces of legislation that relate to diversity in the workplace. Summarise each piece of legislation including the objectives of each Act and explain what an organisation can do to comply with the legislation.
Summative Assessment 2
Project
1. You are in an organisation with a diverse workforce and client base. What actions could you take to encourage respect, deal with problems arising from diversity and assist in using diversity as an asset to your workplace?
(350 words)
2. How can managers facilitate the successful implementation of a diversity policy?
(200 words)
3. How can managers use workforce diversity to enhance products and services and contribute to competitive advantage?
(160 words)

 



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

BSBINN502: Build And Sustain An Innovative Work Environment

Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.


Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.

BSBINN502: Build and sustain an innovative work environment
Formative assessments
Activity 1.
1. Why do you think it is important for leaders to make innovation a part of their management activities? (30-50 words)
2. Provide three examples of innovative activities/ practices that leaders might undertake. Do not limit your ideas to those presented in the text.
Activity 2.
1. Why should managers encourage employees to offer ideas, views or suggestions regarding improvements/ changes that they consider would be beneficial to the organisation? (100-125 words)
2. You are a section (departmental) manager in a large retail store. An employee has come to you to present an idea that they believe will result in improving and streamlining customer service procedures. Provide six examples of how you would respond in a bullet point list.
Activity 3.
1. Innovation necessarily involves risk. Explain what this means to you. (100-125 words)
2. The general confectioner company’s product development team have design a new confectionary product. This product is quite different from those generally sold by the General Confectioner Company. They have conducted suitable market research to identify their target market: 5 to 8 year old children. This means that the product needs to appeal to both the children and their parents.
The company does not have the capacity to ad this product to their product line without removing at least one of their other products. They will need to conduct a product analysis to identify which product/s should be removed from the list.
Even though this will be only one of a number of products sold by the company, it is necessary to analyse the risk involved in making the decision to go ahead with the new product. What risk will be faced and how might these risks be controlled? (150-200 words)
3. When risks are realised it might be necessary to implement a contingency plan. Explain what a contingency plan is and explain the important aspects of contingency plan development. (1 page)
Activity 4.
1. How could you determine whether innovation fits with/ are consistent with organisational goals and objectives? Provide at least five examples.
2. You want to determine whether your own approach to innovation is effective. How might you do this? Provide at least three examples. You do not have to limit your ideas to those presented in the text.
3. How do good leaders build effective relationships, based mutual respect and trust, with employees? Provide at least five examples in a bullet point list.
Activity 5.
1. In a bullet point list, identify at least five of working conditions that might be introduced to encourage innovative practices.
2. Develop, in consultation where appropriate, an innovative idea that could be applied in the organisation for which you work or any other business organisation. This idea need not involve major changes – small changes can often have very beneficial effects. It must, however, add value.
Describe your proposed innovation and explain:
• why it is innovative?
• what type of innovation it is?
• how it will be of benefit to the organisation?
• what value it will add?
• what impact it will have on the staff in the organisation – both direct and indirect?
What testing and exploration techniques might be utilised in order to determine whether your idea can be applied? Draw up a plan or schedule for the purpose of examining, testing, evaluating and refining your idea. (1-2 pages)
Activity 6.

1. Develop an innovative idea that would benefit from collaboration with others. The innovation will preferably relate to a work situation but if you are not currently working might relate to personal situation.
Document your ideas then discuss them with a range of stakeholders.
State who the stakeholders are, whether they are internal or external to the organisation and why they are stakeholders; then document their responses to your ideas.
What conclusion did you come to, as a result of your discussion/ collaboration?
How valuable do you think the discussion with the various stake holders is?
Do you think that asking others to collaborate in the development and assessment of innovative and creative ideas is a good idea? Explain and justify your answer. (100-150 words)
2. From what sources might it be possible to gather current and emerging information that can be used to foster innovative ideas? Provide at least five examples. You might need to conduct some research of your own to determine appropriate sources.
Activity 7.

1. You have been asked to build a team that’s main responsibility is to innovate. What would you base you selection of a team member on? (75-100 words)
2. What do you think is the most important leadership role to maximise a team’s opportunities to innovate? (75-100 words)
Activity 8.
As a leader/ manager, how would you acknowledge, celebrate and reward successful innovation brought about by teams and individuals. Provide at least five examples. Why do you think it is necessary to do so? (200-250 words)
Activity 9.
You work for a health food manufacturer. It has come to you attention that other organisations in the industry have introduced products that they are promoting as being highly healthy and nutritious; however, the new product are very high in sugar content. This change in product has let to increase sales for those organisations. How would you evaluate the opportunity to introduce similar products within the wider organisation context? (100-150 words)
Activity 10.
1. You have a feeling that the physical environment in which your team works is negatively impacting on their motivation to innovate. How might you go about identifying shortcomings in the environment? (20-40 words)
2. Explain how, as a department manager or supervisor, you might ensure that support and resources are accessible and sufficient for the operating needs of your team/section/ division. (150-200 words)
3. What resource should be available, to foster, promote and encourage innovation? Provide at least ten examples in a bullet point list.
Activity 11.
1. If you had a chance to create a unique workspace, what would be most important? Interaction with fellow employees? Design and colour? Uniqueness? Give reasons for your answer. (50-75 words)
2. Make at least three realistic suggestions for improving the atmosphere in your workplace or a workplace you are familiar with to increase/improve creative input. Use drawings, diagrams etc to help explain your ideas. (1 page)
Activity 12.
Explain how proactively sharing relevant information, knowledge and skills with work colleagues can help them to innovate. (150-200 words)
Activity 13.
1. You want to encourage your staff to be creative and innovative. What informal and formal learning opportunities might you provide them with to help them develop the skills needed for innovation? Provide at least five examples.
2. What kinds of thinking or tools might individuals develop as a result of formal and informal learning opportunities? Provide at least five examples.
3. How can individuals learn from the experience of mentors?
Summative assessment 1
Question 1.
Explain the concept of innovation and why it is necessary for organisations to practice innovation in today’s world of work. (75-100 words)
Question 2.
Explain the context for innovation in the workplace by identifying what context relates to. Provide at least 10 examples.
Question 3.
Describe the factors and tools that can be used to motivate individuals to use creative thinking and apply innovative work practices. Provide at least three examples.
Question 4.
Explain the legislative framework that needs to come under consideration when deciding whether or not to go ahead with an innovative idea/proposal. (75-100 words)
Question 5.
Explain how a command and control approach to management and leadership can hinder innovation. (100-150 words)
Question 6.
Describe typical barriers to innovation with teams and organisations. Provide at least five examples of barriers.
Summative assessment 2
Project – (2500-3000 words)
You should address all the topics in this unit of work but might also supplement this information by carrying out your own research. Remember to properly cite any sources used.



Click here to order similar paper @Essaybay.net. 100% Original.Written from scratch by professional writers.