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...
icon
Related questions
Question
  1. Develop a quantitative forecast model for Jacob. Which modeling technique did you choose, and why? What are the assumptions behind your model?
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
Transcribed Image Text: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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Forecasting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.