Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 11, Problem 8P
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A diesel engine uses Type A filter and high-grade lubricating oil costing P5.50 per liter. With this filter, the oil and the filter have to be changed every 500 hours of operation, and 5 liters of coil have to be added every 100 hours. This filter costs P148 a piece. Eighty liters of coil fill the engine. Another type, filter B, costing P120 may be used with a lower grade of oil costing P4.80 per liter. However, if this filter is used, the oil and filter have to be changed every 300 hours, and 10 liters are added after each 150 hours the engine is used. Which type of filter and oil would you recommend?
A city of 70000 residents has an average water demand of 250 L/ca.day. The institutional and commercial, and industrial average areas in the city are 250 and 350 Ha, and water demand expected is 20 and 23 m3 /Ha.d. The public water use and water unaccounted for are 10 and 6 % of total municipal water demand, respectively. Calculate total municipal demand and each component quantity as a % of total municipal demand.
A landscape contractor is hired to cultivate ornamental Plants in three new residential developments. The contrsctor charges the developer for each tree cultivated, an hourly rate to cultivate the ornamental plants, and a fixed delivery charge. In one development it took 211 labour hours to cultivate 244 ornamental plants for a cost of $9394. In second development it took 128 labour hours to cultivate 283 ornamental plants for a cost of $8270. In the final devolopment ir took 165 labour hours to cultivate 386 ornamental plants for a cost of $10938. In total 504 labour hours were taken and 913 ornamental plants were cultivated.
Using cramer's rule of the inverse method, determine the cost for each tree, the hourly labour charge and the delivery charge.
Chapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 11 - Kelson Sporting Equipment, Inc., makes two types...Ch. 11 - The Sea Wharf Restaurant would like to determine...Ch. 11 - Blair Rosen. Inc. (BR) is a brokerage firm that...Ch. 11 - Round Tree Manor is a hotel that provides two...Ch. 11 - Industrial Designs has been awarded a contract to...Ch. 11 - Vollmer Manufacturing makes three components for...Ch. 11 - Photon Technologies, Inc., a manufacturer of...Ch. 11 - The Westchester Chamber of Commerce periodically...Ch. 11 - The management of Hartman Company is trying to...Ch. 11 - The employee credit union at State University is...
Ch. 11 - The Atlantic Seafood Company (ASC) is a buyer and...Ch. 11 - The Silver Star Bicycle Company will manufacture...Ch. 11 - The Clark County Sheriff’s Department schedules...Ch. 11 - Bay Oil produces two types of fuel (regular and...Ch. 11 - Consider the following network representation of a...Ch. 11 - Refer to the transportation problem described in...Ch. 11 - Aggie Power Generation supplies electrical power...Ch. 11 - The Calhoun Textile Mill is in the process of...Ch. 11 - Refer to the Calhoun Textile Mill production...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Solve Exercise 14 if a 25 solution of the same mixture is added instead of pure alcohol.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_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_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. 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_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.Solve for the Constraints.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_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. a. Define the variable used: b. LP Model: Objective function c. Constraints:arrow_forwardYour 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_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 manufacturer has a steady annual demand for 10,850 cases of sugar. It costs $7 to store 1 case for 1 year, $31 in set up cost to produce each batch, and $15 to produce each case. Find the number of cases per batch that should be produced to minimize cost. The manufacturer should produce cases per batch. (Round to the nearest whole number as needed.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY