Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Huck L. B. Finn Incorporated buys plastic resin by the ton and then packages and distributes it in smaller amounts to industrial users. The resin

Huck L. B. Finn Incorporated buys plastic resin by the ton and then packages and distributes it in smaller amounts to industrial users. The resin typically costs $50 per ton, and Finn uses 80,000 tons each year. Placing an order for more resin costs $500 in allocated labor cost for purchasing personnel. Holding costs for the resin are estimated at 1 percent of the product value each month. Finn operates 365 days a year.

Finn received offers from two different suppliers. Supplier 1 delivers each order in one shipment. Supplier 2, on the other hand is flexible enough to deliver one shipment per day, with each shipment covering two days worth of demand. There is also a capacity limit of Finns warehouse, which can store only 1500 tons of resin at a time.

Below, you can find the monthly demand data from 2021 until July of 2023:

Year 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021
Month 1 2 3 4 5 6 7 8 9 10 11 12
Demand (tons) 5771 7444 6240 5509 6277 6331 7300 5692 7099 5222 5916 5648
Year 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022
Month 1 2 3 4 5 6 7 8 9 10 11 12
Demand (tons) 6003 6211 7313 5449 5855 6628 6944 5375 5659 6699 5708 6040
Year 2023 2023 2023 2023 2023 2023 2023
Month 1 2 3 4 5 6 7
Demand (tons) 6855 6292 7098 5578 6233 5532 5149

Use an appropriate forecasting technique to update the demand data until December of 2024. Justify accuracy of your forecasting technique. (You need to try out at least two different forecasting techniques to be able to justify your chosen technique) !!PLEASE ANSWER SOMETHING ELSE THAN EXPONENTIAL SMOOTHING FORECASTING!!). What would be an appropriate inventory management strategy for Finn Incorporated based on the updated demand for the next year (in terms of order quantity and Re-order point)? State your assumptions as part of your recommendations to management.

Evaluation criteria (Max marks 10):

  • Excel skills (8 marks): You are expected to use Excel for calculation and analysis. This may involve using statistics and analysis functions, implementation of formulas, plotting graphs, etc.

8 marks will be provided if a student submits the Excel file with all the functions, analysis, and graphs. An Excel file with randomized demand data is provided along with this assignment paper.

Copy and paste it to your own Excel file using Paste in number format to work with fixed numbers.

  • Recommendation (2 marks): Based on your data analysis, and comparison of approaches, you may provide your recommendation. Your recommendation should also include exploring more advanced or additional techniques in the future, collecting additional data, additional information, etc.

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

Understanding And Managing Public Organizations

Authors: Hal G. Rainey

4th Edition

047040292X, 978-0470402924

More Books

Students also viewed these General Management questions