Graduate Essay Writers
Only the finest writers are selected to be a part of our team, with each possessing specialized knowledge in specific subjects and a background in academic writing..
Fill the order form in 3 easy steps - Less than 5 mins.
Posted: June 9th, 2022
The work needs to be done in an Excel® file
Principles of Supply Chain Management
Problem Set 1
1. Based on the information shown below, develop forecasts for April to October using:
(a) A 3-period weighted moving average model (w1 = 0.5, w2 = 0.3, and w3 = 0.2).
(b) An exponential smoothing model with α = 0.35. Assume the forecast for March was 950.
Month Actual Demand
Jan 1050
Feb 975
Mar 1000
Apr 870
May 970
Jun 1220
Jul 1170
Aug 1150
Sep 1235
Oct 1275
2. Based on the information shown below, calculate MAD, MSE and tracking signal.
Week Actual Demand Forecast
1 750 770
2 690 730
3 820 710
4 850 790
5 870 840
6 780 850
7 915 890
8 950 920
3. For the information given, rank the customers in terms of customer lifetime value.
Avg. Annual Sales Avg. Profit Margin Expected Lifetime
Customer 1: $3,450 17 % 8 years
Customer 2: $2,000 13 % 6 years
Customer 3: $1,400 32 % 10 years
Use a discount rate of 6 percent and treat the average sales figures as annuities. Should any of these customers be fired?
Tags: best custom paper writing service, best online paper writing service, best paper writing service, best research paper writing services, cheap research paper writing service, cheapest paper writing serviceEvery Student Wants Quality and That’s What We Deliver
Only the finest writers are selected to be a part of our team, with each possessing specialized knowledge in specific subjects and a background in academic writing..
We balance affordability with exceptional writing standards by offering student-friendly prices that are competitive and reasonable compared to other writing services.
We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.
When you opt to place an order with Nursing StudyBay, here is what happens:
Place an order in 3 easy steps. Takes less than 5 mins.