Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mr. Kinsley has provided the previous four years of sales data: # of Table # of # of # of Month Sold Month Table Month
Mr. Kinsley has provided the previous four years of sales data: # of Table # of # of # of Month Sold Month Table Month Table Month Table Month # of Table Sold Sold Sold Sold Jun. 2018 40 Jun. 2019 60 Jun. 2020 115 Jun. 2021 125 Jun. 2022 Jul. 2018 35 Jul. 2019 55 Jul. 2020 125 Jul. 2021 120 Jul. 2022 Aug. 2018 30 Aug. 2019 50 Aug. 2020 105 Aug. 2021 110 Aug. 2022 Sep. 2018 30 Sep. 2019 50 Sep. 2020 100 Sep. 2021 110 Sep. 2022 Oct. 2018 35 Oct. 2019 45 Oct. 2020 90 Oct. 2021 95 Oct. 2022 Nov. 2018 35 Nov. 2019 45 Nov. 2020 85 Nov. 2021 90 Nov. 2022 Dec. 2018 30 Dec. 2019 35 Dec. 2020 75 Dec. 2021 85 Dec. 2022 Jan. 2019 30 Jan. 2020 35 Jan. 2021 75 Jan. 2022 90 Jan. 2023 Feb. 2019 40 Feb. 2020 50 Feb. 2021 95 Feb. 2022 100 Feb. 2023 Mar. 2019 50 Mar. 2020 55 Mar. 2021 110 Mar. 2022 115 Mar. 2023 Apr. 2019 55 Apr. 2020 75 Apr. 2021 125 Apr. 2022 130 Apr. 2023 May. 2019 60 May. 2020 100 May. 2021 130 May. 2022 135 May. 2023 Use the data provided to make a forecast for the next 12 months. Show your work below and provide an explanation of your forecasts/methods in your summary and recommendations. Use your forecast to determine your required capacity for the next 12 months. Mr. Kinsley has provided you a table that shows all of the tasks involved in manufacturing a table in his facility: Task That Must Precede Task Task Time Description (minutes) A 20 Rough cut of table top and legs B 15 Sanding of table top C 25 Sanding of legs D 20 Detailing of table top E 30 Detailing of legs F 25 G 20 H 10 Attaching hardware to table top Attaching hardware to legs Attaching leg protectors to legs 1 25 Final assembly of table 60 Applying stain to entire table *The facility operates 20 days a month and for 7.5 hours a day. Precedence Diagram: Cycle Time Required to Meet Forecasted Demand: # of Workstations/Employees Required and Tasks Assigned to Each: Overall Predicted Utilization (next 12 months): A A B C D E G F, H
Step 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