MIS171-RACV Solar & Business Analytics Report – IT Computer Science Assignment

Assignment Task

Task 

Business Analytics 

Description:
The assignment requires that you analyse a data set, interpret, and draw conclusions from your analysis, and then convey your conclusions in a written email. The assignment must be completed individually and must be submitted electronically in CloudDeakin by the due date. When submitting electronically, you must check that you have submitted the work correctly by following the instructions provided in CloudDeakin. Hard copies or assignments submitted via email will NOT be accepted.
The assignment uses the file 2022 T1 RACV Solar Data Set A2.xlsx which can be downloaded from
CloudDeakin. The assignment focuses on materials presented up to and including Week 6.
The data set is based on actual data provided by RACV Solar. For confidentiality and anonymity reasons actual data has been manipulated in the assessment task. Following is an introduction to this scenario and detailed guidelines. 

RACV Solar

• RACV Solar is a wholly-owned subsidiary of the RACV (Royal Automobile Club of Victoria). While the RACV is best known as a provider of car and road-user services, the organisation has been active in expanding the range of services it offers to its members, including insurance and travel services.
• RACV Solar is one of the biggest solar companies in Victoria. RACV Solar has designed and installed more than 10,000 solar installations, with over 50 MW (megawatts) of solar power across multiple sectors, including residential homes, businesses, and community projects.
• RACV Solar holds the record for the largest installations on a school and a hospital in Australia.

Scenario: RACV Community Solar Installation Promotion

• In 2021, RACV Solar partnered with Geelong Sustainability to offer solar power generating and battery systems to households in the Geelong, Surf Coast and Otway region.
• Key data from 250 clients who participated in the promotion is included in the data set in the Excel file which forms part of this assignment (2022 T1 RACV Solar Data Set A2).
• As a commercial business RACV Solar is keen to convert an enquiry from a potential client into a confirmed commitment to purchase a solar installation. RACV Solar aspires to minimise the time between first enquiry and confirmed commitment (i.e., “Conversion Period”).

The promotion with Geelong Sustainability provided potential professional environment with multiple points of contact. The main pathways were coming into an RACV Store or via the RACV Solar website. However, clients also made enquiries via RACV Solar’s social media platforms (e.g., Facebook and Instagram) or by referral from other clients.
Every client enquiry was managed by one of RACV Solar’s three salespeople – Anand, Clayton, or Daiyu. The performance of RACV Solar’s salespeople is measured according to time to “close the deal”, revenue generated (i.e., System Cost”), and client satisfaction. The size of a solar electricity system is measured in kilowatts (kW). This represents the capacity of a solar installation at maximum efficiency. Larger systems have greater capacity to generate electricity than smaller systems. The amount of electricity generated depends on several factors, including system size, orientation (e.g., if the system faces north or west), and shading (i.e., if any shade, for example from nearby trees, falls on the solar panels during the day). Electricity generated is measured as kilowatt hours (kWh), the number of hours the system will power appliances with a requirement of 1,000 watts (i.e., one kilowatt).

The cost of the installation for the client is revenue for RACV Solar. Cost depends on several factors, including the size of the system, the complexity of the system (e.g., one bank of panels facing north and another bank of panels facing west), access to the site, and other factors (e.g., clients are offered different models of solar panels and extended warranties). None of the customers in this promotion disconnected from the national electricity grid. In the evenings and during daylight hours where a solar installation did not generate enough electricity to meet their needs the client would import (and pay their electricity supplier for) electricity from the national grid. Where a solar installation generates more electricity than is required, the surplus can be exported to the electricity grid. Electricity customers will be paid for the amount of electricity
exported to the grid. This “Revenue from Surplus” is based on the kWhs exported multiplied by the “feed-in tariff” (price per kWh) offered by the customer’s electricity supplier.

To track the benefit they receive, RACV Solar’s clients were asked to provide details of the cost of electricity consumed in the year prior to the new system being installed. Based on details of the installation (size, orientation, shading, etc) RACV Solar can estimate the amount of electricity\ generated by the installation. RACV Solar’s clients will not have to purchase this from their electricity supplier, generating a saving. If the annual surplus revenue is added to the annual electricity saving an annual payoff can be calculated. This is the financial benefit to an RACV Solar client following installing a new system.

At the conclusion of each installation RACV Solar asks their clients to rate their experience, on a scale of zero (completely unsatisfied) to 100 (completely satisfied). Using this feedback RACV Solar sorts clients into four groups: Unhappy, Acceptable, Satisfied, and Delighted. Assume that you are a business analyst recruited by RACV Solar. You have received an email from James Wright, RACV Solar’s Regional General Manager. James’s email asks you to analyse the 2021 client data. Your response will be used as part of a report to the RACV Solar Board of Directors. 

Email from James Wright
Subject: Analysis of the RACV Solar’s Promotion with Geelong Sustainability
Hi …,
We are very happy with the strong interest and business generated from the promotion with Geelong Sustainability. The Board wants a detailed understanding of some of the key aspects of the promotion. I have attached an Excel file with key data from the promotion and included some
guidelines (shown in blue) to direct your work.
Please provide answers to the following questions. Return the Excel file to me. As I have training in business analysis I am comfortable with technical language. The Board wants a report from you which explains the outcome of your analysis. As they do not have the benefit of training in business analytics your report must present the results of your analysis in plain, straight-forward language. 

Assignment instructions

Part 1: Data Analysis
Your data analysis must be performed on the Assignment 2 Excel file. The file includes tabs for:
• Data Description
• RACV Solar Data Set
• Analysis for questions 1, 2, 3, and 4

When conducting the analysis, you need to apply techniques from descriptive analytics, visualisations, probabilities, and confidence interval calculations. You will need to use the appropriate (pivot and other) tables, graphs, and summary measures. The analysis section you submit should be limited to the Q1 to Q4 worksheets of the Excel file. These are the only worksheets which will be marked. Your analysis should be clearly labelled and grouped around each question. Poorly presented, unorganised analysis or excessive output will be penalised. In the Conclusion section of each worksheet there is space allocated for you to write a succinct response to the questions posed in James’s email (above). When drafting your Conclusion, make sure that you directly answer the questions asked. Cite (state) the important features of the analysis in your Output section. Responses in the Conclusion section will be marked.

Use the Output section for your analysis, which follows the direction provided in James’s email, and supports your response to his questions (which you will write in the Conclusion section). Analysis in the Output section will be marked, please make sure your analysis is complete, clear, and easy to follow. You may need to add rows or columns to present your analysis clearly and completely. Use the Workings section for calculations and workings that support your analysis. The Workings section will not be marked.

Part 2: Report
Having analysed the data, including answers (in technical terms) to the Data Analysis questions from Part 1 you are required to provide a formal report which can be placed before the RACV Solar Board of Directors. The report must explain all four (4) analysis questions (Univariate Analysis, Bivariate Analysis, Probability, and Confidence Intervals). Assume that none of the directors on the Board have any training in statistics; they will only be familiar with broad generally-understood terms (e.g. average, correlation, proportion, and probability). They will need you to explain more technical terms, such as quartile, mode, standard deviation, coefficient of variation, correlation coefficient, and confidence interval, etc.
You are allowed approximately 1,000 words (950 to 1,050 words) for your report. Remember you should use font size 11 and leave margins of 2.54 cm.
It is useful to produce both numerical and graphical statistical summaries. Sometimes something is revealed in one that is not obvious in the other.

A template is provided for your convenience. Carefully consider the following points:

• Your report is to be written as a stand-alone document. Assume that your Excel file is for James’s use only and that James will only pass your written report directly to the Board. Keep the English simple and the explanations clear. Avoid the use of technical statistical jargon. Your task is to convert your analysis into plain, simple, easy to understand language.
• Follow the format of the template when writing your report. Delete the report template instructions (in purple) when drafting your report. 
• Include a succinct introduction at the start of your report, and a conclusion at the end.
• Marks will be deducted for the inclusion of irrelevant material, poor (unprofessional) presentation, poor organisation, poor formatting, and reports that exceed the word limit.

When you have completed drafting your report, it is a useful exercise to leave it for a day, and then return to it and re-read it as if you knew nothing about the analysis. Does it flow easily? Does it make sense? Can someone without prior knowledge follow your written conclusions? Often when rereading, you become aware that you can edit the report to make it more direct and clearer.

Learning Outcomes
This task allows you to demonstrate achievement towards the unit learning outcomes (ULOs). The ULOs are aligned with specific graduate learning outcomes – that is, the skills and knowledge graduates are expected to have upon completion of their studies – and this assessment task is an important tool in determining achievement of those outcomes. If you do not demonstrate achievement of the unit learning outcomes, you will not be successful in this assignment. It is good practice to familiarise yourself with the ULOs and GLOs as they provide guidance on the knowledge, understanding and skills you are expected to demonstrate upon completion of the unit. In this way they can be used to guide your study.

ULO1: Apply quantitative reasoning skills to analyse business problems.
ULO2: Create data-driven/fact-based solutions to complex business scenarios.
ULO3: Analyse business performance by implementing contemporary data analysis tools.
ULO4: Interpret findings and effectively communicate solutions to business problems.

This MIS171-IT Computer Science Assignment has been solved by our IT Computer Science Expert at TV Assignment Help. 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.