see attached
Application Assignment Instructions
Each application assignment is a comprehensive experiential learning experience and is directly related to business analysis and decision-making. The student will complete four application assignments (4).
Instructions
Each assignment must be a minimum of 3-5 pages of original discussion and analysis, not counting the title page, reference page, figures, tables, and appendixes. Each application assignment must be supported by at least 3 scholarly references, in APA format.
Note: Your assignment will be checked for originality via the Turnitin plagiarism tool. The tool is a starting point for instructors to check overall Academic Integrity and higher scores generally indicate a higher probability of Academic Misconduct. The higher the score the higher the probability that there are too high a percentage of quotations included in the narrative, and/or there are passages that have not been properly cited.
·
Mandatory reading:
Read: Albright & Winston: Chapter 1
·
Read: Reece & Reece: Chapter 1
Application: Introduction to Business Analytics Assignment
Select and complete 1 Question on page 36 of your Albright & Winston textbook)
Question 13 or Question 14 – (p. 36)
Question 13: Julie James is opening a lemonade stand. She believes
the fixed cost per week of running the stand is $50.00.
Her best guess is that she can sell 300 cups per week at
$0.50 per cup. The variable cost of producing a cup of
lemonade is $0.20.
a. Given her other assumptions, what level of sales volume
will enable Julie to break even?
b. Given her other assumptions, discuss how a change in
sales volume affects profit.
c. Given her other assumptions, discuss how a change in
sales volume and variable cost jointly affect profit.
d. Use Excel’s Formula Auditing tools to show which
cells in your spreadsheet affect profit directly