Determine the demand for the year 2021 using the moving averages. b) Comment on the validity of the model based on the 95% confidence level.
Q: A restaurant wants to use value-based pricing. It knows the costs of the ingredients in the food. It…
A: The correct answer is true. So we can say that where I think a restaurant wants to use value-based…
Q: Can you explain the pattern of average sales of S1, S2 and S3?
A: Find the given details below: Given details: OBS S1 S2 S3 1 225 190 205 2 323 210 241 3…
Q: Eastlan Publishing Company is considering publishing an electronic textbook about spreadsheet…
A: Given, Estimated price- $150000 Variable price- $7 Single user access- $49
Q: When a carmaker offers different types of models under a particular brand, such as the Mitsubishi…
A: When a car maker offers different variant for a particular brand then it is an example of Product…
Q: Movements toward sustainability and corporate responsibility often Question 3 options: result…
A: D. All of the above are correct.
Q: 6. A system that enables people to conduct financial transactions from a smartphone or other…
A: Dear student as per our guidelines we can answer only 1 question in case of multiple questions…
Q: Describe the 4Ps(Product, place, promotion, price) marketing mix for the company Dairy Queen. No…
A: Marketing : Truly speaking, marketing refers to the activity, as set of institutions, and…
Q: Which of the following is a characteristic of products in the maturity stage of the product life…
A: A product's life cycle has four stages: introduction, growth, maturity, and finally decline. From…
Q: Should Heel Swaps Move to the Cloud? Heel Swaps is a Chicago-based start-up that sells a stretchable…
A: Planning is the process in which suitable activities are involved to achieve the objectives and…
Q: FIT manufactures wearable fitness devices. FIT devices include special features to be distinct from…
A: Balanced Scorecard may be a performance evaluation tool which aids in categorizing various key…
Q: With regards to a failure, FMEA looks towards the future but FTA towards the past. O True False
A: As per Bartleby's guidelines, we only answer the first question in case multiple questions are asked…
Q: Which of the following would not be a desirable outcome from an organization’s investments…
A: a. An increase in the sales return rate
Q: SWOT ANALYSIS: Voluntrip—A History of Voluntrip Voluntrip was founded in 2016 by three individuals…
A: Voluntrip is classified as a Travel Agency, established in 2016 by 3 people who had each toured…
Q: Outside of the intrinsic properties of the product, what else is involved in a customer’s decision…
A: Apart from the intrinsic properties there are some properties or factors customers takes in…
Q: Give the five steps of the purchase decision process in the correct order.
A: The buying process in retail and ecommerce comes down to one decision to add something to their cart…
Q: Label each of the following range names as “Correct" if is a valid range name in Excel or…
A: Below is the solution:-
Q: Pricing approach Odd-even pricing will be used. And it always must be above market price.…
A: Price is the monetary value one pays in exchange of a product. Price is one of the most important…
Q: Discuss how is CVP analysis used to calculate the break even point for multiple products
A: An evaluation metric is used to analyze how changes in expenditures and volume affect a company's…
Q: One of the products of Edwards Lifesciences (EL) is artificial heart valves made from the heart…
A: Let ‘x’ be the valves ordered from supplier 1. Let ‘y’ be the valves ordered from supplier 2. Let…
Q: The historical demand for four period is 62, 52, 70, and 45 respectively. Using the Naïve method,…
A: Here, for four period, we have data of 62, 52, 70 and 45. Here, I have used Naive forecasting…
Q: Jacqueline Mulvaney makes bespoke corsages. She is about to attend an important show in London. She…
A: Note: - Here the number of deluxe corsages for the favorable market is not given, therefore similar…
Q: fitness band catering to Indian youth in lower price segment. There is a vast market who are health…
A: Marketing and advertising is an essential process to target customers and to reach out to them…
Q: The general theory used for this assignment addresses the relationship between wine closure type…
A: Subjects with changing degrees of wine information were picked for the review. There were 72…
Q: You are planning to purchase a new car so you are studying some information. This new car has two…
A: Since XLE is a 6 speed model, the gear ratio in the car will be different than the 4 speed version.…
Q: An online seller would like to know wether the indication of price on Facebook posts will attract…
A: A dependent variable which is included in a research study can be referred to as the kind of…
Q: Year Sales 1) -30 2) -28 3) -25 4) -21 5) -23 6) -31 7) -22 8) -20 9) -32 10) -33 Find…
A: Given data is
Q: Value is created by the activities of buyers and sellers working together for mutual benefit, but…
A: value is still passed from buyer to seller is called as-
Q: M/S ABC has the options of advertisement of its products Radio Pakistan and Pakistan Television…
A: Fixing an advertising budget can be referred to as saving or making a budget for the advertising…
Q: Explain how is CVP analysis used to calculate the breakeven point for multiple products
A: CVP represents is the cost-benefit analysis. It helps companies understand how the key (variable and…
Q: Maya is setting prices for her home remodeling business. Over the course of the year, there are…
A: A business is an organization or enterprise that is engaged in professional, commercial, or…
Q: Which of the following is an example of a shopping product?
A: Shopping products are basically those products which are purchased by customers not on a regular…
Q: hat is more important for a purchasing transaction, price, timing or quality?
A: Purchasing is the process of acquiring products and services to achieve the company’s objective.
Q: Wings is a small children's outerwear manufacturer based in Chicago. Wings’ mission is to make a…
A: Given, $14.5 million in annual retail sales $15 million in (annual) planned purchases
Q: The personal brand of Elon Musk contributed to the strength and marketing of Tesla’s corporate brand…
A: Tesla is the leading high-tech, modern and sustainable car manufacturer across the globe. It is…
Q: Calculate BEP for the following information. Year 0 Year 1 Year 2 Year 3 Total benefit 0 37036 33741…
A: Given Information - Year 0 Year 1 Year 2 Year 3 Total Benefit 0 37036 33741 28241 Total…
Q: Merv's Hardware, a small family-owned store in Middletown, sells a 100-pack of garnet…
A: A small family-owned hardware store sells garnet sandpaper more expensive than a large retail…
Q: reeway company introduces an improved version of an PC product in 2021; it is likely that the demand…
A: My opinion about the historical demand data is-
Q: A sustainable advantage refers to doing better than competitors do over long periods. It is a…
A: The sustainable competitive advantage is producing the goods at a cheaper rate compared to its…
Q: Cost Per Percent Percent Percent Supplier Valve ($) Large Medium Small 1 10 30 50 20 2 14 10 60 30…
A: Given Information: Supplier Cost per Valve ($) Percent Large Percent Medium Percent…
Q: Can you please outline the basic idea behind the CASP competition?
A: CASP, which represents Critical Assessment of Techniques for Protein Structure Prediction, is a…
Q: Analysis Electrical vehicles external forces in the Battery Electric Vehicle (BEV) industry from…
A: Tesla is an international company owned by Elon Musk. It produces electric vehicles. Tesla produces…
Q: ___________ is based on the idea that customer expectations of the service they will receive shape…
A: Quality is the ability to manufacture the products and services as set standards and increase…
Q: define at least 3 KPIs for each strategic objective including (Measures & Targets)? the strategic…
A: Introduction;- As your business starts to draw out its strategy, it's probable that you'll realise…
Q: Discuss with example the four main dimensions in Hofstede’s model.
A: The Hofstede Model begun with 4 dimensions:
Q: P8-what measures or actions could be used to improve the consistent quality and speed of preparing…
A: Maintaining Food quantity is very essential, Fast-Food business could even be compromised and…
Q: Discuss the make-or-buy decision in terms of cost,flexible response, speed and quality.
A: The make or buy decision refers to the issue experienced by an association when choosing whether an…
Q: As an Internet exercise, explain the rationale behind the crea-tion of EFQM, and the fundamental…
A: The EFQM Model is a universally perceived administration system which permits associations to make…
Q: The Marketing Department is finalizing the CPM, IFE, and EFE for presentation to the CEO and members…
A: The answer to the above question is D.
I need the answer in Excel. Please help me.
The following table contains 5-year quarterly sales information for the KYRYH product.
Year |
Q1 |
Q2 |
Q3 |
Q4 |
Total |
2016 |
43000 |
37800 |
32300 |
40600 |
153700 |
2017 |
47000 |
37000 |
31200 |
40000 |
155200 |
2018 |
46000 |
39000 |
28000 |
40500 |
153500 |
2019 |
49000 |
42300 |
33500 |
44000 |
168800 |
2020 |
52700 |
44000 |
33600 |
45700 |
176000 |
a) Determine the demand for the year 2021 using the moving averages.
b) Comment on the validity of the model based on the 95% confidence level.
Step by step
Solved in 3 steps with 2 images
- 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?Under what conditions might a firm use multiple forecasting methods?The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
- The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 166.125 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year Year Seasonal Year 1 Year 2 Average 4 Index Quarter 205 211 182 1.1768 1 Quarter 152 170 158 156 2 Quarter 182 190 198 193 3 Quarter 128 112 113 0.7178 4The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 215 2 240 3 205 4 190 5 160 6 195 7 150 8 140 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to 1 decimal place.The following table shows a tool and die company's quarterly sales for the current year. What sales would you predict for the first quarter of next year? Quarter relatives are SR= .94, SR,- 97, SR= 97, and SR, 112. For the trend forecast (T), add the difference between quarter 3 and quarter 4's deseasonalized sales data to the deseasonalized quarter 4 sales. (Round your answer to 1 decimal place.) Quarter Sales 84.6 83.0 84.7 108.0
- My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 220,000, an initial trend forecast of 35,000, and smoothing parameters of 015 for both demand smoothing and trend smoothing Month (t) Monthly Application Downloads Forecast for Next Month Trend 220,000.00 35,000.00 200,000 2 250, 100 334,000 380,000 440,000 500,000 (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for next month" and "Trend" columns, using double a. exponential smoothing (Round your answers to 2 decimal places.) Month 7's forecast is b.The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).Fill in the missing values assuming there is no trend.Round seasonal indexes to 4 decimal places.Report Averages accurate to at most 2 decimal places.Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART BSuppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.Use seasonal indexes (rounded to 4 decimal places) from Part A.Report forecast answers as integers accurate to the nearest thousand.Quarter 1 forecast = thousandQuarter 2 forecast = thousandQuarter 3 forecast = thousandQuarter 4 forecast =…Paraphrase this one. Analyze and elaborate in 85 words. Regression analysis data also helps you understand whether the relationship between two different variables can give way to potential business opportunities.
- The table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 Using the following, forecast the sales for the months up to January the following year:- 1. A simple three-month moving average. 2. A three-period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data. 3. Exponential Smoothing when α= .6 and the forecast for March is 350. 4. Determine which of the three forecasting techniques is the most accurate using MAD.Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1770 2 1880 3 1070 4 1420 5 1540 6 2000 7 1910 8 1360 9 1400 10 1500 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your final answer to 3 decimal places.) What is your forecast for next year’s sales? (Do not round intermediate calculations and round your final answer to 2 decimal places.)Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1,640 2 1,850 3 1,240 4 1,250 5 1,980 6 1,400 7 1,060 8 1,430 9 1,050 10 1,990 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your answer to 3 decimal places.) What is your forecast for next year's sales? (Do not round intermediate calculations and round your answer to 2 decimal places.)