Sales for the past 12 months at computer success are given here: January 3,000 July 6,300 february 3,400 August 7,200 March 3,700 Sept 6,400 April 4,100 Oct 4,600 May 4,700 Nov 4,200 June 5,700 December 3,900 a. Use a 3-month moving average to forecast the sales for the months May through December b. Use a 4-month moving average to forecast the sales for the months May through December C. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend? d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend? e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Q: What are some ways that change may need to be managed during their courses at College? What are some…
A: Ways to Manage Change during College Courses:Managing change during college courses is imperative…
Q: Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are…
A: Machine Component Shaper GrinderProfit164$8245$6342$9Availability120 hours110 hours
Q: Explain the concept of Total Quality Management (TQM) and its significance in improving product…
A: The termTotal Quality management (TQM) is a way of thinking and system that can be applied to…
Q: L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An…
A: ABC classification, also known as ABC analysis or ABC categorization, is a technique used in…
Q: A manufacturer of skis produces two types: downhill and cross-country. Use the following table to…
A:
Q: Which technique involves a group trying to find a specific solution for a specific problem by…
A: The brainstorming is a widely accepted technique of referring to group attempts at solving the…
Q: For the given data, the x = Based on the sampling done, the control limits for 3-sigma x chart are:…
A: SampleSample…
Q: The ISME Department at WSU promotes its industrial engineering program by mailing thousands of…
A: Job elementobservations in (seconds)Performance rating12345Compose and type letter79812118%Type…
Q: A study-aid desk staffed by a graduate student has been established to answer students' questions…
A: Shift = 8 hrs. per dayArrival rate = 4 per hourAssistance (service) time = 10 minutesAssume…
Q: If 99 percent service probability is desired, how many units should be ordered? Note: Use Excel's…
A: Given that,Review period Lead time Average daily demand Service level On hand inventory
Q: t sales 1 324 2 245 3256 4 567 5 346 6 357 7 357 8 257 9 1678 What is the predicted future sales for…
A: Predicted Sales = 1213.27 Explanation:I will use Excel for run a regression analysis, here are the…
Q: 2. What is the idle time per cycle?
A: The data given in the question:ActivityImmediate…
Q: The owner of a "Sweet Things Bakery" is considering a new computer system for accounting and…
A: Find the given details below:
Q: can you please answers all the blank and please provide me excel formular.
A: To roll up the individual product forecasts and compare them with the family data, we will first…
Q: Eliminate Self Doubt Forever & The Power of Your Unconscious Mind by Peter Sage. TEDxPatras…
A: 1.What is the main topic or theme of the TED Talk. How does the speaker introduce and establish…
Q: You are a Quality Manager for a very well-known food ingredient company that produces monosodium…
A: Quality Management Principles (QMP) are a set of fundamental beliefs, norms, rules, and values that…
Q: BUSI 2033 | UNIT 11 | LEADERSHIP PROFILES LEADERSHIP PROFILES Identify the primary leadership style…
A: Apple Inc. as the organization, Steve Jobs (Past CEO/Co-Founder):Primary Leadership Style:…
Q: Which chart shows the behaviour of fixed costs per unit? Cost || Cost
A: Fixed cost - The cost incurred in the production that does not change with the level of…
Q: Benny the Barber owns a one-chair shop. At barber college, they told Benny that his customers would…
A: As per the instructions, the first three sub-parts are taken for answering purposes,
Q: 14 10 11 32 The postmaster of a small western town receives a certain number of complaints each day…
A: Sample No. of complaints (C)14210314485966758129131071161241321410
Q: According to SHRM “Generative AI is changing the anatomy of the workplace and supercharging the…
A: 2. The HR Manager's role would undergo significant transformation due to the integration of…
Q: Consider the following all-integer linear program. 5xy + 8x2 Max s.t. 6x₁ + 5x₂ ≤ 35 10x₂ + 4x₂ ≤ 40…
A: Objective Functions and Constraints:Objective Function:Constraints:Subject to
Q: M/s Kobo Bearings Ltd., is committed to supply 24,000 bearings per annum to M/s Deluxe Fans on a…
A: Given Data:Annual Output: 24,000 bearingsSetup cost per run of bearing manufacture: ₹324Annual Cost…
Q: You have the following time and cost information for use in a time-cost CPM scheduling model.…
A: Part 1: AnswerThe correct answer is: A = $200, B = $300, C = $400Explanation:Part 2: Approach to…
Q: The state and local police departments are trying to analyze crime rates so they can shift their…
A: p-bar = 0.00833 sp = 0.00287 UCL = 0.01400 LCL = 0.00270 The process is in control.Explanation:Step…
Q: BUSI 2033 | UNIT 11 | LEADERSHIP PROFILES LEADERSHIP PROFILES Identify the primary leadership style…
A: Based on the information provided in the image, it is not possible to definitively identify the…
Q: Coordination is a fundamental aspect of any organization, whether it's a small team or a…
A: Human resource management is the aspect of management that is concerned with managing, supporting,…
Q: Answer questions 5 & 6 based on the following information. A weekly sports magazine publishes a…
A: The objective of the question is to determine the optimal number of copies to be printed (Q*) for…
Q: A producer of pottery is considering the addition of a new plant to absorb the backlog of demand…
A: Fixed Cost = $11,152 per monthVariable Cost = $1.23 per unitSelling price = $2.07 per unit
Q: What is the estimated expected (mean) time (in days) for activity C? What is the…
A: Expected time for C is 60Standard deviation is 4Variance is 16Explanation:
Q: forgiven product demand the time series trying equation is 53.3+2.1 X what is your forecast demand…
A: The time-series trend equation is :The aim is to find forecast demand for period 6.
Q: Watch the following Ted talk, College Stress to College Success | Brad Smith | TEDxYoungstown, and…
A: 1. The challenge of juggling coursework, extracurricular activities, and social life in college is…
Q: The frenzy of GameStop, AMC and Reddit has made news across the world. What do you think will be…
A: Financial management is the aspect of management that is concerned with or manages all the…
Q: Which of the following is not an objective of operation management?
A: Objectives of Operations Management:To improve product qualityTo reduce the cost of…
Q: ABC Limited directors discovered that employees colluded to overcome control systems put in place.…
A: a) There could be several governance causes contributing to the unethical behavior exhibited by the…
Q: Standard Time: (2) The average observed times of performing three elements in succession are 0.8,…
A: The observed time of the elements is given as follows.Element 1=0.8 minutes.Element 2=0.5…
Q: Explain how the AIS application helped the Malaysian agricultural industry. Describe how the ALPHA…
A: The objective of the question is to understand the impact of the Agricultural Information System…
Q: Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3. Can you…
A: To solve Problem 16A and compare the individual product forecasts with the family data and revise…
Q: Please suggest a narrow topic relating to online advertising to be used for a Research paper
A: A narrowly focused research topic in online advertising is "Evaluating the Efficacy of Behavioral…
Q: = The demand manager of Maverick Jeans is responsible sufficient warehouse space for the finished…
A:
Q: As extracted from the case study, “the pandemic resulted in disrupted deliveries and many other…
A: The objective of the question is to identify and evaluate the measures and strategies that the…
Q: Green Thumb Gardening is a small gardening service using activity-based costing to estimate costs…
A: Activity Rate : Activity rate is the rate which is useful for allocation of manufacturing overhead…
Q: Q2 (BREAK-EVEN ANALYSIS). An operations manager is deciding on the level of automation used to…
A: Find the Given details below:AlternativeFixed CostsVariable Cost per unitA $ 110,000 $ 60B $ 400,000…
Q: Sales for the past 12 months at computer success are given here: January 3,000 July 6,300 february…
A: To forecast sales for the months May through December using a 3-month moving average:Explanation:For…
Q: Below is information related to the processing time for Products A and B, historical averages of the…
A: MPS in unitsProcessing timeEnd product123Hours/unitA5045250.8B3025301.6 WCHistorical…
Q: Henry Crouch's law office has traditionally ordered ink refills 55 units at a time. The firm…
A: Formula:EOQ = sqrt((2 * Demand * Ordering Cost) / Carrying Cost)Given:Demand (D) = 240 units per…
Q: Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current…
A: 1. What percentage improvement is needed in the supply chain strategy for profit to improve to…
Q: Location Score Factor (100 points each) Weight Convenience A 0.15 80 Parking facilities 0.20 72…
A: Using the weight and location score provided in the table, we have to find out the composite score…
Q: Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the…
A: Find the given details below:
Q: 4.7 Complete the following table. Lead time for the part is two weeks. The lot size is 50. What is…
A: Lead Time: The lead time is the amount of time it takes for an order to be placed and received. In…
Sales for the past 12 months at computer success are given here:
January 3,000 July 6,300
february 3,400 August 7,200
March 3,700 Sept 6,400
April 4,100 Oct 4,600
May 4,700 Nov 4,200
June 5,700 December 3,900
a. Use a 3-month moving average to
b. Use a 4-month moving average to forecast the sales for the months May through December
C. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?
d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?
e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Step by step
Solved in 1 steps
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?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.Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.
- 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.Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.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 companys 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 productsand 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 forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. 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 ePlayerXs 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 samethat 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.
- Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.
- The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?