a. Plot the data. Does there seem to be a trend? b. Deseasonalize car sales. c. Plot the deseasonalized data on the same graph as the original data. Comment on the two graphs.
Q: Enter T for true or F for false: 1. Moving averages emphasize the variability in the data over…
A: A moving average is an estimate to examine data points through building a list of averages of…
Q: Which of the following statements about forecasts is true? O A. Forecasts are no substitute for…
A: Forecasting is the method of constructing predictions dependent on historic and current data and…
Q: orecasting is the primary function for predicting the future using the available data to make the…
A: Forecasting is the primary function for forecasting the future and making decisions based on the…
Q: Series forecasting for Business| The F-test used in testing the significance of a regression model…
A: The correct answer is
Q: a. Construct a time series plot. What type of pattern exists in the data? b. Compare a two-week…
A: Forecasting is predicting in advance the values through various methods like moving averages,…
Q: V. Let's Explore / Let's Create 1. Discuss the other types of forecasting methods that financial…
A: Disclaimer: Since you have asked multiple question, so we will solve the first question for you. If…
Q: Suppose the three last values were 20, 19, 20 respectively. Using the naive method, the next…
A: The following is the data provided: Period Data January 20 February 19 March 20 The…
Q: The following data are for calculator sales in units at anelectronics store over the past 9 weeks:…
A:
Q: Sophisticated forecasting models are not always better than simple o There is no single forecasting…
A: Forecasting is one of the ways in which the companies try to analyse their future demand. The…
Q: The intuition behind the MSE metric to evaluate old forecasts is:a. to sum up the forecast errors.b.…
A: Forecast helps in identifying the trend of data by analyzing the past data. Forecast does not…
Q: A "validation set lift chart" a. None of the options are correct. b. is similar to an "out of…
A: lift outline graphically addresses the improvement that a mining model gives when analyzed against…
Q: 1.Forecasts are essential for the ..............operations of business organizations. 2.In a simple…
A: Forecasting is the process of predicting future data based on previous or past data and information.…
Q: A. Delphi method B. naive approach C. decision maker's intuition D. market survey E. sales…
A: Quantitative forecasting:- Using expert judgement, qualitative forecasting is a technique for…
Q: a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive…
A: Forecasting is a technique that uses historical data as information to make informed assessments…
Q: . Discuss the following methods of data collection methods. Be sure to include both merits and…
A: Below is the solution:-
Q: Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the…
A: In the given data, actual sales are presented over the past 21 months, There are four quarters in…
Q: List of specific weakness of each of these approaches to developing a forecast. a. Consumer…
A: a) Consumer Surveys: Consumer survey is a type of source to get information about the satisfaction…
Q: Forecasting is the basis for all strategic and planning decisions in the supply chain. Select one:…
A: Find the answers below: The Correct answer is True.
Q: snip
A: An exponential smoothing forecast becomes more responsive to changes in a data series when its alpha…
Q: The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug…
A:
Q: Construct a time series plot. What type of pattern exists in the data? a. Develop the three-week…
A: There are various methods to forecast demand/sales like the moving averages method, exponential…
Q: The monthly sales for Yazici Batteries, Inc., were as follows: Month Sales Jan Feb Mar 19 21 17 Apr…
A: Find the Given details below: Given details: Month Sales January 19 February 21 March 17…
Q: a. Naive. b. A four-period moving average. c. Exponential smoothing with .50. Use 20 for the week…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: What method would you choose of forecasting technique, which requires subjective inputs obtained…
A: Forecasting is technique which uses past data in order to predict future trends. It is mainly used…
Q: A particular forecasting model was used to forecast a six-month period. Here are the forecasts and…
A: Tracking Signal can be calculated as the ratio of Cumulative forecast error and MAD Tracking…
Q: What is the definition of a forecast error?a. The average difference between the forecast and the…
A: Forecasting is a tool that uses historical data as inputs that are predictive in deciding the path…
Q: List the specific weaknesses of each of these approaches to developing a forecast: Consumer surveys…
A: Weakness of below methods in developing forecast:
Q: The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr Мay Jun Jul Aug…
A: Given data- Month Sales Jan 20 Feb 21 Mar 16 Apr 15 May 15 Jun 16 Jul 17 Aug 19…
Q: The forecasting technique that gives progressively lower weights to all past data without dropping…
A: Forecasting is a method that utilizes recorded information as inputs to construct declared…
Q: Suppose a researcher collected data for his study from the annual financial reports of the ABC…
A: The process used by the organization or individual to systematically collects the data and…
Q: Find the equation of a simple linear regression line using Excel, in the format of Y=a+bX. Keep two…
A: The regression equation is of the form Y=a+bx where: Y= dependent variable that is the quantity x=…
Q: Forecasting is predicting the future; therefore, it is not concerned at all with the past.
A: This do not require any introduction
Q: Type the correct answer In the box. Spell all words correctly. Peter is assisting with a report that…
A: A sales forecast is a forecast of future revenue from sales. The majority of sales forecasts are…
Q: Forecasts are generally wrong.a. Why are forecasts generally wrong?
A: Forecasting is used to predict future changes or demand patterns. Forecasting is the process of…
Q: Which of the following are qualitative methods of forecasting? O a. Sales force composite O b.…
A: Subjective research is done in a characteristic setting. The principle information gathering…
Q: Explain the effects it does on the no. Of cycles in a moving average have on the forecasts…
A: A Moving Average (MA) forecasting method estimates anticipated demand by calculating the average…
Q: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS…
A: Given: Weight for the recent quarter or (3rd quarter) = 0.50 Second most recent or (2nd quarter) =…
Q: Forecasts are generally wrong.a. Why are forecasts generally wrong?b. Explain the term “wrong” as it…
A: Forecasting generally means predicting or estimating something for future events. It is also about…
Q: None of the options are correct.
A: What is Stationarity? A time collection has stationarity if a shift in time doesn’t purpose an…
Q: What are the limitations of Trend analysis. What are the differences between Delphi technique and N
A: Trend analysis denotes to a technique to project the upcoming on the base of past information. Since…
Q: Describe why such forecasting devices as moving average , weighted averages and exponential…
A: To be determined: why such forecasting devices as moving average , weighted averages and…
Q: The following data are for calculator sales in units at an electronicsstore over the past 9…
A: In order to find Trend projection, Trend equation using regression is as follows: Where, and…
Q: What type of pattern exists in the data? The time series plot shows an upward linear trend. The time…
A:
Q: e) What is the Y-intercept (a) of the least squares trend line for these data? f) What is this…
A: The concept of Operation Management: Operation management is the management that applies to a…
Q: A MAD (Mean Absolute Deviation) of 17.3 suggests which of the following? O There is an…
A: Forecast Bias can be defined as a movement to either over-forecast (forecast is more than the…
Q: State what is a qualitative forecasting model and it uses under forecasting
A: To be determined: what is a qualitative forecasting model and it uses under forecasting
help I need it in excel
please
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 8 images
- In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?
- A firm has revenue function given by R=10Q where R=Gross Revenue and Q=Numberof Units Sold, Production Cost function is given byC = 20000+ 50(Q/800)^2Find:(i) the total Profit function, and(ii) the number of Units (Q) to be sold to get the maximum Profit4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.62119.5 Capital Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services, and the health outcomes and revenues are not affected by the method chosen. Therefore, the net cash flows for the decision are all outflows. Here are the projected flows: Year Method A ($) Method B ($) 0 (300,000) (120,000) 1 (66,000) (96,000) 2 (66,000) (96,000) 3 (66,000) (96,000) 4 (66,000) (96,000) 5 (66,000) (96,000) What is each alternative’s IRR? If the opportunity cost of capital for both methods is 9 percent, which method should be chosen? Why?
- 5. Daniel is planning to earn money over the summer mowing lawns in the neighborhood to buy a scooter. The scooter he wants costs $2,200. He will be charging $19.1/lawn and estimates his costs to be $2.7/lawn. How many lawns must he mow in order to pay for the scooter entirely through his earnings? a. 115.18 b. None of the other options. c. -134.15 d. 134.15 e. 112.48 f. 2562.20A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $1.50 to the grocer, and the grape pies are sold for $1.20. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,200 cups of sugar and 2,100 cups of flour. Each apple pie requires 1 1⁄2 cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in six minutes and a grape pie in three minutes. They plan to work no more than 60 hours. b. Determine the amounts of sugar, flour, and time that will be unused.1.A clockmaker makes two types of woodenclocksto sell at various malls. It takes him three hours to assemble a pine clock, which requires two oz of varnish. It takes four hours to assemblea molave clock, which takes four oz of varnish. He has eight oz of varnish available in stock and can work 12 hours. If he makes a P100 profit on each pine clock and P120 on each molave clock, how many of each type should he make to maximize his profit?2.A biologist is developing two new strains of bacteria. Each sample of Type A bacteria produces five new viable bacteria,and each Type B bacteria produces six new viable bacteria. Altogether, at least 150 new viable bacteria must be produced. At least 10, but not more than 20,of the original sample,must be Type A,and not more than 60 of the samples must be Type B. A sample of Type A costs P500,and a sample of Type B costs P700. If both types are to be used, how many samples of each type should be used to minimize the cost?
- A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $10.00 to the grocer, and the grape pies are sold for $8.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,500 cups of sugar and 2,400 cups of flour. Each apple pie requires 1½ cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours. (Round your answers to nearest whole number.) b. Determine the amounts of sugar, flour, and time that will be unused. (Leave no cells blank -…Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution pleaseA company manufactures two products. If it charges aprice pi for product i, it can sell qi units of product i, whereq1 60 3p1 p2 and q2 80 2p2 p1. It costs $25to produce a unit of product 1 and $72 to produce a unit ofproduct 2. How many units of each product should beproduced to maximize profits?