Please answer Newsboy questions with Excel,for upvot formulas step by step and clearly. с E G selling price purchase salvage value marginal marginal 1 (SP) price (PP) (SV) profit (MP) loss (ML) 2 3 p 4 5
Please answer Newsboy questions with Excel,for upvot formulas step by step and clearly. с E G selling price purchase salvage value marginal marginal 1 (SP) price (PP) (SV) profit (MP) loss (ML) 2 3 p 4 5
Chapter6: Exponential And Logarithmic Functions
Section6.8: Fitting Exponential Models To Data
Problem 3SE: What is regression analysis? Describe the process of performing regression analysis on a graphing...
Related questions
Question
please answer in details within 30 minutes.
Transcribed Image Text:Please answer Newsboy questions with Excel ,for upvoting please explain excel
formulas step by step and clearly.
G
H
salvage value marginal
(SV)
selling price purchase
marginal
1 (SP)
price (PP)
profit (MP) loss (ML)
2
5
cumulative
6 order
7 quantity
relative
frequency frequency
P(D=q)
P(D>=q)
9.
65
0.07
10
66
0.09
11
67
0.13
12
68
0.15
13
69
0.18
14
70
0.16
15
71
0.12
16
72
0.06
17
73
0.04
18
19
20
21 D
P(D)
Sales
Turnover
Cost
Salvage value Exp. profit
22
23
65
0.07
24
66
0.09
25
67
0.13
26
68
0.15
27
69
0.18
28
70
0.16
29
71
0.12
30
72
0.06
31
73
0.04
32
33
Newsboy
Billy's Bakery bakes fresh bagels each morning. The daily demand for bagels is
a random variable with a
distribution estimated from prior experience.
The bagels cost Billy's 30 cents to make, and they are sold for 1.20€ each.
Bagels unsold at the end of the day
are purchased by a nearby charity soup kitchen for 10 cents each.
What is Billy's marginal profit and marginal loss for each bagel sold / unsold
Marginal profit (MP):
Marginal loss (ML):
What is the necessary selling probability P* needed for determining the optimal
production quantity of
bagels?
What is Billy's expected profit (in €) when he bakes 50 bagels?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill