Question

In: Finance

Problem 4-19 (Algorithmic) The Silver Star Bicycle Company will be manufacturing both men’s and women’s models...

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 are shown:

Production Labor Requirements (hours) Current
Model Costs Manufacturing Assembly Inventory
Men's $120 2.2 1.3 20
Women's $90 1.5 1.1 30

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 25 units of each model in inventory at the end of the two months.

  1. 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.

    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
  2. 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?

    $ ___________

Solutions

Expert Solution

Decision variables:

x11 = number of men's model produced in month 1

x21 = number of women's model produced in month 1

x12 = number of men's model produced in month 2

x22 = number of women's model produced in month 2

y11 = inventory of men's model at the end of month 1

y12 = inventory of women's model at the end of month 1

y12 = inventory of men's model at the end of month 2

y22 = inventory of women's model at the end of month 2

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


Related Solutions

Scandia Coat Company makes women’s and men’s coats. Both products require filler and lining material. The...
Scandia Coat Company makes women’s and men’s coats. Both products require filler and lining material. The following planning information has been made available: Standard Quantity Women’s Coats Men’s Coats Standard Price per Unit Filler 2.5 lbs. 4.0 lbs. $1.25 Liner 6.0 yds. 8.5 yds. 6.50 Standard labor time 0.30 hr. 0.45 hr. Planned production 4,500 units 5,000 units Standard labor rate $13.40 per hr. $14.80 per hr. Scandia Coat does not expect there to be any beginning or ending inventories...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018: Account                                                           Dr                                         Cr                Cash                                                $   43,200                Accounts Receivable                        $     9,000                Raw Materials Inventory (1)              $    20,240                Work in Process Inv. (2)                    $            0                Finished Goods Inv. (3)                    $     8,100                Land                                                  $ 225,000                Equipment                                        $ 310,000                Vehicles                                             $   84,200...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018:             Account                                               Dr                                Cr             Cash                                                     $   43,200             Accounts Receivable                            $     9,000             Raw Materials Inventory (1)                  $    20,240             Work in Process Inv. (2)                         $            0             Finished Goods Inv. (3)                          $     8,100             Land                                                     $ 225,000             Equipment                                           $ 310,000             Vehicles                                              ...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January...
Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018:        Account                      Dr                 Cr        Cash                                   $   43,200        Accounts Receivable                 $     9,000        Raw Materials Inventory (1)       $    20,240        Work in Process Inv. (2)                     $            0        Finished Goods Inv. (3)               $     8,100        Land                                   $ 225,000        Equipment                         $ 310,000       ...
Vans is a manufacturer of women’s and men’s swimsuits. The company uses a dual-rate system to...
Vans is a manufacturer of women’s and men’s swimsuits. The company uses a dual-rate system to allocate support costs. Last year’s support departments’ fixed and variable costs are as follows: Human Accounting Resources Janitorial Total Variable costs $ 18,420 $ 22,104 $ 60,360 $ 100,884 Fixed costs 55,260 100,696 60,360 216,316 Total costs $ 73,680 $ 122,800 $ 120,720 $ 317,200 Allocation base amounts for all the departments are as follows: Human Accounting Resources Janitorial Women's Men's Total Employees 2...
Pyre Mills, Inc. is a large producer of men’s and women’s clothing. The company uses a...
Pyre Mills, Inc. is a large producer of men’s and women’s clothing. The company uses a standard costing system. The standard costs and actual costs per unit for one of the company’s products are as follows: Direct material: Standard: 4.0 metres at $5.40 per metre Actual: 4.4 metres at $5.05 per metre Direct Labour: Standard: 1.6 hours at $6.75 per hour Actual: 1.4 hours at $7.30 per hour During this period, the company produced 4,800 units of the product. At...
Baby its Cold Outside Inc. makes women’s and men’s overcoats. Both products require filler and lining...
Baby its Cold Outside Inc. makes women’s and men’s overcoats. Both products require filler and lining material. The following planning information has been made available: Standard Amounts                Women’s Coats          Men’s Coats       Standard Price per unit Filler               2.2 lbs/coat       3.5 lbs/coat       $1.00 per lb. Liner               5.5 yds./coat       8.0 yds./coat       $6.50 Standard labor time       0.30 hrs   /coat       0.40 hrs/coat Standard labor rate      ...
Haliburton Mills Inc. is a large producer of men’s and women’s clothing. The company uses standard...
Haliburton Mills Inc. is a large producer of men’s and women’s clothing. The company uses standard costs for all of its products. The standard costs and actual costs for a recent period are given below for one of the company’s product lines (per unit of product): Standard Cost Actual Cost   Direct materials:      Standard: 2.0 metres at $3.90 per metre $ 7.80      Actual: 2.4 metres at $3.65 per metre $ 8.76   Direct labour:     Standard: 1.5 hours at $2.50 per hour 3.75...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $13 $10 2 $15 $12 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However,...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $10 $14 $10 2 $12 $12 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT