Question

The Doan Modianos Manufacturing Company is putting out seven new electronic components. Each of Modianos eight plants has the capacity to add one more product to its current line of electronic parts. The unit manufacturing costs for producing the different parts at the eight plants are shown in the accompanying table How should Modianos assign the new products to the plants in order to minimize manufacturing costs? Plants Electronic Components C53 C81 D5 D44 E2 E35 G99 4 $0.10 $0.12 $0.13 $0.11 $0.10 $0.06 $0.16 $0.12 $0.05 $0.06 $0.04 $0.08 $0.04 $0.09 $0.06 $0.06 S0.32 $0.40 $0.31 $0.30 $0.42 S0.35 $0.36 $0.49 $0.17 $0.14 $0.19 $0.15 $0.10 $0.16 $0.19 $0.12 $0.06 $0.07 $0.10 $0.05 $0.08 $0.10 $0.11$0.05 $0.08 $0.10 $0.12 $0.08 $0.09 $0.10 $0.09 $0.06 $0.55 $0.62 $0.61 $0.70 $0.62 $0.63 $0.65 $0.59Determine the optimal assignments. Electronic Components C53 C81 D5 D44 E2 E35 G99 Plant

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Totals SUM(C3:J3) SUM(C4.J4) SUM(C5:J5) SUM(C6:16) SUM(C7:J7) SUM(C8 :J8) SUM(C919) C53 C81 D5 4 E35 G99 10 Totals SUM(C3:C9) SUMD3D9 SUM E3 E9) SUM(F3 F9) SUM(G3:G9) SUMH3 H9) SUM(I3I9) SUM(J3:J9) 12 13 14 15 16 17 E2 18 E35 19 20 21| Total cost-sUMPRODUCT(C3:19,C13:J19) C53 C81 D5 0.12 0.06 0.4 0.14 0.07 0.13 0.04 0.31 0.19 0.16 0.06 0.36 0.19 0.11 0.09 0.65 0.12 0.06 0.49 0.12 0.05 0.06 0.59 0.11 0.08 0.06 0.09 0.35 0.16 0.05 0.32 0.17 0.06 0.08 0.55 0.04 0.42 0.15 0.05 0.08 0.7 0.08 0.09 0.62 0.12 0.61 G99 0.62 0.63

Solution

Total cost = $1.18

Assignments

C53 --> Plant 6
C81 --> Plant 3
D5 --> Plant 4
D44 --> Plant 5
E2 --> Plant 2
E35 --> Plant 8
G99 --> Plant 1

Add a comment
Know the answer?
Add Answer to:
The Doan Modianos Manufacturing Company is putting out seven new electronic components. Each of Modianos' eight...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please calculate the chemical shift for Ha using the "Aromatic Proton Shift Calculation" Table. Ha H3C02C...

    Please calculate the chemical shift for Ha using the "Aromatic Proton Shift Calculation" Table. Ha H3C02C CN MezN Hb Hc Answer: Fr Jump to... CHEM 308 Class 15.04.2024 CHEM 308 AROMATIC PROTONS CHEMICAL SHIFT CALCULATION SHEET H Zomo DAH = 7.36 + Zorme + Zmeta + Zpara Z mets Zpara Zi for R (ppm) Substituent R Zortho Zmeta Zpara Zmet Zpara H CH, 0.0 -0.18 0.02 0.02 -0.07 C(CH3) CHCI CH,OH 0.0 -0.11 -0.08 -0.01 -0.07 Zi for R (ppm)...

  • a) Which 2 pairs of variables are most correlated with the regressand? b) Which 3 pairs of variables are mostly multicollinear? c) Identify 3 pairs of variables that are most correlated.

    3.      The University Secretary wants to determine how University grade point average, GPA (highest being 4.0) of a sample of students from the University depends on a student’s high school GPA (HS), age of a student (A), achievement test score (AS), average number of lectures skipped each week (S), gender of a student (where M=1 if a student is male or 0 otherwise), computer or PC ownership of a student (where PC=1 if a student owns a computer or 0...

  • Please answer the NMR tables for wintergreen and Pear, can you please make it as neat...

    Please answer the NMR tables for wintergreen and Pear, can you please make it as neat as possible thanks! WINTERGREEN Pear The procedure below is written as if you were conducting this experiment in the lab. You will nee to read through it carefully to complete the lab report and answer the questions appropriately For NMR analyses, complete the spectral assignments as shown in the example below. Example of a 'H-NMR analysis table: HoHo Ha Iodomethane Há На Chemical Shift...

  • The following results were obtained from an undrained shear box test carried out on a set...

    The following results were obtained from an undrained shear box test carried out on a set of undisturbed soil samples. 0.2 0.8 Normal Load (N) Strain (%) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 0 21 46 70 89 107 121 131 136 138 138 137 136 0.4 Shearing force (N) 0 33 72 110 139 164 180 192 201 210 217 224 230 234 237 236 0 45...

  • The following results were obtained from an undrained shear box test carried out on a set...

    The following results were obtained from an undrained shear box test carried out on a set of undisturbed soil samples. 0.2 0.8 Normal Load (N) Strain (%) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 0 21 46 70 89 107 121 131 136 138 138 137 136 0.4 Shearing force (N) 0 33 72 110 139 164 180 192 201 210 217 224 230 234 237 236 0 45...

  • 0.00 0.20 0.60 0.43 0.75 0.27 1.45 0.19 0.26 0.04 0.61 0.26 0.80 0.36 0.26 1.30 0.01...

    0.00 0.20 0.60 0.43 0.75 0.27 1.45 0.19 0.26 0.04 0.61 0.26 0.80 0.36 0.26 1.30 0.01 0.10 0.06 0.19 0.51 1.74 0.01 0.19 0.06 0.19 0.17 0.25 0.24 0.36 0.15 0.36 0.07 1.18 0.83 0.23 0.06 0.01 0.05 0.78 1.14 0.41 0.38 0.40 1.46 0.07 0.63 0.91 0.21 0.75 0.19 0.59 0.12 1.12 0.97 0.02 0.04 0.38 0.56 0.33 0.16 0.16 0.29 0.24 0.02 0.98 0.44 0.19 0.63 0.59 0.50 0.40 1.56 0.12 3.17 0.13 0.41 0.11 0.05 0.59...

  • Can you please show the structure of the ester and fill out an NMR analysis table...

    Can you please show the structure of the ester and fill out an NMR analysis table for the synthesis of banana based on the NMR below? Could you also briefly explain your choice? 2. Banana Acid: Acetic acid Alcohol: Isoamyl alcohol Structure of the ester: Example of a’H-NMR analysis table: Hb Ho Labeled structure: Ha Há Ha Chemical Shift (ppm) Integration Splitting (n+1 rule) Structural Assignment (label of the corresponding proton) 1.8 ppm 3 3 Н. 3.1 ppm 2 4...

  • Questions 1. Given the H NMR spectrum and molec- ular formula for each of the following compounds, deduce the...

    Questions 1. Given the H NMR spectrum and molec- ular formula for each of the following compounds, deduce the structure of the compound, estimate the chemical shifts of all its protons using the parameters in Tables 22.3–22.5, and assign the NMR sig- nals to their respective protons. (a) C.H,,Cl; 1H NMR (CDC12): 8 3.33 (2H, s); 1.10 (9H, s) (b) C-H,,0,; 1H NMR (CDC12): 8 3.88 (1H, s); 2.25 (3H, s); 1.40 (6H, s) (C) CH,,0,; 1H NMR (CDC1,): 8...

  • Can you please show the structure of the ester in the first chart and fill out...

    Can you please show the structure of the ester in the first chart and fill out an NMR analysis table for the synthesis of orange based on the NMR below? Could you also briefly explain your answer? 14. Fill out the table below. Complete the NMR analysis (prepare a table similar to the one given on page 4). The NMR spectrum of the ester is posted on Canvas (Modules section, “Spectral Files for Labs" folder). 3. Orange Acid: Acetic acid...

  • Use Table 8.1, a computer, or a calculator to answer the following. Suppose a candidate for...

    Use Table 8.1, a computer, or a calculator to answer the following. Suppose a candidate for public office is favored by only 47% of the voters. If a sample survey randomly selects 2,500 voters, the percentage in the sample who favor the candidate can be thought of as a measurement from a normal curve with a mean of 47% and a standard deviation of 1%. Based on this information, how often (as a %) would such a survey show that...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT