Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
SEE MORE TEXTBOOKS