Reference no: EM131190255
The Whitt Window Company is a company with only three employees that makes two different kinds of handcrafted windows: a wood-framed and an aluminum framed window. They earn $60 profit for each wood-framed window and $30 pro?t for each aluminum-framed window. Doug makes the wood frames and can make 6 per day. Linda makes the aluminum frames and can make 4 per day. Bob forms and cuts the glass and can make 48 square feet of glass per day.
Each wood- framed window uses 6 square feet of glass and each a|uminum- framed window uses 8 square feet of glass. The company wishes to determine how many windows of each type to produce per day to maximize total pro?t.
a. Describe the analogy between this problem and the Wyndor Glass Co. problem discussed in Section 2.1. Then construct and ?ll in 8 table like Table 2.1 f0l' this problem, identifying b0th the 8CtiVltl€S and "18 |'8SOUI'C8S.
b.ldentify verbally the decisions to be made, the constraints on these decisions, and the overall measure of performance for the decisions.
c.Convert these verbal descriptions of the constraints and the measure of performance into quantitative expressions in terms of the data and decisions.
d. Formulate a spreadsheet model for this problem- Identify the data cells, the changing cells, and the target cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT fUnCtiOn. Then use the Excel Solver t0 solve thiS model.
e.lndicate why this spreadsheet model is a linear programming model.
f.Formulate this same model algebraically.
g.ldentify the decision variables, objective function, nonnegativity constraints, functional constraints, and parameters in both the algebraic version and spreadsheet version of the m0d8l-
h.Use the graphical method to solve this model.
i.A new competitor in town has started making wood-framed windows as well. This may force thecompany to lower the price it charges and so lower the profit made for each wood-framed window. How would the optimal solution change (if at all) if the profit per wood-framed window decreases from $60 to $40? From $60 to $20?
j .Doug is considenng lowering his working hours, which would decrease the number of wood frames he makes per day. How would the optimal solution change if he only makes 6 wood frames per day?
|
What would be the additional funds needed
: Broussard Skateboard's sales are expected to increase by 20% from $7.8 million in 2016 to $9.36 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as proj..
|
|
Are you satisfied with the test for obscenity
: What did the Court mean when it held, in Virginia v. Black, that "just as any State may regulate only that obscenity which is the most obscene due to its prurient content, so too may a State choose to prohibit only those forms of intimidation that..
|
|
How sensitive is wmin to product purities
: How sensitive is Wmin to product purities? Does Wmin, depend on the particular separation operation used? Prove, by calculus, that the largest value of Wmin occurs for a feed with equimolar quantities of A andB.
|
|
Payment bundling have on health care costs
: The Patient Protection and Affordable Care Act established a pilot program to expand the use of payment bundling for better coordinated care for Medicare beneficiaries. What impact does payment bundling have on health care costs?
|
|
Descriptions of the constraints
: a. Describe the analogy between this problem and the Wyndor Glass Co. problem discussed in Section 2.1. Then construct and ?ll in 8 table like Table 2.1 f0l' this problem, identifying b0th the 8CtiVltl€S and "18 |'8SOUI'C8S. b.ldentify verbally t..
|
|
Essay on either strategic management or sustainability
: You are required to write essay on either Strategic Management or Sustainability as follows: Use an organisation that is or has been in the news during the past two years (work-related learning) as an example of strategic management practices
|
|
Provide the record-keeping mechanism for showing ownership
: Provide record-keeping mechanism for showing ownership of the financial instruments used in the flow of financial funds between savers and borrowers and profitability of organizations that produce and exchange goods and services.
|
|
Calculate the currents in various sections
: 3-phase ring main ABCD fed at A at 11 kV supplies balanced loads of 50 A at 0.8 p.f. - Calculate the currents in various sections and station bus-bar voltages at B, C and D.
|
|
Calculate the kci concentration in the tank
: Solve the mass balance equation to obtain an expression for V (t). Then substitute for V in the potassium chloride balance and solve for C (t). Calculate the KCI concentration in the tank at the moment the tank overflows.
|