Scribd Logo
Upload

Welcome to Scribd!

  • 254 views

    Shelby Shelving

    Uploaded by

    rellimnoj
    The document provides data on production costs, capacities, and demands for multiple products and time periods. It includes the costs and machine time requirements to produce different products, the production quantities and available capacities. The summary aims to maximize total profit by determining the optimal production quantities and allocation of machine hours across products and time periods, while satisfying demand and capacity constraints.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Shelby Shelving

    Uploaded by

    rellimnoj
    254 views10 pages
    The document provides data on production costs, capacities, and demands for multiple products and time periods. It includes the costs and machine time requirements to produce different products, the production quantities and available capacities. The summary aims to maximize total profit by determining the optimal production quantities and allocation of machine hours across products and time periods, while satisfying demand and capacity constraints.

    Original Description:

    Shelby Shelving Problem

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides data on production costs, capacities, and demands for multiple products and time periods. It includes the costs and machine time requirements to produce different products, the production quantities and available capacities. The summary aims to maximize total profit by determining the optimal production quantities and allocation of machine hours across products and time periods, while satisfying demand and capacity constraints.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    254 views10 pages

    Shelby Shelving

    Uploaded by

    rellimnoj
    The document provides data on production costs, capacities, and demands for multiple products and time periods. It includes the costs and machine time requirements to produce different products, the production quantities and available capacities. The summary aims to maximize total profit by determining the optimal production quantities and allocation of machine hours across products and time periods, while satisfying demand and capacity constraints.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 10

    Given Data Cost A B C Process 1 Process 2 4 1 3 1 1 1 1 0 X1 0 A B 10 7 4 1 1 -2 -5 5 4 3 2 2 1 0 C

    Graphical Solution to
    10 1 29 38 37 46 55 4 3 2 1 0 0

    Constraints A B C Cost

    Produced 11 5 3 14

    Demand 10 5 3

    X2

    Decision Variables Process 1 Process 2 3 2

    10 0

    2 X1

    Graphical Solution to 3.1


    Isocost=14 14 10 6 2 2 -2 -6

    A B C Isocost=14

    4 X1

    Decision Variables Unit Profit Produced

    Truck Type 1 2 300 500 0 700

    Dedicated Capacity Painting Assembly Profit

    1 800 1500 350000

    2 700 1200

    Used 1 0.583333

    Available 1 1

    Given Data Production Costs Inventory Costs Produced Available Demand Inventory Cost

    1 13 2 30 20 20 15 590

    Week 2 14 2 10 20 10 15

    3 15 2 0 15 15 0

    Given Data Cheesecake Black Forest Cheesecake Produced Demand Inventory Black Forest Produced Demand Inventory Total Capacity Cost

    1 3 2.5

    Baking Costs 2 3.4 2.8

    3 3.8 3.4

    Holding Cost 0.5 0.4

    45 40 5

    25 30 0

    20 20 0

    20 20 0 65 65 464.5

    40 30 10 65 65

    0 10 0 20 65

    Given Data Shirts Pants

    Cloth Used 2 3 Regular Time 4

    Demand in Month 1 2 1000 1200 1500 1400 Overtime 8 Inventory 3

    Costs

    Produced Shirts Pants Total Capacity

    Month 1 Month 2 Regular Time Overtime Regular Time Overtime 900 0 1200 0 1400 0 1300 0 2300 2500 2500 2500

    Inventory Shirts Pants Cloth

    Month 1 0 100

    Month 2 0 0 Month 2 Available Used 9000 6300

    Month 1 Available Used 9000 6000 19500

    Cost

    Costs Drug 1 Drug 2 Machine Time Drug 1 Drug 2

    Indy 4.1 4.5 Indy 0.2 0.3

    LA 4 5.2 LA 0.24 0.33

    Decision Variables Produced Drug 1 Drug 2 Total Machine Time

    Indy LA 0 1000 1666.667 333.3333 Used Indy 500 LA 350

    Total 1000 2000 Available Indy LA 500 400

    Demand 1000 2000

    Cost

    13233.33

    Shelby Shelving Company LP Formulation Machine requirements (hours per unit) Model S Stamping 0.3 Forming 0.25 Model S 1900 <= 1900

    Model LX 0.3 0.5 Model LX 650 <= 1400

    Production per month Assembly capacity Constraints on hourly usage Stamping Forming

    Hours used 765 800

    <= <=

    Available 800 800

    Profit analysis - your job is to complete it and then run the Solver Unit selling price $1,800 $2,100 Unit variable costs Labor 175 210 Material $1,000 $1,200 Overhead $365 $445 Total $1,540 $1,855 Total revenue Total variable cost Fixed overhead Profit $4,785,000 $4,131,750 $385,000 $268,250

    Shelby Shelving Data for Current Production Schedule Machine requirements (hours per unit) Model S Model LX 0.3 0.3 0.25 0.5 Model S Model LX 400 1400 Given monthly overhead cost data

    Stamping Forming

    Stamping Forming Model S Assembly Model LX Assembly

    Current monthly production Hours spent in departments Stamping Forming

    Standard costs of the shelves -- based on the cu Model S Model LX 120 420 100 700 Totals 540 800 Direct materials Direct labor: Stamping Forming Assembly Total direct labor Overhead allocation Stamping Forming Assembly Total overhead Total cost

    Percentages of time spent in departments Model S Model LX Stamping 22.2% 77.8% Forming 12.5% 87.5%

    hly overhead cost data Fixed Variable S $125,000 $80 $95,000 $120 $80,000 $165 $85,000 $0 Variable LX $90 $170 $0 $185

    sts of the shelves -- based on the current production levels Model S Model LX $1,000 $1,200 $35 $60 $80 $175 $149 $150 $365 $664 $1,839 $159 $229 $246 $635 $2,045 $35 $90 $85 $210

    You might also like