What is the expected sale

Assignment Help Applied Statistics

Reference no: EM131416375

Statistics for Financial Decisions Assessment

Learning Outcomes

1. Analyse and present data graphically using spreadsheet software (Excel).

2. Critically evaluate summary statistics against suitable benchmarks.

3. Apply judgement to select appropriate methods of data analysis drawing on knowledge of regression analysis, probability, probability distributions and sampling distributions.

4. Select and apply a range of data analysis tools to inform problem solving and decision making.

5. Conduct quantitative research both individually and as part of a team and articulate and present findings to a wide range of stakeholders, from accounting and non-accounting backgrounds.

Instructions:

You are required to apply your knowledge and draw links between the scenario and the learning resources. In your answers, reflect upon and analyse issues of the key discussion points of the module. Your answers should also effectively communicate and demonstrate that key concepts have been reviewed and that you can apply these concepts to the problems posted.

Assignment

The daily sales figures and prices for our Schmeckt Gut Energy Bars sold in the countries of Nockaragua, Macronesia and Industria are provided with the attached EXCEL file.

The board of directors of Schmeckt Gut is interested in investigating this data in more detail.

The board would like you to answer the following questions by using statistical methods and concepts that have been addressed in the modules.

a) What is the expected sale (number of energy bars sold) and what is the expected revenue on any given day in each of the three countries?

b) Based on the data, what is the probability that Schmeckt Gut:

(i) Sells at least the expected number of energy bars?

(ii) Reaches at least the expected revenue?

c) What are the average number of energy bars sold and revenues achieved for each week day (Monday's, Tuesday's, ... Saturday's and Sunday's) in each country?

(i) Create probability distributions of the average number of sales and the average revenues achieved over any given week (Monday to Sunday)?

(ii) Present your distributions for each country in graphs.

(iii) Given the probability distributions for every day of the week (Monday to Sunday), what are the expected sales and what are the expected revenues for each day of the week (Monday to Sunday) for each country?

(iv) On which day are we experiencing, on average, the highest sales (number of energy bars sold) and on which day the lowest sales?

(v) On which day are we experiencing, on average, the highest revenue and on which day the lowest revenue?

(vi) What is the expected number of energy bars sold on these specific days?

What is the expected revenue on these specific days? Knowing the actual data, what is the probability that we meet the expected sales and revenues on these days?

d) With the knowledge of the above, advise the board in which country we should invest in marketing our Energy Bars. Explain your rational.

Reference no: EM131416375

Questions Cloud

Problem regarding the threads main view : If a project is poorly designed and constructed, will a well-planned and well-executed implementation effort help the project to succeed? Will a well-designed and well-constructed system overcome a poor implementation effort?

How are the target-firm shareholders harmed by such actions : How are the target-firm shareholders harmed by such actions? Explain.

Technology security on the systems design process : What is the impact of information technology security on the systems design process? What key factors need to be addressed in the development cycle before systems construction and implementation? After?

What is the basic determinant of tax status in a merger? : Merger and Taxes Describe the advantages and disadvantages of a taxable merger as opposed to a tax-free exchange. What is the basic determinant of tax status in a merger? Would an LBO be taxable or nontaxable? Explain.

What is the expected sale : STAT 6003: Statistics for Financial Decisions Assessment. What is the expected sale (number of energy bars sold) and what is the expected revenue on any given day in each of the three countries

How does stress impact the body : What did the self-assessment tell you about your level of stress? Were you surprised by the results? Explain.How does stress impact the body? How do you recognize "signs" of stress?The readings for this Module discuss the relationship between motiva..

Is there a possibility of reverse synergy : Why might a company do this? Is there a possibility of reverse synergy?

User for a series of names : Design a program that asks the user for a series of names (in no particular order). After the final person's name has been entered, the program should display the name that is first alphabetically and the name that is last alphabetically.

How could the company hedge its exchange rate risk : Ignoring taxes, what are East Coast Yachts' projected gains or losses from this proposed arrangement at the current exchange rate of $0.73€? What happens to profits if the exchange rate changes to $0.80€? At what exchange rate will the company bre..

Reviews

len1416375

3/6/2017 7:19:28 AM

Highly sophisticated and creative analysis, synthesis of new with existing knowledge. Strong application by way of pretested models and / or independently developed models. Recommendations are clearly justified based on the analysis/synthesis. Applying knowledge to new situations/other cases. Uses ethical principles to identify competing interests and views. Sophisticated understanding of the ethical and moral positions. Well-articulated viewpoint based on moral-ethical reasoning. Expertly written and adheres to the academic genre. Demonstrates expert use of high-quality, credible and relevant research sources to support and develop arguments and position statements. Shows extensive evidence of reading beyond the key reading There are no mistakes in using the APA Style. Expertly presented; the presentation is logical, persuasive, and well supported by evidence, demonstrating a clear flow of ideas and arguments. Engages and sustains audience’s interest in the topic, demonstrates high levels of cultural sensitivity Effective use of diverse presentation aids, including graphics and multi-media.

len1416375

3/6/2017 7:19:19 AM

Evidence of an exceptional level of achievement of learning objectives across the entire content of the course demonstrated in such areas as interpretation and critical analysis, logical argument, creativity, originality, use of methodology and communication skills. Exceeds minimum standard and exhibits high levels of independence Consistently demonstrates a systematic and critical understanding of context and purpose of the assignment. A sophisticated understanding of the field or discipline/s. Systematically and critically discriminates between assertion of personal opinion and information substantiated by robust evidence from the research/course materials and extended reading. Mastery of concepts and application to new situations/further learning. Specific position (perspective or argument) is presented expertly, authoritatively and imaginatively, accurately taking into account the complexities of the issue(s) and scope of the assignment. Limits of position are acknowledged. Justifies any conclusions reached with sophisticated arguments.

Write a Review

Required(*) Message

Applied Statistics Questions & Answers

Develop a frequency distribution of overall design quality

Develop a frequency distribution of the overall mechanical quality ratings. Describe the distribution. Develop a relative frequency distribution of the overall design quality ratings. Describe the distribution.

Suppose x and y are continuous random variables

Suppose X and Y are continuous random variables with joint pdf given by f(x, y) = 24xy if 0 2X].

The joint pdf of lifetimes of a certain part and a spare

Suppose the joint pdf of lifetimes of a certain part and a spare is given by f(x, y) = e-(x + y); 0

Construct a bar graph for the data with annual salary

Construct a bar graph for these data with "Annual Salary" on the axis and "Category of Scientist" on the Y axis. Arrange the categories so that the salaries decrease from left to right.

Application of spc can improve quality standards

SPC is one of a number of tools which can be used to improve manufacturing quality standards - Outline two techniques which can be used to decide where to put SPC effort most effectively.

Statistic is used to test a hypothesis a regression equation

Which statistic is used to test a hypothesis a regression equation?Select one:a. t-statisticb. z-statistic

Cigarette smokers make lower college grades than nonsmokers

Consider the following news headline, "Cigarette Smokers Make Lower College Grades than Nonsmokers" The news article goes on to say that researchers at a university collected information on rate of cigarette smoking (total number of cigarettes smoked..

Find the test statistic

Find the test statistic and do the two-sample test for equality of proportions. Is the decision close?

Formulate and solve a linear optimization model

Formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the production manager explaining the sensitivity information.

Which of the two variables is the independent variable

In a study on speed control, it was found that the main reasons for regulations were to make traffic flow efficient and to minimize the risk of danger. An area that was focused on in the study was the distance required to completely stop a vehicle at..

Difference between a two-way amova and a three-way anova

What is the deference between a complete factorial design and an incomplete factorial design and explain the difference between a two-way AMOVA and a three-way ANOVA.

Given value is a statistic or a parameter

Determine whether the given value is a statistic or a parameter.

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!

Submit Assignment

User Account

All Pages