Chapter One Analysis
Based on the Excel Problem of chapter one, if the total capacity for this business is 725 will you stay in it? If you want to stay in it what price you need to obtain a break even point of 725?
PROBLEM 4 – Chapter 1: See attached completed excel problem completed. Only compare and analyse
Wayne owns a shaved ice stand. He sells 700 shave dice cups per month at $1.50 each ,making the total revenue $1050. Each shaved ice costs Wayne $0.50 and he has fixed costs of $750, making his total costs $1100. Therefore, he realizes a loss of $50 a month. Help him determine what his break-even point is.
Chapter Two Analysis
Based on the excel problem of chapter 2, between cost and sales which column shows more stability or control? If you compare the trend of cost/unit versus the profit/unit using a scatter chart, what can you infer from their behavior?
See attached. Excel problem completed.
Chapter Three Analysis
Based on problem 8, which data set is more stable. Base your answer on standard deviation values. Compare both frequency histograms and which shows a normal distribution behavior? Based on problem 11, if you are the owner of the Eastern airlines how many seats do you need to cover the East Coast flights with a monthly total demand of 487,000 people for the entire airline? If the airplane has 200 seats, how you will distribute them by first class, business class and coach?
See attached completed problem 8 and 11.
·
C
hapter
One
Analysis
Based on the Excel Problem of chapter one, if the total capacity for this business is 725 will you stay in it? If you want to
stay in
it what price you need to ob
tain a break even point of 725
?
PROBLEM 4
–
Chapter
1
:
See attached completed excel problem
completed. Only compare and analyse
Wayne
own
s
a
sha
ve
d
ice
stand.
He
sells
7
00
shave
dice
cups
per
month
at
$1.50
each
,making
the
total revenue $1050. Each shaved ice costs Wayne $0.50 and he has fixed costs of $750,
making his total costs $1100. Therefore, he realizes a loss of $50 a month. Help him determi
ne
what his break
–
even point is.
Chapter
Two
Analysis
Based on the excel problem of chapter 2, between cost and sales which column shows more stability or control?
If you compare the trend of cost/unit versus the profit/unit using a scatter chart, what can you infer from their behavior?
See attached.
E
xcel
problem completed.
C
hapter
Three
Analysis
Based on problem 8, which data set is more stable. Base your answer on standard deviation values. Compare both frequency
histograms and which shows a normal distribution behavior?
Based on probl
em 11, if you are the owner of the Eastern airlines how many seats do you need to cover the East Coast flights
with a monthly total demand of 487,000 people for the entire airline? If the airplane
has 200 seats, how you will distribute them by first class
, business class and coach?
See attached completed problem 8 and 11.
· Chapter One Analysis
Based on the Excel Problem of chapter one, if the total capacity for this business is 725 will you stay in it? If you want to stay in
it what price you need to obtain a break even point of 725?
PROBLEM 4 – Chapter 1: See attached completed excel problem completed. Only compare and analyse
Wayne owns a shaved ice stand. He sells 700 shave dice cups per month at $1.50 each ,making
the total revenue $1050. Each shaved ice costs Wayne $0.50 and he has fixed costs of $750,
making his total costs $1100. Therefore, he realizes a loss of $50 a month. Help him determine
what his break-even point is.
Chapter Two Analysis
Based on the excel problem of chapter 2, between cost and sales which column shows more stability or control?
If you compare the trend of cost/unit versus the profit/unit using a scatter chart, what can you infer from their behavior?
See attached. Excel problem completed.
Chapter Three Analysis
Based on problem 8, which data set is more stable. Base your answer on standard deviation values. Compare both frequency
histograms and which shows a normal distribution behavior?
Based on problem 11, if you are the owner of the Eastern airlines how many seats do you need to cover the East Coast flights
with a monthly total demand of 487,000 people for the entire airline? If the airplane
has 200 seats, how you will distribute them by first class, business class and coach?
See attached completed problem 8 and 11.
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
