The following table lists your company's sales during the last four years. Year 1 Year 2 Year 3 Year 4 Sales 101 109 104 121 a. Using Excel, estimate the linear trend equation, S = a + b*t. b. Save the Excel file and upload to Blackboard.
Q: Today is May 16th. We have got the interim result of the sales figures in the first half of May.…
A: Sales targets stated before the beginning of the task give a clear idea to the sales agents…
Q: Predictive Data Analytics - Forecasting tools are used to predict how a sample population is going…
A: Descriptive data analysis Descriptive data analysis determines the state of any business.…
Q: A sales forecast usually done for a period more than six months but does not exceed two years. It is…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Alligator, Inc. is a shoe designer, manufacturer, and distributor that launched its business in…
A: There are useful issues identified with worldwide strategic sourcing. Right off the bat, the…
Q: Sustainability reporting is referred to as "triple bottom line" reporting because it takes into…
A: Sustainability focuses on fulfilling the needs of the present without compromising the ability of…
Q: Consider a telecommunication service provider. You have the following quarterly data: STATISTICS…
A: Referrals- In this method of prospecting, the salespeople come in contact with their known ones like…
Q: Based on your knowledge of the global business environment and the positioning of Alligator with…
A: Company AL is an internationally involved shoe designer, manufacturer, and distributor. It is one of…
Q: The Managing Director of Shoprite Company is faced with the problem of assigning five senior…
A: Find the Given details below: Given details: Manager Region 1 2 3 4 5 6 A 73 91 87 82 78…
Q: The following data are pulled from a recent HealthPlus Manufacturing Co. annual report. ASSETS (in…
A: Total Inventory = Raw Material Inventory + Work in progress Inventory +Finished Good Inventory
Q: he following is a list of costs that were incurred in the production and sale of large commercial…
A:
Q: A Human Resources Manager who is working remotely has realised that his current mobile phone lacks…
A: The processes a consumer takes to decide what to buy are known as the consumer buying process.…
Q: In the table below ratings data on x = the quality of the speed of execution and y = overall…
A: Given that: Speed Satisfaction 3.5 3.4 3 3.1 3.3 3.2 3.6 3.5 3.4 3.7 3.8 3.6 3.3…
Q: 1-The company believes that a proper inventory control system (techniques) helps the enterprise in…
A: Disclaimer- "Since you have asked multiple questions, we will solve the first question for you. If…
Q: Stocks have high levels of demand at certain times of the year: Select one: a. Cycle stocks b.…
A: Demand is the amount of a good that buyers are willing and ready to buy at different costs during a…
Q: organization
A: The answer to this question is true.
Q: Suppose sales for the past 6 months have been 89, 90, 86, 104, 110, and 83 What is the 3-month…
A: Month Sales 1 89 2 90 3 86 4 104 5 110 6 83
Q: What elements of the strategic sourcing process do you feel are the top candidates for improvement…
A: The components of the strategic procurement method that can be used at Company AL for enhancement…
Q: Use the following financial statements of Heifer Sports Inc. in Table 14.14 to find Heifer’s: a)…
A: Inventory turnover shows the price at which a business markets and replaces its stock of products…
Q: 8. According to the five forces model,. levels of profit in the industry. levels of competition for…
A: Five forces model was made by M. Watchman in 1979 to see what five key serious powers are meaning…
Q: Identify any TWO advantages of standardized marketing. Explain each identified advantage with an…
A: Life is unfair, most of the wealth is cornered by the top 1% and the rest slog their entire lives to…
Q: Discuss the following quotation from an inventory control manager: “It’s not myfault we ran out of…
A: Forecasting is the process of identifying the demand accurately for future production planning and…
Q: EXECUTIVE SUMMARY OF THIS CASE STUDY?
A: The given case study is about Alligator Inc which is a shoe designer, manufacturer and distributor.…
Q: Categorise mtn product portfolio into four strategic business units using a standard model
A: While we can say the choice of strategy is based on the strengths and weaknesses of the company's…
Q: Use the following Profit decision tree and calculate the EVPI. **Enter the number only. Do not enter…
A: Here, the prior probabilities and posterior probabilities are given. Prior Probability: Posterior…
Q: Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties…
A: Find the Given details below: Given Details: Rooms Available (Supply) Rooms Sold (Demand)…
Q: Identify the relationship between economic Growth and unemployment (if any positive, negative, no…
A: THE ANSWER IS AS BELOW:
Q: Draw a decision tree for the above company and write down the REVENUES and COSTS at the end of…
A: There are pilot study cost is £12,000. Here, with favorable market, the company can expect to make…
Q: What are the impacts of less-than-perfect demand forecasts for Alligator products, including…
A: The implications of the prediction of less than perfect demand for the commodity of Company AL are…
Q: Some companies import and export flowers worldwide. It is one of the very competitive businesses in…
A: Fresh Phool Co. is a Flower association, situated in Pakistan. The association do the matter of fare…
Q: How did covid-19 affect strategic management in supply chain management. Argue in favour of the…
A: Supply chain management is described as the management of all the processes, flow of services and…
Q: Brinker International operates restaurants in several different segments of the casual dining…
A: Linked diversification is a kind of diversification in which a product or service sells similar…
Q: Tech company is medium-sized Consumer electronics retailer.The company reported $155,000,000 in…
A: The following information is given: Cost of goods sold= $110,050,000 Average inventory= $20,000,000…
Q: Tax Revenue ($) Refer to the above Laffer Curve diagram. Going into the sluggish U.S. economy of the…
A: The current option: some level above tax rate b. Because in the early 1980s, the highest marginal…
Q: Demonstrate how indexes and ranking data are calculated comparing the subject to the comp set.
A: INDEX can be defined as which mainly deals with the physical position of the record, incremental…
Q: Netflix CEO in 2017: "We're competing with ____." Question 2 options: eating sleeping…
A: According to Netflix CEO, the biggest competition for the organization is sleeping.
Q: Discuss how you would manage a poor forecast.
A: A poor forecast means that, as a result of this forecast, there has been an imbalance between demand…
Q: Microsoft's sales teams were traditionally focused on selling PCs to customers who rarely made…
A: Hunters refer to the doer who is getting their energy to sell through the 'hunting' of new…
Q: Exclusive Footwear Ltd experiencing profit declining in recent times... In the light of the above…
A: Due to current pandemic situation world is facing difficulties. Whether it’s related to human health…
Q: To make sure they have enough stock, a department store implements a new application that analyses…
A: Business: It includes various activities that are associated with the buying, producing,…
Q: This data will help you determine if you have to use the same retailer in a location. * a. Net…
A: The data analysis is performed by analysts who may incorporate their statistical and logical…
Q: Hello: I am trying to fine-tune this question in quotes below to become a qualitative response…
A: Market Basket Sales Market Basket Sales is a technique used by large retailers. This technique is…
Q: formula for the Sales Revenue growth ratio
A: Sales revenue growth ratio is one of the parameters used by companies to calculate its growth. It is…
Q: Business demand changes more rapidly and steeply than consumer demand. For example, after 9-11,…
A: Every individual has separate demand based on his wants and needs. Thus, when a business offers a…
![The following table lists your company's sales during the last four years.
Year 1
Year 2
Year 3
Year 4
Sales
101
109
104
121
a. Using Excel, estimate the linear trend equation, S = a + b*t.
b. Save the Excel file and upload to Blackboard.
Attach File
Browse Local Files](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F130d1251-1f74-4974-84f4-6d92cfa84e59%2F4d7e92eb-611e-441f-87ce-7adea0b2bbe1%2Fixnjgdo_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?
- 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?The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
- Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. 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?The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b? Is it guaranteed to produce better forecasts for the future?
- The file P13_03.xlsx contains monthly data on production levels and production costs during a four-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced. Use the resulting equation to predict total cost in month 49, given that the proposed production level for that month is 450 units. Do you see anything wrong with the analysis? How should you modify your analysis if your main task is to find an equation useful for predicting future costs, and you know that the company installed new machinery at the end of month 18? Write a concise memo to management that describes your findings.The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?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.
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)