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. ■
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
PRACTICAL MGT. SCIENCE (LL)-W/MINDTAP
- 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_forwardIn the context of the fashion industry, we have examined in a very cursory some of the costs and benefits of the production of cheap consumer goods such as "fast fashion" The purpose of such an analysis of production is to identify the different types of ethical concerns and responsibility associated with both the production and consumption of these goods. For this exam, you are to clarify in your view what are the primary ethical concerns, who bears the ethical responsibility, and what actions ought to be taken.arrow_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_forwardPeople have been using Twitter’s social media platform to Tweet short bursts of information in 140 characters or less since 2006 and now average 500 million Tweets a day. The full stream of Tweets is referred to as Twitter’s fire hose. Various firms analyze data from the fire hose and sell the information gleaned from that analysis to other companies. Twitter recently purchased Gnip, the world’s largest social data provider and one of the few companies that had access to the fire hose. Gnip also mines public data from Facebook, Google+, Tumblr, and other social media platforms. Analyzing social data has become a big business because companies such PepsiCo, Warner Brothers, and General Motors pay to learn about consumers’ sentiments toward them. According to the CEO of social media analysis company BrandWatch, “We’re at the bottom of the foothills in terms of the kind of global demand for social data.” Twitter alone earned more than $70 million last year from licensing its data. Perhaps…arrow_forwardYour company's new portable phone/music player/PDA/bottle washer, the RunMan, will compete against the established market leader, the iNod, in a saturated market. (Thus, for each device you sellI, one fewer iNod is sold.) You are planning to launch the RunMan with a traveling road show, concentrating on two cities, New York and Boston. The makers of the iNod will do the same to try to maintain their sales. If, on a given day, you both go to New York, you will lose 500 units in sales to the iNod. If you both go to Boston, you will lose 250 units in sales. On the other hand, if you go to New York and your competitor to Boston, you will gain 2,000 units in sales from them. If you go to Boston and they to New York, you will gain 1,000 units in sales. What fraction of time should you spend in New York and what fraction in Boston? You should spend | of your time in New York and in Boston. How do you expect your sales to be affected? O The expected outcome is a net gain in RunMan sales. O The…arrow_forward
- Assume General Mills has to decide how to invest millions of dollars to try to expand its dessert and yogurt businesses. To allocate this money between these two businesses, what information would General Mills like to have?arrow_forwardCan you please answer question #1 and #2 using excel?arrow_forwardOn With Living (OWL) is a nonprofit organization dedicated to improving the physical and mental health of individuals age sixty-five and older. It is a local chapter of a national organization, the OWL Association, which had been in existence for nearly thirty years. Both the local chapter and the national organizational offer programs and services to help seniors stay healthy and fund research to find ways to prevent, treat, and cure diseases that affect people over sixty-five, such as Alzheimer’s disease, diabetes, and heart disease. Each local chapter is obligated to adhere to the positions of the national organization, and any modification or rejection of the national position is prohibited according to the statement of relationship signed by both parties. Any violation of this relationship agreement would result in disaffiliation from the national organization, which local chapters attempt to avoid at all costs. One position statement of the national organization took a firm…arrow_forward
- A cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research. Objectives: Why users shop online versus in store How to take advantage of the online channel How to improve the company’s website Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites. Ways to improve consumers’ in-store experience Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.arrow_forwardSeptember 14, 2023 Matt’s One Hour Air Conditioning & Heating Dear Melissa, My name is Grace Lathrop with Matt’s One Hour Air Conditioning & Heating Company. We received an email from you explaining your air conditioner that has unfortunately malfunctioned due to a broken capacitor. I understand your frustration and I will help get this problem resolved right away for you. When I looked up your account in our database, it appeared as inactive. I looked into this problem more and discovered a technical issue on our end. We are under new ownership and our system has not been updated over to the new owner. This is what made your account appear inactive. We are getting our database refreshed so our new owner has chosen to honor any warranty from the previous owner so your warranty will cover the capacitor. Let me know if you have any questions or concerns that I can help you with. I need this business letter to be revised. The letter is to a customer that has a air…arrow_forwardBest Buy is the largest consumer electronics retailer in the USA, with 2015 sales of over $50 billion. The company competes aggressively on price with such rivals as Costco, Sam's Club, Walmart, and target, but it is also known by consumers for its first-rate customer service. Best Buy consumers have commented that the retailer' sales staff is exceptionally knowledgeable about the company's products and can direct them to the exact location of difficult-to-find items. Best Buy customers also appreciate that demonstration models of PC monitors, digital media players, and other electronics are fully powered and ready for in-store use. Best Buy's Geek Squad tech support and installation services are additional customer service features that are valued by many customers. How would you characterize Best Buy's competitive strategy? Should it be classified as a low-cost provider strategy? A Differentiation strategy? A best-cost strategy? Explain your answer.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing