The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience, the demand for bananas is expected to be 100, 150, 200, or 250 pounds with the following probabilities: 100lbs 0.20; 150lbs 0.25, 200lbs 0.35, 250lbs 0.20. The bananas cost the store $.45 per pound and are sold for $.085 per pound. Any unsold bananas at the end of each week are sold to a local zoo for $.30 per pound. Use your knowledge of decision analysis to model and solve this problem in order to recommend how many pounds of bananas the manager should order each week
Q: George Johnson recently inherited a large sum of money; he wants to use a portion of this money to…
A: Maximize Z = 0.05B + 0.3S Subject to B >= 0.8(B+S) Bond Fund Minimum Investment 0.05B…
Q: SureStep is currently getting 160 regular-time hours from each worker per month. This is actually…
A: Productivity and complete output standards are met in an organization where the workers work with…
Q: . Midtown Manufacturing Company makes plastic plates and cups, both of which require time on two…
A: Given- Profit margin in plates= $10 Profit margin in cups = $12
Q: Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins…
A: We need to construct the mathematical expression of the objective function that are associated with…
Q: Exhibit 15-2. You would like to invest in one of the three available investment plans: money market,…
A: The expected value of perfect information is the amount that one would be responsible to give in…
Q: A firm offers three different prices on its products, depending upon the quantity purchased. Since…
A: Decision variables - x11= product 1 with a profit of $18 per unit x12= product 1 with a profit of…
Q: Double Tree Hilton is a hotel that provides two types of rooms with three rental classes: Super…
A: Solution Let X1 be the number of type I super saver room. X2 be the number of type I deluxe room. X3…
Q: George Johnson recently inherited a large sum of money; he wants to use a portion of this money to…
A: In case of a linear program the general mathematical model as well as the linear objective function…
Q: George Johnson recently inherited a large sum of money; he wants to use a portion of this money to…
A: B = percentage of funds invested in the bond fund S = percentage of funds invested in the stock…
Q: A local real estate investor in Orlando is considering three alternative investments: a motel, a…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts (a, b,…
Q: An inventor wants to maximize his profit form an investment in three stocks: A, B, & C, with a…
A: Linear programming (LP) is a mathematical modeling approach used by operations managers to come up…
Q: Blair & Rosen, Inc. (B&R), is a brokerage firm that specializes in investment portfolios designed to…
A: Since You have submitted a question with multiple subparts, as per guideline I have answered the…
Q: Eades Corp. has 9% annual coupon bonds that are callable and have 18 years left until maturity. The…
A: The YTM is based on the belief or understanding that an investor purchases the security at the…
Q: Company A proposes a customer loyalty plan, and customers can get reward points for purchasing…
A: If the product A is purchased for $100 then the reward point given to the customer can be used to…
Q: The management of Brinkley Corporation is interested in using simulation to estimate the profit per…
A: Given data: Procurement Cost ($) Probability Labor cost Probability Transportation Cost…
Q: Jane's marginal benefit per day from drinking coke is given in the table below. This shows that she…
A: Marginal benefit refers to the maximum amount of income an individual is willing to spend for an…
Q: Maximizing Profit Johnson's Household Products has a division that produces two sizes of bar soap.…
A: The retail price of the 3.5-oz size bar soaps is p $ per 100 The retail price of the 5-oz size bar…
Q: Olympic Auto Supply, Inc., produces and distributes auto supplies. The company is anxious to enter…
A: To find the target cost per battery, first, determine the desired profit, then the total target…
Q: Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to…
A: Hello thank you for the question. As per guidelines, we would provide only first three sub-parts at…
Q: Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile…
A: Letx4 = the amount of 4-cylinder connecting rods produced next week. x6 = the amount of 6-cylinder…
Q: A firm offers three different prices on its products, depending upon the quantity purchased. Since…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Susan Solomon has been thinking about starting her own fuel station, but Susan's problem is to…
A: Given data:
Q: Coast Corporation's research and development department has a a project to develop a new product…
A: In this problem, the reward for successful completion of the new project is very significant,…
Q: A convenience store manager earns a base salary plus a small bonus of $190 for each of ten different…
A: Question: In order to maximize the total monthly bonus, the manager should allocate___hours…
Q: A manufacturing company has an aggregate planning of selling its beds in the following sizes (the…
A: Given Information: Total Production Bed Sizes Production Proportion Colors Proportion…
Q: An investment of $300,000 is expected to generate the following cash inflows in six years: Year 1:…
A: Find the Given Details below: Given Details: Total Investment 300000 $ Cash Inflows Year 1…
Q: Select the best statement if we consider the following situation: The right-hand side of a…
A: Given - Shadow price = 1.2 Allowable increase = 15 Allowable decrease =10Constraint R.H.S = 30
Q: George Johnson recently inherited a large sum of money;he wants to use a portion of this money to…
A: (a) In the linear program the general mathematical model and the linear objective function set of…
Q: Miller-Orr model to manage its cash investment. Seminole’s management has determined that the cost…
A: The question is related to the Miller-Orr model of Cash management. This approach allows lower and…
Q: A firm offers three different prices on Its products, depending upon the quantity purchased. Since…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: 3. The comptroller of Microsoft Corporation has $100 million of excess funds to invest. She has been…
A: Given data: investment funds = 100 mn rate of return - stocks and bonds probabilities
Q: A firm offers three different prices on its products, depending upon the quantity purchased. Since…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: Bullseye Shirt Company makes three types of shirts: athletic, varsity, and surfer. The shirts are…
A: Decision Variable: Suppose- Xij be the yards of fabric of the ith ingredient used in the jth…
Q: The cost of producing a certain commodity consists of P45.00 per unit for labor and material cost…
A: Formula to be used; Break even quantity = Fixed cost / Contribution margin
Q: The school board for the Bellevue School District has made the decision to purchase 1,350 additional…
A: a) BIP model is following: Let X1, X2, X3 be the number of computers to purchase from each supplier.…
Q: Which of the following recurrence relations might also be suitable to model demand and supply? A. o…
A: Recurrence relation is an equation that defines any sequence as the next term as a function of the…
Q: The management of Brinkley Corporation is interested in using simulation to estimate the profit per…
A: Here the unit formula is given by --> Unit profit =Unit revenue - (Procurement +Lbour +…
Q: A product manager at Clean & Brite (C&B) wants to determine whether her company should market a new…
A: Think about the case of Clean and Brite (C and B) choosing to dispatch new brand…
Q: It costs $300 to buy a lawn mower from a lawn supply store. Assume that you can keep a lawn mower…
A: Build up a bookkeeping page enhancement model for mower purchasing for the following 10 years that…
Q: Steve Johnson believes that this winter is going to be extremely rainy, and he is trying to decide…
A: Please find the attached excel working in below step-
Q: ayue Is The company is evaluating three different expansion plans: Minor, moderate, or major. They…
A:
Q: Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as…
A: The net present value shows the capital appreciation from a project. This means that the net present…
Q: An investor has a certain amount of money available to invest now. Three alternative investments are…
A: Hello thank you for the question. As per guidelines, we would provide only first three sub-parts at…
Q: Ford has four automobile plants. Each is capable of producing the Taurus, Lincoln or Escort but it…
A: Integer programming: Integer programming represents the optimization of a linear function directed…
Q: The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash…
A: The question is related to Miller-Orr model of cash management. This model allows lower and upper…
Q: The daily demand for a product in a shop can assume one of the following values: 100, 120, or 130…
A: The optimal stock assigns the specific measure of stock a business needs to satisfy routine interest…
The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience, the demand for bananas is expected to be 100, 150, 200, or 250 pounds with the following probabilities: 100lbs 0.20; 150lbs 0.25, 200lbs 0.35, 250lbs 0.20. The bananas cost the store $.45 per pound and are sold for $.085 per pound. Any unsold bananas at the end of each week are sold to a local zoo for $.30 per pound. Use your knowledge of decision analysis to model and solve this problem in order to recommend how many pounds of bananas the manager should order each week
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
- It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
- A new edition of a very popular textbook will be published a year from now. The publisher currently has 1000 copies on hand and is deciding whether to do another printing before the new edition comes out. The publisher estimates that demand for the book during the next year is governed by the probability distribution in the file P10_31.xlsx. A production run incurs a fixed cost of 15,000 plus a variable cost of 20 per book printed. Books are sold for 190 per book. Any demand that cannot be met incurs a penalty cost of 30 per book, due to loss of goodwill. Up to 1000 of any leftover books can be sold to Barnes and Noble for 45 per book. The publisher is interested in maximizing expected profit. The following print-run sizes are under consideration: 0 (no production run) to 16,000 in increments of 2000. What decision would you recommend? Use simulation with 1000 replications. For your optimal decision, the publisher can be 90% certain that the actual profit associated with remaining sales of the current edition will be between what two values?Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?You now have 10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the mean and median value of your investment after 50 years. Explain the large difference between the estimated mean and median.
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.W. L. Brown, a direct marketer of womens clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the file P10_33.xlsx. Each operator can handle 15 calls per hour and costs the company 20 per hour. Each phone call that is not handled is assumed to cost the company 6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).
- A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.Assume a very good NBA team has a 70% chance of winning in each game it plays. During an 82-game season what is the average length of the teams longest winning streak? What is the probability that the team has a winning streak of at least 16 games? Use simulation to answer these questions, where each iteration of the simulation generates the outcomes of all 82 games.