Question

In: Statistics and Probability

Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to...

Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total:

Glibber Gems

Blubber Bricks

Total Units Available

Slime Units

1

2

14

Tran Units

3

4

36

Gorilla Mucus Units

9

6

90

The unit profits for each Glibber Gem and Blubber Brick are each $5.

Please program the linear programming model using Excel's "Solver (Please check "Make Unconstrained Variables Non-Negative")

By how much could the unit profit of Glibber Gems increase, before the optimum solution changes?

Solutions

Expert Solution

The parameters and solver output is:

The formulas are:

The profit is $55.


Related Solutions

Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total: Glibber Gems Blubber Bricks Total Units Available Slime Units 1 2 14 Tran Units 3 4 36 Gorilla Mucus...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total: Glibber Gems Blubber Bricks Total Units Available Slime Units 1 2 14 Tran Units 3 4 36 Gorilla Mucus...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total: Glibber Gems Blubber Bricks Total Units Available Slime Units 1 2 14 Tran Units 3 4 36 Gorilla Mucus...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to...
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total: Glibber Gems Blubber Bricks Total Units Available Slime Units 1 2 14 Tran Units 3 4 36 Gorilla Mucus...
G. G. Gems, Inc. Background Glenna Gibbons received a Bachelor's Degree in Elementary Education with a...
G. G. Gems, Inc. Background Glenna Gibbons received a Bachelor's Degree in Elementary Education with a minor in early childhood education and music. She taught kindergarten in Northern Virginia. Later she moved to San Diego to get a Master's Degree in Elementary Education from U.S. International University in San Diego. While in San Diego, she worked for the National Steel and Shipbuilding Company as a facilities administrator during the day and went to school at night. She was in charge...
1. Tommy's Toys produces two types of toys: trains and dolls. Tommy's uses stainless steel to...
1. Tommy's Toys produces two types of toys: trains and dolls. Tommy's uses stainless steel to manufacture the trains and plastic to manufacture the dolls. Information regarding the usage of steel and plastic for the past year follows: Product Names Steel Plastic Direct materials information Standard pounds per unit 2 lb. 1.0 lb. Standard Price (SP) per pound $3.00 ? Actual Quantity (AQ) used per unit 3.0 lb. 3.00 lb. Actual Price (AP) paid for material $1.75 $2.25 Actual Quantity...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s operations in March follows: a. Raw materials were issued for use in production: Molding Department, $29,400; and Firing Department, $4,500. b. Direct labor costs were incurred: Molding Department, $18,900; and Firing Department, $5,100. c. Manufacturing overhead was applied: Molding Department, $22,200; and Firing Department, $36,800. d. Unfired, molded bricks were transferred from the Molding Department to the Firing Department. According to the company's process...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s operations in March follows: Raw materials used in production: Molding Department, $26,900; and Firing Department, $4,000. Direct labor costs incurred: Molding Department, $17,000; and Firing Department, $4,500. Manufacturing overhead was applied: Molding Department, $22,200; and Firing Department, $36,300. Unfired, molded bricks were transferred from the Molding Department to the Firing Department. According to the company’s process costing system, the cost of the unfired, molded...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s operations in March follows: a. Raw materials were issued for use in production: Molding Department, $23,000; and Firing Department, $8,000. b. Direct labor costs were incurred: Molding Department, $12,000; and Firing Department, $7,000. c. Manufacturing overhead was applied: Molding Department, $25,000; and Firing Department, $37,000. d. Unfired, molded bricks were transferred from the Molding Department to the Firing Department. According to the company's process...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s...
Quality Brick Company produces bricks in two processing departments—Molding and Firing. Information relating to the company’s operations in March follows: Raw materials used in production: Molding Department, $26,100; and Firing Department, $4,300. Direct labor costs incurred: Molding Department, $19,900; and Firing Department, $4,700. Manufacturing overhead was applied: Molding Department, $23,100; and Firing Department, $36,200. Unfired, molded bricks were transferred from the Molding Department to the Firing Department. According to the company’s process costing system, the cost of the unfired, molded...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT