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?
Create an LP Model.
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
- A 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_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_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_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_forwardTrans Global Tractor Trailers has decided to spend up to $1,800,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 156,000 cubic feet and feels that it cannot provide drivers and maintenance for more than 36 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 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_forwardBruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurants. His local milk supplier charges $0.50 per kilogram of milk plus a $15 delivery fee (the $15 fee is independent of the amount ordered). Bruno's holding cost is $0.03 per kilogram per month. He needs 8,250 kilograms of milk per month. Suppose Bruno orders 10,000 kilograms each time. What is his average inventory (in kilograms)? Suppose Bruno orders 6,250 kilograms each time. How many orders does he place with his supplier each year? Note: Round your answer to 1 decimal place. How many kilograms should Bruno order from his supplier with each order to minimize the sum of the ordering and holding costs? If Bruno's storage vessel can hold only 2,000 kilograms of milk, what would be Bruno's annual ordering and holding costs if he orders this amount? If Bruno's storage vessel can hold only 7, 000 kilograms of milk, what would be Bruno's annual ordering and holding costs if he orders…arrow_forwardTMA manufactures 37-in. high-definition LCD televisions in two separate locations: Location I and Location II. The output at Location I is at most 6500 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 2600 and 4100 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows. To Pulsar Factories From TMA City A City B Location I $7 $4 Location II $8 $8 TMA will ship x televisions from Location I to City A and y televisions from Location I to City B. Find a shipping schedule that meets the requirements of both companies while keeping costs, C (in dollars), to a minimum. Minimize C =…arrow_forward
- Transformers for underground works were planned to be provided. Type A has an initial cost of $70,000 and a life of 8 years. Type B has an initial cost of $95,000 and a life expectancy of 12 years. The annual operating cost for type A is expected to be $9000, while the AOC for type B is expected to be $7000. Salvage values are $5000 for type A, and $10,000 for type B. Using the incremental cash flow analysis, choose the better alternative.arrow_forwardA manufacturing firm has received a contract to assemble 1000 units of test equipment in the next year. The firm must decide how to organize its assembly operation. Skilled workers, at $33 per hour each, can individually assemble the test equipment in 2.6 hours per unit. Alternatively, teams of four less skilled workers (at $19 per hour per worker) can assemble a unit in one hour. Which approach is more economical?arrow_forwardPenn Hospital generated net patient revenues of $225 million for 20X1, and its cash collections were $210 million. The revenue cycle management costs to collect these revenues were $8 million. Calculate Penn's cost to collect for the year. What is Penn's cost to collect for the year if 35% of the cash collections during the year required human intervention and its EDI costs were $600,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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