ISYS2056 - Business - Business Information Systems - Analyzing a Spreadsheet and Presenting a Business Report - Eclipse Vans - Case Study Assessment Answer

ISYS2056:  Business Information Systems Eclipse Vans Case Study Assessment Answer

Assessment Task: ISYS2056

“Eclipse Vans" is a manufacturer of recreational vehicles (Vans, camper trailers and motorhomes). They build vehicles in their northern suburbs factory and sell direct to the public. They pride themselves on building modern, luxury off road and touring vehicles at affordable prices. Abdul and Joeline Hussein own and manage the business. Joeline manages reception, staffing, customer issues, and accounts. Abdul manages the manufacturing process. Joeline has hired two junior and one senior sales staff. Staff are paid an annual base rate and a commission which is based on the profit of each sale made (see spreadsheet). Customers pay an initial deposit of 10% and the remainder on delivery. A set retail price is charged for vans, which is dependent on the type/model of the van. Abdul has calculated the cost price for each van (excluding batch preparation costs) and added a 20% profit margin to all vans and associated accessories. Vans are manufactured in ‘batches’ based on the model. Abdul has estimated the ‘preparation’ costs for production of each batch at $5,000. He takes this figure into account when calculating profitability. Eclipse vans are advertised in several ‘Camping’ and ‘4WD’ magazines. In 2018, in an effort to further increase sales Joeline decided to offer an ‘options pack’ to each customer which could be purchased at a special discounted price. The pack being offered depended on the van type (see spreadsheet). Over the past two years, Joeline has recorded details of all van sales in an excel workbook. She has asked you to use the data provided in the spreadsheet to complete relevant calculations and to use Excel ‘tools’ to analyze the data provided. She then requires you to write a business report which analyses and discusses both profit growth and the various options available to help increase future profitability. Joeline and Abdul are interested in both quantity and profitability of sales. They hope you can provide some insight regarding, the type of vans they should focus their efforts on. Joeline also wonders if she should make changes to the ‘options pack’ offer. Perhaps the data has highlighted other actions that would assist them in improving profitability. A spreadsheet has been provided containing the data for “Eclipse Vans” sales for 2017 and 2018.

In summary
Undertake descriptive and predictive analysis of the data Joeline has maintained over the past two years. Present your findings in a professionally presented report:

• Provide an overview of profitability trends (past and present) undertaking predictive analysis.
• Discuss the results of your descriptive analysis and options for future sales growth (based on the requirements of Abdul and Joeline).
• Discuss at least one other activity which you believe could assist profitability and is supported by the data you have been given.
• Make recommendations with regard to future changes which might assist in further improving profitability. Briefly justify these recommendations (i.e. prescribe what should be done and why this would be helpful, drawing on your predictive and prescriptive analysis).

PREPARING THE BUSINESS REPORT
Report Content
The analysis, findings, and recommendations which you prepare for Jane should be outlined in a professional business report.
This report should include:
? A title page – with a relevant graphic, report title, student name/number, course name (Business Information Systems), course number (ISYS2056), your workshop time and your workshop tutors’ names.

? A Table of Contents (TOC) automatically generated by Microsoft Word. Default settings for the table of contents should not be altered.

? A brief introduction which outlines clearly the purpose of the report.

? A discussion regarding the results of your analysis. Possible options for increasing future profitability have been included.

? Identification and discussion of one further action that might improve profitability (which has been identified through your analysis)

? A short concluding summary of the major findings of the report (supported by figures).

? Clear recommendations that Joeline and Abdul can adopt. These recommendations must be drawn from the analysis you have carried out and must have been discussed in the body of your report.

This ISYS2056: Business Assessment has been solved by our Business 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.