Consider a company that manufactures three home air conditioners: an economy model (E), a standard model...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider a company that manufactures three home air conditioners: an economy model (E), a standard model (S), and a deluxe model (D). The objective is to determine how many economic models, standard models, and deluxe models they should produce in order to maximize profit. Each model requires processing time (seconds) at three workstations detailed below. Product D 4 seconds Product E Product S Process time at workstation 1 Process time at workstation 2 Process time at workstation 3 3 seconds 5 seconds 5 seconds 3 seconds 4 seconds 2 seconds 4 seconds 7 seconds Profit per unit 63.00 $ 95.00 S 135.00 The goal of maximizing profit is analyzed over a one-hour period (3,600 seconds). Using Excel Solver, the folowing sensitivity report was generated. Variable Cells Final Reduced Objective Allowable Allowable Cll Name Value Cost Coefficient Increase Decrease SB$15 Product E 0. 63 -A 1E+30 SB$16 Product S 900 95 1E+30 17.85 SB$17 Product D B 135 -8 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SBS21 Available time (seconds) 3600 23.75 3600 1E+30 3600 What is the value of the objective function? Select one: a. $121,500 b. $85,500 o. $56,700 d. $93,700 Consider a company that manufactures three home air conditioners: an economy model (E), a standard model (S), and a deluxe model (D). The objective is to determine how many economic models, standard models, and deluxe models they should produce in order to maximize profit. Each model requires processing time (seconds) at three workstations detailed below. Product D 4 seconds Product E Product S Process time at workstation 1 Process time at workstation 2 Process time at workstation 3 3 seconds 5 seconds 5 seconds 3 seconds 4 seconds 2 seconds 4 seconds 7 seconds Profit per unit 63.00 $ 95.00 S 135.00 The goal of maximizing profit is analyzed over a one-hour period (3,600 seconds). Using Excel Solver, the folowing sensitivity report was generated. Variable Cells Final Reduced Objective Allowable Allowable Cll Name Value Cost Coefficient Increase Decrease SB$15 Product E 0. 63 -A 1E+30 SB$16 Product S 900 95 1E+30 17.85 SB$17 Product D B 135 -8 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SBS21 Available time (seconds) 3600 23.75 3600 1E+30 3600 What is the value of the objective function? Select one: a. $121,500 b. $85,500 o. $56,700 d. $93,700
Expert Answer:
Answer rating: 100% (QA)
d 3125 The current value of D in the optimal solution is 0 Reduced cost or opportunity cost ... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these mathematics questions
-
Consider a company that manufactures and sells personal computers (lets call the company Bell Computers). Recently the company lowered its prices dramatically. The company is very efficient and needs...
-
A company that builds sailboats wants to determine how many sailboats to build during each of the next four quarters. The demand during each of the next four quarters is as follows: first quarter,...
-
The Admissions Office at Tech wants to determine how many in-state and out-of-state students to accept for next falls entering freshman class. Tuition for an in-state student is $7600 per year while...
-
A production supervisor at a major chemical company wishes to determine whether a new catalyst, catalyst XA-100, increases the mean hourly yield of a chemical process beyond the current mean hourly...
-
Using Appendix B, Table 8, find: (a) P [ Ws 57] when nA = 6, nB = 8. (b) P [ Ws 31] when nA = 8, nB = 6. (c) P [Ws 38 or Ws < 22 ] when nA = 5 and nB = 6. (d) The point c such that P [ Ws < c ] is...
-
Which type of asset is more likely to be liquidated for close to its full market value in the event of financial distress: a. An office building or a brand name? b. Product inventory or raw...
-
What is protected visibility? Give an example.
-
Susan Varhard, treasurer of the Gammamax Company, has proposed that the company should sell equity and buy back debt in order to maximize its value. As evidence, she presents the financial statements...
-
What is the output of the following C program when it is run as "a.out 1 2 3"? 4 5 7 MAS698 1 #include 2 9 10 11 12 13 } } #include int yMethod(int a[]) { a-(4,5,6,7,8); return...
-
Benjamin used regression analysis to fit quadratic relations to monthly revenue and cost data with the following results: R = 0.007 Q2 + 32 Q TC = 0.004 Q2 + 2.2 Q + 8 (a) Plot R and TC. Estimate...
-
What case or article within the years 2 0 2 0 - 2 0 2 3 where a white - collar crime had been committed? Highlight the source and provide a summary of the crime committed.
-
Describe a cognitive bias that may skew an entrepreneur's perception of the opportunity to open a new hip - hop dance studio near Ryerson's campus. Why is an entrepreneur more prone to this bias...
-
John and Kate are partners in Reality Partnership, with John holding a 40% interest and Kate holding a 60% interest. The partnership agreement states that Kate will receive a salary of $75,000 and 8%...
-
If f(x) = 5x1, and g(x) is x, determine the value of (fog)(4).
-
Annabelle, Boden, and Christy form ABC Partnership as equal partners. Annabelle and Boden contribute cash of $40,000 each and Christy contributes equipment with a $70,000 fair market value and...
-
How do the interdisciplinary perspectives of sociology, economics, psychology, and political science intersect to enhance our comprehension of the intricate dimensions and importance of social...
-
In the event of default, actions available to creditors include Multiple select question. providing a grace period if the circumstances are significant. decreasing the interest rate. renegotiating...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
A city in Ohio is considering replacing its fleet of gasoline-powered automobiles with electric cars. The manufacturer of the electric cars claims that this municipality will experience significant...
-
During the next two months an automobile manufacturer must meet (on time) the following demands for trucks and cars: month 1, 400 trucks and 800 cars; month 2, 300 trucks and 300 cars. During each...
-
The file P02_11.xlsx contains data on 148 houses that were recently sold. Two variables in this data set are the selling price of the house and the number of bedrooms in the house. We want to use a...
-
Honeybees accumulate charge as they fly, and they transfer charge to the flowers they visit. Honeybees are able to sense electric fields; tests show that they can detect a change in field as small as...
-
A platypus foraging for prey can detect an electric field as small as 0.002 N/C. To give an idea of the sensitivity of the platypuss electric sense, how far from a +10 nC point charge does the field...
-
A bumblebee can sense electric fields as the fields bend hairs on its body. Bumblebees have been conclusively shown to detect an electric field of 60 N/C. Could a bumblebee use this sense to detect...
Study smarter with the SolutionInn App