3. A grain mill has two main locations. One in lowa and one in Illinois. Those two locations ship products to three intermediary locations in Kansas City, Omaha, and Iowa City. Those three locations ship to Chicago, St. Louis, and Louisville. The cost of shipping per ton from each location is as follows: Kansas City $16 Iowa Illinois $15 Chicago Kansas City $6 Omaha $7 Iowa City $4 Omaha $10 Iowa City $12 $14 $17 St Louis Louisville $8 $10 $11 $11 $5 $12 Iowa and Illinois both have a capacity of 300 tons. Chicago has a demand for 200 tons. St Louis has a demand for 100 tons. Louisville has a demand for 300 tons. Determine the Total minimum cost. Determine the amount of product going to each destination.

3. A grain mill has two main locations. One in lowa and one in Illinois. Those two locations ship products to three intermediary locations in Kansas City, Omaha, and Iowa City. Those three locations ship to Chicago, St. Louis, and Louisville. The cost of shipping per ton from each location is as follows: Kansas City $16 Iowa Illinois $15 Chicago Kansas City $6 Omaha $7 Iowa City $4 Omaha $10 Iowa City $12 $14 $17 St Louis Louisville $8 $10 $11 $11 $5 $12 Iowa and Illinois both have a capacity of 300 tons. Chicago has a demand for 200 tons. St Louis has a demand for 100 tons. Louisville has a demand for 300 tons. Determine the Total minimum cost. Determine the amount of product going to each destination.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 7P: Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are...

See similar textbooks

Similar questions

Schneider Logistics Company has built a new warehouse in Columbus, Ohio, to facilitate the consoli-dation of freight shipments to customers in the region. George Schneider must determine how manyteams of dock workers he should hire to handle the cross-docking operations and the other warehouseactivities. Each team costs $5,000 a week in wages and overhead. Extra capacity can be subcontracted ata cost of $8,000 a team per week. Each team, whether in-house or subcontracted, can satisfy 200 laborhours of work a week. The labor hour requirements for the new facility are uncertain. Management hasestimated the following probabilities for the requirements: How many teams should Schneider hire?
Flanger is an industrial distributor that sources from hundreds of suppliers. One of these vendors supplies three products—A, B, and C—to Flanger. Annual demand for the three products are 24000, 600, and 600 units respectively. All the three products cost $200 per unit. Flanger uses a trucking company that charges a fixed transportation cost of $4000. An additional fixed cost of $1000 is incurred for receiving and storage. Flanger incurs a holding cost of 20% of the product purchase price. a. Evaluate the lot sizes that Flanger should order if lots for each product are ordered and delivered independently. What is the annual total cost (holding and ordering) of such a policy? b. Suppose the three product managers overseeing the replenishment of products A, B, and C decide to aggregate and order all three products each time they place an order. Evaluate the optimal order size for each product in this case. What is the annual total cost (holding and ordering) of this policy? c. In part…
Cascade Containers is organized into two divisions-Manufacturing and Distribution. Manufacturing produces a product that can be sold immediately or transferred to Distribution for further processing and then sold. Distribution only buys from Manufacturing for quality control reasons. Manufacturing currently sells 2,400 units annually at a price of $600 per unit to outside customers. It sells an additional 1,200 units to Distribution. The unit variable cost in Manufacturing is $300 and annual fixed costs are $300,000. Manufacturing is located in a country with a 20 percent tax rate. Distribution can sell units that have had further processing for $1,200 each. In addition to what it pays Manufacturing, the variable costs in Distribution are $150 per unit. Annual fixed costs in Distribution are $360,000. Distribution is located in a country with a 10 percent tax rate. Required: a. Suppose Manufacturing would have excess capacity even with the demand from Distribution. Ignoring tax…
A factory manufactures three products, A, B, and C. Each product requires the use of two machines, Machine I and Machine II. The total hours available, respectively, on Machine I and Machine Il per month are 7,050 and 10,100. The time requirements and profit per unit for each product are listed below. AB C Machine I 6 8 9 Machine II 9 8 16 Profit $9 $15 $18 How many units of each product should be manufactured to maximize profit, and what is the maximum profit? Set up the linear programming problem, with A, B, and C representing the number of units of each product that are produced. Maximize P= = subject to: $ 7,050 ≤ 10,100
A company manufactures a type of product in three different production plants: P1, P2 and P3. Each of these production plants can produce up to 1570 units per month. The company supplies four customers who require each 1000, 1200, 1500 and 1000 units per month. The company makes a gross profit of R110/unit (excluding transport cost). The transportation rates (Rand/unit) from each production plant to each customer are displayed below: ETTTI Customer 3 25 Customer 1 Customer 2 Customer 4 Plant 1 30 10 20 30 15 Plant 2 15 25 10 Plant 3 20 30 20 A stockout rate of R12/unit applies for the short supply of products to the customers. Assist the company to find the shipment plan that will allow them to maximise profits.
A small shop in Bulacan fabricates portable threshers for palay producers in the locality. The shop can produce each thresher at a labor cost of P1,800. The cost of materials for each unit is P2,500. The variable costs amount to P650 per unit, while fixed charges incurred per annum totals P69,000. If the portable threshers are sold at P7,800 per unit, how many units must be produced and sold per annum to break-even? Support your answer with computations and also by graphical solution.
A small shop in Bulacan fabricates portable threshers for palay producers in the locality. The shop can produce each thresher at a labor cost of P1,800. The cost of materials for each unit is P2,500. The variable costs amount to P650 per unit, while fixed charges incurred per annum totals P69,000. If the portable threshers are sold at P7,800 per unit, how many units must beproduced and sold per annum to break-even? Support your answer with computations and also by graphical solution. (Kindly provide a COMPLETE and CLEAR solution. Also, write legibly)
Vernon Electronics currently produces the shipping containers it uses to deliver the electronics products it sells. The monthly cost of producing 9,100 containers follows. Unit-level materials Unit-level labor Unit-level overhead Product-level costs* Allocated facility-level costs $5,700 6,500 3,200 8,400 27,100 *One-third of these costs can be avoided by purchasing the containers. Russo Container Company has offered to sell comparable containers to Vernon for $2.60 each. Required a. Calculate the total relevant cost. Should Vernon continue to make the containers? b. Vernon could lease the space it currently uses in the manufacturing process. If leasing would produce $12,700 per month, calculate the total avoidable costs. Should Vernon continue to make the containers? a. Total relevant cost a. Should Vernon continue to make the containers? b. Total avoidable cost b. Should Vernon continue to make the containers?
The Toowoomba Produce Suppliers packages and distributes three grades of animal feed. The material cost per tonne and estimated annual sales for each of the products are: Product Material cost Estimated sales Super Premium $16 1000 tonnes Premium $12 1500 tonnes Economy $10 2500 tonnes The indirect cost of operating the machinery used to package all three products is $20 000 per year. In the past, prices have been set by allocating the indirect costs to products on the basis of estimated sales in tonnes. The resulting total costs (material costs plus allocated fixed overhead) are then marked up by 100 per cent. a. allocate total indirect cost to each product. b. Determine the total cost for each product. c. Calculate the selling price per unit for each product, using the method described for setting prices. d. Does the price in part C, take into account how much customers are willing to pay for the product? explain.
Jumbo Co. sells a special toy product in Hong Kong. The cost information for the current year is as follows: Direct materials at $12 per poundDirect labour at $10 per hourVariable manufacturing overheadsVariable selling and administrative overheads Fixed manufacturing overheads Fixed selling and administrative overheads 2 pounds per unit 4 hours per unit$5 per direct labour hour $18 per unit $2,000,000 per year $1,000,000 per year A supplier selling production machines has offered Jumbo Co. a new model of the machine which can improve productivity by reducing one hour of labour time per unit. The renting cost of this new machine will incur an extra cost of $45,000 per month. Currently the annual sales quantity is 60,000 units and the selling price is $300 each. Your manager is seeking your advice for the replacement of the machine. Required: (a) Calculate the change in Net Profit resulting from the replacement of the machine. Indicate whether it is an Increase or a…
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: The shaper is available for 120 hours, and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1,000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are 8, 6, and 9, respectively. a. Formulate and solve for the recommended production quantities. b. What are the objective coefficient ranges for the three components? Interpret these ranges for company management. c. What are the right-hand-side ranges? Interpret these ranges for company management. d. If more time could be made available on the grinder, how much would it be worth? e. If more units of component 3 can be sold by reducing the sales price by 4, should the company reduce the price?
Vision Manufacturing Limited manufactures Airport Trolleys. It has a factory that has two divisions viz. Fabrication and Assembly. It also has two service departments viz Stores and Maintenance. Amount in Rs. Allocated Overhead Costs Fabrication Department 15,52,000 Assembly Department 7,44,000 Stores 2,36,000 Maintenance Department 1,96,000 Other Overheads Factory Rent 15,28,000 Factory Building Insurance 1,72,000 Plant and Machinery Depreciation 2,65,000 Subsidy for Staff Canteen 4,48,000 Direct Costs Amount in Rs. Fabrication Department 63,26,000 Material 8,62,000 Labour Assembly Department Material 1,42,000 Labour 13,06,000 The company provides the following additional Information: Particulars Fabrication Department Assembly Department Stores Department Maintenance Department Floor Area in Square…