MBAS901 - Essential Tools for Business Analytics - Management Assignment Help

Assignment Task

Task 1: Exploratory Data Analysis (25 points) Using ‘FACILITY_TOY’ dataset available in SAS Viya, answer the following questions. Export/copy all charts you create into your answer script, describe the charts (e.g. what your chart is visualising in each axis) and interpret the charts i.e. what your chart is highlighting. This interpretation is ideally accessible to even a non-technical reader.

Q1. On a geographic map, show the countries where toy facilities are located. Size of the bubble should be the total unit capacity (4 points).

Q2. What is the total unit capacity in the United States (1 point) and in Australia (1 point).

Q3. Temporarily remove United States from the map you prepared in Q1. Show the updated map (without US) (3 points). Which country has the second largest unit capacity after United States (1 point).

Q4. Many countries have more than one toy facility. Further, most facilities have more than one unit manufacturing toys. As one would expect, majority of these units do not operate at full capacity. Assuming the actual usage of the units is provided by ‘Unit Actual’ variable and the total unit capacity is provided by ‘Unit Capacity’ variable, calculate the ‘Capacity Utilization Ratio’ and store values in a new variable. Show how you created this calculated item by taking a screenshot of the appropriate SAS Viya window. Generate a histogram of the new variable and copy/export it into your answer script. Interpret the histogram (4 Points).

Q5. Prepare a bar chart to show the average ‘Capacity Utilization Ratio’ by facility for each country. Use a filter to show only Spain, Australia and Japan in this bar chart. Copy/export the chart into your answer script. Interpret your chart (4 points)

Q6. There are many factors that could explain the variation observed in the Unit Capacity Utilization Ratio. Identify two such factors and demonstrate how these two factors explain the variation in Unit Capacity Utilization Ratio with the help of two charts and associated interpretation. (3.5 points per chart).

This (MBAS901) 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 distinctio.