Global Supply Chains-Problem Set Time Series Forecasting

Create an Excel spreadsheet that fits a time series model (with level, linear trend, and seasonal components) for purposes of forecasting daily demand at Penguin. Include calculations necessary to determine forecast margin of uncertainty. Assume that forecast errors are normally distributed.

Use your time series model to forecast future daily demand for the next three weeks (April 9-28), including a margin of uncertainty for each day’s forecast. Include a graph that shows information regarding the forecast.

The assessment of your work will include the accuracy as well as the clarity of the spreadsheet and graph (e.g., clear labels, good alignment, easy to understand, etc.).

Data

Date Day Images
5-Mar Monday 29
6-Mar Tuesday 36
7-Mar Wednesday 46
8-Mar Thursday 39
9-Mar Friday 32
10-Mar Saturday 27
12-Mar Monday 35
13-Mar Tuesday 40
14-Mar Wednesday 56
15-Mar Thursday 47
16-Mar Friday 41
17-Mar Saturday 34
19-Mar Monday 44
20-Mar Tuesday 53
21-Mar Wednesday 73
22-Mar Thursday 61
23-Mar Friday 59
24-Mar Saturday 46
26-Mar Monday 61
27-Mar Tuesday 73
28-Mar Wednesday 96
29-Mar Thursday 84
30-Mar Friday 79
31-Mar Saturday 61
2-Apr Monday 80
3-Apr Tuesday 96
4-Apr Wednesday 129
5-Apr Thursday 111
6-Apr Friday 102
7-Apr Saturday 81AD680 Global Supply Chains

Problem Set #1: Time Series Forecasting

Penguin Images Services is a US-based healthcare service provider, specializing in state-of-the-art medical imaging. The imaging services they offer include MRI, MR Angiography (MRA), CT Scan, 3D Imaging, X-ray and Ultrasound. Their business model is based on low cost but responsive service. They attempt to achieve this goal by maintaining a group of radiologists who are paid to evaluate images and to be available during various periods when services are expected. That is, when on duty, each radiologist is paid a minimum amount even when service is not required. Labor costs are minimized by hiring radiologists located in certain high quality but lower cost locations, mainly India.

The effectiveness of Penguin’s service is affected a great deal by their ability to forecast demand. Penguin does not require that patients make an appointment, because most patients were referred by their physician. These patients necessitated service on short notice.

Penguin’s location in Bainston, Rhode Island, is opened for customers Monday through Friday (0800-1700) and Saturday (0800-1200). At this location, a short-term increase in demand for MRI image evaluation has occurred. This growth was caused by the closing of the other major imaging service provider in Bainston. The increase in demand is expected to continue over the next several weeks. Historical demand (number of images by day) is shown below and included on the accompanying Excel file:

 

 

Create an Excel spreadsheet that fits a time series model (with level, linear trend, and seasonal components) for purposes of forecasting daily demand at Penguin. Include calculations necessary to determine forecast margin of uncertainty. Assume that forecast errors are normally distributed.

Use your time series model to forecast future daily demand for the next three weeks (April 9-28), including a margin of uncertainty for each day’s forecast. Include a graph that shows information regarding the forecast.

The assessment of your work will include the accuracy as well as the clarity of the spreadsheet and graph (e.g., clear labels, good alignment, easy to understand, etc.).

Attach one Excel file, using a file name Lastname_PS1.

Date Day Images

5-Mar Monday 29

6-Mar Tuesday 36

7-Mar Wednesday 46

8-Mar Thursday 39

9-Mar Friday 32

10-Mar Saturday 27

12-Mar Monday 35

13-Mar Tuesday 40

14-Mar Wednesday 56

15-Mar Thursday 47

16-Mar Friday 41

17-Mar Saturday 34

19-Mar Monday 44

20-Mar Tuesday 53

21-Mar Wednesday 73

22-Mar Thursday 61

23-Mar Friday 59

24-Mar Saturday 46

26-Mar Monday 61

27-Mar Tuesday 73

28-Mar Wednesday 96

29-Mar Thursday 84

30-Mar Friday 79

31-Mar Saturday 61

2-Apr Monday 80

3-Apr Tuesday 96

4-Apr Wednesday 129

5-Apr Thursday 111

6-Apr Friday 102

7-Apr Saturday 81

0

20

40

60

80

100

120

140

M o

n 0

3 /0

5

T u

e 0

3 /0

6

W ed

0 3

/0 7

T h

u 0

3 /0

8

Fr i 0

3/ 09

Sa t

0 3

/1 0

M o

n 0

3 /1

2

T u

e 0

3 /1

3

W ed

0 3

/1 4

T h

u 0

3 /1

5

Fr i 0

3/ 16

Sa t

0 3

/1 7

M o

n 0

3 /1

9

T u

e 0

3 /2

0

W ed

0 3

/2 1

T h

u 0

3 /2

2

Fr i 0

3/ 23

Sa t

0 3

/2 4

M o

n 0

3 /2

6

T u

e 0

3 /2

7

W ed

0 3

/2 8

T h

u 0

3 /2

9

Fr i 0

3/ 30

Sa t

0 3

/3 1

M o

n 0

4 /0

2

T u

e 0

4 /0

3

W ed

0 4

/0 4

T h

u 0

4 /0

5

Fr i 0

4/ 06

Sa t

0 4

/0 7

N um

b er

Demand for Images (March 5 through April 7)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Apply: Case Study Analysis – Case 2 Airbnb In 2018

Prepare a case study analysis for Case 2 Airbnb in 2018 with at least 3 references.

Read “Case 2: Airbnb in 2018,” which is attached below.

In the accommodations market, Airbnb appears to have a significant advantage over its competitors as it relates to regulations affecting the operations of its business.

Develop a business strategy that will allow Airbnb to meet local, state, and international regulatory requirements and motivate individuals

tho75109_case02_C6-C10.indd!C-6 12/18/18 09:23 PM

Airbnb In !”#$

John D. Varlaro Johnson & Wales University

John E. Gamble Texas A&M University–Corpus Christi

Airbnb was founded in 2008 when Brian Chesky and a friend decided to rent their apartment to guests for a local convention. To accommo- date the guests, they used air mattresses and referred to it as the “Air Bed & Breakfast.” It was that week- end when the idea—and the potential viability—of a peer-to-peer room-sharing business model was born. By 2018, Airbnb had seen immense growth and suc- cess in its 10-year existence. The room-sharing com- pany had expanded to over 190 countries with more than 4 million listed properties, and had an estimated valuation of $31 billion. Airbnb seemed poised to revolutionize the hotel and tourism industry through its business model that allowed hosts to offer spare rooms or entire homes to potential guests, in a peer- reviewed digital marketplace.

This business model’s success was leveraging what had become known as the sharing economy. Yet, with its growth and usage of a new business model, Airbnb was now faced with resistance, as city officials, owners and operators of hotels, motels, and bed and breakfasts were all crying foul. While these traditional brick-and-mortar establishments were sub- ject to regulations and taxation, Airbnb hosts were able to circumvent and avoid such liabilities due to participation in Airbnb’s digital marketplace. In other instances, Airbnb hosts had encountered legal issues due to city and state ordinances governing hotels and apartment leases. Stories of guests who would not leave and hosts needing to evict them because city regulations deemed the guests apartment leasees were beginning to make headlines.

As local city and government officials across the United States, and in countries like Japan, debated regulations concerning Airbnb, Brian Chesky needed

to manage this new business model, which had led to phenomenal success within a new, sharing economy.

OVERVIEW!OF! ACCOMODATION!MARKET Hotels, motels, and bed and breakfasts competed within the larger, tourist accommodation market. All businesses operating within this sector offered lodg- ing, but were differentiated by their amenities. Hotels and motels were defined as larger facilities accom- modating guests in single or multiple rooms. Motels specifically offered smaller rooms with direct parking lot access from the unit and amenities such as laun- dry facilities to travelers who were using their own transportation. Motels might also be located closer to roadways, providing guests quicker and more con- venient access to highways. It was also not uncom- mon for motel guests to segment a longer road trip as they commuted to a vacation destination, thereby potentially staying at several motels during their travel. Hotels, however, invested heavily in additional amenities as they competed for all segments of trav- elers. Amenities, including on-premise spa facilities and fine dining, were often offered by the hotel. Further, properties offering spectacular views, bol- stering a hotel as the vacation destination, may con- tribute to significant operating costs. In total, wages, property, and utilities, as well as purchases such as food, accounted for 59 percent of the industry’s total costs—see Exhibit 1.

CASE !

Copyright ©2018 by John D. Varlaro and John E. Gamble. All rights reserved.

Final PDF to printer

https://www.coursehero.com/file/75718546/Case1pdf/

Th is

stu dy

re so

ur ce

w as

sh ar

ed v

ia

Co ur

se H

er o.

co m

 

 

tho75109_case02_C6-C10.indd!C-7 12/18/18 09:23 PM

CASE”# Airbnb In !”#$ C-7

Bed and breakfasts, however, were much smaller, usually where owner-operators offered a couple of rooms within their own home to accommodate guests. The environment of the bed and breakfast—one of a cozy, home-like ambience—was what the guest desired when booking a room. Contrasted with the hotel or motel, a bed and breakfast offered a more personal- ized, yet quieter atmosphere. Further, many bed and breakfast establishments were in rural areas where the investment to establish a larger hotel may have been cost prohibitive, yet the location itself could be an attraction to tourists. In these areas individuals invested in a home and property, possibly with a his- torical background, to offer a bed and breakfast with great allure and ambience for the guests’ experiences. Thus, the bed and breakfast competed through offer- ing an ambience associated with a more rural, slower pace through which travelers connected with their hosts and the surrounding community. A comparison of the primary market segments of bed and breakfasts and hotels in 2017 is presented in Exhibit 2.

While differing in size and target consumer, all hotels, motels, and bed and breakfasts were subject to city, state, and federal regulations. These regulations covered areas such as the physical property and food safety, access for persons with disabilities, and even alcohol distribution. Owners and operators were sub- ject to paying fees for different licenses to operate. Due to operating as a business, these properties and

the associated revenues were also subject to state and federal taxation.

In addition to regulations, the need to construct physical locations prevented hotels and motels from expanding quickly, especially in new international markets. Larger chains tended to expand by purchas- ing preexisting physical locations, or through merg- ers and acquisitions, such as Marriott International Inc.’s acquisition of Starwood Hotels and Resorts Worldwide in 2016.

A!BUSINESS!MODEL!FOR!THE! SHARING!ECONOMY Startup companies have been functioning in a space commonly referred to as the “sharing economy” for several years. According to Chesky, the previous model for the economy was based on ownership.1 Thus, operating a business first necessitated owner- ship of the assets required to do business. Any spare capacity the business faced—either within production or service—was a direct result of the purchase of hard assets in the daily activity of conducting business.

Airbnb and other similar companies, however, operated through offering a technological platform, where individuals with spare capacity could offer their services. By leveraging the ubiquitous usage of smart- phones and the continual decrease in technology

Costs Hotels/ Motels

Bed & Breakfasts

Wages !%% #&%

Purchases !’% !#%

Depreciation #”% &%

Marketing !% !%

Rent and Utilities $% ##%

Other #(% !!%

EXHIBIT!” Hotel, Motel, and Bed & Breakfast Industry Costs as Percentage of Revenue, 2017

Source: www#ibisworld#com.

EXHIBIT!$ Major Market Segments for Hotels/Motels & Bed & Breakfast/Hostels Sectors, 2017

Market Segment B&Bs* Hotels**

Recreation $”% ‘”%

Business #!% #$%

Other, including meetings

$% #!%

Total #””% #””%

*The bed & breakfast market was primarily domestic. **Includes both domestic and international travelers. Approximately !”% was associated with international travelers.

Source: www#ibisworld#com.

Final PDF to printer

https://www.coursehero.com/file/75718546/Case1pdf/

Th is

stu dy

re so

ur ce

w as

sh ar

ed v

ia

Co ur

se H

er o.

co m

 

 

tho75109_case02_C6-C10.indd!C-8 12/18/18 09:23 PM

C-8 PART”# Cases in Crafting and Executing Strategy

this change seemed to be how the consumer had deem- phasized ownership. Instead of focusing on ownership, consumers seemed to prefer sharing or renting. Other startup companies have been targeting these segments through subscription-based services and on-demand help. From luxury watches to clothing, experiencing— and not owning—assets seemed to be on the rise. Citing a more experiential-based economy, Chesky believed Airbnb guests desired a community and a closer rela- tionship with the host—and there seemed to be support for this assertion.4 A recent Goldman Sachs study showed that once someone used Airbnb, their pref- erence for a traditional accommodation was greatly reduced.5 The appeal of the company’s value proposi- tion with customers had allowed it to readily raise capi- tal to support its growth, including an $850 million cash infusion in 2016 that raised its estimated valu- ation to $30 billion. A comparison of Airbnb’s 2018 estimated market capitalization of $31 billion to the world’s largest hoteliers is presented in Exhibit 4.

costs, these companies provided a platform for indi- viduals to instantly share a number of resources. Thus, a homeowner with a spare room could offer it for rent. Or, the car owner with spare time could offer [his or her] services a couple of nights a week as a taxi service. The individual simply signed up through the platform and began to offer the service or resource. The company then charged a small transaction fee as the service between both users was facilitated.

Within its business model, Airbnb received a percentage of what the host received for the room. For Airbnb, its revenues were decoupled from the considerable operating expenses of traditional lodg- ing establishments and provided it with significantly smaller operating costs than hotels, motels, and bed and breakfasts. Rather than expenses related to own- ing and operating real estate properties, Airbnb’s expenses were that of a technology company. Airbnb’s business model, therefore, was based on the revenue- cost-margin structure of an online marketplace, rather than a lodging establishment. With an esti- mated 11 percent fee per room stay, it was reported that Airbnb achieved profitability for a first time in 2016.2 Airbnb’s revenues were estimated to increase from approximately $6 million in 2010 to a projected $1.2 billion in 2017—see Exhibit 3. However, it was announced in an annual investors’ meeting that the company had recorded nearly $3 billion in revenue and earned over $90 million in profit in 2017.3

A!CHANGE!IN!THE! CONSUMER!EXPERIENCE! AND!RATE Airbnb, however, was not just leveraging technology. It was also leveraging the change in how the current con- sumer interacted with businesses. In conjunction with

EXHIBIT!% Airbnb Estimated Revenue and Bookings Growth, 2010–2017 (in millions)

!”#” !”## !”#! !”#$ !”#% !”#& !”#’ !”#(

Estimated Revenue $) $%% $#(! $!)% $%() $)’* $&%* $#,!!&

Estimated Bookings Growth !'(% )))% !””% #””% )*% **% %”% (“%

Source: Ali Rafat, “Airbnb’s Revenues Will Cross Half Billion Mark in !”#*,” Analysts Estimate, March !*, !”#*, skift#com/&'()/’*/&)/ airbnbs+revenues+will+cross+half+billion+mark+in+&'()+analysts+estimate/.

EXHIBIT!, Market Capitalization Comparison, 2018 (in billions)

Competitor Market Capitalization

Marriot International Inc. $%&

Airbnb $(#

Hilton Worldwide Holdings. $!*

Intercontinental Hotels Group $##

Source: Yahoo Finance (accessed April !”#$); “Airbnb Announces It Won’t Go Public in !”#$,” Business Insider, http-//www#busines+ sinsider#com/airbnb+announces+it+wont+go+public+in+&'(.+&'(.+& (accessed April !”, !”#$).

Final PDF to printer

https://www.coursehero.com/file/75718546/Case1pdf/

Th is

stu dy

re so

ur ce

w as

sh ar

ed v

ia

Co ur

se H

er o.

co m

 

 

tho75109_case02_C6-C10.indd!C-9 12/18/18 09:23 PM

CASE”# Airbnb In !”#$ C-9

Finally, there were accusations of businesses using Airbnb’s marketplace to own and operate accommodations without obtaining the proper licenses. These locations appeared to be individu- als on the surface, but were actually businesses. And, because of Airbnb’s platform, these pseudo- businesses could operate and generate revenue with- out meeting regulations or claiming revenues for taxation.

Airbnb continued to respond to some of these issues. A report was written and released by Airbnb in 2015 detailing both discrimination on its platform and how it would be mitigated. Airbnb also settled its lawsuit with San Francisco in early 2017. The city was demanding Airbnb enforce a city regulation requiring host registration, or incur significant fines. As part of the settlement, Airbnb agreed to offer more information on its hosts within the city.9 And in 2018, Airbnb began partnering with local municipalities to help collect taxes automatically for rentals within their jurisdic- tions, helping to potentially recoup millions in lost tax revenue.10 11

“WE!WISH!TO!BE!REGULATED$! THIS!WOULD!LEGITIMIZE!US” Recognizing that countries and local municipalities were responding to the local business owner and their constituents’ concerns, Chesky and Airbnb have focused on mobilizing and advocating for con- sumers and business owners who utilize the app. Airbnb’s website provided support for guests and hosts who wished to advocate for the site. A focal point of the advocacy emphasized how those particu- larly hit hard at the height of the recession relied on Airbnb to establish a revenue stream, and prevent the inevitable foreclosure and bankruptcy.

Yet, traditional brick-and-mortar establishments subject to taxation and regulations have continued to put pressure on government officials to level the playing field. “We wish to be regulated; this would legitimize us,” Chesky remarked to Noah in the same interview on The Daily Show.12 Proceeding forward and possibly preparing for a future public offering, Chesky would need to manage how the progressive business model—while fit for the new, global sharing economy—may not fit older, local regulations.

Recognizing this shift in consumer preference, traditional brick-and-mortar operators were respond- ing. Hilton was considering offering a hostel-like option to travelers.6 Other entrepreneurs were con- structing urban properties to specifically leverage Airbnb’s platform and offer rooms only to Airbnb users, such as in Japan7 where rent and hotel costs were extremely high.

To govern the community of hosts and guests, Airbnb had instituted a rating system. Popularized by companies such as Amazon, eBay, and Yelp, peer-to- peer ratings helped police quality. Both guests and hosts rated each other in Airbnb. This approach incentivized hosts to provide quality service, while encouraging guests to leave a property as they found it. Further, the peer-to-peer rating system greatly min- imized the otherwise significant task and expense of Airbnb employees assessing and rating each individ- ual participant within Airbnb’s platform.

NOT!PLAYING!BY! THE!SAME!RULES Local and global businesses criticized Airbnb for what they claimed were unfair business practices and lobbied lawmakers to force the company to comply with lodging regulations. These concerns illuminated how due to its business model, Airbnb and its users seemed to not need to abide by these same regula- tions. This could have been concerning on many levels. For the guest, regulations exist for protection from unsafe accommodations. Fire codes and occu- pation limits all exist to prevent injury and death. Laws also exist to prevent discrimination, as tradi- tional brick-and-mortar accommodations are barred from not providing lodging to guests based on race and other protected classes. But, there seemed to be evidence that Airbnb guests had faced such discrimi- nation from hosts.8

Hosts might also expose themselves to legal and financial problems from accommodating guests. There had been stories of hosts needing to evict guests who would not leave, and due to local ordinances the guests were actually protected as apartment leasees. Other stories highlighted rooms and homes being damaged by huge parties given by Airbnb guests. Hosts might also be exposed to liability issues in the instance of an injury or even a death of a guest.

Final PDF to printer

https://www.coursehero.com/file/75718546/Case1pdf/

Th is

stu dy

re so

ur ce

w as

sh ar

ed v

ia

Co ur

se H

er o.

co m

 

 

tho75109_case02_C6-C10.indd!C-10 12/18/18 09:23 PM

C-10 PART”# Cases in Crafting and Executing Strategy

ENDNOTES !”#), www#bloomberg#com/news/ articles/&'(/+’&+(//goldman+sachs+more+ and+more+people+who+use+airbnb+don+t+ want+to+go+back+to+hotels. ) D. Fahmy, “Millennials Spending Power Has Hilton Weighing a ‘Hostel-Like’ Brand,” March+$, !”#), Bloomberg Businessweek, www#bloomberg#com/businessweek. ‘ Y. Nakamura and M. Takahashi, “Airbnb Faces Major Threat in Japan, Its Fastest-Growing Market,” Bloomberg, February #$, !”#), www #bloomberg#com/news/articles/&'(/+’&+(./ fastest+growing+airbnb+market+under+threat+ as+japan+cracks+down. $ R. Greenfield, “Study Finds Racial Discrimination by Airbnb Hosts,” Bloomberg, December #”, !”#*, www #bloomberg#com/news/articles/&'()+(&+(‘/ study+finds+racial+discrimination+by+airbnb+ hosts.

# Interview with Airbnb founder and CEO Brian Chesky, The Daily Show with Trevor Noah, Comedy Central, February !%, !”#). ! B. Stone and O. Zaleski, “Airbnb Enters the Land of Profitability,” Bloomberg, January !), !”#’, https-//www#bloomberg#com/news/ articles/&'(0+'(+&//airbnb+enters+the+ land+of+profitability (accessed June !”, !”#’). ( O. Zaleski, “Inside Airbnb’s Battle to Stay Private,” Bloomberg.Com, February ), !”#$, https-//www#bloomberg#com/news/arti+ cles/&'(.+’&+’//inside+airbnb+s+battle+to+ stay+private (accessed April !”, !”#$). % Interview with Airbnb founder and CEO Brian Chesky, The Daily Show with Trevor Noah, Comedy Central, February !%, !”#). * J. Verhage, “Goldman Sachs: More and More People Who Use Airbnb Don’t Want to Go Back to Hotels,” Bloomberg, February+!),

& K. Benner, “Airbnb Adopts Rules to Fight Discrimination by Its Hosts,” New York Times, (September $, !”#)) http-//www#nytimes #com/&'(//’1/’1/technology/airbnb+anti+ discrimination+rules#html (accessed June !”, !”#’). #” S. Cameron, “New TN Agreement Ensures $#(M in Airbnb Rental Taxes Collected,” wjhl. com, April !”, !”#$, http-//www#wjhl#com/ local/new+tn+agreement+ensures+(*m+in+ airbnb+rental+taxes+collected/((*((1&*1& (accessed April !”, !”#$). ## “Duluth, Airbnb Make Deal on Lodging Tax Collection,” TwinCitiesPioneerPress, April #&, !”#$, https-//www#twincities#com/&'(./’2/(1/ duluth+airbnb+make+deal+on+lodging+tax+collec+ tion/ (accessed April !”, !”#$). #! Interview with Airbnb founder and CEO Brian Chesky, The Daily Show with Trevor Noah, Comedy Central, February !%, !”#).

Final PDF to printer

https://www.coursehero.com/file/75718546/Case1pdf/

Th is

stu dy

re so

ur ce

w as

sh ar

ed v

ia

Co ur

se H

er o.

co m

Powered by TCPDF (www.tcpdf.org)

 

to benefit from participating in this space of the accommodations market. Address the following questions:

  • How can Airbnb ensure the ethical treatment of consumers?
  • Should there be a separate strategy for the international component of their business model?
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

OPERATIONS AND SUPPLY CHAIN MANAGEMENT Assignment 2

Operations and Supply Chain Management

MGMT 3306

Lecture 03

Instructor: Dr. Yan Qin

Outline – Demand Forecasting

What is Forecasting

Qualitative forecasting methods

Quantitative forecasting methods

Time-series models

Associative models

Linear regression

Trend and Seasonal factors

Trend-adjusted exponential smoothing method

Seasonal indices

Forecasting

Forecasting is the art and science of predicting future events.

Three major types of forecasts in planning future operations:

Economic forecasts: address the business cycle by predicting inflation rates, money supplies, and etc.;

Technological forecasts: predict rates of technological progress;

Demand forecasts: projections of demand for a company’s products or services. (What we’ll discuss in this lecture)

3

Seven Steps in Forecasting

Determine the use of the forecast

Select the items to be forecasted

Determine the time horizon of the forecast

Select the forecasting model(s)

Gather the data

Make the forecast

Validate and implement results

Demand Forecasts

There are two general approaches to forecasting:

Qualitative, which incorporate factors such as decision maker’s intuition, emotions, personal experience, and so on.

Quantitative, which uses a variety of models that rely on historical data to forecast demand.

Common types of Qualitative Methods

Jury of execution opinion: The opinions of a group of high-level experts or mangers are pooled together to arrive at a group estimate of demand.

This approach is used widely because it is relatively quick, inexpensive and uses the solid understanding of participants who are presumed to have relevant knowledge.

Consumer market survey: Collect information from current or potential customers about future purchasing plan.

6

Common types of Qualitative Methods

Delphi method: Surveys and questionnaires are distributed to a group of selected respondents. Then a group of 5-10 experts make the decision based on the responses.

The state of Alaska used Delphi method to develop its long-range economic forecast.

Sales force composite: Combine each sales person’s estimate of future demand.

Lexus dealers meet every quarter to talk about the sales, such as what is selling, in what colors, so the manufacturer has an idea what to build.

7

Common Quantitative Methods

Time series models predict on the assumption that the future is a function of the past.

NaĂŻve approach

Moving averages

Exponential smoothing

Associative Models incorporate variables that might influence the quantity being forecast.

For example, an associative model for lawn mowers sales might use factors such as new housing starts, advertising budget and so on.

Linear regressions

8

NaĂŻve Approach

Assume that demand in the next period will be equal to the most recent period.

For example, if the sales in Feb was 56 units, the forecast for March would be 56 under the naĂŻve approach.

This approach takes a temporary change as a permanent change.

Bull-whip effect will be maximized under this forecasting method.

9

Moving averages

A moving-average forecast uses a number of historical actual data values to generate a forecast.

It is useful if we can assume that market demands will stay fairly steady over time.

An n-period moving-average model:

Usually the n is 3, 6, 9 periods.

n : # of periods to be averaged

: Forecast for period t

: Actual demand for period t-1

10

Example: 3-/6-month moving average

Month Actual Sales 3-Month 6-Month
Jan 10
Feb 12
March 13
April 16 (10+12+13)/3=11.7
May 19 (12+13+16)/3=13.7
June 23 (13+16+19)/3=16
July 26 (16+19+23)/3=19.3 (10+12+13+16+19+23)/6=15.5
Aug 30 (19+23+26)/3=22.7 (12+13+16+19+23+26)/6=18.2
Sep 28 (23+26+30)/3=26.3 (13+16+19+23+26+30)/6=21.2
Weighted moving averages

Weights can be used to place more emphasis on recent values or older values.

A n-period weighted moving average:

: Weight attached to the actual demand in period i

12

Example: Weighted moving average

Suppose we use the 3-period weighted moving average method to make demand forecasts. An importance weight of 0.6 is assigned to the most recent actual demand, 0.3 to the second most recent actual demand, and 0.1 to the oldest observation.

Then what are the 3-period forecasts for demands in April and May?

Month Actual Sales Forecasts
Jan 10
Feb 12
March 13
April 16 ?
May 19 ?
Example: Solution

We first calculate the forecast for April. Let t = 4. Then, period 1 is Jan. Period 2 is Feb. And period 3 is Mar in this case.

We now calculate the forecast for May. Let t = 5.

Limitations of moving averages

Increasing the size of n makes the method less sensitive to real changes in the data;

Moving averages cannot predict changes to either higher or lower levels. They lag the actual values.

Moving averages require extensive records of past data.

Exponential smoothing

Exponential smoothing is a sophisticated weighted-moving-average method.

Call a smoothing constant, valued between 0 an 1. Usually from 0.05 to 0.50 for business application.

That is, the forecast for period t is the sum of the forecast for period t -1 and the amount of adjustment determined by the forecast error in period t-1 and the smoothing constant.

Example: Exponential Smoothing

Let . Then what are the forecasts for the demands in Feb, Mar, and April using Exponential Smoothing?

Month Actual Sales Forecast
Jan 10 8
Feb 12 ?
March 13 ?
April 16 ?
May 19
Example: Solution

Let Jan be period 1, Feb be period 2, Mar be period 3, and so on.

Then the forecast for Feb can be computed as follows:

The forecast for March:

The forecast for April:

Impact of Smoothing Constant

225 –

200 –

175 –

150 –

| | | | | | | | |

1 2 3 4 5 6 7 8 9

Quarter

Demand

a = .1

Actual demand

a = .5

Chose high values of α when underlying average is likely to change

Choosing Smoothing Constant

The objective is to obtain the most accurate forecast no matter the technique

We generally do this by selecting the model that gives us the lowest forecast error

Forecast error = Actual demand – Forecast value

= At – Ft

Common Measures of Error

Mean Absolute Deviation (MAD): Average of the absolute values of the individual forecast errors.

Mean Squared Error (MSE): The average of the squared forecast errors.

Example: Measures of Error

Rounded Absolute Rounded Absolute

Actual Forecast Forecast error Forecast Forecast error

Tonnage with for with for

Quarter Unloaded a = .10 a = .10 a = .50 a = .50

1 180 175 5.00 175 5.00

2 168 175.5 7.50 177.50 9.50

3 159 174.75 15.75 172.75 13.75

4 175 173.18 1.82 165.88 9.12

5 190 173.36 16.64 170.44 19.56

6 205 175.02 29.98 180.22 24.78

7 180 178.02 1.98 192.61 12.61

8 182 178.22 3.78 186.30 4.30

82.45 98.62

Sum

Sum

Example: MAD

For α = 0.1,

For α = 0.5,

Lower overall forecast error based on MAD when

Example: MSE

For α = 0.1, 190.82

For α = 0.5, 195.24

Lower overall forecast error based on MSE when

Associative Model – Linear Regression

Regression is used to predict one variable given the other variable(s). The relationship is usually developed from observed data.

Linear regression is a special class of regression where the relationship between variables is linear.

a: Intercept; b: Slope

Y: dependent variable we are tying to make forecast for

X: independent variable whose value has a linear impact on the value of Y.

25

Least squares method

It is a method to estimate the a and b values based on historic data.

The objective is to minimize the sum of the squares of the differences between forecasts and actual observations.

Let denote the y value of the observation and be the corresponding forecast using a certain set of a and b values. Suppose there are n data points.

Forecast error of observation 1

Forecast error of observation 2

Forecast error of observation n

Figure: Least squares method

We want to find a straight line that minimizes the sum of the squared forecast errors.

Least squares method (Cont.)

Using the least squares method,

where is the x value of observation i;

is the y value of observation i;

is the mean of all x values;

is the mean of all y values;

n is the number of observations in the data set

Least squares method (Cont.)

Standard error of estimates (How well the estimated line fits the data)

where is the forecast for the y value of observation i.

Example: Least squares

Consider a situation where the sales of a product is time-dependent. What is the forecast for the demand in month 6 using the least squares Linear Regression method?

Month () Actual Sales ()
1 10
2 12
3 13
4 16
5 19
Example: Solution

We first calculate the squares and products required in the calculation of a and b.

Month () Actual Sales ()
1 10 10 1
2 12 24 4
3 13 39 9
4 16 64 16
5 19 95 25
14

Example: Solution

The linear regression function is:

Y = 7.4 + 2.2X

Then the forecast for the demand in month 6

= 7.4 + 2.26

= 20.6

Note that

Decomposition of a time series

A time series can have 4 components:

Trend: the gradual upward or downward movement of the data over time. (Can be estimated using Least squares Linear Regression method)

Seasonality: a data pattern that repeats itself after a period of days, weeks, months, or quarters.

Cycle: patterns in the data that occur every several years.

Random variations: “blips” in the data caused by chance and unusual situations.

33

Figure: 4 major components

Exponential smoothing with Trend adjustment

Adjust exponential smoothing forecasts for positive or negative lag in trends. (requires two smoothing constants: )

Steps to take:

Step 1: Compute , the exponential smoothing forecast for period t.

Step 2: Compute the trend estimate for period t,

Step 3: Calculate the forecast for period t including trend

35

Example: Trend adjustment

Let the smoothing constants and . The company assumes that the initial forecast for Jan was 10 and the trend over that period was 2 units. What are the trend-adjusted forecasts for Feb in this case?

Month Actual Sales Forecast t Trend t
Jan 10 9 2
Feb 12 ? ?
Example: Solution

For Feb,

10.8

=12.72

Seasonal index

A seasonal index is the amount of correction needed in a time series to adjust for the season of the year.

Example 1: Assume that in past years, a firm sold an average of 1,000 units of a product each year. On average, 200 units were sold in the spring, 350 units in the summer, 300 units in the fall, and 150 units in the winter.

Then the seasonal index is the ratio of the amount sold during each season divided by the average for all seasons.

Example: Seasonal index

Question 1: For the previous example, what are the four seasonal indices?

Seasonal average = 1,000 / 4 = 250

Seasonal index = average sales in a season / seasonal average

Seasonal index for spring = 200/250 = 0.8

Seasonal index for summer = 350/250=1.4

Seasonal index for fall = 300/250 = 1.2

Seasonal index for winter = 150/250 = 0.6

Example: Seasonal index (Cont.)

Question 2: Now suppose the expected demand for next year is 1,100 units. What are the forecasts for each season next year?

Forecast for a season = seasonal average for next year * seasonal index for that season

Seasonal average for next year = 1100 / 4 = 275

Forecast for spring =275*0.8 = 220

Forecast for summer =275*1.4 = 385

Forecast for fall = 275*1.2 = 330

Forecast for winter = 275*0.6 = 165

Example 2: Seasonal index

What if we have more than one year of data?

Answer: Divide the average for each season by the general seasonal average for all years. (Assuming constant seasonal indices for each year or additive seasonal effect)

Year 1 Actual Sales Year 2 Actual Sales
Spring 300 Spring 520
Summer 200 Summer 420
Fall 220 Fall 400
Winter 530 Winter 700
The general average is 411.25 (Average of the 8 numbers)

Seasonal index for Spring = ((300+520)/2)/411.25 = 0.99

212

128.728205

2

)(

2

1















n

Yy

S

i

n

i

i

xy

= 269.85

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Process Quality Exercise

Exercise:

Tom Dooley just graduated from Arizona State and accepted a job with Meyerson Candy Company. One of their major products is gum drops that are packaged in an assortment of colors, each color being a different flavor. Most of the process is automated with machines producing the gum drops, mixing the different flavors, and packaging them in plastic bags. Each bag should contain 16 ounces of candy; each gum drop is about 1/2 ounce. The mix in each bag should be approximately 20% red (cherry), 20% orange, 20% white, 20% yellow (lemon) and 10% each of black (licorice), and green (lime).

Recently, the company has received customer complaints along two lines:

1. Many are complaining that the bags do not appear full and they believe that they are not getting a fair measure for what they are paying, but no one has verified this.

2. Several customers have complained about “too many green ones” in the package. Some have even reported counting the total number of gum drops and the number of green ones in a package. No one has ever complained about too few green ones.

Tom has been given copies of the complaint letters and the assignment to “fix the problem.” He decides his first step is to determine if there really is a problem with the process. To do that he will need to use the tools and ideas he learned in his Operations Management course.

Tom has been trying to figure out what information he needs, how to analyze it, and how to create a system to monitor the quality of the product to assure that these customer complaints do not arise in the future. At first, he was not sure whether to count the gum drops, weigh them, or use some other measure. After giving it more thought, Tom has decided to take random samples of 10 bags throughout the day and use their weights to monitor “fair measure.”

The problem of “too many green ones” is a bit more difficult for Tom to formulate. He thought about calling the green ones “defects” but then he would have to say that each bag should contain about 10% “defects” that wouldn’t sound right in a report to management. A better approach, he thought, would be to say that since the bag should contain about 32 gum drops and 10% of those should be green, any bag containing 2 or 3 or 4 green ones would be a “good” bag. Therefore, if a bag contained less than 2 or more than 4 green ones, the bag would be considered “bad” or “defective” with respect to the product specifications.

Now, Tom has to determine if he needs a p-chart, an X-bar chart, an R-chart or what. He needs your help.

THE “FAIR MEASURE” PROBLEM

1. What kind of chart(s) does Tom need to analyze this problem? Explain why you chose the chart(s) he should use.

Tom should use both the x-bar and R-charts since weight is a variable measure of quality. These charts must be used together.

2. Specifically, what information will Tom need to construct the chart(s) and how will he gather it?

Tom will need to take random samples of 10 bags each from the process. For each bag, he will measure the weight and record it. Then he will calculate the average weight of those 10 bags by averaging the 10 recorded weights. Finally, he will calculate the range of the weights by subtracting the smallest of the 10 weights from the largest of the 10 weights.

3. Explain the calculations Tom will need to make — including formulas and tables he will need — to construct the chart(s).

Answer should show the formulas for the x-bar and R-charts. In addition, the answer should explain that Tom will need to look up information in a table to estimate 3 standard deviations from the mean for the control limits.

4. After he has the chart(s) completed, what should Tom do over the next week or so?

Tom should continue taking samples at regular intervals to determine whether the process is still in control or not. If it is out of control, Tom will need to take action to fix the assignable cause of the variation.

“TOO MANY GREEN ONES” PROBLEM

1. Should Tom use the same or different type of chart(s) to analyze this problem?

Explain why.

Tom should use the p-chart. He must use a different chart since the quality characteristic being measured is an attribute. The background information suggests that he should not use a c-chart since he does not think it is reasonable to count each green gum drop as a defect.

2. Specifically, what information will Tom need to construct the chart(s) for this problem and how will he gather it?

Tom will need to gather random samples of 10 bags. For each bag, he will count the number of green gum drops. If the number is less than 2 or more than 4, then the bag is considered defective. Each plot on the p-chart will then show the proportion of the 10 bags that were defective. For example, if 2 out of the 10 bags have the wrong number of green ones, then the proportion defective is 0.20 (20%).

3. Explain the calculations Tom will need to make — including formulas and tables he will need — to construct the chart(s).

The answer should show the formulas for the center line and control limits for the p-chart.

4. After he has the chart(s) completed, what should Tom do over the next week or so?

Tom should continue taking samples at regular intervals to determine whether the process is still in control or not. If it is out of control, Tom will need to take action to fix the assignable cause of the variation.

PAGE

2

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"