Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12.

Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Jordin Henry's machine shop uses 2,470 brackets during the course of a year. These brackets are…

A: Ans) Data:

Q: Write a brief note about importance of Quality control (QA) and Quality Assurance (QA) for the…

A: Quality Control - This means how a particular company measures product quality and takes measures to…

Q: A start-up company in Vanderbijlpark that produces toy buses and cars, has two primary resources…

A: Here, I have been given a case, from these data, I would formulate an LP, after formulating this LP,…

Q: which of the following will provide the must reliable estimate of the time required for a company…

A: Too often, deadlines are missed or teams overextend themselves because the project manager failed to…

Q: Describe, with examples, why it is beneficial for operations managers to anticipate changes to…

A: Operations managers are tasked with managing the flow of products and services to customers. They…

Q: sparkling wines. Its most popular product is the French Bete Noire, which is shipped directly from…

A: Ans) Data: Annual Demand = D = Weekly Demand*52 = 50*52 = 2600 S = ordering cost = 260 Unit cost = c…

Q: Construct the Project Network Diagram 2.Find the Expected Duration and Standard Deviation and…

A: The critical path is a method for determining the most efficient way to complete a project. It…

Q: Solve the following linear programming model graphically: maximize Z = 3x₁ + 6x₂ subject to 3x₁ +…

A: Linear programming is a mathematical technique that is also used in operations management…

Q: Jantel Mitchell's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when…

A: Given data; Cost price 10 $ per cake Selling price 16 $ per cake Salvage price 8 $ per…

Q: Exponential Smoothing when α= .6 and the forecast for March is 350.

A: Exponential smoothing is one of the methods of forecasting. It is used in case of time-series demand…

Q: 5- A sourcing strategy for procuring leverage items would be to? a-use reverse auctions.…

A: Note: - Since we can answer only one question, we will answer question 5 here. If an answer is…

Q: A process that produces computer chips has a mean of .04 defective chips and a standard deviation of…

A: Process capacity index (Cp) is a statistical tool which helps to identify whether a process capable…

Q: e weapon" Justify the statemen

A: Since quality is an integral component of an organization's overall competitive advantage, the…

Q: 4. Consider the following problem Maximize Z = 3x₂ + 2x₂ subject to x₁ ≤4 2x₂ ≤ 12 3x₂ + 2x₂ ≤ 15…

A: Primal to the dual problem: Need to consider the below: In primal, There are 2 variables and 3…

Q: Given the following historical data, what is the moving-average forecast for period 6 based on the…

A: A moving average is a method for determining the general trend in a data set. The data set used in…

Q: An appliance manufacturer wants to contract with a repair shop to handle authorized repairs In…

A: Process capability Ratio (Cpk) is a statistical tool which helps to identify the process capability…

Q: What is the average number of errors per order? Do not round intermediate calculations. Round your…

A: c-bar = Average number of errors per order = Total Errors/Total Samples =…

Q: Question B Elaburate the Smart Warehouse contribution to enhance companies’ supply chain…

A: An automated warehouse system, either entirely or in part, is known to as a smart warehouse. The…

Q: 1. Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in…

A: Total cost=Fixed cost + Variable cost per unit × number of units

Q: One appropriate measure to reduce replenishment lead times is to a. reduce flexibility. b. increase…

A: Companies should compare their processing times to standards to find solutions to reduce lead times…

Q: Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern…

A: An estimate of the line that depicts the actual but unidentified linear connection between the two…

Q: One mechanic services 7 drilling machines for a steel plate manufacturer. Machines break down on an…

A: When the source of the population is finite-number of customers or units in the queue is limited,…

Q: What is the tool used by a project manager to check whether the resources are allocated correctly…

A: There are several tools available nowadays for resource management and overall every tool is similar…

Q: QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months.…

A: Formulae used: The simple moving Average Forecast: Moving Average Forecast = (At-1+ At-2 + At-3…

Q: Discuss how operations management applies to the service sector.

A: When it comes to running a business, it's the job of operations management for services to create…

Q: Based on the following BPMN diagram: List the main elements in the diagram. Illustrate the model…

A: BPMN or business process modeling and notation is a concept where certain processes or systems are…

Q: Zuke's Nukes is a retailer of organic microwavable entrees. They purchase frozen meals in batches…

A: The entire number of units produced during a production run is, in fact, referred to as the batch…

Q: 1) A construction company needs to move heavy equipment from city 1 to city 9, where the numbers on…

A: Linear programming is a mathematical technique that is also used in operations management…

Q: “Being successful in business requires a number of qualities and competencies, not all of which can…

A: The aptitude and preparedness to create, plan, and manage a business enterprise—along with all of…

Q: Explain FIVE (5) types of warehouses available in Malaysia.

A: Warehouses are the storehouses for a company's inventory. Warehouses are essential to the supply…

Q: 4. A production manager at any is monitoring the quality of the company's production process. There…

A: Given data:

Q: Given the situation above with an output rate of five units per hour, a) Draw the network precedence…

A: Project schedule helps in calculating different values all related to the production cycle like the…

Q: Explain the use of a flowchart in operational design.

A: Operational design is the detailed design for the organizational operations, and is helpful for the…

Q: Given the following historical data, what is the simple three-period moving average forecast for…

A: 3-period moving average forecast is calculated the sum of last three period and divided by 3 .

Q: what is the pareto chart and discuss its benefits and application in the project management field.

A: The Pareto Principle, usually referred to/known as the 80/20 rule, argues that 20% of the labor can…

Q: 1. What is the forecast for week 101 using last period demand? 2. What is the forecast for week 101…

A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Q: Booktopia, a bookstore in Melbourne, has a new collection of 200 books to sell. The management…

A: The data table is a way to calculate the value of one variable with a change in the other variable.…

Q: Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes.…

A: Please note that in the question, 2 plants are mentioned, but details of 3 plants are given. Hence,…

Q: IN THE MID-1960S, WALT DISNEY’S DREAM was to build a family resort destination like no other. The…

A: Forecasting is a technique to predict future value. It is useful to predict future demand, sales, or…

Q: Management is trying to decide how many repair persons to hire, and has asked you for cost data. b.…

A: Queueing theory is a branch of mathematical modeling that studies the behavior of queues. It has…

Q: Management at Webster Chemical Company is concerned as to whether caulking tubes are being properly…

A: Find the Calculations below: Central line: Sum of Fraction Defectsn A central line is 0.0385…

Q: Which type of network optimization problem is used to solve this problem?

A: The network optimization problem is a mathematical problem that is trying to find the least cost of…

Q: The table below includes a number of activities for a particular project. Find the time to complete…

A: Ans) Formula/Concept: Use table to make activity on node (AON) diagram. Carefully use followed by to…

Q: Explain Three (3) approaches that a buyer could take to obtain reliable information about suppliers’…

A: Here, let me describe the three approaches that a buyer could take to get reliable information about…

Q: 150 2 300 3 480 4 600 5 630 6…

A: Ans) Table Calculation:

Q: A crew of mechanics at the Highway Department garage repair vehicles that break down at an average…

A: Given data: Arrival rate (λ)= 312= 0.25 per min = or 15 per hour Service rate(μ) = 310=0.3 per min…

Q: Using the following, forecast the sales for the months up to January the following year:- A simple…

A: The mean absolute deviation (MAD) is a measure of the accuracy of forecasts. It measures how far off…

Q: UCLp = of a sample size of 500, the upper and lower (enter your response as a number between 0 and…

A: It is given that defect rate is 4.50 % or 0.045. So, p-bar = 0.045 Sample Size (n) = 500z = 3…

Q: The following table shows the fixed cost and variable cost for 3 locations. Construct cost curves…

A: Total cost for any location = Fixed cost + Number of units X Variable cost per unit Compute the…

Q: What is the difference between process versus product layout? Where is each best?

A: Here, I would establish the difference between process layout and product layout with examples,…

Question

i. Using trend projection, develop a formula to predict sales for years 11 and 12. You
have to show all working. You will need to develop a table to calculate the slope and
the intercept.
ii. Use that formula to forecast television sales for years 11 and 12.

b. The following table shows the number of televisions sold over the last ten years at a
local electronic store.
YEAR
1
2
3
4
5
6
7
8
9
10
TV SALES
150
300
480
600
630
640
700
825
900
980

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

PT XYZ is a FREEMed brand mask distributor that sells various types of masks. Mask typeKN95 is a mask that is in demand in the market in the conditions of the Covid-19 pandemic in 20152020. At the peak of the pandemic in April 2020, it reached 40% of total salesmasks in the market. However, in February 2021 sales fell sharply and only controlled 9%only.Based on these conditions, the company wants to conduct a study with the following alternatives:1. Develop a product in the presence of product development costs 2. Continue business as usual without product development.3. Do nothing.Based on the results of meetings and coordination with the management team within the company, severalthe conditions in each study are as follows:Alternative 1:The probability of successful product development is 80%, while the chance of failure is 20% andbased on information from the sales division when a new product is marketed, the sales rate is high90% (company profit IDR 50 million) and 10% low sales…
Year Season Sales 2018 Winter 40 2018 Spring 29 2018 Summer 31 2018 Fall 40 2019 Winter 102 2019 Spring 87 2019 Summer 96 2019 Fall 132 2020 Winter 105 2020 Spring 93 2020 Summer 105 2020 Fall 117 2021 Winter 141 2021 Spring 39 2021 Summer 114 2021 Fall 123 What is the slope of the trend equation obtained by linear regression? Round to two decimal digits. What is the intercept of the trend equation obtained by linear regression? Round to two decimal digits. What is the seasonal index for Spring? Round to two decimal digits. The quarter number for Winter of 2018 is 1. What is the quarter number for Spring of 2025? What is the trend based forecast for Spring of 2025. Round to a whole number. What is the seasonally adjusted trend based forecast for Spring of 2025? Please do not use excel to find the slope and intercept, thank you so much!
An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. Table 3 Quarter Percent change in income Percent Change in appliance sold Quarter Percent change in income Percent Change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 1) What forecasting model should be used for this data.Why? 2) Develop the forecasting model that you have proposed in(a). 3) Compute the relationship for these data. In your opinion, is the relationship between independent variable strong enough to base a predictive the…
The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LO
Outlet All Sales Tortilla Sales Madre's Tortilla Stocked Padre's Tortilla Stocked Store 1 $100,000 $1,000 Yes Yes Store 2 $75,000 $500 Yes Yes Store 3 $50,000 $300 Yes No Store 4 $40,000 $400 No Yes Weighted Distribution or Product Category Value (PCV) Distribution (%) Numerical 4: The marketers at Madre's Tortillas want to know the Product Category Value or Weighted Distribution (%) of their distribution network. How much is it?FOR THIS QUESTION PLEASE REFER TO 3rdTABLE
what is Nissan's car company sales for the past 7 years?
The 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.
B. The following table shows the number of televisions sold over the last ten years at a local electronic store. year TV sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using the trend projection, develop a formula to predict sales for years 11 and 12. Develop a table to calculate the slope and intercept. Please Show All Working. Use that formula to forecast television sales for years 11 and 12
List the elements of a good forecast
Given the following historical data, what is the simple three-period moving average forecast for period 6? Period Value 1 73 2 68 3 65 4 72 5 67
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using the naive approach.
In contrast to causal techniques, what are the fundamental assumptions made when time series predicting techniques?