The forecasting department, traditionally reporting to the sale manager, has historically seen aforecast accuracy of about 60%, and this in turn causes problems for the following departments:...

1 answer below »

The forecasting department, traditionally reporting to the sale manager, has historically seen aforecast accuracy of about 60%, and this in turn causes problems for the following departments:



  • Purchasing: What should we buy and how much?

  • Production: What should we really build?

  • Inventory management: We keep building the wrong thing.


The sales manager asked you to write her a memo, specifically addressing the following:





  • How could yousuggest that your new system would achieve any better levels of forecast accuracy?

  • Why is forecast accuracy itself not as important under traditional methods?

  • Create a chart or timeline that includes all of the following:

    • Which purchase orders have to be placed, and when

    • When manufacturing needs to begin, to have products delivered to a customer

    • Approximate dates for all of the following:

      • When the product must be shipped to meet the customer's due date

      • When the application of the cover and packaging must take place to meet the customer's due date

      • When the manufacturing of the widget must begin and end

      • When the raw material for the widget must be ordered

      • When the plastic cover must be ordered

      • When the cardboard box must be ordered



    • Includes notes explain your timing calculation

    • Assumes all of the following conditions:

      • The factory has two departments: manufacturing and packaging

      • Product X consists of 3 components

        • a widget manufactured in the factory with a total manufacturing lead time of 1 week

        • a plastic cover purchased from vendor A with a procurement lead time of 3 weeks

        • a cardboard shipping box purchased from vendor B with a procurement lead time of 4 weeks



      • The widget itself is made from steel (whose lead time from vendor C is 4 weeks).

      • It takes 1 day for the cover to be applied to the product and for the product to be inserted in the box in the packaging department.

      • The shipping time to this customer is in 3 weeks, and you do not want it to be late or early.

      • Assume you received the customer order on 1/1/20XX.

      • Ignore any holidays

      • Assume a 5-day work week

      • The customer requires the product to arrive at his location on 3/31/2011





Answered Same DayDec 23, 2021

Answer To: The forecasting department, traditionally reporting to the sale manager, has historically seen...

Robert answered on Dec 23 2021
124 Votes
To: Sales Manager
From: Production planner
Date: 31/1/20XX
Subject: Aggregate plan and Master Production Schedule for Product X
We have been facing challenges i
n aggregate and sales planning for our product as our supply
and demand varies to a great extent. Due to variation in forecast and demand of the product we
fail in offering our product at right place, right time and right price. This has resulted in
diminishing market share.
In order to eradicate this problem we have come up with a forecasting technique which will
reduce the error gap in forecast and demand. We will be now following web based forecasting:
Collaborative Planning, Forecasting and Replenishment (CPFR) which will allow us to integrate
our suppliers, distributors and retailers also. CPFR will take inputs directly from front end
(customers) and synchronize production, procurement and distribution accordingly. Selected
information from customer will be sent to stakeholders through web based server and allow all of
them to plan accordingly. CPFR will use cyclic approach to drive forecasts and develop a long
term relationship within the supply chain. This will help us in eradicating bullwhip effect where
we were working in silos and generating forecast only for our organization.
Front end agreement will be signed between the stakeholders to collaborate on reducing
inventories, lost sale elimination etc. Followed by joint business planning will cement
relationship and identifying sequence and frequency of planning activities. Developing a demand
forecast in collaboration will allow mitigating risk of holding high inventories and efficient
handling of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here