Upload File

aggregate planning transportation (production) problem in ms excel

  • Home
  • Documents
  • Aggregate Planning Transportation (Production) Problem in MS Excel
prev
next
out of 53
Download Aggregate Planning Transportation (Production) Problem in MS Excel

Upload: subhrodip-sengupta

Post on 02-Jun-2018

224 views

Category:

Documents


1 download

Report

TRANSCRIPT

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    1/53

    Period Actual De Forecasts

    1 39773 39773

    2 36289 36985.8

    3 55588 51867.56

    4 45891 47086.31

    5 55056 53462.06

    6 32974 37071.61

    7 57803 53656.72

    8 33792 37764.94

    9 63321

    0

    10000

    20000

    30000

    40000

    50000

    60000

    70000

    0 1 2 3 4 5 6 7

    Actual Vs. Predicted vs. Movi

    Actual Demand Forecasts

    2 per. Mov. Avg. (Actual Demand ) 2 per. Mov. Avg. (For

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    2/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    3/53

    Period 1 2 3 4 5 6 7 8 Slack Supply

    D1 D2 D3 D4 D5 D6 D7 D8 Dummy y

    S1 R1 39773 1827 0 0 0 0 0 0 0 41600 #### ####

    S2 O1 0 0 0 0 0 0 0 0 20800 0 #### ####

    S3 R2 0 35159 6441 0 0 0 0 0 0 41600 #### ####

    S4 O2 0 0 0 0 0 0 0 0 20800 0 #### ####

    S5 R3 0 0 41600 0 0 0 0 0 0 41600 #### ####

    S6 O3 0 0 3826 0 0 0 0 0 16974 3826 #### ####

    S7 R4 0 0 0 41600 0 0 0 0 0 41600 #### ####

    S8 O4 0 0 0 5486 0 0 0 0 15314 5486 #### ####

    S9 R5 0 0 0 0 41600 0 0 0 0 41600 #### ####

    S10 O5 0 0 0 0 11862 0 0 0 8938 11862 #### ####

    S11 R6 0 0 0 0 0 37072 4528 0 0 41600 #### ####

    S12 O6 0 0 0 0 0 0 0 0 20800 0 #### ####

    S13 R7 0 0 0 0 0 0 41600 0 0 41600 #### ####

    S14 O7 0 0 0 0 0 0 7528 0 13272 7528 #### ####S15 R8 0 0 0 0 0 0 0 16965 24635 16965 #### ####

    S16 O8 0 0 0 0 0 0 0 20800 0 20800 #### ####

    DD 39773 36986 51868 47086 53462 37072 53657 37765

    39773 36986 51868 47086 53462 37072 53657 37765

    Total Product 2E+06

    Inventory&S 3199

    Total Cost 2E+06

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    4/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    5/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    6/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    7/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    8/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    9/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    10/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    11/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    12/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    13/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    14/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    15/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    16/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    17/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    18/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    19/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    20/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    21/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    22/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    23/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    24/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    25/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    26/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    27/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    28/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    29/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    30/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    31/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    32/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    33/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    34/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    35/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    36/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    37/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    38/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    39/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    40/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    41/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    42/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    43/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    44/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    45/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    46/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    47/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    48/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    49/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    50/53

    Deriving new parameters or decision variables if you need.

    Mi = Regular time production (Maximum) during period i

    Yi = Overtime production (Maximum) during period i

    Di = Demand during period i

    Ii = Inventory at the end of period i, Pi =Pre-order

    r = Regular time cost of production, per unit

    v = Over time cost of production, per unit

    h = Cost of carrying the inventory per unit per period.

    Min TC =

    s.t

    The Excel sheet with solver notes is attached.

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    51/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    52/53

  • 8/10/2019 Aggregate Planning Transportation (Production) Problem in MS Excel

    53/53


16. Aggregate Demand & Aggregate Supply

RHODE ISLAND DEPARTMENT OF …RHODE ISLAND DEPARTMENT OF TRANSPORTATION MATERIALS SECTION Sieve Analysis of Fine and Coarse Aggregate Unit Weight and Void in Aggregate Specific Gravity

Transportation Applications of Recycled Concrete Aggregate

Aggregate Interlock: A Pure-Shear Load Transfer …14 TRANSPORTATION RESEARCH RECORD 1286 Aggregate Interlock: A Pure-Shear Load Transfer Mechanism ANASTAs1os M. loANNIDES AND GEORGE

POOL DISTRIBUTION - Amazon Web Services · transportation costs, but they’re also achieving efficiencies that simply can’t be attained using an Excel-based transportation management

(QM) HC Conc Aggregate, Fine Description of Test Result ... · (QM) HC Conc Aggregate, Fine Test Data Report Oklahoma Department of Transportation Description of Test Result Indicators

ODOT Certified Aggregate Sources - USDA · ODOT Certified Aggregate Sources. 2013 . Certified Ohio Department of Transportation (ODOT) aggregate sources can be obtained directly from

RHODE ISLAND DEPARTMENT OF TRANSPORTATION MATERIALS AND ... · PDF filerhode island department of transportation materials and quality assurance sieve analysis of fine aggregate

Excel - Ireminiremin.cl/pdf/plantas-de-procesamiento/harneros/rip-flow/Excel... · As a natural extension of Excel’s broad product offering of premium replacement parts to the aggregate

Effects of Aggregate, Water/Cement Ratio, and Curing on the …onlinepubs.trb.org/Onlinepubs/trr/1992/1335/1335-007.pdf · 44 TRANSPORTATION RESEARCH RECORD 1335 Effects of Aggregate,

The new normal…. Bank or Processor Aggregate Payee transportation company Independent Contractor Drivers IRS

Nuno Alexandre Magalhães Pereira - core.ac.uk · proposed distributed algorithms for obtaining aggregate quantities excel. The implementa- ... em redes de sensores sem fio densas

Planning for Aggregate - Oregon for Aggregate ... Akin Owosekun, Associate Transportation Planner ... TYPE OF USE PERCENT OF ALL AGGREGATE USED Residential

Aggregate Aggregate

The Transportation Modelcanmedia.mcgrawhill.ca/college/olcsupport/stevenson/om4ce...LO 2 o THer relaTed appliCaTions Some of the other uses of the transportation model include aggregate

TRANSPORTATION RESEARCH CIRCULAR aggregate blending procedures have been validated with laboratory analysis and field trials (1,2,3,4). ... 4 Transportation Research Circular E-C044:

Measurement of Aggregate Shape, Surface Area, and Roughnessonlinepubs.trb.org/Onlinepubs/trr/1991/1301/1301-014.pdf · TRANSPORTATION RESEARCH RECORD 1301 107 Measurement of Aggregate

AGGREGATE TESTING FOR TRANSPORTATION SYSTEMS … · Worksheets QMP Award ... Aggregate Testing for Transportation Systems Course Syllabus 8:00 - 8:15 Registration, Introductions,

Dune Sand-Aggregate Mixes and Dune Sand-Sulfur Mixes for ...onlinepubs.trb.org/Onlinepubs/trr/1982/843/843-011.pdf · 72 Transportation Research Record 843 Dune Sand-Aggregate Mixes

aggregate demand and aggregate supply - · PDF file259 CHAPTER 8 aggregate demand and aggregate supply Aggregate demand Aggregate demand curve The aggregate demand

Chapter 22: Aggregate Supply and Aggregate Demand · Aggregate demand Aggregate supply Equilibrium Downward sloping Determinants of AD Aggregate Demand 2/ 20 Aggregate demand: schedule

Transportation Technician Qualification Program ...materialstraining.com/waqtc/2016/Aggregate Full Manual.pdfAGGREGATE WAQTC CONTENTS 03_Agg_TOC Aggregate-ii Pub. October 2016 Chapter

Aggregate supply and aggregate demand

Chapter 12 Aggregate Supply, Aggregate Demand, and ... · PDF fileChapter 12 Aggregate Supply, Aggregate Demand, ... Chapter 12: Aggregate Supply, Aggregate Demand, and ... mentioned

Effect of Aggregate Chemistry and Modification on Moisture ...onlinepubs.trb.org/Onlinepubs/trr/1993/1386/1386-005.pdf38 TRANSPORTATION RESEARCH RECORD 1386 Effect of Aggregate Chemistry

excel functions v10 - Air Transportation Systems Lab at ...128.173.204.63/courses/cee3804/cee3804_pub/excel functions v10.pdf · Using Excel’s Built-in Functions ... Functions are

Forecasting and Aggregate Planning - The University of ...metin/Or6366/Folios/scaggregate.ppt · PPT file · Web viewForecasting and Aggregate Planning ... pdf for more on ... Excel

2006 ANNUAL REPORT FOR THE MONTANA … DEPARTMENT OF TRANSPORTATION RESEARCH PROGRAMS ... Analysis of Coarse Surfacing Aggregate using ... of the Montana Department of Transportation

Chap_33 Aggregate Demand & Aggregate Supply

Asphalt Aggregate Mixturesonlinepubs.trb.org/Onlinepubs/trr/1986/1096/1096-005.pdf · 42 TRANSPORTATION RESEARCH RECORD 1096 Asphalt Aggregate Mixtures J. BONNOT In France, mechanical

Transportation Technician Qualification Program AGGREGATE … · 2019-10-10 · high standards of the Transportation Technician Qualification Program. Please take the time to fill

PUBLICATION: TRANSMITTAL LETTER Publication 2 · Aggregate Gradation, Course Aggregate Wash Test, Course Aggregate Moisture, Course Aggregate Crush Count, Fine Aggregate Gradation,

Cycles in the Transportation Sector and the Aggregate Economyklahiri/TRB2004.pdf · inventories. Thus, transportation activity itself is expected to be highly correlated with inventory

IND780 Task Expert Applications Characteristics Benefits Food Chem Aggregate Metal Transportation

Aggregate demand & aggregate supply