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
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5
during the previous month. Gershon has collected the data shown in the following table:
Maroon 5 TV Appearances
Demand for Guitars
3 3 8
3 5 6
c) The estimate for guitar sales if Maroon 5 performed on TV 10 times =
5 9 6
4 10 6
This exercise contains only parts b, c, and d.
b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places):
Y = 1.0852 +0.8085¹x
sales (round your response to two decimal places).
answer a,b,c and d (show your solution)
CANON produces printers for sale in northern Europe in its Taiwan factory. Printers sold in different countries differ in terms of the power outlets as well as the language for the manuals. Currently, CANON assembles and packs printers for sale in individual countries. The distribution of weekly demand in different countries is normally distributed, with means and standard deviations as shown in the table below:
Country
Mean Weekly Demand
Standard Deviation
Germany
3,000
2,000
Norway
4,000
2,200
Denmark
2,000
1,400
3(a). Initially, it is assumed that demand in different countries is independent. Given that the lead time from the Taiwan factory is eight (8) weeks, how much safety inventory does CANON require in northern Europe if it targets a CSL of 95 percent? HINT: For the disaggregated option, just show sample calculations for one country (e.g., Germany), then organize the results for the remaining countries in a table or amend the table…
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
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardThe 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.arrow_forwardAssume 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_forward
- 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.arrow_forwardWeek Demand of beef 1 500 2 550 3 600 4 720 5 780 6 800 Corresponding weights are W1=0.6, W2=0.4 and W3=0.3 The 3-week weighted moving average to forecast- Week Demand of beef 3- weeks weighted moving average forecast 1 500 2 550 3 600 4 720 (500×0.6+550×0.4+600×0.3) / (0.6+0.4+0.3) = 538.46 5 780 (550×0.6+600×0.4+720×0.3) / (0.6+0.4+0.3) = 604.61 (600×0.6+720×0.4+780×0.3) / (0.6+0.4+0.3) = 678.46 Forecast for week 4,5 and 6 = 538.46, 604.61 and 678.46 4-week weighted moving average to forecast- Corresponding weights are W1=0.6, W2=0.4, W3=0.3, and W4=0.2 Week Demand of beef 4-weeks weighted moving average forecast 1 500 2 550 3 600 4 720 5 780 (500×0.6+550×0.4+600×0.3+720×0.2) / (0.6+0.4+0.3+0.2) = 562.66 (550×0.6+600×0.4+720×0.3+780×0.2) / (0.6+0.4+0.3+0.2) = 628 Forecast for week 6 and 7 = 562.66, 628…arrow_forward10. Quarterly demand for Jaguar XJ8’s at a Tacloban Auto dealership is forecast with the equation, Y = 10 + 3x Where; X = time period (quarterly): Quarter 1 of 2021 = 0Quarter 2 of 2021 = 1Quarter 3 of 2021 = 2Quarter 4 of 2021 = 3 and so on...The demand for the luxury car is seasonal, and the weights of quarter 1, 2, 3, and 4 are 80%, 100%,130%, and 90% respectively. Using the trend projection, forecast the demand for each quarter of2023 and 2024. Then adjust each forecast with the weighted indices.arrow_forward
- A manager uses this equation to predict demand for landscaping services: Ft= 10 + 5t Over the past eight periods, demand has been as follows: Period, t: 1 Demand: 15 2 21 Period, t Tracking signal 1 2 3 4 5 6 7 8 3 23 30 5 32 6 38 42 Click here for the Excel Data File Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) 8 47arrow_forwardSolve the problem using the answer sheet (Problem 1) SOLVE STEP BY STEP PLEASEarrow_forwardUsing the information provided below, answer the following questions.INFORMATIONThe data in the table below shows the number of Next-generation Rangers exported to over 100 countries through Durban’s roll-on roll-off (RORO) vehicle terminal during 2022 and the first quarter of 2023. A demand planner wants to compare the relative performance of the weighted moving average method against the simple exponential method in forecasting the volume of export of the next-gen Ranger from the Silverton Assembly Plant.Required:5.1. Using the simple exponential smoothing method (SESM), compute the forecasts for the February 2022 to March 2023 period.Use a smoothing constant of 0.2 and assume a forecast of 7 000 units for January 2022.5.2. Compute the three-month weighted moving average (3MWMA) forecasts for the April 2022 to March 2023 period, using weights of 0.2, 0.3, and 0,5 (oldest data to newest data, respectively).5.3. Using the forecasts calculated for the April 2022 to March 2023 period,…arrow_forward
- In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2 years, 240 and 240, respectively were sold in fall, 350 and 320 in winter,150 and165 in spring, and 340 and 195 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Fall: Winter: Spring: Summer:arrow_forwardThe Marketing Manager of Dotcom Limited has conducted a market research on the price-demand relationship for its consumer durable Product-V which has been recently launched. The price-demand pattern will be as follows: Price per unit (Rs.) 16.650 16.050 14.400 13.050 Product-V is manufactured in batches of 1.000 units. The production manager of Dotcom Limited has also researched and studies the pattern and believes that 50% of the variable manufacturing cost would have a learning effect. This learning curve effect will continue up to 4.000 units of production at constant rate But after 4.000 units of production unit variable manufacturing cost would be equal to the unit cost at the 4 batch. The manufacturing unit cost of the first batch will be Rs. 6.600 of which only 50% is subjected to learning and experience curve effect. The average unit variable of all 4 batches will be Rs 6.180 The price and maximum contribution at which Dotcom Limited should sell Product-V is: Rs.14,400, Rs.…arrow_forwardGreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $2,500 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media. S = −2R2 − 10M2 − 8RM + 18R + 34M where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising. GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. (a) What is the value of sales (in dollars) if $1,500 is spent on radio advertising and $1,000 is…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,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning