The attached spreadsheet shows weekly demands and receipts. Assume that the receipts are at the beginning of the week. Also assume that not satisfied demand is backlogged (rather than lost). Calculate actual fill ratio and actual service level. Hint: Remember that service level is a probability of satisfying all demand during the ordering cycle (not per period).

Brandt enterprises is considering a new project that has a cost of $1,000,000, and the cfo set up the following simple decision tree to show its three most likely scenarios. the firm could arrange with its work force and suppliers to cease operations at the end of year 1 should it choose to do so, but to obtain this abandonment option, it would have to make a payment to those parties. how much is the option to abandon worth to the firm?