Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Production Planning Forecast Accuracy Case As the head of the Demand Planning area, you have the following set of historical data for the last 3

Production Planning Forecast Accuracy Case As the head of the Demand Planning area, you have the following set of historical data for the last 3 months. The plant produces industrial chemicals for 3 business divisions: Solvents for the paint industry, Alcohols for plastic printing, and Corrosives (acids and bases for cleaning stainless steel tanks and pipes). Each division is managed by a different sales executive. The strategy that the company has defined is the quarterly assignment of a sales forecast, that is, the months of 1 quarter have the same sales estimate aligned with the company's sales objective. In the review of forecasts with the Commercial Director, you must propose new forecasts and support your response with data. Which seller makes the best forecasts? Consider the comment of each one of the sales executives and offer confirmation arguments or, on the contrary, question them.

image text in transcribed

((A good handwriting would be appreciated, thank you.))

It is done with forecasts and that is all the information provided

Category Product xylene toluene Solvent Benzene Ethanol Alcohols methanol Caustic soda Acids & Hydrochloric Bases acid Sulfuric acid Monthly Forecast Royal Sale Month 1 Month Month Month al 3 3 2,000 3,500 2,800 3,200 2,500 2,800 2,500 2,900 1,000 900 1,100 1,200 8,000 5,500 6,000 5,800 600 500 400 500 20,000 23,000 27,000 21,500 5,000 2,400 2,000 4,200 5,000 3,500 2,300 3,800 Monthly Forecast Month 4 al 6 4,000 3,200 1,500 8,000 600 30,000 4,500 4,500 Justification "I am the seller who makes the best sales forecasts. They cannot stop me from selling, I need to increase the estimates to be able to sell more" "I have to close the gap in the annual alcohol sales plan. I earn by commission and I need to sell more, not like you who always pay your full salary" "I need to increase sales by 50%, every month I exceed the estimate" "If I don't sell hydrochloric, I sell sulfuric and vice versa, but I always meet the volume" Category Product xylene toluene Solvent Benzene Ethanol Alcohols methanol Caustic soda Acids & Hydrochloric Bases acid Sulfuric acid Monthly Forecast Royal Sale Month 1 Month Month Month al 3 3 2,000 3,500 2,800 3,200 2,500 2,800 2,500 2,900 1,000 900 1,100 1,200 8,000 5,500 6,000 5,800 600 500 400 500 20,000 23,000 27,000 21,500 5,000 2,400 2,000 4,200 5,000 3,500 2,300 3,800 Monthly Forecast Month 4 al 6 4,000 3,200 1,500 8,000 600 30,000 4,500 4,500 Justification "I am the seller who makes the best sales forecasts. They cannot stop me from selling, I need to increase the estimates to be able to sell more" "I have to close the gap in the annual alcohol sales plan. I earn by commission and I need to sell more, not like you who always pay your full salary" "I need to increase sales by 50%, every month I exceed the estimate" "If I don't sell hydrochloric, I sell sulfuric and vice versa, but I always meet the volume

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Fiduciary Finance Investment Funds And The Crisis In Financial Markets

Authors: Martin Gold

1st Edition

1848448953, 9781848448957

More Books

Students also viewed these Finance questions