Two years ago, Top-Slice Company moved from just making golf balls to also producing oversized drivers. Top-Slice makes three different models: the Bomber, the Hook King, and the Sir Slice-A-Lot. As the names suggest, the last two clubs help correct for golfers who either hook or slice the ball when driving. While Top-Slice is pleased with the growing sales for all three models (see the following tables), the numbers present Jacob Lee, the production manager, with a dilemma. Jacob knows that the current manufacturing work cell is capable of producing only 2,700 drivers per month, and total sales seem to be rapidly approaching that number. Jacob's staff has told him it will take at least three months to plan for and implement an expanded work cell. MONTH BOMBER ноок KING SIR SLICE-A-LOT April 2017 1,410 377 343 May 1,417 381 344 June 1,434 387 346 July 1,452 391 349 August 1,466 396 350 September 1,483 400 352 October 1,490 403 354 November 1,505 409 357 December 1,521 412 359 January 2018 1,536 420 363 February 1,547 423 365 March 1,554 426 367 April 1,562 431 369 May 1,574 437 371 June 1,587 441 375 July 1,595 445 377 August 1,613 454 381 September 1,631 461 384 October 1,642 464 386 November 1,656 471 389 December 1,673 477 392 January 2019 1,685 480 394 February 1,703 485 396 March 1,720 490 399
Two years ago, Top-Slice Company moved from just making golf balls to also producing oversized drivers. Top-Slice makes three different models: the Bomber, the Hook King, and the Sir Slice-A-Lot. As the names suggest, the last two clubs help correct for golfers who either hook or slice the ball when driving. While Top-Slice is pleased with the growing sales for all three models (see the following tables), the numbers present Jacob Lee, the production manager, with a dilemma. Jacob knows that the current manufacturing work cell is capable of producing only 2,700 drivers per month, and total sales seem to be rapidly approaching that number. Jacob's staff has told him it will take at least three months to plan for and implement an expanded work cell. MONTH BOMBER ноок KING SIR SLICE-A-LOT April 2017 1,410 377 343 May 1,417 381 344 June 1,434 387 346 July 1,452 391 349 August 1,466 396 350 September 1,483 400 352 October 1,490 403 354 November 1,505 409 357 December 1,521 412 359 January 2018 1,536 420 363 February 1,547 423 365 March 1,554 426 367 April 1,562 431 369 May 1,574 437 371 June 1,587 441 375 July 1,595 445 377 August 1,613 454 381 September 1,631 461 384 October 1,642 464 386 November 1,656 471 389 December 1,673 477 392 January 2019 1,685 480 394 February 1,703 485 396 March 1,720 490 399
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
- Develop a quantitative
forecast model for Jacob. Which modeling technique did you choose, and why? What are the assumptions behind your model?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.