Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The number of persons likely to die within a year, at each age, is calculated by actuaries on the basis of past experiences and made available as:
a.
Mortality tables
b.
Calculation tables
c.
Monetary tables
d.
Tariff tables
For offering a group insurance scheme, we need a:
a.
Large group
b.
Heterogeneous large group
c.
Homogeneous large group
d.
Small group
Sampaguita Company makes corsages that it sells through salespeople on the streets. Each sells for P2 and has variable production costs of P0.80. The salespeople receive a P0.50 commission on each corsage they sell, and the company must spend P0.05 to get rid of each unsold corsage. The corsages last for only one week and cannot be carried in inventory.The manager of the firm had estimated demand per week and associated probabilities as follows:Demand Probability100,000 0.20120,000 0.20140,000 0.30160,000 0.30
The optimal weekly production of the corsage is? Please show solution.
Every four years, Blockbuster Publishers revises its textbooks. It has been three years since the best-selling book, The Joy of OR, has been revised. At present, 2,000 copies of the book are in stock, and Blockbuster must determine how many copies of the book should be printed for the next year. The sales department believes that sales during the next year are governed by the distribution in Table 8. Each copy of Joy sold during the next year brings the publisher $35 in revenues. Any copies left at the end of the next year cannot be sold at full price but can be sold for $5 to Bonds Ennoble and Gitano’s bookstores. The cost of a printing of the book is $50,000 plus $15 per book printed. How many copies of Joy should be printed? Would the answer change if 4,000 copies were currently in stock?
Table 8:
Copies Demanded
Probability
5,000
.30
6,000
.20
7,000
.40
8,000
.10
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_forwardIn Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)arrow_forwardPlease do not give solution in image format thanku Deltic sells this component for 55 per unit with a 4-month delivery lead time. Assume Deltic covers all transportation and related processing until delivery. TCX’s demand forecast for the upcoming selling season (12 months) is a normal distribution with mean 13500 and standard deviation 3736,4 . TCX sells each unit, after integrating their proprietary software, for 135. Assume that TCX uses a holding cost rate of 25 %, and any leftover units can be sold for 30 on average. Due to the long lead time and high minimum order quantity required, TCX is planning on a single order from Deltic to meet their needs in the next year. How many of these components should TCX order? Calculate the resulting expected annual profits for TCX.arrow_forward
- Consider a toy retailer with warehouses in St. Louis and Kansas City, Missouri. The warehouses stock an identical popular toy delivered to stores in the two cities. Assume a warehouse serves only stores in its city. Weekly demand for St. Louis is normally distributed with mean 2,000, and standard deviation 400 (that is N(μ = 2,000, σ = 400)). Weekly demand for KansasCity is distributed N(μ = 2,000, σ = 300). We assume that the two cities are far enough apart so that demand in the two cities is independent.The following parameters are seen by both warehouses:Replenishment lead time in weeks ~ N(μ = 2, σ = 0.1);Fixed shipping cost of replenishment: $500;Cost per toy: $10; andHolding cost per toy 20 percent of toy’s value per year.How many toys should each location order at a time and when should they reorder if they want a 99 percent cycle service level? What if they pool the two locations?arrow_forwardCompany C sells semiconductors that are used in handheld consumer electronics. The company has been extremely successful recording an increase in earnings each of the past four quarters. At the end of the current quarter, Larry Gomez, the company’s accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Z100 model had not changed during the quarter. Larry confirmed his calculation with the inventory control manager, who indicated that sales of the Z100 had stopped when the Z200 semiconductor was released early in the quarter. Larry found out that the Z200 semiconductor has the same applications as the Z100, but has more computing power and a lower cost than the Z100. Larry notified Sheena Snyder , the chief financial officer, about the semiconductors and recommended that the company apply the lower-of-cost-or-market method to the Z100 semiconductors in inventory. Later that day, Sheena called Larry telling him not to apply…arrow_forwardA Mercedes dealer must pay $20,000 for each car purchased. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He considers the lawsuit to be behind schedule but estimates that if he is short on one car in one year he will lose $20,000 worth of future profits. Each time the dealer places an order for automobiles, the ordering cost adds up to $10,000. Determine the distributor's optimal ordering policy. What is the maximum deficit that will occur? What is the total annual cost?arrow_forward
- 3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $12 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $1 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 15 pounds. a) What is the cost of underestimating demand for each pound? b) What is the overage cost per pound? c) How many pounds of oyster should she order each day? d) What is the stockout risk for this order size?arrow_forward35) Orders for a stock trading system are coded as follows from left to right: i. The first character is 'B' for a "buy" order, 'S' for a "sell" order ii. The number of shares to buy or sell iii. The stock ticker symbol in all uppercase letters for a "buy" order or alf lowercase letters for a "sell" order iv. If the order is a "limit" order with a specific buy/sell price, the requested price in pennies, otherwise the price should be omitted and the order will be a market order at the current asking price for the stock v. If the order is a "limit" order with an expiration time, the character 'T' followed by the number of minutes until the order expires and should no longer be executedarrow_forwardplease solve within 30 minutes.arrow_forward
- Purchase Discounts It is typically beneficial for companies to take advantage of early-paymentdiscounts allowed on purchases made on credit. To see why this is the case, determine the effectiverate of interest associated with not taking advantage of the early-payment discount for each of thefollowing situations. Assume in each case that payment is made on the 30th day of the billing cycle.Required1. What is the opportunity cost of not taking advantage of the discount associated with purchases madeunder the following terms: 2/10, n/30? (Show calculations.)2. What is the opportunity cost of not taking advantage of the discount associated with purchases madeunder the following terms: 1/10, n/30? (Show calculations.)3. To motivate managers to take early-payment discounts, what is the appropriate accounting treatment forpurchase discounts?arrow_forwardULINE packaging supplies has a contract to fill 50 gallon barrels with gasoline for use by the U.S. Army. The machine that ULINE uses has an adjustable device that allows the average fill per barrel to be adjusted as desired. However, the actual distribution of fill volume from the machine is known to be normally distributed with a standard deviation equal to 0.5 gallons. The contract that ULINE has with the military calls for no more than 2 percent of all barrels to contain less than 49.2 gallons of gasoline. In order to meet this requirement, ULINE should set the mean fill to approximately 49.92 gallons. 00 True Falsearrow_forwardA Mercedes dealer pays $40,000 for each car purchased (wholesale price). The annual holding cost is estimated to be 30% of the dollar value of inventory. The dealer sells an average of 1200 cars per year. They believe that demand is backlogged but estimate that if they are short one car for one year, the loss in future profits is about 10% of the wholesale price. Each time the dealer places an order for cars, ordering costs amount to $1600. Assume there are 360 work days per year. Question: What percent of the time do shortages occur? I've deduced the percent of shortage time to be 25%, but am not sure I've set up my formulas correctly.arrow_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,