1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
frez [133]
3 years ago
11

Photon Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacture

r to produce three models of lithium-ion battery packs for a new line of phones. The contract calls for the following
Battery Pack Production Quantity
PT-100 200,000
PT-200 100,000
PT-300 150,000
Photon Technologies can manufacture the battery packs at manufacturing plants located in the Philippines and Mexico. The unit cost of the battery packs differs at the two plants because of differences in production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows:
Plant
Product Philippines Mexico
PT-100 0.95 0.98
PT-200 1.34 0.98
PT-300 1.06 1.15
The PT-100 and PT-200 battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of PT-100 and PT-200 battery packs produced. The combined PT-100 and PT-200 production capacities are 175,000 units at the Philippines plant and 160,000 units at the Mexico plant. The PT-300 production capacities are 75,000 units at the Philippines plant and 100,000 units at the Mexico plant. The cost of shipping from the Philippines plant is $0.15 per unit, and the cost of shipping from the Mexico plant is 0.08 per unit.
(a) Develop a linear program that Photon Technologies can use to determine how many units of each battery pack to produce at each plant to minimize the total production and shipping cost associated with the new contract.
(b) Solve the linear program developed in part (a), to determine the optimal production plan. Qty Produced Phillipines Mexico PT-100 16000c 40000 PT-200 100000 0 5000 1000 PT-300 Total Cost-$
(c) Use sensitivity analysis to determine how much the production and/or shipping cost per unit would have to change to produce additional units of the PT-100 in the Philippines plant. If required, round your answer to two decimal digits At least $ / unit.
(d) Use sensitivity analysis to determine how much the production and/or shipping cost per unit would have to change to produce additional units of the PT-200 in the Mexico plant. If required, round your answer to two decimal digits. At least $ .05/ unit.

Business
2 answers:
julia-pushkina [17]3 years ago
6 0

Answer:

a

Explanation:

777dan777 [17]3 years ago
4 0

Answer:

Check the explanation

Explanation:

a) Linear program model:

Decision variables: Let

P1 = Number of PT-100 products produced at Philippines plant

P2 = Number of PT-200 products produced at Philippines plant

P1 = Number of PT-300 products produced at Philippines plant

M1 = Number of PT-100 products produced at Mexico plant

M2 = Number of PT-200 products produced at Mexico plant

M3 = Number of PT-300 products produced at Mexico plant

Objective: Min (0.95+0.15)P1 + (0.98+0.15)P2 + (1.34+0.15)P3 + (0.98+0.08)M1 + (1.06+0.08)M2 + (1.15+0.08)M3

or,

Min 1.10P1 + 1.13P2 + 1.49P3 + 1.06M1 + 1.14M2 + 1.23M3

s.t.

P1 + M1 ≥ 200,000

P2 + M2 ≥ 100,000

P3 + M3 ≥ 150,000

P1 + P2 ≤ 175,000

M1 + M2 ≤ 160,000

P3 ≤ 75,000

M3 ≤ 100,000

P1, P2, P3, M1, M2, M3 ≥ 0

(b) Solution of the linear program using Excel Solver can be seen in the first attached image below.

Formula: H2 =SUMPRODUCT(B2:G2,$B$11:$G$11)   copy to H2:H9

Optimal Solution:

Decision Variable              Value

P1                                     40000

P2                                     100000

P3                                     50000

M1                                     160000

M2                                     0

M3                                     100000

Total production and shipping cost = $ 524,100

Sensitivity report can be seen in the second attached image below.

Referring to above sensitivity analysis,

(c) Allowable decrease in objective coefficient of P1 is 0.04 therefore production and/or shipping cost per unit has to decrease by $ 0.04 to produce additional units of PT-100 in Philippines plant.

(d) Allowable decrease in objective coefficient of M2 is 0.05 therefore production and/or shipping cost per unit have to be decreased by $ 0.05 to produce additional units of PT-200 in Mexico plant.

You might be interested in
healthcare, paid time off, disability insurance, and matching contributions to a retirement account are all types of
Leto [7]

Answer:

people

Explanation:

because I know ..........................

3 0
3 years ago
A firm that uses ___________ segmentation divides a market into groups based on life stage, race, or profession.
Triss [41]

Answer:

Demographic

Explanation:

Demographic segmentation is often used in marketing to group customers according to demographic factors. The demographic factors include- age, gender, occupation, race, religion and income.

Other forms of segmentation includes :

1. Behavioural segmentation

2. Geographic segmentation

3. Psychographic segmentation

I hope my answer helps you

7 0
3 years ago
A factor that most influences changes in consumer demand is
aksik [14]
A factor that most influences changes in consmer demand is pice makes the most senice to me good luck
4 0
3 years ago
Read 2 more answers
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating mai
Lelu [443]

Answer:

Month       Maintenance      Machine     Equation       MAPE

                 costs                   hours          error (Abs.)

1                $2,750                1,840           $269            9.78%

2               $2,910                 1,920           $197             6.77%

3               $3,060                2,000          $135              4.41%

4               $3,170                 2,020            $47              1.48%

5               $<u>3,250</u>                <u>2,050</u>                0                 0%

6               $3,220                2,030             $8             0.25%

7               $3,160                 2,010            $46              1.46%

8               $3,000                1,990           $184             6.13%

9               $2,770                1,850           $260            9.39%

10             <u>$2,370</u>                <u>1,250</u>                  0                 0%

11              $2,380                1,450             $210           8.82%

12             $2,600                1,740            $309           <u>11.88%</u>

                                                                                    60.37%

variable cost per unit = (highest activity cost - lowest activity cost) / (highest activity units - lowest activity units) = ($3,250 - $2,370) / (2,050 - 1,250) = $880 / 800 units = $1.10 per unit

fixed cost = $3,250 – ($1.10 x 2,050) = $995

Cost model = $995 + $1.10X

2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.

MAPE = 60.37% / 12 = 5.03%

5 0
3 years ago
Cultural convergence says that media companies will continue to produce messages for large audiences, but according to this view
crimeas [40]

Answer: Personalized messages which will be tailored to individual needs

Explanation:

Cultural convergence is a theory which simply implies that as two cultures interact together often, they will increasingly become somewhat similar as their arts, ideas, values will almost be thesame.

Cultural convergence says that media companies will continue to produce messages for large audiences, but according to this view, audiences will more frequently receive Personalized messages which will be tailored to individual needs.

7 0
3 years ago
Other questions:
  • Jasper is a self-employed businessman. on march 5, 2015 he purchases a personal computer for use at his home. he uses the comput
    11·1 answer
  • Bonnie and james are retired. they wish to continue to invest in their portfolio and are seeking income instead of growth. which
    11·1 answer
  • Henry is a landlord renting an apartment to​ Steven, a student at a nearby university. The two enter into a​ one-year lease arra
    15·1 answer
  • Kirnon Clinic uses client-visits as its measure of activity. During July, the clinic budgeted for 2,000 client-visits, but its a
    15·1 answer
  • Patrick Company expects to generate freeminuscash of​ $120,000 per year forever. If the​ firm's required return is 12​ percent,
    9·1 answer
  • Two friends, Rachel and Joey, enjoy baking bread and making apple pie. rachel takes 2 hours to bake a loaf of bread and 1 hour t
    10·1 answer
  • Golden Eagle Company prepares monthly financial statements for its bank. The November 30 adjusted trial balance includes the fol
    8·1 answer
  • What is an example of an interest leading to a career choice
    14·1 answer
  • 4. Which of the following financial statements is the main tool for figuring out how much
    9·2 answers
  • How to overcome the challenges that affect the quality of teaching science?​
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!