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 months 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...
Brightstone Tire and Rubber Company has capacity to produce 176,500 tires. Brightstone presently produces and sells...
Brightstone Tire and Rubber Company has capacity to produce
176,500 tires. Brightstone presently produces and sells 131,600
tires for the North American market at a price of $190 per tire.
Brightstone is evaluating a special order from a European
automobile company, Euro Motors. Euro is offering to buy 15,100
tires for $115.30 per tire. Brightstone’s accounting system
indicates that the total cost per tire is as follows:
Direct materials
$55
Direct labor
24
Factory overhead (57% variable)
23
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
_________
________...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A)Given a generic array with ‘n’ items (not only integers). Give a solution for checking whether...
- Explain virtualization as a key technology in cloud computing environments, as well as the purpose of...
- A system is set up to take raw grading information from the console and calculate a...
- I have an 8 by 8 array that has values ranging from 1-64. I am wanting...
- The background information and instruction of the question is provided below, and i only asked for...
- Which business or industry sectors have the most startups companies that consider a small and medium...
- 16. Cost of trade credit Firms usually offer their customers some form of trade credit. This...
ADVERTISEMENT