A manager uses this equation to predict demand for landscaping services: Ft = 14 + 4t. Over the past eight periods, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 Demand: 20 25 25 35 35 40 45 50 Compute the tracking signals for Periods
Q: Room Type Budget Budget-Plus Deluxe Туре 1 30 40 Type 2 25 35 45 The above table shows that Type 1…
A: (a) The demand for Budget = 125, Budget-plus = 55 and Deluxe = 45. So from the constraints table, we…
Q: The Saki motorcycle dealer in the Minneapolis–St. Paul area wants to make an accurate forecast of…
A: a) The Moving Average Forecast method uses the data from the past periods to forecast the value of…
Q: For the Orlando real estate investment problem, assume the probabilities for the gasoline shortage,…
A: Given data is
Q: Assuming a linear trend, use the tabular method to derive values for: the slope the intercept…
A: THE ANSWER IS AS BELOW:
Q: Fit a linear trend equation by the method of least squares. Determine the predicted value of trend…
A: THE ANSWER IS AS BELOW:
Q: Use the below formula to calculate the CLV for the following: A manager of a cable company wants…
A: Given that - Margin profit (M) = $150 Annual marketing cost (C) = $30 Retention rate (r) = 65%…
Q: of hybrid cars that have be requested for rental from a car rental office during a 50 day sample…
A: Demand for Cars Number of Days Probability 3 3…
Q: A company is trying to determine the proper capacity level for its new electric car. A unit of…
A: Above excel sheet will help in determining the cost of various level in production along with the…
Q: The University of Miami bookstore stocks textbooks in preparation for sales each semester. It…
A: Given: a demanding range of 65-85 is given, as well as the probability associated with each demand…
Q: North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to…
A: The concept used here is forecasting using linear trend and seasonal relatives.
Q: I need a detailed explanation on how to solve this problem: A bagel shop buys each bagel for $0.08…
A: Given Information:Each bagel buys at the rate of $0.08And each bagel sells at the rate of…
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Given information, Production lot size = 150 Cusromers orders - 88,86,25,65,20,51,0,0 Present…
Q: The forecasted annual demand for a company is 4000 units. It costs $200 each time an order is…
A: Given That - Annual Demand (D)= 4000 units Ordering Cost (S)= $200 Holding Cost (H)= $0.50
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: Use Excel to make calculations Given the following sales data: Quarter Year 1 Year 2 1 120…
A: Given sales data - Quarter Year 1 Year 2 1 120 150 2 160 200 3 210 250 4 130 170
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Given Order policy=150 Opening inventory=100
Q: for managing its data processing operation: continuing with its own staff, hiring an outside vendor…
A: When the expected value of a decision alternative is turned as the sum of weigh payoffs for the…
Q: North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be:…
A: This problem can be solved using the multiplicative seasonal method of forecasting.
Q: optimal lot sizes and reorder points for this brand
A: The decision Variable Q is the number of units to be purchased at the beginning of the period. The…
Q: Highline Financial Services provides three categories of service to its clients. Managing partner…
A: Service A: Formula:
Q: Whitebridge Hardware Store Whitebridge Hardware Store has a monthly demand for lawn fertilizer…
A: Formulae used: Error = Actual Demand - Forecast Absolute Error = ABS (Error) = |Actual Demand -…
Q: North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to…
A: The demand forecast : D = (80 + 0.43Q) x Multiplicative seasonal factor
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: Cafe Michigan 's manager, Gary Stark, suspectsthat demand for mocha latte coffees depends on the…
A: Given Price Number Sold $2.70 760 $3.50 510 $2.00 980 $4.20 250 $3.10 320 $4.05…
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 local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: The University of Miami bookstore stocks textbooks in preparation for sales each semester. It…
A: The demand ranges from 70 to 90 units, and the likelihood associated with each demand figure is also…
Q: TP Inc. is a small company specializes in supplying toilet paper to small businesses, offices,…
A: Given data: Weekly demand d = 650 boxes Ordering cost = S = $150 per order Cost of each package -…
Q: Haip Save & C This is the same information for all six questions about this hypothetical situation…
A: In exponential Smoothing : Forecast formula: F(t+1) = alpha*D(t) + (1-alpha)*F(t)
Q: The number of students enrolled in Spring Valley Elementary school has been steadily increasing over…
A:
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Introduction: The term Business refers to an exchange of goods and services between the buyer and…
Q: Estimate the average of MSE of a three-month moving average and an exponential smoothingfor α = 0.3.
A:
Q: A local manufacturer of toys produces several toys. Among the most popular is Disney-car toy model.…
A: Week 1 2 3 4 5 6 7 8 Forecast 176 172 50 130 40 120 132 135 Customer Orders 88 86 25 65 20 51 0…
Q: The management decided to use the exponential smoothing to determine the projected monthly demand…
A:
Q: A shop is planning an order for a popular Christmas festive season product. Demand for the product…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Piedmont Fasteners Corporation makes three different clothing fasteners in its manufacturing…
A:
Q: Prepare a purchases budget expressed in quantities to be purchased.
A: Introduction: In general, the term production refers to the process of converting the inputs into…
Q: The Ramshead Pub sells a large quantity of beer every Saturday. From past sales records, the pub has…
A: Expected number of barrels=60.10+70.20+80.40+90.25+100.05=0.6+1.4+3.2+2.25+0.5=7.95
Q: The average number of operational losses in a year at a particular plant is 18, so the number of…
A:
Q: Fit a linear trend equation by the method of least squares. Determine the predicted value of trend…
A: The provided data can be considered as year on X-axis and Production on Y-axis.
Q: National Auto parts uses a 4-week periodic review system to reorder parts for its inventory stock. A…
A: 1. Existing stock = 8 units, On-order qty = 16 Prob{stockout happens before the next arrival} =…
Q: Q.2: An economist who estimated the Keynesian money demand function in logarithmic form using data…
A: Keynes made the demand for money an element of two factors, in particular income and the pace of…
Q: The following data relate the sales figure of the bar in Mark Kaltenbach's small bed- and -breakfast…
A: Bar Sales = 37.5 + 19.0 Guests
Q: Suppose that for years East Campus' short-run Phillips Curve was such that each 1 percentage point…
A: given, East Campus' short-run Phillips Curve was such that each I percentage point increase in its…
Q: The forecasted annual demand for a company is 4000 units. It costs $200 each time an order is…
A: Ordering costs per annum or Annual ordering cost =Annual usageOrder Size× Cost per order EOQ=2×cost…
Q: The University of Miami bookstore stocks textbooks in preparation for sales each semester. It…
A: Given- Sales price = $95 Cost price = $70 Cost-refund = $30 Marginal Profit on each book = Sales…
Q: The owner of Western Clothing Company has determined that the company must sell 670 pairs of denim…
A: Here, mean is 805 and standard deviation is 207 and more than 670 pairs of jeans need to be sold to…
A manager uses this equation to predict demand for landscaping services: Ft = 14 + 4t. Over the past eight periods, demand has been as follows:
Period, t: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Demand: | 20 | 25 | 25 | 35 | 35 | 40 | 45 | 50 |
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.)
Period t Tracking Signal
1
2
3
4
5
6
7
8
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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.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.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.
- The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?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.
- 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.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?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).
- Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation 1300 and that the demand at the reduced price is normally distributed with mean 3800 and standard deviation 1400.An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.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?