Question
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.
((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 volumeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started