Question
In: Operations Management
Gatson manufacturing company produces 2 types of tires: Economy tire; Premium tire. The manufacturing time and...
Gatson manufacturing company produces 2 types of tires: Economy tire; Premium tire. The manufacturing time and the profit contribution per tire are given in the following table.
|
Operation |
Manufacturing Time (Hours) |
Time Available |
|
|
Economy tires |
Premium tires |
Hours |
|
| Material Preparation |
4/3 |
1/2 |
600 |
| Tire Building |
4/5 |
1 |
650 |
| Curing |
1/2 |
2/4 |
580 |
| Final Inspection |
1/5 |
1/3 |
120 |
| Profit/Tire |
$12 |
$10 |
|
Answer the following assuming that the company is interested in maximizing the total profit contribution.
a. Develop a spreadsheet model and find the optimal solution using Excel Solver. What is the total profit contribution Gatson can earn with the optimal production quantities? Enter your answer without a dollar sign and rounded to two decimal places.
b. Based on your answer to Question 1, how many Economy tires should Gatson manufacture to maximize profit contribution? Round your answer to one decimal place.
c. Based on your answer to Question 1, how many Premium tires should Gatson manufacture to maximize profit contribution? Round your answer to one decimal place.
Solutions
Expert Solution
a.
Let,
E = number of economy tires to produce
P = number of premium tires to produce
objective is to maximize profit = Max 12E+10P
subject to,
4E/3+P/2 <= 600
or, 8E+3P <= 3600 (Material preparation)
4E/5+P <= 650
or, 4E+5P <= 3250 (Tire building)
E/2+2P/4 <= 580
or, 2E+2P <= 2320 (Curing)
E/5+P/3 <= 120 (Final inspection)
or, 3E+5P <= 1800
E,P >= 0
Solving in solver we get,
Total maximized profit contribution = 6038.709677 = 6038.71 (Rounded to 2 decimal places)
Solver screenshot
Solver formula
Solver window
b.
number of economy tires to produce to maximize profit contribution = 406.4516129 = 406.45(Rounded to 2 decimal places)
c.
number of premium tires to produce to maximize profit contribution = 116.1290323 = 116.13 (Rounded to 2 decimal places)
keosha answered 2 weeks agoRelated Solutions
Gatson manufacturing company produces 2 types of tires: Economy tire; Premium tire. The manufacturing time and...
Gatson manufacturing
company produces 2 types of tires: Economy tire; Premium tire. The
manufacturing time and the profit contribution per tire are given
in the following table.
Operation
Manufacturing
Time (Hours)
Time
Available
Economy
tires
Premium
tires
Hours
Material
Preparation
4/3
1/2
600
Tire Building
4/5
1
650
Curing
1/2
2/4
580
Final Inspection
1/5
1/3
120
Profit/Tire
$12
$10
Answer the following
assuming that the company is interested in maximizing the total
profit contribution.
Let E =
number...
Talladega Tire and Rubber Company has capacity to produce 162,000 tires. Talladega presently produces and sells...
Talladega Tire and
Rubber Company has capacity to produce 162,000 tires. Talladega
presently produces and sells 124,000 tires for the North American
market at a price of $115 per tire. Talladega is evaluating a
special order from a European automobile company, Autobahn Motors.
Autobahn is offering to buy 19,000 tires for $97.85 per tire.
Talladega’s accounting system indicates that the total cost per
tire is as follows:
Direct materials
$44
Direct labor
16
Factory overhead (70% variable)
26
Selling and...
.Tire manufacturer is interested in testing the fuel economy for two different tread patterns. Tires of...
.Tire manufacturer is interested in testing the fuel economy for
two different tread patterns. Tires of each tread type were driven
for 1000 miles on each of 9 different cars. The mileages, in miles
per gallon, were as follows. Test whether the mean mileage is the
same for both types of tread. (ANOVA test)
Car
1
2
3
4
5
6
7
8
9
Tread A
24.7
22.5
24.0
26.9
22.5
23.5
22.7
19.7
27.5
Tread B
20.3
19.0
22.5...
A tire manufacturer is interested in testing the fuel economy for two different tread patterns. Tires...
A tire manufacturer is interested in testing the fuel economy
for two different tread patterns. Tires of each tread type were
driven for 1000 miles on each of 9
different cars. The mileages, in miles per gallon, were as
follows:
Car
Tread A
Tread B
1
24.7
20.4
2
22.6
19.0
3
23.9
22.4
4
26.8
23.0
5
22.4
20.8
6
23.4
23.5
7
22.6
21.3
8
19.7
18.1
9
27.3
25.8
(a) Construct an 80% confidence interval for the...
A tire manufacturer produces tires that have a mean life of at least 25000 miles when...
A tire manufacturer produces tires that have a mean life of at
least 25000 miles when the production process is working properly.
The operations manager stops the production process if there is
evidence that the mean tire life is below 25000 miles.
The testable hypotheses in this situation are
?0:?=25000H0:μ=25000 vs ??:?<25000HA:μ<25000.
1. Identify the consequences of making a Type I error.
A. The manager does not stop production when it is
not necessary.
B. The manager stops production when...
A tire manufacturer produces tires that have a mean life of at least 32500 miles when...
A tire manufacturer produces tires that have a mean life of at
least 32500 miles when the production process is working properly.
The operations manager stops the production process if there is
evidence that the mean tire life is below 32500 miles.
The testable hypotheses in this situation are
?0:?=32500H0:μ=32500 vs ??:?<32500HA:μ<32500.
1. Identify the consequences of making a Type I error.
A. The manager stops production when it is
necessary.
B. The manager stops production when it is not...
A tire manufacturer produces tires that have a mean life of at least 30000 miles when...
A tire manufacturer produces tires that have a mean life of at
least 30000 miles when the production process is working properly.
The operations manager stops the production process if there is
evidence that the mean tire life is below 30000 miles. The testable
hypotheses in this situation are ?0:?=30000 H 0 : μ = 30000 vs
??:?<30000 H A : μ < 30000 .
1. Identify the consequences of making a Type I error. A. The
manager does not...
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...
The Grilton Tire Company manufactures racing tires for bicycles.
Grilton sells tires for $50 each. Grilton is planning for next year
(2020) by developing a master budget by quarters. Grilton’s balance
sheet for December 31, 2019 follows:
GRILTON TIRE COMPANY
Balance Sheet
December 31, 2019
Assets
Current Assets:
Cash $ 39,000
Accounts
Receivable 40,000
Raw Materials
Inventory 2,400
Finished Goods
Inventory 8,700
Total Current
Assets $
90,100
Property, Plant and Equipment:
Equipment 177,000
Less: Accumulated
Depreciation (42,000) 135,000
Total
Assets $225,100
Liabilities
Current Liabilities:
Accounts
Payable $ 8,000
Stockholder’s Equity
Common Stock,...
The Gessing Tire Company manufactures racing tires for bicycles. Gessing sells tires for $85 each. Gessing...
The Gessing Tire Company manufactures racing tires for bicycles.
Gessing sells tires for $85 each. Gessing is planning for the next
year by developing a master budget by quarters. Gessing’s balance
sheet for December 31, 2018, follows:
Gessing Tire Company| Balance sheet |December 31, 2018
Current Assets:
Cash
$
52,000
Accounts Receivable
35,000
Raw Materials Inventory 1,900
Finished Goods Inventory 2,400
________
Total Current Assets
$
91,300
Property, Plant, and Equipment:
Equipment
142,000
Less: Accumulated Depreciation (50,000)
92,000
_________
________...
The Gessing Tire Company manufactures racing tires for bicycles. Gessing sells tires for $85 each. Gessing...
The
Gessing Tire Company manufactures racing tires for bicycles.
Gessing sells tires for $85 each. Gessing is planning for the next
year by developing a master budget by quarters. Gessing’s balance
sheet for December 31, 2018, follows:
Gessing Tire Company
Balance sheet
December 31, 2018
Current
Assets:
Cash
$
52,000
Accounts Receivable
35,000
Raw Materials Inventory 1,900
Finished Goods Inventory 2,400
________
Total Current Assets
$
91,300
Property, Plant, and Equipment:
Equipment
142,000
Less: Accumulated Depreciation (50,000)
92,000
_________
________...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Public policy can be seen as the result of “complex negotiations” between contesting groups, while others...
- A saturated, aqueous solution of a salt having the formula, AX3, is prepared. The equilibrium that...
- What might be some disadvantages of acqui-hiring? As a manager, how would you draw up a...
- A monopolist faces 300 customers divided into 3 different groups: 1. High-Demand customers each have a...
- You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door...
- You are given the following information: Stockholders' equity as reported on the firm’s balance sheet =...
- You are the manager of a U.S. company situated in Los Angeles and manages the import/export...
ADVERTISEMENT