How much sales do you expect to generate

Assignment Help Applied Statistics
Reference no: EM132527824

STA101 Statistics for Business - Elite Education Institute

As a business analyst, you work in a large personal care company Boween Pty Ltd. You are required to conduct a research and write a report to your department supervisor. You report needs to include the following focus:

1) Give a brief introduction of the firm provided, including basic background information and issues to address.

2) How much sales do you expect to generate in the overseas market in the 2nd quarter of 2020based on the least squares line? In your work, you need to include your excel calculation for covariance, correlation coefficient between selling expense and sales as well as a plotted scatter diagram. Briefly comment on the relationship between selling expense and sales.

3) The company wants to find out whether the consumer will consume more than 7bottles of liquid hand wash in the next quarter. Identify an appropriate statistical test and hypothesis, carrying out your analysis using a significance level of α =0.05. Show details of your work.

4) Provide a sales forecast report for 2nd half of 2020 based on your analysis from the data provided and your revised estimate of the probabilities of each scenario that is based on the new market information.

Your assignment should follow below structure

1. Introduction

1.1 Firm Background
1.2 Issues to address

2. Statistical methods chosen and Data analysis
2.1 Prediction on overseas 2nd quarter sales based on least square method
2.2 What methods were used, why, and prediction on domestic 2nd quarter sales in hypothesis testing using α =0.05
2.3 Prediction on domestic 2nd half sales based on the scenario analysis and probability.

3. Conclusion and recommendation
Marks will be allocated as follows:

Introduction, assignment presentation and excel workings(incorporated into the Word report)
o Well planned structure.
o The student's essay uses correct grammar and sentence structure.
o The introduction clearly outlines the objective of the essay (what the student is going to do) while the conclusion reiterates the objective and summarises their argument/position.
o All the workings are done via Excel clearly with all the formula and diagram incorporated into the report.

Details of the data analysis, Your assessment
o Calculations are done via Excel and all the calculations must be clear and sufficient
o There is a relevant discussion on different parameters and methods used.
o Hypothesis testing has been conducted and explained clearly with supporting calculation provided
Conclusion and recommendation
o The student's arguments are logical and consistent.A clear, consistent argument is presented which addresses the student's perspective/position in relation to the proposed 3 scenarios., including the reasons for modifying the probabilities and any new recommendations.
o Conclusion is made based on correct calculations.
o Calculations are correct and clear

Case Details

Boween Pty Ltd is a personal care company, and the key product is liquid hand wash product. The company sells its products both domestically and internationally. Due to the outbreak of the corona virus globally, consumers tend to wash hands more often recently, which lead to a temporary shortage of the product in the market. Thus, the management decided to run the factory into full capacity in order to meet demand in both local and overseas market.

The sales manager has collected overseas sales data for the past 8 weeks, the total selling expensevs. the sales were recorded below. The manager expects the selling expense would be stable at around $23,000 each week in the 2nd quarter and use this as the base assumption to estimate the sales for the foreign business.

The company wants to have a better understanding of how the consumption looks like in the next quarter in Australia, so they did the survey for a sample of 100 target households asking about ‘how many bottles of liquid hand wash would a household consume in the next quarter'. The survey data is attached in the excel. Given that the consumption for liquid hand wash is normally distributed with a standard deviation of 5.

Given the current situation is quite tough, the company also wants the sales department to forecast the sales for the second half of this year. Then the sales department did a scenario analysis as below:
Scenario 1: The outbreak will not get better until the end of the year, so they expect sales will increase by20% in the 2nd half of this year vs. 1sthalf of 2020.

Scenario 2: The market is not getting worse further, sales in the 2nd half of this year will be similar to the 1st half of 2020.

Scenario 3: The vaccine or medicine will be on the market soon and people will return to normal usage level, which is down by -25% in 2nd half compared to the 1st half of 2020.

After the discussion, management thinks the probability of scenario 1 is about 20%, probability of scenario 2 is 30% and probability of scenario 3 is 50%. 1st half of 2020 sales are expected to be AU$20mn.

As a business analyst, however, based on your recent shop visits and the market news, you disagree with the probability of the above. On the back of your findings and analysis of the market, you adjust the probabilities of each scenario and make a new suggestion to the management team.

Attachment:- Statistics for Business.rar

Reference no: EM132527824

Questions Cloud

Why do not arctic and alpine plants experience frost damage : Explain dormancy in plants (not their seeds), giving an example of where/when you have seen a dormant plant. describe or draw the species.
Differences between the speech given by old major : Differences between the speech given by Old Major in chapter one, and Lenin in 1919.
Industry experts believe blockchain is technology : Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years.
What are the basic hand strikes in taekwondo : What are the basic hand strikes in taekwondo?
How much sales do you expect to generate : How much sales do you expect to generate in the overseas market in the 2nd quarter of 2020based on the least squares line? In your work
Explain beta distribution and the benefits of the technique : Explain beta distribution, when it is used, and the benefits and shortcomings of the technique. What is the result of this estimate in the example?
What journal entries would be made relative to the facts : Instructions - Assuming that actual warranty costs are incurred exactly as estimated, what journal entries would be made relative to the following facts
Why did not strategy work : Why do you think the author/producer thought this message would be effective? In other words, what was the strategy behind the message?
Emerging threats and counter measures : A threat is an event which has the potential to adversely affect assets.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd