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

Solution about losing a rental book, I have a question about losing a renta...

I have a question about losing a rental book. One of my rental textbook: legal Management environmental MGMT330 has been lost. I want to ask how I can do for this textbook. Do I ha

Calculate the expected value of perfect information, Clay Why bark, a soft-...

Clay Why bark, a soft-drink vendor at Hard Rock Cafe%u2019s annual Rockfest, created a table of conditional values for the various alternatives (stocking decision) and states of na

Write the facultyids of faculty who are not qualified, Using the following ...

Using the following tables (primary keys are underlined), write the expressions that follow in SQL. STUDENT (StudentID, StudentName) FACULTY(FacultyID, FacultyName) COURSE(CourseID

Explain organization predict the short and long- term future, How do organi...

How do organization predict the short and long- term future? Explain in detail how a downturn in the economy affects not-for- profit organizations, as opposed to for-profit ones.

Explain flight reservations and vacation packages, Which strategy does this...

Which strategy does this exemplify? Kayak and Orbitz provide their customers with a variety of travel options including flight reservations, vacation packages, flight and hotel opt

Why user should be involved design of the database, We are agree that the u...

We are agree that the user should be involved in the design of the database. Class, how would you go about the process of designing a database? What processes are involved? And ple

Explain what you anticipate managing from a transition, What you anticipate...

What you anticipate 'managing" from a transition perspective to comply with this law

Describe the difference between trait-oriented appraisals, Describe the dif...

Describe the difference between trait-oriented and results-oriented performance appraisal instruments, identifying some of the instruments used in each case.

Modern global business environment, Describe briefly, major opportunities f...

Describe briefly, major opportunities for an organisation operating in a modern global business environment.   There are several significant opportunities for an organisation o

Describe assaults a waitress at a nearby restaurant, A company hires a file...

A company hires a file clerk but does not inquire into his criminal history. In fact, he has had several convictions for driving while intoxicated. On a lunch break, he gets drunk

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