Please solve complete 1. A retall has sixteen stores in a region supplied from elght supply sources. Trucks have a capacity of20,000 units and cost $1,000 per load plus $200 per delivery. Thus, a truck making two deliverlescharges $1,400. The cost of holding one unit in inventory at retail store for a year is$1.00.The vice president of supply chain Is considering whether to use direct shlpping from suppliers to retailstores or setting up milk runs (2 and 4 stores milk run) from suppliers to retail stores.A. What network do you recommend if annual sales for each product at each retail store are 600,000?What is the total transportation and inventory cost of this strategy?B. What network do you recommend if anual sales for each product at each retail store are 300,0007What is the total transportation and inventory cost of this strategy?

Direct deliveries refer to those that originate from one location and end at one receiving location.…

A. What network do you recommend if annual sales for each product at each retail store are 600,000? What is the total transportation and inventory cost of this strategy? B. What network do you recommend if annual sales for each product at each retail store are 300,0007 What is the total transportation and inventory cost of this strategy?

A. What network do you recommend if annual sales for each product at each retail store are 600,000? What is the total transportation and inventory cost of this strategy? B. What network do you recommend if annual sales for each product at each retail store are 300,0007 What is the total transportation and inventory cost of this strategy?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Are my formulas correct and did I get the correct answer? Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20. a. Determine how Sunblessed can maximize its profit.
A factory produces three types of fertilizer: A, B, and C. The profits gained from a kilo of each type of are P100, P120, and P80 respectively. The raw materials from which the fertilizers are made are nitrogen, sulfur, and potassium which are used in the following quantities: Турe of Nitrogen Sulfur Potassium Fertilizer A 3 3 6 В 4 2 2 1 The available stocks include 1,500 kilograms of nitrogen, 1,300 kilograms of sulfur, and 1,20o kilograms of potassium. Find the amount of fertilizers to produce to maximize the factory's profit. How much is the maximum profit gained from the second table?
Use the data above to calculate unemployment rate.
Types of problem are: А. occurred and available problem В. presented and constructed problem C. make and settle problem D. others and solve problem
i need help constructing a pay-off the table with the given question :
What does the phrase "disjointness constraint" mean?
What is Extreme point? What is Alternative optimal solutions? What is Infeasibility? *
PROBLEM The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash investment. They have determined that the cost of either investing in or selling marketable securities is $100. By looking at Book Warehouse’s past cash needs, they have determined that the variance of daily cash flows is $20,000. Book Warehouse’s opportunity cost of cash, per day, is estimated to be 0.03%. Based on experience, management has determined that the cash balance should never fall below $10,000. 1. How much is the cost per transaction?(Use a number, no decimal value, no commas, no currency, no space) * 2. How much is the return point based on the Miller-Orr model of cash management? (Use a number, no decimal value, no commas, no currency, no space) * 3. How much is the upper limit based on the Miller-Orr model of cash management?(Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS. THANKS!
Describe the steps that are used to resolve constraint issues.
I need help with this question 6
Problem #4 - Jasper Inc. would like you to provide consulting services and provide recommendation on building a new assembly facility for air conditioning units in Florida. Jasper's initial assessment indicates the following conditions for this decision-making problem: With a favorable market in Florida, Jasper thinks that a large facility would result in a net profit of $200,000 to his firm. If the market is unfavorable in Florida, the construction of a large facility would result in $190,000 net loss. - A small facility would result in a net profit of $100,000 in a favorable market, but a net loss of $20,000 would occur if the market was unfavorable. Doing nothing would result in $0 profit in either market conditions. a) Create a decision table for this problem. b) What is your recommendation if y would apply the Maximax criterion (Optimistic)? C What is your recommendation if you would apply the Criterion of Realism (Hurwicz Criterion) with a erricient of realism a = 0.9? d) What is…