1. Below is data collected on the number of prescriptions requests filed at a pharmacy each season in the past three years.

Season	2020	2021	2022
Winter	3124	3227	3606
Spring	2634	2492	2715
Summer	1078	1284	1645
Fall	1639	1733	1789

1. Build a running chart plot of the three years of data (time on the horizontal axis and number of prescriptions filled on the vertical axis).
2. Apply the Least Square Regression model (using MS Excel) to forecast demand for the four seasons of the upcoming year (2022).

Problem 2

1. Below is the layout of three work stations (rooms 1,2,3) in a primary care clinic, along with data regarding traffic between the work stations and distance between the zones (A,B,C).
2. Find the load-distance for the current layout.
3. Redesign the layout to minimize load-distance (i.e. which room should be in which zone). What is the total load-distance for your recommended layout?

Zone A Room 1	Zone B Room 2
Zone C Room 3

	To	Zone
From		A	B	C
A		-	40	80
B			_-	25

Distances Between Locations (in Feet)

Daily Traffic (Number of Trips) Between Rooms

	To Room
From	1	2	3
Room 1	-	18	4
Room 2	20	-	6
Room 3	7	12	-