Question

In: Advanced Math

Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products: Product Order (Units)...

Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 1950 B 400 C 1300 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows: Machine Capacity (Units) 1 1600 2 1400 3 1000 Product Machine A B C 1 $1.00 $1.30 $0.90 2 $1.30 $1.30 $1.30 3 $0.80 $0.90 $1.20 Use the transportation model to develop the minimum cost production schedule for the products and machines. Show the linear programming formulation. If the constant is "1" it must be entered in the box. If your answer is zero enter "0". The linear programming formulation and optimal solution are shown. Let xij = Units of product j on machine i. Min x1A + x1B + x1C + x2A + x2B + x2C + x3A + x3B + x3C s.t. x1A + x1B + x1C ≤ x2A + x2B + x2C ≤ x3A + x3B + x3C ≤ x1A + x2A + + x3A = x1B + x2B + x3B = x1C + x2C + x3C = xij ≥ 0 for all i, j If required, round your answers to the nearest whole number. Optimal Solution Units Cost 1-A $ 1-B $ 1-C $ 2-A $ 2-B $ 2-C $ 3-A $ 3-B $ 3-C $ Total $

Solutions

Expert Solution

Please find the answer shown below.

The explanation is given below. We have set up the model as shown in the question and then applied solver formulas to obtain the values. The model is shown below

The formulas are shown below

The solver setup is shown below

The result is shown below


Related Solutions

Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products: Product Order (Units)...
Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 2250 B 550 C 1100 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows:...
The Ace Manufacturing Company has orders for three similar products. Product Orders (units) AA 2,200 BB...
The Ace Manufacturing Company has orders for three similar products. Product Orders (units) AA 2,200 BB 700 CC 1,400 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. Machine Capacity (units)...
The Ace Manufacturing Company has orders for three products. Each product can be produced on one...
The Ace Manufacturing Company has orders for three products. Each product can be produced on one of three different machines. The time (hours) for producing each product on each machine is given below: Product Machine                      A                    B                     C                  1                             11                    12                    10                  2                             12                    9                     11                  3                             13                    15                    12        Each machine can be assigned to only one product. Set up the objective function and the constraints necessary to minimize the total time.
A company has orders for approximately 100,000 units of a product that it can sell at...
A company has orders for approximately 100,000 units of a product that it can sell at a price of €150.00 per unit. The company operates 300 days per year. It costs €5.00 to store one unit of the product for one month. The company manufactures other products, and it must set up the manufacturing system for a production order for the product, which costs €300. The product can be produced at a rate of 600 per working day. Determine: The...
Problem 12-09 (Algorithmic) A project has four activities (A, B, C, and D) that must be...
Problem 12-09 (Algorithmic) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Activity Time (weeks) Probability A 3 0.29 4 0.38 5 0.29 6 0.04 B 7 0.22 9 0.53 11 0.25 C 9 0.05 11 0.24 13 0.36 15 0.19 17 0.16 D 10 0.59 12 0.41 Provide the base-case, worst-case, and best-case calculations for the...
Ace Household Products Inc. is a multi-product company with several manufacturing plants. The Shareport Plant manufactures...
Ace Household Products Inc. is a multi-product company with several manufacturing plants. The Shareport Plant manufactures and distributes two household cleaning and polishing compounds, standard and commercial, under the Clean & Bright label. The forecasted operating results for the first six months of the current year, when 100,000 cases of each compound are expected to be manufactured and sold, are presented in the following statement. CLEAN & BRIGHT COMPOUNDS - SHAREPORT PLANT Forecasted Results of Operations For the Six-Month Period...
Archi ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders from...
Archi ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders from a foreign company to manufacture plastic bags and disposable cups and which the company considers it as a positive sign for growth in the future. The company’s existing machinery will not be sufficient enough to produce for the present demand and to meet the foreign order. Two options are available (1) to lease a machinery or (2) buy a new machinery using bank loan....
1. Fahad Ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders...
1. Fahad Ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders from a foreign company to manufacture plastic bags and disposable cups and which the company considers it as a positive sign for growth in the future. The company’s existing machinery will not be sufficient enough to produce for the present demand and to meet the foreign order. Two options are available (1) to lease a machinery or (2) buy a new machinery using bank...
Abbas ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders from...
Abbas ltd. is a manufacturing company involved in manufacturing plastic products. It has received orders from a foreign company to manufacture plastic bags and disposable cups and which the company considers it as a positive sign for growth in the future. The company’s existing machinery will not be sufficient enough to produce for the present demand and to meet the foreign order. Two options are available (1) to lease a machinery or (2) buy a new machinery using bank loan....
Question 6 Hickory Company manufactures two products—14,000 units of Product Y and 6,000 units of Product...
Question 6 Hickory Company manufactures two products—14,000 units of Product Y and 6,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all $684,000 of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine-hours $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT