Question

In: Operations Management

A company manufactures mountain bikes, hybrid bikes and road bikes. Each bicycle passes through three departments:...

A company manufactures mountain bikes, hybrid bikes and road bikes. Each bicycle passes through three departments: fabrication, painting, and final assembly. The total labor hours available for fabrication are 100, for painting are 120 and for final assembly are 140. The labor requirements and profit are given in the following table.

Type

Fabrication (hr)

Painting (hr)

Assembly (hr)

Profit ($)

Mountain

3

5

3

90

Hybrid

4

2

7

110

Road

3

6

3

70

  1. Formulate the linear programming model (be sure to state what the variables stand for.

  1. How many bicycles of each type should the company make to maximize its profit (record your answer to the nearest whole number)? What is the maximum profit?


  1. Find the sensitivity ranges for the three constraint amounts.

Solutions

Expert Solution

Following information given in the question :-

(1) available Labour hours for Fabrication:-100

(2) available Labor hours for Painting:- 120

(3) available hours for Assembly:- 140

Data table provided

Type Fabrication hr Painting Hr Assembly Hr Profit ($)
Mountain 3 5 3

90

Hybrid 4 2 7

110

Road 3 6 3

70

Decision Variables :- Maximum profit depended upon total no of cycles made in available hrs

(1) X1 = Total no cycle made of Montain

(2) X2 = Total no of cycles made of Hybrid

(3) X3 = Total no cycles made of Road

Objective Function :-

let Z be the maximum profit; Z = 90X1 +110 X2 + 70 X3

For maximizing the profit we have to utilize maximum labor hrs.

Constraints :-

From the given data table it is clear that

hrs has taken to manufacture one cycle * total no of cycles = Total available hrs.

Therefore ;

3X1+4X2+3X3=100 -----(1)

5X1+2X2+6X3 =120------(2)

3X1+7X2+3X3 =70------ (3)

Now Solving the above three equations using determinants or linear method we can find the values of X1 , X2 , X3 as

X1 = 10 , X2 =15 X3 = 23

Threfore maximum profit  

Z= 90 X1 + 110 X2 + 70 X3 =90 * 10 + 110* 15 + 70* 23 = 4160

Process of Solving above three equations:-

From (1) X1 = (100-4x2-3x3)/3

Putting the value of X1 in equations 2 we get an equation in X2 AND X3

14 X2- 3 X3=140 ---------------(4)

NOW putting value of x1 from equation 3 in equation 1 we directly get the value of X3 = 23

Similarly putting the value of X3 in equation 4 we get X2 = 15

And putting the values of X3 and X2 in equation 1 we get X1 =10


Related Solutions

Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has...
Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has hired you as an outside consultant. Peak Bikes currently has 170 both full-time and part-time employees. The firm’s management is organized as follows: Frontline managers: Oversee bike production and production staff. This is the part of the company that actually manufacturers the bicycles. Middle-level managers: Manage frontline managers, track performance versus company’s goals and strategy, and report to top level managers Top-level managers: Set...
Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in...
Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in western Canada. Below is a partial list of expense items incurred in the most recent month (November), when 1,180 bicycles were manufactured, shipped, and sold. There was no beginning or ending work in process or finished goods inventory in November:   Item October November   Units produced and sold 1,080 1,180   Sales $ 1,080,000 $ 1,180,000   Leather used for the bicycle seats 30,240 33,040   Production manager’s...
Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in...
Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in western Canada. Below is a partial list of expense items incurred in the most recent month (November), when 1,060 bicycles were manufactured, shipped, and sold. There was no beginning or ending work in process or finished goods inventory in November:   Item October November   Units produced and sold 960 1,060   Sales $ 960,000 $ 1,060,000   Leather used for the bicycle seats 34,560 38,160   Production manager’s...
Bianca Bicycle Company manufactures mountain bikes with a variable cost of $1,600. The bicycles sell for...
Bianca Bicycle Company manufactures mountain bikes with a variable cost of $1,600. The bicycles sell for $2,350 each. Budgeted fixed manufacturing overhead for the most recent year was $11,600,000. Planned and actual production for the year were the same. State whether income is higher under variable or absorption costing and the amount of the difference in reported opearting income under the two methods. Treat each condition as an independent case. (Round intermediate calculations to 2 decimal places.) 1. Production 22,600...
Michael’s Bicycles manufactures different types of bicycles: mountain, road, and youth. Sales of the road bikes...
Michael’s Bicycles manufactures different types of bicycles: mountain, road, and youth. Sales of the road bikes have fallen. The firm is considering two options: (1) drop the road bike line; or (2) replace the road bike line with fat tire bikes. Price and cost data are as follows: Mountain Road Youth Fat Tire Price/unit $400 $1200 $120 $600 Variable cost/unit $300 $600 $75 $400 Total Fixed costs $3,000,000 $2,500,000 $500,000 $1,000,000 Number of units 15,000 4,000 20,000 10,000 If the...
:Roan Bicycle Manufactures Mountain, BMX, and Hybrid bicycles. Sales and expense data for the past month...
:Roan Bicycle Manufactures Mountain, BMX, and Hybrid bicycles. Sales and expense data for the past month follow: Total Mountain Bicycle BMX Bicycle Hybrid Bicycle Revenue $ 880,000 $ 190,000 $430,000 $260,000 Variable expense 420,000 80,000 220,000 120,000 Contribution Margin 460,000 110,000 210,000 140,000 Fixed Expenses: Advertising-traceable 168,000 55,000       60,000 53,000 Depreciation of special equipment 85,000 25,000 30,000 30,000 Line Supervisors’ salaries 68,000 28,000 24,000 16,000 General Administrative overhead* 99,000 32,000 45,000 22,000 Total Fixed expenses 420,000 140,000 159,000 121,000...
SHU Bicycle Shop sells Mountain bikes, Dirt bikes and Leisure bikes. D. Shim, owner, aggregated the...
SHU Bicycle Shop sells Mountain bikes, Dirt bikes and Leisure bikes. D. Shim, owner, aggregated the following information with help of SHU Accounting Consulting Group: Product sales price purchase cost Mountain bike $1,500 $900 Dirt Bike $1,800 $800 Leisure Bike $800 $600 The shop anticipates selling 600 Mountain bikes, 250 Dirt bikes and 150 Leisure bikes. Monthly common fixed costs which can’t be separated to any product are $1,000,000 and income tax rate is 40%. Required) 1. What is unit...
Yosemite Bike Corp. manufactures mountain bikes and distributes them through retail outlets in California, Oregon, and...
Yosemite Bike Corp. manufactures mountain bikes and distributes them through retail outlets in California, Oregon, and Washington. Yosemite Bike Corp. has declared the following annual dividends over a six-year period ended December 31 of each year: Year 1, $24,000; Year 2, $10,000; Year 3, $126,000; Year 4, $100,000; Year 5, $125,000; and Year 6, $125,000. During the entire period, the outstanding stock of the company was composed of 25,000 shares of cumulative preferred 2% stock, $90 par, and 100,000 shares...
Yosemite Bike Corp. manufactures mountain bikes and distributes them through retail outlets in California, Oregon, and...
Yosemite Bike Corp. manufactures mountain bikes and distributes them through retail outlets in California, Oregon, and Washington. Yosemite Bike has declared the following annual dividends over a six-year period ended December 31 of each year: 20Y1, $24,250; 20Y2, $10,500; 20Y3, $112,750; 20Y4, $92,500; 20Y5, $112,500; and 20Y6, $142,500. During the entire period, the outstanding stock of the company was composed of 25,000 shares of cumulative preferred 2% stock, $85 par, and 100,000 shares of common stock, $4 par. Required: 1....
Dividends on Preferred and Common Stock Yosemite Bike Corp. manufactures mountain bikes and distributes them through...
Dividends on Preferred and Common Stock Yosemite Bike Corp. manufactures mountain bikes and distributes them through retail outlets in California, Oregon, and Washington. Yosemite Bike has declared the following annual dividends over a six-year period ended December 31 of each year: 20Y1, $24,750; 20Y2, $10,250; 20Y3, $105,000; 20Y4, $95,000; 20Y5, $115,000; and 20Y6, $130,000. During the entire period, the outstanding stock of the company was composed of 25,000 shares of cumulative preferred 2% stock, $80 par, and 100,000 shares of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT