Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Photon Technologies, Inc. a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery

image text in transcribedimage text in transcribed Photon Technologies, Inc. a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line of phone. The contract calls for the following: 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: 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 550,000 units at the Philippines plant and 440,000 units at the Mexico plant. The PT-300 production capacities are 475,000 units at the Philippines plant and 300,000 units at the Mexico plant. The cost of shipping from the Philippines plant is $0.45 per unit, and the cost of shipping from the Mexico plant is $0.30 per unit. Develop a linear program that Photon Technologies can use to determine how many units (in 000s, thousands) of each battery pack to produce at each plant to minimize the total production and shipping cost associated with the new contract. Remember, your answer should be in thousands of units and should not include a decimal point or comma. What is the total cost (in dollars, not thousands of dollars) ? Please do not include a dollar sign in your answer. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Photon \\ Parameters \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multirow{2}{*}{ Battery Pack } & & & Plant & PER UNIT & & & \multirow[b]{2}{*}{ Capacities } & & \\ \hline & \multicolumn{2}{|c|}{ Production Quantity (000s) } & Product & \multicolumn{2}{|c|}{ Philippines Mexico } & & & \multicolumn{2}{|c|}{ Philippines Mexico } \\ \hline PT-100 & 500 & & PT-100 & $1.11 & $1.13 & & PT-100+ PT-200 & 550 & 440 \\ \hline PT-200 & 300 & & PT-200 & $1.17 & $1.27 & & PT-300 & 475 & 300 \\ \hline \multirow[t]{2}{*}{ PT-300 } & 750 & & PT-300 & $1.75 & $1.48 & & & & \\ \hline & & & Shipping & $0.45 & $0.30 & & & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Model } \\ \hline & & & & & & & & & \\ \hline Product & Philippines & Mexico & \begin{tabular}{l} Total (000s) for \\ each product \end{tabular} & & & \multicolumn{2}{|c|}{ Philippines Mexico } & & \\ \hline \multicolumn{3}{|l|}{ PT-100 (000s) } & & & \multicolumn{2}{|c|}{ PT-100 + PT-200 } & & & \\ \hline \multicolumn{3}{|l|}{ PT-200 (000s) } & & & PT -300 & & & & \\ \hline \multicolumn{10}{|l|}{ PT-300 (000s) } \\ \hline \multicolumn{10}{|c|}{ Total (000s) for each plant } \\ \hline & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{ Production Cost }} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Shipping Cost } \\ \hline \multicolumn{10}{|l|}{ Total Cost (000s)} \\ \hline Total Actual Cost & & & & & & & & & \\ \hline \end{tabular} Photon Technologies, Inc. a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line of phone. The contract calls for the following: 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: 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 550,000 units at the Philippines plant and 440,000 units at the Mexico plant. The PT-300 production capacities are 475,000 units at the Philippines plant and 300,000 units at the Mexico plant. The cost of shipping from the Philippines plant is $0.45 per unit, and the cost of shipping from the Mexico plant is $0.30 per unit. Develop a linear program that Photon Technologies can use to determine how many units (in 000s, thousands) of each battery pack to produce at each plant to minimize the total production and shipping cost associated with the new contract. Remember, your answer should be in thousands of units and should not include a decimal point or comma. What is the total cost (in dollars, not thousands of dollars) ? Please do not include a dollar sign in your answer. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Photon \\ Parameters \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multirow{2}{*}{ Battery Pack } & & & Plant & PER UNIT & & & \multirow[b]{2}{*}{ Capacities } & & \\ \hline & \multicolumn{2}{|c|}{ Production Quantity (000s) } & Product & \multicolumn{2}{|c|}{ Philippines Mexico } & & & \multicolumn{2}{|c|}{ Philippines Mexico } \\ \hline PT-100 & 500 & & PT-100 & $1.11 & $1.13 & & PT-100+ PT-200 & 550 & 440 \\ \hline PT-200 & 300 & & PT-200 & $1.17 & $1.27 & & PT-300 & 475 & 300 \\ \hline \multirow[t]{2}{*}{ PT-300 } & 750 & & PT-300 & $1.75 & $1.48 & & & & \\ \hline & & & Shipping & $0.45 & $0.30 & & & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Model } \\ \hline & & & & & & & & & \\ \hline Product & Philippines & Mexico & \begin{tabular}{l} Total (000s) for \\ each product \end{tabular} & & & \multicolumn{2}{|c|}{ Philippines Mexico } & & \\ \hline \multicolumn{3}{|l|}{ PT-100 (000s) } & & & \multicolumn{2}{|c|}{ PT-100 + PT-200 } & & & \\ \hline \multicolumn{3}{|l|}{ PT-200 (000s) } & & & PT -300 & & & & \\ \hline \multicolumn{10}{|l|}{ PT-300 (000s) } \\ \hline \multicolumn{10}{|c|}{ Total (000s) for each plant } \\ \hline & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{ Production Cost }} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Shipping Cost } \\ \hline \multicolumn{10}{|l|}{ Total Cost (000s)} \\ \hline Total Actual Cost & & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions