Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 13QP
a)
Summary Introduction
To formulate: An LP model for the problem.
b)
Summary Introduction
To sketch: The feasible region for the problem.
c)
Summary Introduction
To calculate: The optimal solution.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
A manufacturer has a production facility that requires 10,237 units of component JY21 per year.
Following a long-term contract, the manufacturer purchases component JY21 from a supplier with
a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an
order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent
of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is
appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is
the annual holding cost?
Use at least 4 decimal places.
Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…
Chapter 2 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - Prob. 19QPCh. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - For the Lines They Are a-Changin (with apologies...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.arrow_forwardThomas has eight horses averaging 1,400 pounds. They are on 20 acres of orchard grass and clover. Each year, Thomas applied 30-30-30 units of fertilizer per acre using 46-0-0 urea at $408 per ton, 18-46-0 DAP at $496 per ton, and 0-0-60 muriate of potash at $506 per ton. He reseeded with 10 pounds per acre of orchard grass at $1.19 per pound and 2 pounds per acre of clover at $3.18 per pound. The horses are housed in a barn 34 feet wide with stalls 12 by 12 feet on each side and a 10-foot aisle down the center. He needs at least one fifth of the barn, not including the center, for hay and tack room. What did it cost to fertilize and reseed the pasture? How long must he barn be in even number of feet?arrow_forwardA machine part to be fabricated may be made from alloy of either of two metals. There is an order for 10,000 units. Metal A costs 3 pesos per kg, while Metal B costs 9 pesos per kg. If Metal A is used, the material per unit weighs 110 grams; for metal B, 30 grams. When metal A is used, 50 units can be produced per hour; for metal B, 80 units per hour. Metal B fabrication requires the aid of a tool costing P1,000, which will be useless after the 10,000 units are finished. The machine operator's wage is P50 per hour. If all other costs are identical, determine which material will be more economical to finish the 10,000-unit order. How much is the total cost difference between the use of metal A and metal B?arrow_forward
- Bill is trying to determine how many units of two types of telephones to produce each day. One of these is the standard, while the other is the deluxe. The profit per unit on the standard is $50, while the profit per unit on the deluxe is $60. Each model requires 30 minutes of assembly time. The standard requires 10 minutes of inspection time and the deluxe requires 15 minutes of inspection time. There are 450 minutes of assembly time and 180 minutes of inspection time available each day. How many of each product should be manufactured to maximize profits? Standard Phones Deluxe Phones Time Available (X1) (X2) Assembly 30 30 450 Inspection 10 15 180 Profit $50 $60 Which of the following graphs best describes the solution using this data?arrow_forward2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…arrow_forwardChina Mania restaurant’s owners worry about the environment, using paper products made from recycled paper and recycling everything possible. They also gives their employees every Sunday off to be with family, and the restaurant sponsors many local sports teams. It does this while also making sure it is profitable. China Mania demonstratesarrow_forward
- At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…arrow_forwardAt a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…arrow_forwardThe Decision Sciences Department is trying todetermine whether to rent a slow or a fast copier. Thedepartment believes that an employee’s time is worth$15 per hour. The slow copier rents for $4 per hour,and it takes an employee an average of 10 minutes tocomplete copying. The fast copier rents for $15 per hour,and it takes an employee an average of six minutes tocomplete copying. On average, four employees per hourneed to use the copying machine. (Assume the copyingtimes and interarrival times to the copying machineare exponentially distributed.) Which machine shouldthe department rent to minimize expected total cost perhour?arrow_forward
- You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________arrow_forwardCasting molds are produced by MYMOLD company. Each order has unique specifications, depending on customer needs. MYMOLD has received an order of two molds from a customer. The agreed selling price of the molds is 5000TL per mold. According to the agreement, for a defective mold the customer will pay 1000TL instead of the standard price. The customer will not buy any more than two molds and there is a 2000 TL fine for not meeting the demand with two non-defective molds. The excess molds can be salvaged for 500 TL per piece. The cost of production per mold is 2000TL and the probability of producing a non-defective mold is 0.8. Assume that MYMOLD decided to produce two molds, and the first production has been succesfull (a non-defective mold is produced). What is the expected profit given the result of the first production?arrow_forwardA company makes three types of candy and packages them in three assortments. Assortment I contains 4 cherry, 4 lemon, and 12 lime candies, and sells for a profit of $4.00. Assortment Il contains 12 cherry, 4 lemon, and 4 lime candies, and sells for a profit of $3.00. Assortment III contains 8 cherry, 8 lemon, and 8 lime candies, and sells for a profit of $5.00. They can make 5,200 cherry, 4,000 lemon, and 6,000 lime candies weekly. How many boxes of each type should the company produce each week in order to maximize its profit (assuming that all boxes produced can be sold)? What is the maximum profit? Select the correct choice below and fill in any answer boxes within your choice. OA. The maximum profit is $ when boxes of assortment 1. boxes of assortment II and assortment III are produced. OB. There is no way for the company to maximize its profit boxes ofarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,