Problem 3-5 (Algo) Best Bicycles manufactures three different types of bikes: the Tiny Tike, the Adult Aero, and the Mountain Monger. Assume that Best Bicycles operates two shifts, each with 1,750 hours per year. Bike Tiny Tike Adult Aero Mountain Monger Demand Forecast Processing Time (minutes/unit) 29.3 23.8 15.3 (units/year) 45,630 44,800 24,800 Lot Size (of bikes) 26 20 32 Setup Time (minates/setup) 52 82 48 PictureClick here for the Excel Data File PLEASE NOTE: The Excel file shows the column C values for Processing time rounded to a whole minute. You'll get the answer wrong if you use this rounded value. In Excel, select cells C3 to CS and on the Home ribbon, in the Number section, click the Increase Decimal button. Calculate the required capacity for this year's production. Note that the times are given for assembly lines, so capacity calculations should be in terms of the number of lines necessary. (Round up your answer to the next whole number.)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
icon
Related questions
Question
Problem 3-5 (Algo)
Best Bicycles manufactures three different types of bikes: the Tiny Tike, the Adult Aero, and the Mountain Monger. Assume that Best
Bicycles operates two shifts, each with 1,750 hours per year.
Bike
Tiny Tike
Adult Aero
Mountain Monger
Demand Porecast Processing Time
(minutes/unit)
29.3
23.8
15.3
(units/year)
45,630
44,800
24,800
Lot Size
(# of bikes)
26
26
32
Setup Time
(minutes/setup)
52
82
48
pictureClick here for the Excel Data File
PLEASE NOTE: The Excel file shows the column C values for Processing time rounded to a whole minute. You'll get the answer wrong
If you use this rounded value. In Excel, select cells C3 to CS and on the Home ribbon, in the Number section, click the Increase
Decimal button.
Calculate the required capacity for this year's production. Note that the times are given for assembly lines, so capacity calculations
should be in terms of the number of lines necessary. (Round up your answer to the next whole number.)
Number of assembly lines
Transcribed Image Text:Problem 3-5 (Algo) Best Bicycles manufactures three different types of bikes: the Tiny Tike, the Adult Aero, and the Mountain Monger. Assume that Best Bicycles operates two shifts, each with 1,750 hours per year. Bike Tiny Tike Adult Aero Mountain Monger Demand Porecast Processing Time (minutes/unit) 29.3 23.8 15.3 (units/year) 45,630 44,800 24,800 Lot Size (# of bikes) 26 26 32 Setup Time (minutes/setup) 52 82 48 pictureClick here for the Excel Data File PLEASE NOTE: The Excel file shows the column C values for Processing time rounded to a whole minute. You'll get the answer wrong If you use this rounded value. In Excel, select cells C3 to CS and on the Home ribbon, in the Number section, click the Increase Decimal button. Calculate the required capacity for this year's production. Note that the times are given for assembly lines, so capacity calculations should be in terms of the number of lines necessary. (Round up your answer to the next whole number.) Number of assembly lines
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
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,