Let x = the number of contemporary-style cabinets produced each week y = the number of farmhouse-style cabinets produced each week (a) Develop the objective function, assuming that Brooklyn Cabinets wants to maximize the total weekly profit. Max 520x + 750y × (b) Show the mathematical expression for each of the constraints on the three processes. carpentry painting finishing (c) Show the mathematical expression for each of Brooklyn Cabinets' contractual agreements. contemporary farmhouse

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
100%

Please use excel to help me solve. Need to learn how to do it on excel

Brooklyn Cabinets is a manufacturer of kitchen cabinets. The two cabinetry styles manufactured by Brooklyn are contemporary and farmhouse. Contemporary-style cabinets sell for $110 and
farmhouse-style cabinets sell for $120. Each cabinet produced must go through carpentry, painting, and finishing processes. The following table summarizes how much time in each process must be
devoted to each style of cabinet.
Hours per Process
Style
Carpentry
Painting
Finishing
Contemporary
2.4
1.7
1.5
Farmhouse
2.8
1.0
1.2
Carpentry costs $15 per hour, painting costs $12 per hour, and finishing costs $18 per hour; and the weekly number of hours available in the processes is 3,200 in carpentry, 1,600 in painting, and
1,600 in finishing.
Brooklyn also has a contract that requires the company to supply one of its customers with 525 contemporary cabinets and 750 farmhouse-style cabinets each week.
Let
x = the number of contemporary-style cabinets produced each week
y = the number of farmhouse-style cabinets produced each week
(a) Develop the objective function, assuming that Brooklyn Cabinets wants to maximize the total weekly profit.
Max 520х + 750y
(b) Show the mathematical expression for each of the constraints on the three processes.
carpentry
painting
finishing
(c) Show the mathematical expression for each of Brooklyn Cabinets' contractual agreements.
contemporary
farmhouse
Transcribed Image Text:Brooklyn Cabinets is a manufacturer of kitchen cabinets. The two cabinetry styles manufactured by Brooklyn are contemporary and farmhouse. Contemporary-style cabinets sell for $110 and farmhouse-style cabinets sell for $120. Each cabinet produced must go through carpentry, painting, and finishing processes. The following table summarizes how much time in each process must be devoted to each style of cabinet. Hours per Process Style Carpentry Painting Finishing Contemporary 2.4 1.7 1.5 Farmhouse 2.8 1.0 1.2 Carpentry costs $15 per hour, painting costs $12 per hour, and finishing costs $18 per hour; and the weekly number of hours available in the processes is 3,200 in carpentry, 1,600 in painting, and 1,600 in finishing. Brooklyn also has a contract that requires the company to supply one of its customers with 525 contemporary cabinets and 750 farmhouse-style cabinets each week. Let x = the number of contemporary-style cabinets produced each week y = the number of farmhouse-style cabinets produced each week (a) Develop the objective function, assuming that Brooklyn Cabinets wants to maximize the total weekly profit. Max 520х + 750y (b) Show the mathematical expression for each of the constraints on the three processes. carpentry painting finishing (c) Show the mathematical expression for each of Brooklyn Cabinets' contractual agreements. contemporary farmhouse
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Knowledge Booster
Matrix Operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman