Question
In: Operations Management
As a supervisor of a production department, you must decide the daily production totals of a...
As a supervisor of a production department, you must decide the daily production totals of a certain product that has two models, the Deluxe and the Special. The profit on the Deluxe model is $12 per unit and the Special's profit is $10. Each model goes through two phases in the production process, and there are only 100 hours available daily at the construction stage and only 80 hours available at the finishing and inspection stage. Each Deluxe model requires 20 minutes of construction time and 10 minutes of finishing and inspection time. Each Special model requires 15 minutes of construction time and 15 minutes of finishing and inspection time.
a) Write the LP model
b) Solve the model with Solver in excel
Solutions
keosha answered 6 months agoRelated Solutions
As a supervisor of a production department, you must decide the daily production totals of a...
As a supervisor of a production department, you must decide the
daily production totals of a certain product that has two models,
the Deluxe and the Special. The profit on the Deluxe model is $12
per unit and the Special's profit is $10. Each model goes through
two phases in the production process, and there are only 100 hours
available daily at the construction stage and only 80 hours
available at the finishing and inspection stage. Each Deluxe model
requires...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year:
Niland Company
Machining Department
Monthly Production Budget
Wages
$912,000
Utilities
56,000
Depreciation
92,000
Total
$1,060,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
January
$1,000,000
93,000
February
948,000
84,000
March
908,000
76,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year:
Niland Company
Machining Department
Monthly Production Budget
Wages
$515,000
Utilities
38,000
Depreciation
63,000
Total
$616,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
January
$582,000
126,000
February
553,000
114,000
March
530,000
103,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Hagerstown Company agreed to the following monthly static...
The production supervisor of the Machining Department for
Hagerstown Company agreed to the following monthly static budget
for the upcoming year:
Hagerstown Company
Machining Department
Monthly Production Budget
Wages
$863,000
Utilities
65,000
Depreciation
108,000
Total
$1,036,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
May
$979,000
99,000
June
935,000
90,000
July
893,000
81,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year:
Niland Company
Machining Department
Monthly Production Budget
Wages
$310,000
Utilities
17,000
Depreciation
28,000
Total
$355,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
January
$334,000
71,000
February
316,000
64,000
March
303,000
58,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Hagerstown Company agreed to the following monthly static...
The production supervisor of the Machining Department for
Hagerstown Company agreed to the following monthly static budget
for the upcoming year:
Hagerstown Company
Machining Department
Monthly Production Budget
Wages
$514,000
Utilities
36,000
Depreciation
61,000
Total
$611,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
May
$577,000
111,000
June
552,000
101,000
July
527,000
91,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year:
Niland Company
Machining Department
Monthly Production Budget
Wages
$964,000
Utilities
62,000
Depreciation
103,000
Total
$1,129,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
January
$1,065,000
104,000
February
1,011,000
94,000
March
968,000
85,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year: Niland Company Machining Department Monthly
Production Budget Wages $1,001,000 Utilities 50,000 Depreciation
84,000 Total $1,135,000 The actual amount spent and the actual
units produced in the first three months in the Machining
Department were as follows: Amount Spent Units Produced January
$1,069,000 102,000 February 1,021,000 93,000 March 974,000 84,000
The Machining Department supervisor has been very pleased with this...
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static...
The production supervisor of the Machining Department for Niland
Company agreed to the following monthly static budget for the
upcoming year:
Niland Company
Machining Department
Monthly Production Budget
Wages
$576,000
Utilities
26,000
Depreciation
44,000
Total
$646,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
January
$608,000
96,000
February
583,000
88,000
March
553,000
79,000
The Machining Department supervisor has been very pleased with
this...
The production supervisor of the Machining Department for Hagerstown Company agreed to the following monthly static...
The production supervisor of the Machining Department for
Hagerstown Company agreed to the following monthly static budget
for the upcoming year:
Hagerstown Company
Machining Department
Monthly Production Budget
Wages
$310,000
Utilities
15,000
Depreciation
26,000
Total
$351,000
The actual amount spent and the actual units produced in the
first three months in the Machining Department were as follows:
Amount Spent
Units Produced
May
$331,000
71,000
June
312,000
64,000
July
299,000
58,000
The Machining Department supervisor has been very pleased with
this...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Suppose Rialto is the only movie cinema in a small college town, so it is essentially...
- With VMI, members of the supply chain share planning, demand, forecasting, and inventory information.
- Large lots are desirable in supply chain coordination despite increasing holding costs.
- ***Convert the C++ to Python*** #include <iostream> using std::cout; using std::cin; using std::endl; int charClass; char...
- Make-or-Buy Decision Fremont Computer Company has been purchasing carrying cases for its portable computers at a...
- The following costs were incurred for the single product produced during the first year of operations...
- Non-constant growth model: Do=$2.00 required return on equity= 5% g= 9% n=1,2 g=7% n=3,4 g=3% n=5...
ADVERTISEMENT