![Practical Management Science, Loose-leaf Version](https://www.bartleby.com/isbn_cover_images/9781305631540/9781305631540_largeCoverImage.gif)
Concept explainers
The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the company’s current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the “big boys,” but they are also worried that the ePlayerX could cannibalize sales of their existing products—and that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must
The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are “binary”: low-end or high-end, small-effect or large-effect, and so on.)
- In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of $10 million, and the forecast of the annual increase in net revenues is 2%.
- The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs ($1.5 million or $2.5 million), variable
manufacturing costs ($ 100 or $200). and selling prices ($150 or $300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. - The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are $1.5 million in year 1 and $0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to $3.5 million and $1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.)
- Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerX’s cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization.
- A “base case” forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is −10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case.
- Demand and units sold are the same—that is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur.
Table 2.3 Demand Adjustments When No Competing Product Is Introduced
Table 2.4 Demand Adjustments When a Competing Product Is Introduced
Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following:
- You should enter all of the given data in an “inputs” section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units.
- You should have a “scenario” section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen.
- You should have a “parameters” section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be $1.5 million or $2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters.
- You should have a “cash flows” section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.)
- You should calculate the company's
NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. - You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX.
Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios. ■
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 2 Solutions
Practical Management Science, Loose-leaf Version
- Assume that the Ken Cory Consulting and Construction Company is involved in four different businesses that have almost no linkages between them (such as being in financial consulting, road construction, wheat farming, and auto repair industries simultaneously). Now assume that the financial consulting company accounts for 12% of total company revenues, road construction accounts for 74% of company revenues, wheat farming accounts for 10%, and auto repair accounts for 4% of total company revenues. What is the best way to describe the level or category of diversification that the Ken Cory Company has? O Conglomerate O Single Business O Related-Linked O Dominant Businessarrow_forwardWrigley’s is the world’s leading manufacturer of chewing gum, producing literally millions of packages of gum each day. It is a large, financially strong company whose manufacturing technology for producing gum is state-of-the-art. It sells its products to millions of gum-chewing consumers all over the United States and many other countries around the world. Still, Wrigley’s has never attempted to sell its chewing gum directly to consumers, but instead uses a wide variety of intermediaries at the wholesale and retail levels. Why do you suppose Wrigley has chosen to use intermediaries rather than sell directly to consumers? Explain the underlying economics of the company’s policy.arrow_forwardAssume you are the chief operating officer of the fast food chain with 5,000 stores in North America. Each store operates 360 days a year and has one heated dryer in the ladies and men's restrooms. Each dryer operates 190 times per day per restroom. One pound is 453.60 grams. To dry your hands in a retail store restroom requires zero carbon dioxide emissions if you let your hands drip dry. If you use one standard size paper towel, 11 grams of CO2 were generated to manufacturer the towel. If you use a standard heated electric dryer 21 grams of CO2 are used to generate this energy and operate the dryer. How many pounds of carbon dioxide are released in the atmosphere from the heated electric hand dryers in the fast-food chain's stores? Round your answer to the nearest whole number. poundsarrow_forward
- Your uncle owns and operates a small retail store that sells the outdoor clothing of a Ghanaian manufacturer to the predominantly college-student market at KNUST. Lately, a large department store in Kumasi has started selling similar but lower-priced clothing manufactured in China. Your uncle is starting to lose business to this new store. A business associate of your uncle suggested that he considers selling over the internet. Your uncle is the ‘old school type’ who doesn’t even have an email and he has his doubts about getting into something he doesn’t understand. When your uncle heard that you had recently completed a course in e-business, he got excited and contacted you to analyze the situation and offer some suggestions. Your uncle is very much worried about the drastic change that this e-business approach will have on his business and he wonders how he will cope with managing this change. What is an online revenue model? Explain any four (4) online revenue models that will fit…arrow_forwardThe Market for Home Security Cameras Example 2 update: In the last few years, major technology companies have bought up small home "smart" device companies. Ovs VS ring Google bought up Nest and Amazon bought Ring. Now Nest and Ring are much easier to use than other home security products since they can use Alexa and "Hey Google." in a much easier way than producers not owned by a major technology company. Nest and Ring now have advertisements during popular tv shows and on various social media 1. How is this market changing? 2. What market structure might it be in the future? 3. What effect might this have on producers and consumers?arrow_forwardA NY Times best-selling author wants to write a new book as either volume II of her earlier successful book or an autobiography. She believes that by writing the volume II, given her previous success, she will have a 50% chance of placing it with a major publisher where it should ultimately sell about 40,000 copies. However, the worst-case scenario, if she can’t get a major publisher to take it, then she thinks there is 80% chance of placing it with a smaller publisher, with sales of 30,000 copies. On the other hand, if she writes an autobiography, considering the potential interest in her journey as successful writer, she thinks there will be 40% chance of placing it with a major publisher, and it should result in ultimate sales of about 50,000 copies. If she can’t get a major publisher to take it, the worst-case scenario, she thinks there is a 50% chance of placing it with a smaller publisher, with ultimate sales of 35,000 copies. Construct a decision tree to help this author…arrow_forward
- M K gift store buys items for ₹65. At an original retail price of ₹89, it expects to sell 1,000 units. If the price is marked down to ₹79, how many units must the retailer sell to earn the same total gross profit it would attain with an ₹89 price? If the price is marked up to ₹99, how many units must the retailer sell to earn the same total gross profit it would attain with an ₹89 price?arrow_forwardWhy is it usually a bad idea to buy a newly completed condo unit to flip for a quick profit? A In a rising market, condos typically rise in value faster than single family homes B In a rising markets condos typically rise more slowly in value than single family homes C Condos price tend to rise at times when single family houses prices dropping D In a failing market, condos typically drop in value more slowly than single family homesarrow_forwardUnder the COSO framework, the Enterprise Risk Management provides value creation by enabling the management through the following, except A. By avoiding to make decision on risks that are assessed to have a higher impact on its operation. B. Responding in a manner that reduces the likelihood of downside outcomes and increases the upside. C. None of the choices given D. Dealing effectively with potential future events that create uncertaintyarrow_forward
- Andy’s Bicycle Company (ABC) has the hottest new product on the upscale toy market—boys’ and girls’ bikes in bright fashion colors, with oversize hubs and axles; shell design safety tires; strong padded frames; chrome-plated chains, brackets, and valves; and non-slip handlebars. Due to the seller’s market for high-quality toys for the newest baby boomers, ABC can sell all the bicycles it manufactures at the following prices: boys’ bikes, $220; girls’ bikes, $175. This is the price payable to ABC at its Orlando plant. The firm’s accountant, V. R. Dondeti, has determined that direct labor costs will be 45% of the price that ABC receives for the boys’ model and 40% of the price received for the girls’ model. Production costs, other than labor but excluding painting and packaging, are $44 per boys’ bicycle and $30 per girls’ bicycle. Painting and packaging are $20 per bike, regardless of model. The Orlando plant’s overall production capacity is 390 bicycles per day. Each boys’…arrow_forwardRead the statements below and answer all the five questions that follow:Materials management includes the job of purchasing. In any industry, purchase refers to the acquisition of necessary equipment, materials, tools, and parts. The relevance of the buying function varies depending on the industry and its size. This duty is performed by the works manager in small businesses, and by a distinct department in major manufacturing companies. As soon as a purchaser places an order he/she commits a substantial portion of the finance of the corporation which affects the working capital and cash flow position. He/she is a highly responsible individual who interacts with many salespeople and can thus be deemed to have contributed to the company's public relations efforts. Source: https://businesstech.co.za/news/business/220551/these-are-the-5-biggest-retailers-in-south-africa/ You are managing the purchasing department at Walmart's Cambridge Foods in South Africa. Critically discuss the…arrow_forwardPlease show all work and explain answer. OneRing Company sells memorabilia to residents of Middle-Earth. They are about to invest $6 million in a new ring making plant. Fixed costs of operating the plant are $1 million a year. The ring costs $60/unit to manufacture (variable cost) and will be sold for $200/unit. The plant will last for 5 years, and will be depreciated over 5 years to zero using the straight-line method. The plant will have no salvage value after five years. Net working capital requirements are negligible for this project. Assume there are no taxes in Middle-Earth, and that the appropriate discount rate for the project is ten percent. How many rings per year must OneRing sell in order to break even?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)