You are running a hospital in Zwedru, Liberia. The food for the patients is provided for by the Earth Food Program (EFP). Every month you must place an order with the EFP for the food that youll need the coming month. You place your order on the 1^st of every month, and the EFP delivers it on the same day. You always order one months worth of food (assume a month has 30 days) so that it will last until the 1^st of the next month.

Create a tool that takes as inputs:

1.The average daily number of people

2.A persons required daily food by meal

3.Your current stock by food type

4.Bag sizes

and returns the amount of each type of food to order in number of bags. On the exam, I will ask you to put different inputs in (the required food per person per meal, the number of people, how much stock you have, etc.) and write out the outputs.

What you know is the following:

1.How many people you expect to have on average every day in the hospital in the coming month.

2.The different types of required foods (Cereals, CSB, Pulses, Oil, Sugar).

3.How much of each food each person needs for every meal, in grams:

Breakfast
CSB	80
Oil	20
Sugar	30
Lunch
Cereals	75
Pulses	100.0
Oil	10
Dinner
CSB	10
Oil	10
Sugar	5

4.The size of the bags:

5.How much stock you have of each food type in your warehouse in kilograms.

6.Constants such as the number of days in a month (assume 30), the number of grams in a kilogram, etc.

Hints

1.The better (more flexible) a tool you develop, the faster you will be able to answer the questions I ask

2.Think about the structure of the model in Excel before you start typing (i.e., the way I give you the data may not be the best way to create a model in Excel)

3.To validate your model, if there are 100 patients, then given the following in-stock amounts, you should order the following amounts in kg:

4.Use the previous amounts (100 patients, the above food requirements per meal, and the in-stock amounts of 200, 100, 500, 50, and 75 respectively) to initialize your model.

Bring the model to class initialized with these values.

50 kg/bag 50 kg/bag 25 kg/bag 10 kg/bag 100 kg/ba;g