The Silver Star Bicycle Company will be manufacturing both men’s and women’s models of 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 170 men’s and 145 women’s models to be shipped during the first month and 210 men’s and 160 women’s models to be shipped during the second month. Additional data are shown: Production Labor Requirements (hours) Current Model Costs Manufacturing Assembly Inventory Men's $170 1.9 1.6 30 Women's $140 1.7 0.9 40 Last month the company used a total of 1000 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 35 units of each model in inventory at the end of the two months.
Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained, and what are the monthly labor requirements?
If required, round your answers to the nearest whole number. If an amount is zero, enter "0"
Production schedule:
The optimal solution is to produce _____ of the men's model in month 1, ______ of the men's model in month 2, _______ units of the women's model in month 1, and ______ of the women's model in month
2. Total Cost = $ _____
Inventory Schedule
Month 1 ____Men's _____Women's
Month 2 ____Men's _____Women's
Labor Levels
Previous month ______ hours
Month 1 ______ hours
Month 2 _______ hours
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? If required, round your answers to the nearest whole number.
Production schedule:
The optimal solution is to produce _____ of the men's model in month 1, _____ of the men's model in month 2, ____ units of the women's model in month 1, and _____of the women's model in month 2.
Total Cost = $____
How much will the cost increase? $ ____
What would you recommend?
Labour hours per unit of men's model = manufacturing hours per unit + assembly hours per unit
= 2.2 + 1.3 = 3.5 hrs per unit
Labour hours per unit of women's model = manufacturing hours per unit + assembly hours per unit
= 1.5 + 1.1 = 2.6 hrs per unit
Minimize: Total production costs + Total inventory costs
= Production cost per unit*(Men's model produced in months 1 & 2) + 2%*production costs*(Men's model inventory in months 1 & 2) + Production cost per unit*(Women's model produced in months 1 & 2) + 2%*production costs*(Women's model inventory in months 1 & 2)
= 120*(x11 + x12) + 2.40*(y11 + y12) + 90*(x21 + x22) + 1.80*(y21 + y22)
Constraints:
1). 20 + x11 - y11 = 150 or x11 - y11 = 130 (Demand for men's model in month 1)
2). 30 + x21 - y21 = 125 or x 21 - y11 = 95 (Demand for women's model in month 1)
3). y11 + x12 - y12 = 220 (Demand for men's model in month 2)
4). y21 + x22 -y22 = 170 (Demand for women's model in month 2)
5). y12 >= 25 (inventory in month 2 has to be at least 25 units)
6). y22 >= 25 (inventory in month 2 has to be at least 25 units)
7). 3.50*x11 + 2.60*x21 <= 1100 (labour hours constraint for month 1)
8). 3.50*x11 + 2.60*x21 >= 900 (labour hours constraint for month 2)
9). 3.50*x11 + 2.60*x21 - 3.50*x12 - 2.60*x22 <= 100 (difference in labor hours has to be at most 100)
10). 3.50*x11 + 2.60*x21 - 3.50*x12 - 2.60*x22 >= -100 (difference in labor hours has to be at most 100)
11). x11, x12, x21, x22, y11, y12, y21, y22 >= 0
Solving this LP, we get:
Number of models produced
Month 1 Month 2
Men 210 165
Women 95 195
Inventory
Month 1 Month 2
Men 80 25
Women - 25
Labor hours:
Month 1 Month 2
Men hours 736.25 576.25
Women hours 247.00 507.00
Total labor hours 983.25 1,083.25
Total cost = 71,398
b). Change the hours constraints to 50:
7). 3.50*x11 + 2.60*x21 <= 1050 (labour hours constraint for month 1)
8). 3.50*x11 + 2.60*x21 >= 950 (labour hours constraint for month 2)
9). 3.50*x11 + 2.60*x21 - 3.50*x12 - 2.60*x22 <= 50 (difference in labor hours has to be at most 50)
10). 3.50*x11 + 2.60*x21 - 3.50*x12 - 2.60*x22 >= -50 (difference in labor hours has to be at most 50)
Solving this, we get:
Number of models produced
Month 1 Month 2
Men 218 158
Women 95 195
Inventory (Sij)
Month 1 Month 2
Men 88 25
Women - 25
Labor hours:
Month 1 Month 2
Men hours 761.25 551.25
Women hours 247.00 507.00
Total labour hours 1,008.25 1,058.25
Total cost = 71,415
Cost increases by 71,415 - 71,398 = 17
The Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal...
Problem 4-19 (Algorithmic) The Silver Star Bicycle Company will be manufacturing both men’s and women’s models of 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 220 men’s and 170 women’s models to be shipped during the second month. Additional data...
The Silver Star Bicycle Company will manufacture both men's and women's models for its Easy-Pedal 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: Labor Requirements (hours)...
The Silver Star Bicycle Company will manufacture both men's and women's models for its Easy-Pedal 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: Labor Requirements (hours)...
please answer all of B and my answers for
part A are correct.
The Silver Star Bicycle Company will be manufacturing both men's and women's models of 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 210 men's and 160 women's...
Please help and show work for all steps! Everything marked with
a red X is incorrect.
Problem 4-19 (Algorithmic) The Silver Star Bicycle Company will be manufacturing both men's and women's models of 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 160 men's and 135 women's models to be shipped during the first month...
Aside from selling yarn skeins, the Yarn Barn also plans to sell men’s and women’s hand-knit scarves during the next 2 months. The company wants to develop a production schedule indicating how many scarves of each type should be produced each month. Current demand forecasts show that 150 men’s and 125 women’s scarves are needed during the first month and 200 men’s and 150 women’s scarves are needed for the second month. Additional data are shown in Figure 2: Labour...
Benson Boot Co. sells men’s, women’s, and children’s boots. For
each type of boot sold, it operates a separate department that has
its own manager. The manager of the men’s department has a sales
staff of nine employees, the manager of the women’s department has
six employees, and the manager of the children’s department has
three employees. All departments are housed in a single store. In
recent years, the children’s department has operated at a net loss
and is expected...
The Boilermakers is a manufacturing company that uses gear assemblies to produce four different models of mountain bikes. One of these gear assemblies, the "Smooth Shifter," is used for the two most expensive models, and has an estimated annual demand of 540 units. The Boilermakers estimates the cost to place an order is $100, and the holding cost for each assembly is $10 per month. a) Currently, not knowing about EOQ, the purchasing manager places an order for the Smooth...
The New England Cycle Company is planning next month’s production of its two bicycles: its B2 tandem cycle built for two and its S10 single-rider 10-speed model. Both models use the same seats and tires. Management has been informed that 2000 seats, 1000 gear assemblies (only the S10 requires a gear assembly), and 2400 tires are available next month for production. On the average, it takes two hours to produce a B2 and three hours to produce a S10 bicycle....
Also please solve by either using excel or R LP solvers
The Magnetron Company manufactures and markets microwave ovens. Currently, the company produces two models: full-size and compact. Production is limited by the amount of labor available in the general assembly and electronic assembly departments, as well as by the demand for each model. Each full-size oven requires 2 hours of general assembly and 2 hours of electronic assembly, whereas each compact oven requires 1 hour of general assembly and...