Module 14 Examples and assignments updated

A Production-Mix Problem Department Minimum PRODUCT Wiring Drilling Assembly Inspection Unit Profit Requirement XJ201 0.5 3 2 0.5 $ 9 150 XM897 1.5 1 4 1.0 $ 12 100 TR29 1.5 2 1 0.5 $ 15 200 BR788 1.0 3 2 0.5 $ 11 400 Capacity 1500 2350 2600 1200 Decision Wiring Drilling Assembly Inspection Total Profit XJ201 XM897 TR29 BR788 Total Surplus Capacity Failsafe Electronics Corporation (FEC) primarily manufactures mainly four highly technique products, which supplies to aerospace firms that hold NASA contracts. each of the products must pass through the following departments before they are shipped: Wiring, Drilling, Assembly, and Inspection. The time requirements in each department (in hours) for each unit produced and its corresponding profit value are summarized in the below table:

Workforce-Scheduling Model Input Data Hour Min Staff Required 8-9 5 9-10 12 10-11 15 11-Noon 12 Noon-1 11 1-2 18 2-3 17 3-4 19 4-5 14 PT Hours per shift= 4 hours Full-time employees= 5 people Model Hour Shift 1 Shift 2 Shift 3 Shift 4 Shift 5 Shift 6 8-9 9-10 10-11 11-Noon Noon-1 1-2 2-3 3-4 4-5 x1 x2 x3 x4 x5 x6 Decision Objective 8-9 9-10 10-11 11-Noon Noon-1 1-2 2-3 3-4 4-5 Brewer Services contracts with outsoursing partners to handle various customer-service functions. The cust open Monday through Friday from 8 a.m. to 5 p.m.. Calls vary over the course of a typical day. Vased on a st provided by one of firm's partners, the minimum number of staff needed each hour of the day are as follow

RHS Slack >= >= >= >= >= >= >= >= >= tomer-service dpartment is tudy of call volumes ws:

Shift 6 Shift 7 Shift 6 Shift 7 RHS Slack >= >= >= >= >= >= >=

Cleveland Capacity 3 100 3 300 5 300 200 3 Cleveland XA3 XB3 XC3 Cleveland Total

A Production-Mix Problem Product PRODUCT Ferrari BMW Lotus Tesla Molding 5.00 3.50 1.00 3.00 Sanding 4.00 3.20 2.00 3.65 Polishing 3.00 2.00 3.00 1.00 Painting 3.75 3.25 1.75 2.00 Finishing 4.00 1.00 2.00 3.00 Prices $ 350 $ 330 $ 270 $ 255 PRODUCT Molding Sanding Polishing Painting Ferrari 5.00 4.00 3.00 3.75 BMW 3.50 3.20 2.00 3.25 Lotus 1.00 2.00 3.00 1.75 Tesla 3.00 3.65 1.00 2.00 Capacity Minutes/day 600 600 480 480 Decision Molding Sanding Polishing Painting Ferrari 40 200 160 120 150 BMW 40 140 128 80 130 Lotus 68 68 136 204 119 Tesla 40 120 146 40 80 Total 528.00 570.00 444.00 479.00 Surplus Capacity 72.00 30.00 36.00 1.00 a. How many of each type of car should be produced to maximize profit? (Run solver once); Ferrari 0 BMW 56 Lotus 103 Tesla 58 b. What happens if market requires that at least 50 units of each be produced each day? (run solver twice wit 50 units of each can not be produced. c. What happens if market requires that at least 40 units of each be produced each day? (run solver twice with Decision The Martinez Model Car Company produces four different radio-controlled model cars based on exotic production models. Each model required production in five departments. See the table below and answer the following three questions: a. How many of each type of car should be produced to maximize profit? (Run solver once); b. What happens if market requires that at least 50 units of each be produced each day? (run solver twice with 50 instead of 40).

Capacity Minutes/day 600 600 480 Transposed to fit into the same model as the video 480 480 Finishing Prices Minimum Requirement 4.00 $ 350 40 You will need to enter the minimum 1.00 $ 330 40 2.00 $ 270 40 3.00 $ 255 40 480 Finishing Revenue 160 14000 Also make sure the decision variable 40 13200 136 18360 120 10200 456.00 55760.00 24.00 th 50 instead of 40). h 50 instead of 40).

m requirements by question b. es should be an integer solution.

ll time employees. Requirement >= >= >= >= >= >= om historical records, we all hours (just like the

Seattle San Francisco Las Vegas Tucson Distribution Cent Atlanta 2.15 2.1 1.75 1.5 Lexington 1.95 2 1.7 1.53 Milwaukee 1.7 1.85 1.5 1.41 Salt Lake City 0.6 0.55 0.35 0.6 Demand 5500 17000 3900 3400 1 2 3 4 Decision From Seattle San Francisco Las Vegas Tucson A Atlanta XA1 XA2 XA3 XA4 B Lexington XB1 XB2 XB3 XB4 C Milwaukee XC1 XC2 XC3 XC4 D Salt Lake City XD1 XD2 XD3 XD4 E Demand XE1 XE2 XE3 XE4 Decision From Seattle San Francisco Las Vegas Tucson A Atlanta B Lexington C Milwaukee D Salt Lake City E Demand

Destination Denver Charlotte Minneapolis Fayetteville Birmingham Orlando Cleveland 1.2 0.65 0.9 0.8 0.35 0.15 0.6 1.1 0.55 0.6 1.05 0.6 0.5 0.25 0.95 0.4 0.4 0.95 0.7 0.7 0.35 0.4 0.95 1 1.1 1.35 1.6 1.6 4500 7500 3000 8500 3300 12000 9000 5 6 7 8 9 10 11 Denver Charlotte Minneapolis Fayetteville Birmingham Orlando Cleveland XA5 XA6 XA7 XA8 XA9 XA10 XA11 XB5 XB6 XB7 XB8 XB9 XB10 XB11 XC5 XC6 XC7 XC8 XC9 XC10 XC11 XD5 XD6 XD7 XD8 XD9 XD10 XD11 XE5 XE6 XE7 XE8 XE9 XE10 XE11 Denver Charlotte Minneapolis Fayetteville Birmingham Orlando Cleveland

Philadelphia Supply 0.5 39200 0.3 32500 0.4 15200 1.7 17000 14000 12 Philadelphia XA12 XB12 XC12 XD12 XE12 Philadelphia Supply