Please solve exact, acurate with complete details follows:The monthly sales for Yazici Batteries, Inc., were asMONTHJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberSALES202115141316171820202123a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection.c) With the data given, which method would allow you to fore-cast next March's sales? PX

Answered: follows: The monthly sales for Yazici…

follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April May June July August September October November December SALES 20 21 15 14 13 16 17 18 20 20 21 23

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...

See similar textbooks

Related questions

Q: If the lead time is six days, what is the reorder point for both the no-backorder and backorder…

A: Monthly Demand = 50 Annual demand (D) = 50*12 =600 Number of business days = 300 Days in a month =…

Q: Portfolio Management If x dollars are invested in a company that controls, say, 30% of the market…

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: I just need help with D AND E Please!! The answer that i have for D was wrong and cant figure it…

A: Given-

Q: 1. Inventory Problem Figure 6 shows the inventory levels of dried Rainier cherries at a natural food…

A: Given data is Annual demand (D) = 800 Ordering cost (S) = $16 Carrying cost (C) = $4

Q: What are the two primary questions a client will ask you when beginning a project? Why is it hard to…

A: The beginning or initiation of the project is the first step when the project gets started. During…

Q: 23. Find the shortest route from node 1 to node 7 in the network shown. 18 6 7

A: In the shortest route problem:The main purpose of the shortest route problem - is to identify the…

Q: Discuss why many modern organizations adopt a just-in-time philosophy for their manufacturing…

A: Just-in-time is a kind of inventory system where the company or the buyer makes an order only when…

Q: (a) Formulate a linear programming model for maximizing total profit contribution. (Let P, units of…

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

Q: Briefly describe the term project management. Describe what a project manager does.

A: A project is exceptional, quick work, undertaken to achieve planned goals, which could be…

Q: a) Using a 2-year moving average, the forecast for year 6= 3750 miles (round your response to the…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. Business…

Q: Peter Ittig's department store, Ittig Brothers, is Amherst's largest independent clothier. The The…

A: A process control chart is a type of statistical graph that monitors the quality of a process over…

Q: A 20 16 B 11 # D E F 14 23 14 19 H 14 10 11 K 18 23 21 M Note: This question requires Solver.…

A: Operation management is performed in each manufacturing organization. It all deals with the…

Q: Arnold Tofu owns and operates a chain of "hamburger" restaurants in northern Louisiana. Sales…

A: 1) Using Excel: In Excel select columns of profit and sales, go to insert tab select scatter chart.…

Q: List out the benefits of biometric authentication?

A: Ans) Biometric authentication as the name suggests it is the process of authenticating each and…

Q: A manufacturing company produces single item product. The production manager decide to arrange 6…

A: Find the Given details below: Period 1 2 3 4 5 6 Forecast 112 157 126 176 124 181 Customer…

Q: The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is…

A: Given data: Monthly demand (d) = 50 cars Then Annual demand (D) = 50 × 12 = 600 cars Ordering cost…

Q: 10. Using the Key steps of the Basic Purchasing Process, cite an example of an industrial purchase…

A: The procurement process is a variable process that varies with respect to industries. However, the…

Q: Scenario 14.1 — Vidalia Onions When Vidalia onions are ready, the entire 13 county (plus parts of…

A: Given data: Price per unit = 100$ per bag The safety inventory requires is = 30% of lead time…

Q: K The school board is trying to evaluate a new math program introduced to second-graders in five…

A: C-chart is the type of control chart. It is help to monitoring the total number of conformities per…

Q: All of the below are tips to ensure a successful operating budget process except? Recognize and…

A: The operating budget refers to the list of total earnings and expenses done by an organization in a…

Q: Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: analyse the role of operations management capacity planning and control in a clothing business and…

A: Operations management is the process of designing, implementing, and controlling the production and…

Q: (d) Assume that the company wants to complete the project in six months or 26 weeks. What is the…

A: A network diagram related to the project shows the sequence of the task that is performed to…

Q: What is a layout strategy for a retail facility?

A: An effective use of space to affect the shopping experience is a retail store layout, whether it be…

Q: (d) Management realized that the optimal product mix, taking setup costs into account, might be…

A: The decision variables are already given. Objective function: Max…

Q: (a) Formulate a 0-1 integer linear programming model that will enable Bayside's management to…

A: (a) Minimize Z = 1x1 + 1x2 + 1x3 + 1x4 + 1x5 + 1x6 + 1x7 + 1x8 + 1x9 + 1x10 + 1x11 + 1x12 + 1x13…

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 are stakeholders relating to Sustainable Supply Chain Management.

A: The term sustainable supply chain management (SSCM) is often used to describe the process of…

Q: Benny the Barber owns a one-chair shop. At barber college, they told Benny that his customers would…

A: Given data: Arrive rateλ = 4.0 per hour.Service rate μ= 6013= 4.615 per hour

Q: The figure below shows the possible routes from city A to city M as well as the cost (in dollars) of…

A: Ans) In the current diagram we can see that traveller wanted to reach from A to M in minimum cost.…

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: 1. A company would like to develop an aggregate plan and evaluate its cost using the transportation…

Q: An accounting firm is capable of processing 20 EZ tax forms per day, and the average number of forms…

A: Queuing theory is the study of waiting for lines/queues. This model helps to determine the length…

Q: K- The following table gives the number of pints of type A blood used at Damascus Hospital in the…

A: Given data is

Q: Draw out the below process: Customer places an order, the order is the specified a delivery time…

A: Different steps found in the given process are listed below. Placing an order with a delivery time…

Q: 5. Consider the following project network, consisting of 10 activities (A-J) Activity Predecessor(s)…

A: AOA is a project management tool that used to map and schedule the project activities, events or…

Q: Describe the differences between input and output in healthcare budgeting.Explain it?

A: Inputs can be understood as all the resources that a business uses in order to carry out the…

Q: 24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that…

A: The given value for the Smoothing parameter α = 0.20 We have to find the forecast for year 5. This…

Q: A project is scheduled to complete in six months duration. There are two activities in the project.…

A: Actual cost of Activity 1 = AC1 = SAR 300,000 Actual cost of Activity 2 = AC2 = SAR 200,000 Planned…

Q: Zimmerman's Bank is the only bank in the small town of St. Thomas. On a typical Friday, an average…

A: Given data: Arrival Rate (λ)=10 customers/hr The average time required is (t) = 4 minutes Now…

Q: 9. The following information is given for a CPM network: Activity Predecessor Successor Normal Time…

A: A network diagram is visual representation of a project which helps to identify the project duration…

Q: Under the operations analysis, how do you complete resource allocation?

A: Every company has some objectives and all the processes, strategies, and hard work is made to…

Q: A project is scheduled to complete in six months duration. There are two activities in the project.…

A: Given data is

Q: Borges Machine Shop, Inc., has a 1-year contract for the production of 75,000 gear housings for a…

A: Given table; Particulars GPE FMS DM Units 75000 75000 75000 Fixed Cost 100000 225000…

Q: WEEK 1 maner 234567 ∞ 8 FORECAST DEMAND 135 135 135 134 134 144 155 156 Week 1 2 3 4 5 6 7 8 ACTUAL…

A: MAD is the proportion between total absolute error values and the number of weeks considered to…

Q: MRP EXERCISE The product M is obtained from two units of N and three units of P. N is obtained from…

Q: Consider the following requirements for an office chair product. Week 2 3 Gross requirements 90 300…

A: Ans) Formula in excel sheet:

Q: An Assembly line with 17 tasks is to be balanced. The longest task is 2.2 minutes, and the total…

A: An assembly line indicating the task allocation to the workstation based on different heuristics.…

Q: a) Explain what a “supply chain” is. b) Explain why practioneers of supply chain management need…

A: Supply chain management is an important part of business strategy. It can be used to improve…

Question

Please solve exact, acurate with complete details

follows:
The monthly sales for Yazici Batteries, Inc., were as
MONTH
January
February
March
April
May
June
July
August
September
October
November
December
SALES
20
21
15
14
13
16
17
18
20
20
21
23
a) Plot the monthly sales data.
b) Forecast January sales using each of the following:
i) Naive method.
ii) A 3-month moving average.
iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,
with the heaviest weights applied to the most recent months.
iv) Exponential smoothing using an a = .3 and a September
forecast of 18.
v) A trend projection.
c) With the data given, which method would allow you to fore-
cast next March's sales? PX

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
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?
What forecasting technique makes use of written surveys or telephone interviews? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 2 Which qualitative forecasting technique was developed to ensure that the input from every participant in the process is weighted equally? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting? 3 When forecasting demand for new products, sometimes firms will use demand data from similar existing products to help forecast demand for the new product. What technique is this an example of? Historical analogy, Delphi method, Marketing research, Ad hoc forecasting, or Collaborative forecasting
Explain the benefits does exponential smoothing have over moving avarages as a forecasting tool ?
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
The sales of Bluetooth Headphones at the Dubai Electronics Enterprises in Jebel Ali, UAE, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using the following techniques: 5B. If next month's sales turn out to be 140 units, forecast the following month's sales (months) using a 4-month moving average.
10 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 What is the forecast for day 4 using a 3-period moving average model? (1 mark) (Round to two decimal places). 11 What is the forecast for day 5 using a 3-period moving average model? (Round to two decimal places). 12 What is the forecast for day 6 using a 3-period moving average model? (1 mark) (Round to two decimal places). 13
Corporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 9.5 9.3 9.4 9.6 9.8 9.7 9.8 10.5 9.9 9.7 9.6 9.6 a. Construct a time series plot. What type of pattern exists in the data? b. Develop the three-month moving averages for this time series. Compute MSE. c. Compute MAE. d. Compute MAPE. e. What is the three-month moving average forecast for the next month (month 13)?
a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average.ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MAD.
What forecasting technique makes use of written surveys or telephone interviews?
The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value? MSE forecast for week 13 Time Series 1.08 14.76 3-week MA 3.04 13.67 exp smoothing 11.04 9.5 Group of answer choices A.) Time Series, forecasted value = 14.76 B.) 3-week MA, forecasted value = 13.67 C.) exp smoothing, forecasted value = 9.5 D.) Time Series, forecasted value = 1.08 E.) 3-week MA, forecasted value = 3.04 F.) exp smoothing, forecasted value = 11.04
Lesson about Forecasting: Linear Regression and Measures of Variations, view the photo for details. Help me pls.