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 phones. 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 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.18 per unit, and the cost of shipping from the Mexico plant is $0.10 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.
- 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.
- 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.
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
- Solve Exercise 14 if a 25 solution of the same mixture is added instead of pure alcohol.arrow_forwardA company needs to choose one supplier for a particular type of silicon wafer used in the production of semiconductors. The company has three options. Supplier A sells the silicon wafers for $2.40 per wafer, independently of the number of wafers ordered. Supplier B sells the wafers for $2.20 each but does not consider an order for less than 2,000 wafers. Supplier C sells the wafers for $2.00 each but does not accept an order for less than 3,000 wafers. Assume an order setup cost of $200 and an annual requirement of 10,000 wafers. Assume a 20% annual interest rate for holding cost calculations. Which supplier should be chosen to minimize the total annual cost for the wafers, and what is the optimal order quantity? If the replenishment lead time for wafers is three months, determine the reorder point based on the on-hand level of inventory of wafers.arrow_forwardA company makes three components for sale. The components are processed on two machines: a shaper and a grinder. The time required. (in minutes) on each machine are as follows: Component Shaper Time Grinder Time A 6 4 B 4 5 C 4 2 The shaper is available for 7200 min. and grinder for 6600 min. No more than 200 units of component C can be sold, but up to 1000 units of each of the other components can be sold. In fact the company has orders for 600 units of component A that must be satisfied. The profit contributions for components A, B and C are $8, $6 and $9 respectively. Formulate the problem for deciding the production quantities. Solve the problem using Excel Solver. Run the sensitivity analysis report in Excel Solver. What are the objective coefficient ranges (Range of Optimality) for each coefficient. Interpret these. What are the dual prices for each constraint? Interpret these. What are the right-hand side ranges (Range of Feasibility)? Interpret them. If more time is…arrow_forward
- A Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month's production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem.Solve for the Constraints.arrow_forwardA Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month’s production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem. a. Define the variable used: b. LP Model: Objective function c. Constraints:arrow_forwardA Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month’s production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem. In the given probelm, company produces precision medical diagnostic equipment at two factories i.e.,Fatory 1 and Factory 2. Three medical centers i.e., Customer 1, Customer 2, Customer 3 have placed orders for this month’s production output. Consider variables xijxij that denotes the number of units that are shipped from factory ii to customer jj. Where i=1,2 and j=1,2,3Where i=1,2 and j=1,2,3 The objective function is given by…arrow_forward
- Your desktop computer uses between 100 - 250 watts when in use (depending on the components) and around 3 watts when turned off (on average). NIPSCO is currently charging $0.1165 per kilowatt-hour. How much would you pay for electricity each year even if you never turned your computer on? What if you had it on 24 hours per day, every day? What if you turned it off every night, and only turned it on every evening for a few hours?arrow_forwardTrans Global Tractor Trailers has decided to spend up to $2,700,000 on a fleet of new trucks, and it is considering three models: the Gigahaul, which has a capacity of 6,000 cubic feet and is priced at $60,000; the Megahaul, with a capacity of 5,000 cubic feet, priced at $50,000; and the Picohaul, with a capacity of 2,000 cubic feet, priced at $40,000. The anticipated annual revenues are $500,000 for each new truck purchased (regardless of size). Trans Global would like a total capacity of up to 234,000 cubic feet and feels that it cannot provide drivers and maintenance for more than 54 trucks.How many of each should it purchase to maximize annual revenue? (Gigahaul, Megahaul, Picohaul) = trucks What is the largest possible revenue it can make? $arrow_forwardA Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month’s production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem. a. Define the variable used: b. LP Model: c. Objective function d. Identify the feasible region: e. Corner points and the value of objective function f. Final Anser Please help, thank you so much!arrow_forward
- The number of collection vehicles a community would need for solid waste collection in a certain municipality is 6 trucks. Find a total number of services (customers) that are to be collected once per week during 4 working days. (Realistically, most trucks can service only about 200 to 300 customers before the truck is full and a trip to the landfill is necessary).arrow_forwardAssume that the production of 1 unit of magnesium requires 0.8 units of magnesium and 0.2 units of aluminum, and that the production of 1 unit of aluminum requires 0.3 units of magnesium and 0.2 units of aluminum.arrow_forwardA computer company has manufacturing plants in Raleigh and Palo Alto. The Raleigh plant manufactures 330 keyboards per week, whereas the Palo Alto plant produces 670. The company has stores in Chicago and Denver. The Chicago store orders 590 keyboards per week and the Denver store orders 410. The shipping costs per keyboard from each factory to each store are as follows: Raleigh to Chicago: $7 Raleigh to Denver $10 Palo Alto to Chicago: $12 Palo Alto to Denver: $9arrow_forward
- Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,