• Home
  • Blog
  • Michigan Cost Capacity & Demand for Shipping Widgets to Distribution Centers Excel

Michigan Cost Capacity & Demand for Shipping Widgets to Distribution Centers Excel

0 comments

  1. Cost, capacity, and demand for shipping widgets from plants (A & B) to distribution centers (X through Z) can be found in the table below. How many should be shipped from each plant to each distribution center if cost is to be minimized?
    PlantDistribution W X Y Z Capacity
    A $12.60 $14.35 $11.52 $17.58 1,200
    B $9.75 $16.26 $8.11 $17.92 800
    Demand 150 350 500 1,000
  2. A new mix is being developed that is to contain at least 13% protein and 15% fat with no more than 14% fiber. Nutrients and the wholesale cost per pound for the potential ingredients are in the table below. What is the minimal cost mixture that meets these requirements?
    Ingredient Protein% Fat% Fiber% Cost/lb
    Sunflower seeds 16.9 26.0 29.0 $0.22
    White millet 12.0 4.1 8.3 $0.19
    Kibble corn 8.5 3.8 2.7 $0.10
    Oats 15.4 6.3 2.4 $0.10
    Cracked corn 8.5 3.8 2.7 $0.07
    Wheat 12.0 1.7 2.3 $0.05
    Safflower 18.0 17.9 28.8 $0.26
    Canary grass seed 11.9 4.0 10.9 $0.11
  3. $100,000 had been invested in the top four holdings in the table below. There are several more options available. Please reallocate these funds using the following restrictions in a manner that maximizes the net return.–Keep at least $5000 in savingsInvest at least 14% in the money market fundInvest at least 16% in international fundsKeep 35% in current holdingsNo more than 20% in any one investment except money market and savings accounts.Allocate at least 30% into new investments.
    Investment Average return % Expenses %
    Large cap blend 17.2 0.93
    Small cap growth 20.4 0.56
    Green fund 26.3 0.70
    Growth and income 15.6 0.92
    Multicap growth 19.8 0.92
    Midcap index 22.1 0.22
    Multicap core 27.9 0.98
    Small cap international 35.0 0.54
    Emerging international 36.1 1.17
    Money market fund 4.75 0
    Savings account 1.0 0

  4. A mill produces three types of make-to-order fabrics using 15 regular and 3 dobbie looms operating 24/7 during a 13-week period. After weaving, fabrics are sent to finishing before sale. If demand exceeds weaving capacity, fabric will be purchased from an external supplier and then sent to finishing before sale. The table below has detail about the fabrics and the looms. Which looms should produce each fabric and, if necessary, how much of each fabric should be bought externally?
    Fabric Demand (yd) Dobbie Capacity (yd/hr) Regular Capacity (yd/hr) Mill Cost ($/yd) Outsource Cost ($/yd)
    1 45,000 4.7 0.0 0.65 0.85
    2 76,500 5.2 5.2 0.61 0.75
    3 10,000 4.4 4.4 0.50 0.65

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}