Compute forecasted sales, Operation Management

Assignment Help:

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what would be the quantities that would need amendment as far as Distribution Manager is concerned to service for week two and onwards? After week one the actual sales to Forecasted sales for week one ratio is as under: Mumbai did 80 % of forecast , Lucknow did 75 % of forecast Kolkata did 60 % of week one forecast Chennai did 125 % of forecast and Delhi did 150 % of week one forecast Note : Kolkata will receive transit stocks in week 2 . The Table datas are as follows....... Mumbai: Op Bal = 120, safety Stk = 60, Min Ord Qty = 80, Lead Time = 1 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,35,55,65,80,125 & 50 Respectively. Chennai: Op Bal = 350, safety Stk = 125, Min Ord Qty = 200, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 100,75,125,100,200,150 & 100 Respectively. Lucknow: Op Bal = 270, safety Stk = 150, Min Ord Qty = 200, Lead Time = 3 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 150,100,150,200,300,200 & 100 Respectively. Delhi: Op Bal = 250, safety Stk = 100, Min Ord Qty = 100, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,75,80,55,75,80 & 90 Respectively. Kolkata: Op Bal = 350, safety Stk = 200, Min Ord Qty = 300, Lead Time = 3 Week, Transit = 300, Sales Forecast Week 1 to Week 7 = 100,150,200,135,125,165 & 200 Respectively


Related Discussions:- Compute forecasted sales

Explain the overall strategy, Put yourself in the position of an entreprene...

Put yourself in the position of an entrepreneur who is developing a new product to introduce into the market. Briefly describe the product. Then develop the segmentation, targeting

Explain what type of human resource strategy did lenovo, Overview: This cas...

Overview: This case explores the mission to become a major player in the global personal computer industry. Lenovo acquired IBM%u2019s personal computer division in 2004 to become

Depict diagram a complex system, Diagram a complex system (a series of caus...

Diagram a complex system (a series of causal loops and their interconnections) for the ecosystem of your choice (desert, rainforest, tidal marsh, etc.).

Explain what is the current capacity flow chart for cpc, Define the product...

Define the product you will be offering at College Pretzel Company (CPC) in detail. Create any necessary documentation such as an engineering drawing or a bill of material for the

Explain supply base innovation and risk management, Why are supply base inn...

Why are supply base innovation and risk management two future areas that will consume more of the supply manager's day?

Define the coordinate of potential sites for hospital, Suppose a new hospit...

Suppose a new hospital is to be built to provide emergenct medical healthcare service to 5 town w coordinates (5,6), (1,3), 13,7), (11,2), (18,1) on a map. The exisiting transporta

500, find the optimal location for kilroy"s distribution center in this exp...

find the optimal location for kilroy"s distribution center in this expanded version of the problem

Find gross domestic product is accounted for by logistics, What percent of ...

What percent of North American gross domestic product is accounted for by logistics? Almost 11 percent Almost 22 percent Almost 33 percent Almost 44 percent Flingers

What is the distinction between prediction and forecasting, Question 1: ...

Question 1: Show the nature and importance of the four logistics-related elements of customer service. Question 2: (a) Describe the concept of supply chain management.

Explain the internal and external environments, Describe the internal and e...

Describe the internal and external environments of 2 real world companies using an environmental scan. What competitive advantages does each company have and what strategies are ea

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd