Material Requirement Planning for a Four-Week Party (MRP)

This assignment presents a material requirement plan (MRP) for a party with 50 guests, scheduled to occur in four weeks. The plan focuses on providing sandwiches, snacks, and soft drinks. The solution details the gross and net material requirements for each week, considering on-hand inventory and the need for weekly shopping. Calculations are based on recipes that serve four, scaled up for the party size, and include assumptions such as zero lead time and weekly shopping constraints. The plan covers various items like sandwiches, biscuits, nuts, corn, oatmeal, cheese, assorted sodas, fruit juice, milk, and yogurt. The assignment includes an Excel spreadsheet for the computations and references relevant sources.

Surname 1
Student’s Name
Professor’s Name
Course
Date
Material Requirement Planning
Introduction
The plan is to hold a party in the next four weeks, and 50 guests are expected. The guest will
feast on sandwiches, snacks, and soft drinks. The host has some of the required materials for
preparation in the house. Still, there is a need to outsource for more through shopping; the
following tables and calculations show the planning of material needed for each of the three
edibles to be consumed at the party.
Material Requirements for Sandwiches, Snacks, drinks
Sandwich Snacks Drinks
(4 serves)
1. Two * 250g pieces
of steak
2. 4 garlic cloves
3. Thyme
4. 6 tablespoons
olive oil
5. 1 sourdough bread
1. Biscuits
2. Nuts
3. Popcorns
4. Oatmeal
5. Cottage cheese
1. Coca colas sodas
(Assorted)
2. Fruit juice
3. Milk
4. Yogurt

Surname 2
6. 1 slices beefsteak
tomato
7. 6 leaves Cos
lettuce
8. 50g cocktail
gherkin
9. 1 tablespoon of
capers
10. 1 bunch flat leave
parsley
11. 7 tablespoons
mayonnaise
12. Worcestershire
sauce
13. 4 shakes of
tobacco sauce
14. 1 red onion
(121 Easy & Delicious Healthy Snacks in 2020 For Every Type of Snacker; Ainsworth
and Plunkett)
The requirements for the sandwich are extracted from a recipe that serves four, so every
requirement is to be multiplied by 50/4 to get the required volume/amount. In the interest of
expenditure, sandwiches will be orders from a nearby fast food store. All the calculations have

Surname 3
assumed a zero-lead time. Given the nature of the situation, it’s a one-time occasion, not a
continuous production process. The material requirement plan is calculated as the shopping that
the cost needs to do to fill up the requirements for the guests. The planning will consider that the
host will still be using some of the resources during the preparation period.
The plan assumes that on some of the days prior to the party week, some preparations will be
done, and the persons responsible for the preparation will have to be catered for.
Other assumptions
1. The host already has all the utensils required.
2. There is no constant daily consumption at the party venue.
3. The host can only shop on a weekly basis.
4. There are no running schedules; inventory on hand is not recharged within the week.
Material Requirements Planning for Typical party planned to occur four
weeks from the planning date with 50 attendees who will feed on
sandwiches snacks and soft drinks.
Sandwiches Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 0 2 7 70
Projected on hand 1 1 0 0 10
Net requirements 9 11 17 80
Biscuits (Packets) Week1 Week 2 Week 3 Week 4
S
S

Surname 4
Gross Requirements 2 6 10 70
Projected on hand 15 13 7 3 10
Net requirements 0 3 13 77
Nuts (Kgs) Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 0.5 0.3 0 8
Projected on hand 7 6.5 6.2 6.2 10
Net requirements 3.5 3.8 3.8 11.8
Corn (Kgs) Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 0 1 0 12
Projected on hand 2 2 1 0 10
Net requirements 8 9 9 22
Oatmeal (Serves) Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 6 3 0 70
Projected on hand 25 19 16 16 10
Net requirements 0 0 0 64
Cheese (Serves) Week1 Week 2 Week 3 Week 4
S
S

Surname 5
Gross Requirements 1 4 2 70
Projected on hand 27 26 24 22 10
Net requirements 0 0 0 58
Assorted soda Bottles Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 0 0 4 70
Projected on hand 9 9 9 5 10
Net requirements 1 1 5 75
Fruit Juice (Ltrs) Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 0.5 0.1 0.5 29
Projected on hand 10 9.5 9.4 8.9 10
Net requirements 0.5 0.6 1.1 30.1
Milk (Litres) Week1 Week 2 Week 3 Week 4
S
S
Gross Requirements 1 1 1.5 37
Projected on hand 0 0 0 0 10
Net requirements 11 11 11.5 47
Yogurt (Litres) Week1 Week 2 Week 3 Week 4
S
S

Surname 6
Gross Requirements 0.5 1 0.4 15
Projected on hand 0 0 0 0 10
Net requirements 10.5 11 10.4 25
(Mula, Poler, and Garcia-Sabater; Tersine and Termine)
The computations were obtained using an excel program; the spreadsheet is attached herein.
1246283.xlsx

Surname 7
Works Cited
121 Easy & Delicious Healthy Snacks in 2020 For Every Type of Snacker. 2020. 07 April 2020.
<https://snacknation.com/blog/guide/healthy-snacks/>.
Ainsworth, P., and A. Plunkett. "Snack Food." Reducing Salt in Foods (n.d.).
Mula, Josefa, Raul Poler, and Jose Pedro Garcia-Sabater. "Material Requirement Planning with
fuzzy constraints and fuzzy coefficients." Fuzzy Sets and Systems (2010).
Ramsay, Gordon. Tripple Decker Steak Sandwich. 2020. 07 April 2020. <bbcgoodfood.com>.
Tersine, Richard J, and Richard J Tersine. "Principles of inventory and materials management."
(n.d.).