The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown. Model Production Costs Labor Requirements (hours) Current Inventory Manufacturing Assembly Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Only integer amounts of bicycles can be produced. (a) Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. men's model in month 1        bicycleswomen's model in month 1        bicyclesmen's model in month 2        bicycleswomen's model in month 2        bicyclesTotal Cost$       What inventories will be maintained? Inventory Schedulemen's model in month 1        bicycleswomen's model in month 1        bicyclesmen's model in month 2        bicycleswomen's model in month 2        bicycles What are the monthly labor requirements? previous month hrsmonth 1 hrsmonth 2 hrs (b) If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? men's model in month 1        bicycleswomen's model in month 1        bicyclesmen's model in month 2        bicycleswomen's model in month 2        bicyclesTotal Cost$       How much will the cost increase? $

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 46P
icon
Related questions
icon
Concept explainers
Topic Video
Question
A linear programming computer package is needed.
The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown.
Model Production Costs Labor Requirements (hours) Current Inventory
Manufacturing Assembly
Men's $120 2.0 1.5 20
Women's $90 1.6 1.0 30
Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Only integer amounts of bicycles can be produced.
(a)
Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements.
men's model in month 1
 
 
 
 bicycleswomen's model in month 1
 
 
 
 bicyclesmen's model in month 2
 
 
 
 bicycleswomen's model in month 2
 
 
 
 bicyclesTotal Cost$
 
 
 
What inventories will be maintained?
Inventory Schedulemen's model in month 1
 
 
 
 bicycleswomen's model in month 1
 
 
 
 bicyclesmen's model in month 2
 
 
 
 bicycleswomen's model in month 2
 
 
 
 bicycles
What are the monthly labor requirements?
previous month hrsmonth 1 hrsmonth 2 hrs
(b)
If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule?
men's model in month 1
 
 
 
 bicycleswomen's model in month 1
 
 
 
 bicyclesmen's model in month 2
 
 
 
 bicycleswomen's model in month 2
 
 
 
 bicyclesTotal Cost$
 
 
 
How much will the cost increase?
 
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 10 images

Blurred answer
Knowledge Booster
Inventory management
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,
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