a) (5 points): Over the past 5 weeks, demand for wine at Winston's Winery has been 2400, 1300, 2700, 1900, and 1100 bottles. Winston has placed weekly orders for glass bottles of 2700, , 1000, 3000, 2000, and 800 units.

i. What is the variance of demand for Winston's Winery?

ii. What is the variance of orders from Winston's Winery for glass bottles?

iii. What is the bullwhip measure for glass bottles for Winston's Winery? iv. Is Winston's Winery providing an amplifying or smoothing effect?

b) (5 points): Century Outlet has total end-of-year assets of $10 million. The first-of-the-year inventory was $800,000, with a year-end inventory of $700,000. The annual revenue was $18 million and the annual cost of goods sold was $15 million. The owner wants to evaluate his supply chain performance. Pease calculate the following SC performance measures:

Gross Margin Percentage =

Average Inventory Investment =

Percentage of Assets invested in inventory =

Inventory turnover = Weeks of supply =

c) (5 points): The fixed costs for operating our plant at locations A, B, and C, D are $1600, $1000, $2,200, and $4,200 per day respectively. The variable costs are $11, $7, $4 and $2 per unit respectively. Find the range of production level where each location is optimal.

d) (5 points): We are trying to lease a warehouse for the next four years. Option 1 is to pay a non-refundable deposit of $25,000 now and then $4,000 per month at the end of each month for the next four years. Another option is to pay one month rent of $4,600 at the beginning of each month for the next four years and a security deposit of $4,600 now which will be returned at the end of the lease period. Find the present value of each option using an interest rate of 8% per year.

Please provide graphs and excel sheets as well.