Make sure you show how many of each of the types of cabinets should be produced. It should be done using Excel Solver. Thanks
Homework Answers
Let Assume Xij represent the number of cabinets for each type where i = 1,2 and represent the Cabinet A & B and j = 1,2,3 and represent the type of woods.
And simultaneously Yij represent the revenue per unit and Zj represent the cost per unit
X11 = Cabinet A with Maple
X12 = Cabinet A with Pine
X13 = Cabinet A with Walnut
X21 = Cabinet B with Maple
X22 = Cabinet B with Pine
X23 = Cabinet B with Walnut
Objective -
Max Z = Sum of (Xij*Yij) - (X11+X21)*Z1 - (X12+X22)*Z2 - (X13+X23)*Z3
Constraints -
X11 + X21 <= 400
X12 + X22 <= 600
X13 + X23 <= 200
X11 + X12 + X13 >= 400
X21 + X22 + X23 >= 600
Xij >= 0
Below is the screenshot of the LP table in excel -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the result obtained -
Add Answer to:
Make sure you show how many of each of the types of cabinets should be produced....
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a...
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the...
(Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and...
(Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the...
Wild West produces two types of cowboy hats. A Type 1 requires twice as much labor...
Wild West produces two types of cowboy hats. A Type 1 requires twice as much labor time as a Type 2. If all the available labor time is dedicated to Type 2 alone, the company can produce a total of 400 Type 2 hats a day. The respective market limits for the two types are 150 and 200 hats per year. The revenue is $8 per Type 1 hat and $5 per Type 2 hat. a) Determine the number of...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE TO SHOW ALL CODE &...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE
TO SHOW ALL CODE & ANSWER/FOLLOW ALL THE QUESTIONS IN THE
ASSIGNMENT!
. . Your program assignment Write a program name DeskGUI that computes the price of a desk and whose button Click Event calls the following methods: • A method to accept the number of drawers in the desk as input from the key board. This method returns the number of drawers to the SelectDesk_Click event. A method...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE TO SHOW ALL CODE &...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE
TO SHOW ALL CODE & ANSWER/FOLLOW ALL THE QUESTIONS IN THE
ASSIGNMENT!
. . Your program assignment Write a program name DeskGUI that computes the price of a desk and whose button Click Event calls the following methods: • A method to accept the number of drawers in the desk as input from the key board. This method returns the number of drawers to the SelectDesk_Click event. A method...
Please make sure you label each part of the question, and please make sure to show...
Please make sure you label each part of the question,
and please make sure to show ALL of your math work! Please make
sure your handwriting is clear and easy to read. Thank
you!
2. Suppose labor (L) and capital (K) are fixed proportion inputs, and that each unit of output must be produced with exactly 5 units of labor and 2 unit of capital. The price of a unit of labor is w, and the price of a unit...
M3_IND4. A gear manufacturer is planning next week's production for four types of gears. Because are limited resour...
M3_IND4. A gear manufacturer is planning next week's production for four types of gears. Because are limited resources in the plant for production, the manufacturer can outsource the gears by there C purchasing these gears from a regional supplier. The regional supplier can supply a maximum of 400 units of each type of gear. The table below shows the exact demand for the gears, the revenue per unit, and the outsource cost per unit if the gears are purchased from...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments include Cutting and Assembly. The Janitorial and Security departments support the Cutting and Assembly departments. The Assembly Department spans about 51,200 square feet and holds assets valued at about $67,840. The Cutting Department spans about 28,800 square feet and holds assets valued at about $144,160. Charlie's Wood Works allocates support department costs using the direct method. If costs from the Janitorial Department are allocated...
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob...
Wild West produces two types of cowboy hats. A Type 1 requires twice as much labor time as a Type 2. If all the available labor time is dedicated to Type 2 alone, the company can produce a total of 400 Type 2 hats a day. The respective market limits for the two types are 150 and 200 hats per year. The revenue is $8 per Type 1 hat and $5 per Type 2 hat. a) Determine the number of...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE
TO SHOW ALL CODE & ANSWER/FOLLOW ALL THE QUESTIONS IN THE
ASSIGNMENT!
. . Your program assignment Write a program name DeskGUI that computes the price of a desk and whose button Click Event calls the following methods: • A method to accept the number of drawers in the desk as input from the key board. This method returns the number of drawers to the SelectDesk_Click event. A method...
VISUAL STUDIO - WINDOWS FORM APP (C#) - PLEASE MAKE SURE
TO SHOW ALL CODE & ANSWER/FOLLOW ALL THE QUESTIONS IN THE
ASSIGNMENT!
. . Your program assignment Write a program name DeskGUI that computes the price of a desk and whose button Click Event calls the following methods: • A method to accept the number of drawers in the desk as input from the key board. This method returns the number of drawers to the SelectDesk_Click event. A method...
Please make sure you label each part of the question,
and please make sure to show ALL of your math work! Please make
sure your handwriting is clear and easy to read. Thank
you!
2. Suppose labor (L) and capital (K) are fixed proportion inputs, and that each unit of output must be produced with exactly 5 units of labor and 2 unit of capital. The price of a unit of labor is w, and the price of a unit...
M3_IND4. A gear manufacturer is planning next week's production for four types of gears. Because are limited resources in the plant for production, the manufacturer can outsource the gears by there C purchasing these gears from a regional supplier. The regional supplier can supply a maximum of 400 units of each type of gear. The table below shows the exact demand for the gears, the revenue per unit, and the outsource cost per unit if the gears are purchased from...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments include Cutting and Assembly. The Janitorial and Security departments support the Cutting and Assembly departments. The Assembly Department spans about 51,200 square feet and holds assets valued at about $67,840. The Cutting Department spans about 28,800 square feet and holds assets valued at about $144,160. Charlie's Wood Works allocates support department costs using the direct method. If costs from the Janitorial Department are allocated...
Most questions answered within 3 hours.
-
1-Write an algorithm to get two numbers from the user (as
inputs) and calculate the sum...
asked 3 hours ago -
Define white-collar crime. What is the difference between
offender and offense-based definitions of white-collar crime? What...
asked 3 hours ago -
Consider a reaction which is 1st order with respect to A and 1st
order with respect...
asked 4 hours ago -
c++
The length of the hypotenuse of a right-angled triangle is the
square root of the...
asked 4 hours ago -
When a metal rod is heated, not only its resistance but also its
length and cross‐sectional...
asked 4 hours ago -
write a c++ program that computes the L^1 - Norm of a given
vector (L^1 norm...
asked 4 hours ago -
A manufacturer of banana chips would like to know whether its
bag filling machine works correctly...
asked 4 hours ago -
Complete the chapter case, "Turnover Analysis".
Chapter Case
Turnover Analysis
You recently completed your company’s new...
asked 4 hours ago -
What is the pH of solutions having the following H3O+
concentrations? Identify each as acidic, basic,...
asked 4 hours ago -
How does over-voltage of the diode usually occur?
asked 4 hours ago -
If you step on a dirty nail, your doctor will recommend you
update your Tetanus vaccination....
asked 4 hours ago -
Suppose that decreases in the price of milk lead to decrease s
in the retail prices...
asked 4 hours ago