Reference no: EM13961924
Work-force planning
All-Basa, Inc., produces two models of bookcases, for which relevant data are summarized as follows:
Bookcase 1
- Selling Price $15
- Labor Required 0.75 hour/unit
- Bottleneck machine time required 1.5 hours/unit
- Raw Material Required 2 bf/unit
Bookcase 2
- Selling Price $8
- Labor Required 0.5 hour/unit
- Bottleneck machine time required 0.8 hours/unit
- Raw Material Required 1 bf/unit
Each week, up to 400 board feet (bf) or raw material (RM) is available at a cost $1.50/bf. The company employs four workers, who work 40 hours per week for a total regular-time labor supply of 160 hours per week. They work regardless of production volumes, so that their salaries are treated as fixed costs. There are 320 hours per week available on the bottleneck machine.
In the absence of advertising, 50 units per week of bookcase 1 and 60 units of bookcase 2 will be demanded. Advertising can be used to stimulate the demand for each product. Experience shows that each dollar spent on advertising bookcase 1 increases demand for bookcase 1 by 10 units, while each dollar spent on advertising bookcase 2 increases demand for bookcase 2 by 15 units. At most $100 per week can be spent on advertising.
Formulate a LP program (not integer programming) to maximize the profit and determine how much of each product (P1 and P2) to produce each week, how much raw material (RM) to buy, how much overtime to use (OT), and how much advertising to buy for each product (A1 and A2). You must use the notation given in the parenthesis for each variable.
a) What is the maximum profit value?
b) If overtime costs only $4/hour (and all other parameters unchanged), how much overtime should All-Bala use?
c) If each unit of bookcase 1 sold for $15.50 (and all other parameters unchanged), what will the optimal profit per week be?
d) What is the most All-Bala should be willing to pay for another unit of raw material?
e) If each worker were required to work 45 hours per week (and all other parameters unchanged), what would the company's profit be?
f) If each unit of bookcase 2 sold for $10 (and all other parameters unchanged), what would be the optimal quantity of bookcase 2 to produce.
|
How much force necessary to maintain uniform motion upward
: A weight of 30lb rests on an inclined plane 3 ft high and 5 ft long. a force F making an angle of 30° with the plane pulls the body upward. If the coefficient of friction is 0.20, how much force is necessary to maintain uniform motion upward?
|
|
Solve the model with excel solver
: Assume that x and y can be positive or negative (URE can either consume or supply labor and capital), formulate the model and solve it with Excel Solver. Try different starting points (initial values in the changing cells).
|
|
Solve the linear programming model
: For the following problem, solve the linear programming model by using the computer. You must use QM for Windows to solve this problem. Please include the original problem plus results screen in the Word document you create. Follow the format of t..
|
|
What the probability that bob will arrive earlier than john
: Bob and John are traveling from city A to city D. Bob decides to take the upper route (through B) whereas John takes the lower route, What is the probability that John will not arrive in city D within ten hours? What is the probability that Bob will..
|
|
Determining the work-force planning
: Work-force planning All-Basa, Inc., produces two models of bookcases, for which relevant data are summarized as follows:
|
|
What is the net force applying to the box
: Imagine a book on the horizontal surface. without motion (at rest). Gravity force pushing the book down with force 10 N, but the book is remaining on the surface without motion (at rest). What is the Net Force applying to the box?
|
|
Generate the most profit
: Angela and Bob Ray keep a large garden in which they grow cabbage, tomatoes, and onions to make two kinds of relish - chow-chow and tomato. The chow-chow is made primarily of cabbage, whereas the tomato relish has more tomatoes than does the chow-..
|
|
Explain static determinancy in detail
: The attached diagrams show a rectangular plate held by joints defined by pins and links.
|
|
What mass would have to be suspended
: An organic pipe that is closed at one end has a length of 0.80 m. At 20 degrees Celsius, what is the distance between a node and an adjacent antinode for (a) the second harmonic and (b) third harmonic?
|