Northern Airplane

.xlsx
School
University of Texas **We aren't endorsed by this school
Course
BUSINESS 7E
Subject
Statistics
Date
Sep 29, 2023
Pages
2
Uploaded by trantony2293 on coursehero.com
Northern Airplane Co. Production-Scheduling Problem Production Cost Regular Storage Cost ($millions) Time Overtime ($millions per month) Month 1 1.08 1.10 0.015 Month 2 1.11 1.12 Month 3 1.10 1.11 Month 4 1.13 1.15 Unit Cost Month Installed ($millions) 1 2 3 4 1 (RT) 1.08 1.10 1.11 1.13 1 (OT) 1.10 1.12 1.13 1.15 2 (RT) - 1.11 1.13 1.14 Month 2 (OT) - 1.12 1.14 1.15 Produced 3 (RT) - - 1.10 1.12 3 (OT) - - 1.11 1.13 4 (RT) - - - 1.13 4 (OT) - - - 1.15 Month Installed Maximum Units Produced 1 2 3 4 Produced Production 1 (RT) 10 5 0 5 20 <= 20 1 (OT) 0 0 0 0 0 <= 10 2 (RT) 0 10 0 0 10 <= 30 Month 2 (OT) 0 0 0 0 0 <= 15 Produced 3 (RT) 0 0 25 0 25 <= 25 3 (OT) 0 0 0 10 10 <= 10 4 (RT) 0 0 0 5 5 <= 5 4 (OT) 0 0 0 0 0 <= 10 Installed 10 15 25 20 = = = = Total Cost Scheduled Installations 10 15 25 20 ($millions) 77.4 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Range Name Cells Installed D33:G33 MaxProduction J25:J32 Produced H25:H32 ProductionCost D5:E8 ScheduledInstallations D35:G35 StorageCost G5 TotalCost J36 UnitCost D13:G20 UnitsProduced D25:G32 K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Page1of 2
Uploaded by trantony2293 on coursehero.com