Excel Exam

profilesward44
MGMT364-01-Midterm-Template.xlsx
Home>Business & Finance homework help>Financial markets homework help>Excel Exam

Problem 1.

1. What advantages does selling books via the Internet provide over a traditional bookstore? Are there any disadvantages to selling via the Internet? Your Answer:

2. Should Amazon stock every product it sells? Your Answer:

 3. What advantage can bricks-and-mortar players derive from setting up an online channel? How should they use the two channels to gain maximum advantage? Your Answer:

4. What advantages/disadvantages does the online channel enjoy in the sale of shoes /diapers relative to a retail store? Your Answer:

5. For what products does the online channel offer the greater advantage relative to retail stores? What characterizes these products? Your Answer:

Problem 2.1

No Cooperation Capacity= 0
Sales Leftover Capacity Shortage
Demand Probability Demand Satisfied Extra Capacity Deficient Capacity Cumulative Probability
100 0.2 0 0 100 0.2
200 0.3 0 0 200 0.5
300 0.2 0 0 300 0.7
400 0.3 0 0 400 1
E[sales] E[left] E[short]
Exp.Value 260 Exp. Demand Satisfied Exp. Extra Capacity Exp. Capacity Deficiency
0 0 260
Green's Selling Price $ 45.00 per unit Green's Exp. Profit =
Green's purchase price $ 15.00 per unit Whole's Exp. Profit =
Salvage Value $ - 0 per unit
Supply Chain Exp. Profit =
Whole's Production Cost $ 10.00 per Unit
Possible Capacity Retailer Exp. Profit Manufacturer Exp. Profit Supply Chain Exp. Profit
Underage Cost cu= 100
Overage Cost co= 200
300
Critical Ratio = 400

Given the current information, how many units of products should Green stock to satisfy demand? What is the associated profit for Whole and Green, respectively? What is the profit for the supply chain in total? Your Answer:

Problem 2.2

Cooperation Capacity= 0
Sales Leftover Capacity Shortage
Demand Probability Demand Satisfied Extra Capacity Deficient Capacity Cumulative Probability
100 0.2 0 0 100 0.2
200 0.3 0 0 200 0.5
300 0.2 0 0 300 0.7
400 0.3 0 0 400 1
E[sales] E[left] E[short]
Exp.Value 260 Exp. Demand Satisfied Exp. Extra Capacity Exp. Capacity Deficiency
0 0 260
Green's Selling Price $ 45.00 per unit
Green's purchase price $ 15.00 per unit
Salvage Value $ - 0 per unit
Supply Chain Exp. Profit =
Whole's Production Cost $ 10.00 per Unit
Possible Capacity Retailer Exp. Profit Manufacturer Exp. Profit Supply Chain Exp. Profit
Underage Cost cu= 100
Overage Cost co= 200
300
Critical Ratio = 400

If Whole and Green were one integrated company, how many units would be stocked? What is the associated profit for the supply chain? Your Answer:

Problem 2.3

3. Why is there a discrepancy between the previous two questions? What steps would you recommend to coordinate this supply chain? Your Answer:

Problem 3

Mortgage arriving order arrival rate: 40 orders per day working hours 8 hours per day
Commerical Credie order arrival rate: 20 orders per day working minutes 480 minutes per day
Total aarival rate:
Total Lead Time: day
Stage Number of Clerks Set-up Time Processing Time Processing Rate Lead Time (read from Queue Template)
Data Collection 6 20 minutes 10 minutes orders per day day
Data Verification 4 25 minutes 3 minutes orders per day day
Loan Pricing 4 15 minutes 10 minutes orders per day day
Loan Closing 4 4 minutes 20 minutes orders per day day
Loan Maintenance 6 10 minutes 20 minutes orders per day day

Queue Template

M/M/s queuing computations lambda/mu 0.9375 s-1 0 THE ARRIVAL RATE SHOULD BE LESS THAN THE OVERALL SERVICE RATE!
Arrival rate 15 Assumes Poisson process for /s 0.9375
Service rate 16 arrivals and services. 15 s factorial = 1
Number of servers 1 (max of 40)
P(0) = 0.0625 0.9375 1
Utilization 93.75% P(n) 1.0 1.0
P(0), probability that the system is empty 0.0625 0 1 0.0625 0.0625 1.0 1.0
Nq, expected queue length 14.0625 1 0 0.05859375 0 1.0 1.0
N, expected number in system 15.0000 2 0 0.0549316406 0 1.0 1.0
Lq, expected time in queue 0.9375 3 0 0.0514984131 0 1.0 1.0
L, expected total time in system 1.0000 4 0 0.0482797623 0 1.0 1.0
Probability that a customer waits 0.9375 5 0 0.0452622771 0 1.0 1.0
6 0 0.0424333848 0 1.0 1.0
7 0 0.0397812983 0 1.0 1.0
8 0 0.0372949671 0 1.0 1.0
9 0 0.0349640317 0 1.0 1.0
10 0 0.0327787797 0 1.0 1.0
11 0 0.030730106 0 1.0 1.0
12 0 0.0288094743 0 1.0 1.0
13 0 0.0270088822 0 1.0 1.0
14 0 0.0253208271 0 1.0 1.0
15 0 0.0237382754 0 1.0 1.0
16 0 0.0222546332 0 1.0 1.0
17 0 0.0208637186 0 1.0 1.0
18 0 0.0195597362 0 1.0 1.0
19 0 0.0183372527 0 1.0 1.0
20 0 0.0171911744 0 1.0 1.0
21 0.016116726 0 1.0 1.0
22 0.0151094306 0 1.0 1.0
23 0.0141650912 0 1.0 1.0
24 0.013279773 0 1.0 1.0
25 0.0124497872 0 1.0 1.0
26 0.0116716755 0 1.0 1.0
27 0.0109421958 0 1.0 1.0
28 0.0102583085 0 1.0 1.0
29 0.0096171642 0 1.0 1.0
30 0.0090160915 0 1.0 1.0
31 0.0084525858 0 1.0 1.0
32 0.0079242991 0 1.0 1.0
33 0.0074290305 0 1.0 1.0
34 0.006964716 0 1.0 1.0
35 0.0065294213 0 1.0 1.0
36 0.0061213325 0 1.0 1.0
37 0.0057387492 0 1.0 1.0
38 0.0053800774 0 1.0 1.0
39 0.0050438225 0 1.0 1.0
40 0.0047285836 0 1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0