Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

SALES & OPERATIONAL PLANNING Your company is undertaking its monthly S&OP process. This is a 4 weeks exercise. As part of the Demand Planning Department

SALES & OPERATIONAL PLANNING

Your company is undertaking its monthly S&OP process. This is a 4 weeks exercise.

As part of the Demand Planning Department you are to review the Supply/Demand schedules prior to the Executive S&OP meeting which occurs in week 4.

Your team is to establish all of the necessary DATA to convince the Executive Team that your Demand Planning numbers are to be used by the organization.

The time horizon for your plan is 90 days. The meeting will occur on March

29 th. 2021 and the start of production is July 1st 2021.

Your product is shipped all across Canada, and sold to the consumers thru several retailers ( WMT, LCL, CTC, HD, COSTCO etc..)

You will create a shipment plan based on the population distribution across Canada.

Your production plan is based on your market share. Market share is calculated as a percentage of the total Canadian population.

You must state a forecasted number for your product and how this will be achieved the manufacturing capacity. Make sure that you add the promotional sale quantity to your forecasted number. This forcasted number is your qualitative/quantative forecast.

The promotional date for the item across Canada is July 10th - a Saturday.

You must also show a plan reflecting the transportation schedule that will be executed to have your promotional products on shelf across Canada on the same sales day.

Your product, market share and promo data are as follows:

GROUP #

PRODUCT/ITEM

MARKET SHARE

PROMOTION (pcs or each)

1

Chick peas canned 16 ozs.

21%

1,300,000 tins

2

Pasta 900 grms

7%

500,000 packs

3

Mango Juice 1 litre Tetra pak

30%

7,520,000 pcs.

4

Cooking oil 1 litre

12%

125,000 bottles

5

Bleach 3 litre bottles

18%

800,000 bottles

6

Tooth paste 82 ml tubes

9%

800,00 tubes

7

Peanut Butter 1n lb. bottles

30%

7,780,000 bottles

8

32 roll packs bathroom tissue

24%

1,520,000 packs

9

1 liter bottle carbonated water

16%

900,000 bottles

10

Wire-O cereals 2 lb boxes

40%

6,320,000 boxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

978-1259307416

Students also viewed these Accounting questions