Problem 1: Three products can be manufactured on any of four machines. The unit production costs (in $) are summarized below. MACHINE PRODUCT 1 2 3 4 1 4 4 5 7 2 6 7 5 6 3 12 10 8 11 The time (in hours) required to produce a unit of each product on each of the machines is given below. MACHINE PRODUCT 1 2 3 4 1 0.3 0.25 0.2 0.2 2 0.2 0.3 0.2 0.25 3 0.8 0.6 0.6 0.5 3000, 6000, and 4000 units of the products are required, and that the available machine hours are 1500, 1200, 1500, and 2000 on machines 1-4, respectively. Given the above problem, answer the following questions: 1. Give the complete LP formulation without using the index and summation notations 2. Give the complete LP formulation using the index and summation notation. 3. Solve the problem using EXCEL SOLVER and tabulate the sensitivity analysis report. 4. Obtain the dual problem. 5. Solve the dual problem using EXCEL SOLVER. 6. Draw the problem as a network model. 7. Obtain the matrix form of the formulated problem.

Problem 1: Three products can be manufactured on any of four machines. The unit production costs (in $) are summarized below. MACHINE PRODUCT 1 2 3 4 1 4 4 5 7 2 6 7 5 6 3 12 10 8 11 The time (in hours) required to produce a unit of each product on each of the machines is given below. MACHINE PRODUCT 1 2 3 4 1 0.3 0.25 0.2 0.2 2 0.2 0.3 0.2 0.25 3 0.8 0.6 0.6 0.5 3000, 6000, and 4000 units of the products are required, and that the available machine hours are 1500, 1200, 1500, and 2000 on machines 1-4, respectively. Given the above problem, answer the following questions: 1. Give the complete LP formulation without using the index and summation notations 2. Give the complete LP formulation using the index and summation notation. 3. Solve the problem using EXCEL SOLVER and tabulate the sensitivity analysis report. 4. Obtain the dual problem. 5. Solve the dual problem using EXCEL SOLVER. 6. Draw the problem as a network model. 7. Obtain the matrix form of the formulated problem.

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

#4- The mean number of air conditioning units assembled per month by Freeze, Inc. is 750 and the standard deviation is 100 units. a. If the number of air conditioning units assembled per month follows a normal distribution, calculate the probability of Freeze, Inc to assemble a quantity of air conditioning units greater than the monthly break-even point calculated in problem 3-a. b. An improved assembling process is proposed to Freeze, Inc. to reduce the variable cost from $500 per unit to $400 per unit., increase the mean number of air conditioning units assembled per month from 750 to 850 and reduce the standard deviation to 90 units. As a result of the improvements, monthly fixed costs would go up from $250,000 to $300,000. Once these improvements are implemented, calculate the new number of air conditioning units that Freeze Inc. must sell every month to break-even, discuss and justify if you would recommend the process improvement initiative. c. If the number of air conditioning…
A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for manufacturing, and the parameters of each process are as follows: Process 1 Production rate Daily production time Process 2 35 parts/hour 4 hours/day 20% 15 parts/hour 7 hours/day 9% Percent parts rejected Assume that the daily demand for hubs allows all defect-free hubs to be sold. Select the process that maximizes profit per day if each part is made from $4 worth of material and can be sold for $30. Both processes are fully automated, and variable overhead cost is charged at the rate of $40 per hour.
Assume that direct labor is a variable cost. The special order would have no effect on the company's total fixed manufacturing overhead costs. The customer would like modifications made to product A90 that would increase the variable costs by $4.20 per unit and that would require an investment of $21,000 in special molds that would have no salvage value. This special order would have no effect on the company's other sales. The company has ample spare capacity for producing the special order. The annual financial advantage (disadvantage) for the company as a result of accepting this special order should be: Brady Corporation has received a request for a special order of 6,000 units of product A90 for $21.20 each. Product A90's unit product cost is $16.20, determined as follows: Direct materials $ 6.10 Direct labor 4.20 Variable manufacturing overhead 2.30 Fixed manufacturing overhead 3.60 Unit product cost $ 16.20
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
Tuff-Rider, Inc., manufactures touring bikes and mountainbikes in a variety of frame sizes, colors, and component com-binations. Identical bicycles are produced in lots of 100. Theprojected demand, lot size, and time standards are shown inthe following table: Item Touring MountainDemand forecast 5,000 units/year 10,000 units/yearLot size 100 units 100 unitsStandard processing time .25 hour/unit .50 hour/unitStandard setup time 2 hours/lot 3 hours/lot The shop currently works 8 hours a day, 5 days a week,50 weeks a year. It operates five workstations, each producingone bicycle in the time shown in the table. The shop main-tains a 15 percent capacity cushion. How many workstationswill be required next year to meet expected demand withoutusing overtime and without decreasing the firm’s currentcapacity cushion?
The binary variables in the fixed cost models correspond to: A.) The number of units or products produced. B.) The total profit C.) The amount of labor hours D.) A process for which a fixed cost ovcurs
The manager of Roth Corporation, wants to determine whether or not the type of work schedule for her employees has any effect on their productivity. She has selected 15 production employees at random and then randomly assigned 5 employees to each of the 3 proposed work schedules. The following table shows the units of production (per week) under each of the work schedules. Work Schedule (Treatments) Schedule 1 50 60 70 40 45 Compute MSTR MSTR- 95 94.68 128.166 3.8856 Schedule 2 60 65 65 58 57 Schedule 3 75 75 55 40 55
Dd.17.
xxx=182
a.) in table 1, the transportation cost is? b.) in the evaluation of occupied cells in table 1, the value of W2 is? c.) in yhe evaluation of vacant/unoccupied cells in table 1, the highest negative index is? d.) in table 2, the tiles manufactured by PlantB will be supplied to distributor? e.) the transportation cost in table 2 is? f.) in the evaluation of occupied cells in table 2, the value of V2 is? g.) in the evaluation of occupied cells in table 2, the value of W3 is? h.) in the evaluation of unoccupied/vacant cells in table 2, the highest negative index is? i.) the optimal solution is found in table? **Note: find for the tables**
a.) in table 1, the transportation cost is?b.) in the evaluation of occupied cells in table 1, the value of W2 is?c.) in yhe evaluation of vacant/unoccupied cells in table 1, the highest negative index is?d.) in table 2, the tiles manufactured by PlantB will be supplied to distributor?e.) the transportation cost in table 2 is?f.) in the evaluation of occupied cells in table 2, the value of V2 is?g.) in the evaluation of occupied cells in table 2, the value of W3 is?h.) in the evaluation of unoccupied/vacant cells in table 2, the highest negative index is?i.) the optimal solution is found in table? **Note: find for the tables**
17-36 Weighted-average method. Larsen Company manufactures car seats in its San Antonio plant. Each car seat passes through the assembly department and the testing department. This problem focuses on the assembly department. The process-costing system at Larsen Company has a single direct-cost cat- egory (direct materials) and a single indirect-cost category (conversion costs). Direct materials are added at the beginning of the process. Conversion costs are added evenly during the process. When the assembly department finishes work on each car seat, it is immediately transferred to testing. Larsen Company uses the weighted-average method of process costing. Data for the assembly depart- ment for October 2017 are as follows: Physical Units (Car Seats) Direct Conversion Materials $1,250,000 Costs $ 402,750 Work in process, October 1 Started during October 2017 Completed during October 2017 Work in process, October 31b Total costs added during October 2017 5,000 20,000 22,500 2,500…