unit 4 ( 2 part paper ) ....gom

This is a 2 part paper. please make sure both parts are seprate and different refrences are used for each part.
Part 1 = to 3 pages with 5 refrences
details:
The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

Day
Demand
Day
Demand

1
200
8
150

2
134
9
182

3
157
10
197

4
165
11
136

5
177
12
163

6
125
13
157

7
146
14
169


Develop a spreadsheet to answer the following questions.

•Calculate a forecast of the above demand using a 3- and 5-period moving average.
•Graph these forecasts and the original data using Excel. What does the graph show?
•Which of the above forecasts is best? Why?
Grading Criteria
% of grade for this assignment

Calculate a forecast of the above demand using a 3- and 5-period moving average.
30%

Graph these forecasts and the original data using Excel. What does the graph show?
20%

Which of the above forecasts is best? Why?
30%

APA citation and references
5%

Part 2 = to 1 page with 5 refrences different from part 1.
Details:
Use a library, corporate Web sites, and other online resources to locate a firm that incorporates the fixed order quantity system, fixed order period system, or a hybrid system to its management of inventory.
•Identify the type of inventory system it uses.
•Indicate the type of inventory issues the firm has such as stock out costs, carrying costs, order quantity issues, safety stock, and EOQ issue.
•In your opinion, is its system appropriate for the firm’s business?