BUMAN201A - Business Maths - Statistics - Analysis - Accountable - Business Assessment Answer

Assessment Task:

Task 1 

Using the Excel data - ‘Sales’ sheet

• Generate one table and one graph that provides a break up of all Sales Revenue by Region and Representative (in rows) and for all products (in the columns). The data presented in the table for each product/representative should be shown in dollars. A pivot table/chart is a great tool in Excel to do this. Make sure your graphs and tables look professional.
• Generate one table that provides a break up of all Sales Revenue by Region and Representative (in rows) and for all products (in the columns). The data presented in the table for each product/representative should be shown in percentages of the grand totalof sales revenue. Percentages should be to two decimal places.
• Generate separate table for each of the 3 product categories. You will have table for Cricket Balls, a table for Stumps, and a table for Cricket Bats. Each table should include data for each representative within each region, detailing sales in units and revenue in dollars. Make sure your tables look professional.
• Generate 3 pie charts, one for each of the product categories, detailing the sales for each region as a percentage of the total sales for each product category.
• Generate 3 pie charts, onefor each of the three regions detailing the sales for each representative as a percentage of the total region’s sales.

Comment on the data you have created.  As the manager of this business, how could you use this data? 
 

Task 2 

You are the production manager for Yummy Yoghurt. Your production line produces 750g tubs of yogurt for sale at supermarkets all over Australia. Your company has a target that at least 95% of its yogurt tubs will contain between 745g and 755g grams of yogurt. Assume the distribution of the weight of yogurt is normal.

1. Calculate the average and standard deviation of the tubs that have been measured.  You should use excel formulas for this. 
2. What is the probability that a tub will weigh between 745 and 755 grams? 
3. What is the probability that a tub will weigh less than 740 or more than 760 grams? 
4. What is the probability of a tub weighing less than 735 grams? 
5. What is the probability of a tub weight over 765g grams? 
6. Has the company meet their target?  What are the consequences of not meeting this target? 

How can you use this data in your business? 

The Business Assessment above question 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.