Table 14.1 below

I cannot calculate right answer

all the answers I wrote in the blanks were wrong

Use Table 13.4 Fashionables is a franchisee of The Unlimited, the well-known retailer of fashionable clothing. Prior to the winter season, The Unlimited offers Fashionables the choice of five different colors of a particular sweater design. The sweaters are knit overseas by hand, and because of the lead times involved, Fashionables will need to order its assortment in advance of the selling season. As per the contracting terms offered by The Unlimited, Fashionables will also not be able to cancel, modify or reorder sweaters during the selling season. Demand for each color during the season is normally distributed with a mean of 575 and a standard deviation of 150. Further, you may assume that the demand for each sweater is independent of the demand for any other color. The Unlimited offers the sweaters to Fashionables at the wholesale price of $41 per sweater, and Fashionables plans to sell each sweater at the retail price of $68 per unit. The Unlimited does not accept any returns of unsold inventory. However, Fashionables can sell all of the unsold sweaters at the end of the season at the fire-sale price of $18 each. If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. How many units of each sweater-type should Fashionables order to maximize its expected profit? Use Table 13.4 and round to nearest integer. a. If Fashionables wishes to ensure a 97.5% in-stock probability, what should its b. order quantity be for each type of sweater? Use Table 13.4 and round to nearest integer C. Say Fashionables orders 725 of each sweater. What is Fashionables' expected profit? Use Table 13.4. d. Say Fashionables orders 725 of each sweater. What is the stockout probability for each sweater? Use Excel. (Round your answer to 4 decimal places.) PA 15-4 A police station had to deploy a police officer... A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The table below shows the number of emergencies each evening. (Round your answers to 3 decimal places.) Weekday Number of calls each day Forecast for tomorrow (calls) 8 Monday 8.000 Tuesday 8.000 Wednesday 6.000 Thursday 8 3 7 10 6.400 a. Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing forecasting approach, with a=0.4 and a forecast for Monday of 8. (Round your answer to 3 decimal places.) What would be their forecast for Friday using the same exponential smoothing forecasting approach? b. 7.840 PA 14-5 A Cold Inc is a frozen food distributor with... Use Table 14.1. ACold Inc is a frozen food distributor with 10 warehouses across the country. Ivan Tory, one of the warehouse managers, wants to make sure that the inventory policies used by the warehouse are minimizing inventory while still maintaining quick delivery to ACold's customers. Since the warehouse carries hundreds of different products, Ivan decided to study one. He picked Caruso's Frozen Pizza (CFP). Average daily demand for CFPs is normally distributed with a mean of 416 and a standard deviation of 151. Since ACold orders at least one truck from their supplier each day, ACold can essentially order any quantity of CFP it wants each day. In fact, ACold's computer system is designed to implement an order-up-to policy for each product. Ivan notes that any order for CFPs arrives 5 days after the order. Suppose an order-up-to level of 2439 is used. What is the expected on-hand inventory? Use Table 14.1 and round to nearest integer. 130 b. Suppose an order-up-to level of 2475 is used. What is the expected on-order inventory? Round your answer to the nearest integer. Suppose an order-up-to level of 2071 is used. What is the in-stock probability? Use Table 14.1. Round your answer to one decimal. C. d. Suppose Acold wants a 0.92 in-stock probability. What should the order-up-to level be? Use Table 14.1. Round your answer to the nearest integer. PA 12-1 Millennium Liquors is a wholesaler... Millennium Liquors is a wholesaler of sparkling wines. Their most popular product is the French Bete Noire which is shipped directly from France. Weekly demand is for 45 cases. Millennium purchases each case for $105, there is a $350 fixed cost for each order (independent of the quantity ordered) and their annual holding cost is 20 percent What order quantity minimizes Millennium's annual ordering and holding costs? 263 cases If Millennium chooses to order 300 cases each time, what is the sum of their annual ordering and holding costs? $ 5,577 (Round your answer to 2 decimal places.) c. If Millennium chooses to order 100 cases each time, what is the sum of the ordering and holding costs incurred by each case sold? $ 4.00 per case If Millennium is restricted to order in multiples of 50 cases (e.g., 50, 100, 150, d. etc.) how many cases should they order to minimize their annual ordering and holding costs? 250 cases Millennium is offered a 5.00% discount if they purchase at least 1,000 cases. e. If they decide to take advantage of this discount, what is the sum of their annual ordering and holding costs? $ 10,703 TABLE 13.4 The Distribution, FQ), and Expected Inventory, 1(), Functions for the Star -4.0 -3.9 -3.8 -1.3 -1.2 -1.1 F() 0968 .1151 .1357 .0000 .0000 0001 .0001 .0002 .0002 .0003 .0455 .0561 0686 0833 1004 .1202 -3.7 -1.0 .1587 -3.6 -0.9 1841 -3.5 -0.8 2119 -3.4 -0.7 2420 .1429 -3.3 0005 -0.6 2743 . 1687 -3.2 .0007 -0.5 3085 .1978 -3.1 -0.4 3446 2304 -3.0 -0.3 .3821 .0010 .0013 .0019 .0026 -2.9 -0.2 .4207 (z) .0000 0000 .0000 .0000 .0000 .0001 0001 .0001 .0002 0003 .0004 .0005 .0008 0011 .0015 .0020 0027 .0037 0049 .0065 .0085 0111 0143 0183 0232 -2.8 -0.1 4602 2668 3069 .3509 3989 .4509 5069 -2.7 0035 0 -26 .1 .0047 ,0062 .5000 .5398 .5793 -2.5 2 -2.4 .0082 3 .6179 5668 -23 0107 4 .6554 .6304 -22 .0139 5 .6915 -2.1 0179 .6 .7257 -20 0228 .7 .7580 -1.9 0287 8 .7881 .6978 .7687 8429 .9202 1.0004 1.0833 1.1686 -1.8 0359 8159 - 1.7 .0446 1.0 .8413 -1.6 0548 1.1 8643 -1.5 .0668 0293 1.2 8849 1.2561 -1.4 0808 0367 1.3 .9032 1.3455