Solve The Following LP Problem without using excel
Without using excel:
A company which manufactures canoes employs 120 employees, each of whom working 30 hours per week. Half of them work in the carpenter department, 20 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit € 7 and the luxury canoes with corresponding profit € 10. A simple canoe requires 4.5 hours in the carpenter department and two hours in each of the other two departments. The working hours for each luxury canoe are 5, 1 and 4 at the carpenter department, plastics department and completion department respectively. Marketing calculations have shown that not less than 1/3 and not more than 2/3 of the total number of the canoes should be luxurious. How will the company maximize its overall net profit?
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Solve the following LP problem using the Solver in MS Excel. A company which manufactures canoes...
Solve the following LP problem using the Solver in MS Excel. A company which manufactures canoes employs 120 employees, each of whom working 30 hours per week. Half of them work in the carpenter department, 20 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit € 7 and the luxury canoes with corresponding profit € 10. A simple canoe requires 4.5 hours in the carpenter...
a company which manufactures canoes employs 150 I. A company which manufactures canoes employs 150 employees, each of whom working 35 hours per week. Half of them work in the carpenter d...
a company which manufactures canoes employs 150
I. A company which manufactures canoes employs 150 employees, each of whom working 35 hours per week. Half of them work in the carpenter department, 50 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit 8 and the luxury canoes with corresponding profit 10. A simple canoe requires 5 hours in the carpenter department and two hours in...
a company which manufactures canoes employs 150 I. A company which manufactures canoes employs 150 employees,...
a company which manufactures canoes employs 150
I. A company which manufactures canoes employs 150 employees, each of whom working 35 hours per week. Half of them work in the carpenter department, 50 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit 8 and the luxury canoes with corresponding profit 10. A simple canoe requires 5 hours in the carpenter department and two hours in...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...
pla solve the problem step by step using excel., pla describe in detail 44. Mega-Mart, a...
pla solve the problem step by step using excel., pla describe
in detail
44. Mega-Mart, a discount store chain, is to build a new store in Rock Springs. The parcel of land the company has purchased is large enough to accommodate a store with 140,000 square feet of floor space. Based on marketing and demographic surveys of the area and historical data from its other stores, Mega-Mart estimates its annual profit per square foot for each of the store's departments...
Formulate the LP Problem, but do NOT solve: A furniture manufacturer makes armchairs and benches. The...
Formulate the LP Problem, but do NOT solve: A furniture manufacturer makes armchairs and benches. The company has a maximum of 200 labor hours available in the Cutting Department, a maximum of 480 labor hours available in the Finishing Department, and a maximum of 150 labor hours available in the Packaging Department. Each armchair requires two hours in the Cutting Department, four hours in the Finishing Department and one hour in the Packaging Department. Each bench requires one hour in...
Formulate but do not solve the following exercise as a linear programming problem A company manufactures...
Formulate but do not solve the following exercise as a linear programming problem A company manufactures x units of product A, y units of product, and units of product C Each product is processed in three departments: I, I, and TIL The total available labor hours per week for Departments I, II, and I are 920, 2000, and 310, respectively. The time requirements in hours per unit and profit per unit for each product are as follows. Product Product Product...
Use the following information to answer the following question(s), using the SUMPRODUCT function. Stone Age Surfboards...
Use the following information to answer the following question(s), using the SUMPRODUCT function. Stone Age Surfboards is a small manufacturer of two types of popular high-tide surfboards, the Rockwell and the Limestone models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 15 skilled workers, each of whom works 5 hours per day. The finishing department has 5 workers, who also work a 5-hour shift. Each pair of Rockwell surfboards requires 3 labor hours in...
Please solve using solver in excel, screenshots appreciated!! Product Mix Homework Problem Furnco manufactures desks an...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks! Product Mix Homework Problem Furnco manufactures desks and chairs. Each des...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
a company which manufactures canoes employs 150
I. A company which manufactures canoes employs 150 employees, each of whom working 35 hours per week. Half of them work in the carpenter department, 50 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit 8 and the luxury canoes with corresponding profit 10. A simple canoe requires 5 hours in the carpenter department and two hours in...
a company which manufactures canoes employs 150
I. A company which manufactures canoes employs 150 employees, each of whom working 35 hours per week. Half of them work in the carpenter department, 50 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit 8 and the luxury canoes with corresponding profit 10. A simple canoe requires 5 hours in the carpenter department and two hours in...
pla solve the problem step by step using excel., pla describe
in detail
44. Mega-Mart, a discount store chain, is to build a new store in Rock Springs. The parcel of land the company has purchased is large enough to accommodate a store with 140,000 square feet of floor space. Based on marketing and demographic surveys of the area and historical data from its other stores, Mega-Mart estimates its annual profit per square foot for each of the store's departments...
Formulate the LP Problem, but do NOT solve: A furniture manufacturer makes armchairs and benches. The company has a maximum of 200 labor hours available in the Cutting Department, a maximum of 480 labor hours available in the Finishing Department, and a maximum of 150 labor hours available in the Packaging Department. Each armchair requires two hours in the Cutting Department, four hours in the Finishing Department and one hour in the Packaging Department. Each bench requires one hour in...
Formulate but do not solve the following exercise as a linear programming problem A company manufactures x units of product A, y units of product, and units of product C Each product is processed in three departments: I, I, and TIL The total available labor hours per week for Departments I, II, and I are 920, 2000, and 310, respectively. The time requirements in hours per unit and profit per unit for each product are as follows. Product Product Product...
Use the following information to answer the following question(s), using the SUMPRODUCT function. Stone Age Surfboards is a small manufacturer of two types of popular high-tide surfboards, the Rockwell and the Limestone models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 15 skilled workers, each of whom works 5 hours per day. The finishing department has 5 workers, who also work a 5-hour shift. Each pair of Rockwell surfboards requires 3 labor hours in...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago
> Answer
Selamawit Tue, Jan 4, 2022 12:52 PM