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

Analyze on the price of heating oil, Question For the financial year 20...

Question For the financial year 2012-2013, it has been decided the equalization of the tax on heating oil with the tax on fuel, thus increasing the price of heating oil. Do you

Explain what would be your total cost, A manufacturing firm is considering ...

A manufacturing firm is considering two locations for a plant to produce a new product. The two locations have fixed and variable costs as follows: Site Fixed Cost (Annual) Variabl

Explain organizational culture regarding staffing decisions, What is the re...

What is the relationship between the business strategy and an entity's organizational culture regarding staffing decisions? Is it possible to strengthen one without the other?

Explain fishbone diagram conflict, Activity Instructions There are two part...

Activity Instructions There are two parts to this assignment. Part 1: Revise the previous flowchart you created based on any new or different information you gleaned during the las

South African activists promise massive protest at World Cup, identify the ...

identify the material requirement lacking and its cause

Explain supplementary unemployment benefit plans, Analyze the benefits of S...

Analyze the benefits of Supplementary Unemployment Benefit Plans, and list potential scenarios when they become quite vulnerable. Address service requirements, duration, benefit fo

How to choose the most qualified suppliers and strategies, Use at least one...

Use at least one project you have been a team member of, or a project manager for, as an example to contextualize the research topics below: All of the following topics must be

Explain why has globalization become so important, What specific challenges...

What specific challenges P&G and Colgate-Palmolive face, and why has globalization become so important to them?

Explain the utilization and the efficiency of each situation, Determine the...

Determine the utilization and the efficiency for each of these situations: a. A loan processing operation that processes an average of 7 loans per day. The operation has a design c

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