Maintaining Control and Effectiveness of Organisation - Management Assignment Help

Assignment Task

Assessment layout
Tasks
Task 1 – Financial management
Reflect on the following statement:
Organisations are all different in terms of the products and/or services they provide, the competitive environment they operate within and the scale of operations. As a result their structure and resource requirements may also be different. A sound Financial Management and compliance process however is crucial in maintaining control and effectiveness of any organisation.
Required:
In the context of the above statement please answer the following questions.
Create your WORD document (or something similar) to answer this task. This document can be used for all required tasks in the assessment as indicated.
Part A
Outline the three (3) major commercial organisation types. Explain briefly the advantages and disadvantages associated with each one.
Part B
What are Key Performance Indicators (KPIs)? Why is it important to establish Objectives and KPIs at the start of the Financial Management Process? Provide three (3) examples of both Financial & Non-Financial KPIs. For each KPI what is being measured?
Part C
Assume you are managing a project involving the implementation of a new computer system. You have received a brief from Senior Management and created your project team and drafted a plan relating to the project. You will need to work closely with team members and stakeholders and you have had several meetings and attended presentations with the Finance Division to gain a full understanding of their policy and processes.
What do you consider to be the key attributes of a sound Financial Management Process to ensure the key objectives and KPIs of this project and the organisation are met (Refer to the Financial Management cycle) - Guide: 200 words in length.
Part D
An effective Financial Management Process is dependent on a number of factors. Crucial is the establishment of a sound system of Internal Control to minimise risk and maximise effectiveness.
Outline your understanding of Internal Control and why it is important to have a system in place as part of the Financial Management process. What are the key areas that need to be considered when implementing internal controls? Give an example of three (3) key controls that will assist in achieving these objectives – Guide: 200 words in length.
Task 2 – Basic spreadsheets for budgeting
You are required to use the template provided for this task.
Part A – Creation, formatting and formulas for the spreadsheet
Open the worksheet on the bottom tab in the Excel template titled “Task 2 – Part A”.
You are required to:
Replicate the spreadsheet below by implementing the following:
Change the name of the worksheet to "Create Spreadsheets".
Centre the title across width of the table.
Fill the range of cells from Jul 14 to Dec 14 for units and revenue with a colour of your choice.
Ensure the width of each column is such that the text and figures are presentable.
Include the appropriate formats for numbers, dollars, dates and font size.
Use the SUM formula to arrive at 'Total' Quantity and 'Total' Revenue.
Calculate ‘Revenue’ being the quantity multiplied by the Price Per Unit. Use Absolute Values in your calculation.

Part B – Linking spreadsheets
Task 2 – Part B requires you to create three spreadsheets on the template provided. The spreadsheets will be for Slater Stationery for Quarter 1, Quarter 2 and then the Total of the 2 Quarters.
Open the worksheet on the bottom tab in the Excel template titled “Task2 – Part B – 1st Qtr”
You are required to:
Replicate the spreadsheet below by implementing the following:
Centre the title of the spreadsheet across the width of the table.
Fill the range of cells relating to the column headings and total first quarter with a colour of your choice.
Ensure the width of each column is such that the text and figures are presentable. Where appropriate implement “Wrapping of text” for each heading.
Include the appropriate formats for numbers, dollars, dates and font size.
Calculate ‘Employee Total’ using the SUM function for Jan, Feb and Mar.
Calculate the % of Total Sales column be that is the employee total as a % of the Total Sales. Use the Absolute Value function in your calculation.
Calculate the Commission Earned that is the Employee total multiplied by the ‘Current Commission Rate’. Use the Absolute Value function in your calculation.
Slater Stationery - Sales by Employee for the 1st Quarter
Current Commission Rate 7% Employee # Salesperson Jan Feb Mar EmployeeTotal % of Total Sales Commission Earned
101 Marsh, Sam $2,500 $4,100 $3,500      
102 Fairs, Brian $4,500 $3,850 $3,900      
104 Bishop, Mary $3,200 $3,500 $3,700      
106 Docker, Pauline $4,210 $4,400 $4,500      
109 Spooner, Fred $3,000 $3,200 $3,500      
Total First Quarter            
Part B – 2nd Quarter
Open the worksheet on the bottom tab in the Excel template titled “Task 2 – Part B – 2nd Qtr”
You are required to:
Replicate the spreadsheet below by implementing the following -
Centre the title across the width of the table.
Fill the range of cells relating to the column headings and total second quarter with a colour of your choice.
Ensure the width of each column is such that the text and figures are presentable. Where appropriate implement “Wrapping of text” for each heading.
Include the appropriate formats for numbers, dollars, dates and font size.
Calculate ‘Employee Total’ using the SUM function for Apr, May and Jun.
Calculate the % of Total Sales column that is the Employee total as a % of the Total Sales. Use the Absolute Value function in your calculation.
Calculate the Commission Earned that is the Employee total multiplied by the ‘Current Commission Rate’. Use the Absolute Value function in your calculation.
Slater Stationery - Sales by Employee for the 2nd Quarter
Current Commission Rate 7% Employee # Salesperson Apr May Jun EmployeeTotal % of Total Sales Commission Earned
101 Marsh, Sam $4,100 $6,000 $4,000      
102 Fairs, Brian $3,800 $3,500 $4,800      
104 Bishop, Mary $4,500 $4,000 $5,500      
106 Docker, Pauline $4,300 $3,500 $4,500      
109 Spooner, Fred $3,850 $4,000 $4,200      
Total Second Quarter            
 

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.