QSO 320 Problem Set (Problem Set 4-20) Complete problem 4-20 at the end of Chapter 4...

QSO 320 Problem Set (Problem Set 4-20)

Complete problem 4-20 at the end of Chapter 4 in your textbook. You will demonstrate your work using Excel templates provided. You do not need to include a graphical procedure.

Problem 4-20

	X	Y

Profit	$4	$5	=SUMPRODUCT(B5:C5,$B$4:$C$4)
Constraints
Labor	1	2	=SUMPRODUCT(B7:C7,$B$4:$C$4)	<=	10
Material	6	6	=SUMPRODUCT(B8:C8,$B$4:$C$4)	<=	36
Storage	8	4	=SUMPRODUCT(B9:C9,$B$4:$C$4)	<=	40
			LHS	Sign	RHS

Hi All, The homework problem does not seem straight forward, so I put together a help file to get students moving on this one. The point of this problem is to understand the sensitivity analysis shown in the problem's figure. The sensitivity analysis for the subpart questions should be done out manually. That said, if you have already started your work using the template and have modified the model to align with the textbook subpart questions, then I will accept that format also. Please make sure that after you modify the model for the subpart, you re-solve it and that you add some text to answer the subpart question. Please make sure you add a tab for each subpart question answer. (I would start out by Solving the model and then copy the tab over for each subpart while renaming the tab, a, b, c, etc.) For those who would like to do the assignment to its original intent, I have attached some guidance on how to do the required analysis.

Expert Solution

1) Formulation of table

2) Formulas used

3) Solver inputs

4) Final solution

The final solution is 2 units of X and 4 units of Y for the optimal value of the objective function. The optimal value of the objective function is $28.

keosha answered 8 months ago

09problem 3/4/2019 20:30 9/14/2015 Chapter 9. Solution for End-of-Chapter Comprehensive/Spreadsheet problem Problem 9-22 Taussig Technologies Corporation...

09problem 3/4/2019 20:30 9/14/2015 Chapter 9. Solution for End-of-Chapter Comprehensive/Spreadsheet problem Problem 9-22 Taussig Technologies Corporation (TTC) has been growing at a rate of 20% per year in recent years. This same growth rate is expected to last for another 2 years, then to decline to gn = 6%. a. If D0 = $1.60 and rs = 10%, what is TTC's stock worth today? What are its expected dividend and capital gains yields at this time, that is, during Year...

Behind the Supply Curve — End of Chapter Problem VC Quantity of trucks FC 20 orders...

Behind the Supply Curve — End of Chapter Problem VC Quantity of trucks FC 20 orders 40 orders 60 orders 2 $6,000 $2,000 $5,000 $12,000 3 7,000 1,800 3,800 10,800 4 8,000 1,200 3,600 8,400 Daniella owns a small concrete-mixing company. Her fixed cost is the cost of the concrete-batching machinery and her mixer trucks. Her variable cost is the cost of the sand, gravel, and other inputs for producing concrete; the gas and maintenance for the machinery and trucks;...

Problem 4 [20 pts]: Playing Cards Let C represent a set of 52 playing cards with...

Problem 4 [20 pts]: Playing Cards Let C represent a set of 52 playing cards with four suits (♥, ♦, ♣, ♠) each having 13 ranks (Ace,2,3,4,5,6,7,8,9,10,Jack,Queen,King). We define the following additional sets. F =Face cards (Jack, Queen, and King). R =Red cards. P =Ranks that are prime (2,3,5,7). J =One-eyed Jacks (Jack of Hearts, Jack of Spades). 1. Depict these sets as a Venn Diagram and show the cardinality of each distinct region. (The regions don’t have to be...

Complete the following conversions using dimensional analysis 1. 320 pennies to number of nickels 2. 320...

Complete the following conversions using dimensional analysis 1. 320 pennies to number of nickels 2. 320 nickels to number of American dollars 3. 750cm to feet 4. 750cm to miles 5. 316nm to yards 6. 12 meters/seconds to miles/hour 7. $9.50/hour to pennies/day 8. 3.5 millimeters/min to liters/hour 9. 35 centimeters/day to meters/second 10. 35 meters/seconds to miles/year Please explain every step to help me better understand. Also, please, type out your responses so I can legibly read. Thank you...

On your own, complete the "assessing yourself" at the end of this chapter "Can you distinguish...

On your own, complete the "assessing yourself" at the end of this chapter "Can you distinguish between discipline and punishment?"

This is the complete set of data for this question Problem 1: The information is available...

This is the complete set of data for this question Problem 1: The information is available for the first year of operations for Medeiros, Inc. The following differences enter into the reconciliation of financial income and taxable income of Medeiros, Inc. for the year ended December 31, 2018, its first year of operations. The enacted income tax rate is 40% for all years a) The company has chosen to depreciate all of its fixed assets on an accelerated basis for...

Chapter 4 Problem 11 Problem 15, part f. in Chapter 3 asks you to construct a...

Chapter 4 Problem 11 Problem 15, part f. in Chapter 3 asks you to construct a five year financial projection for Aquatic Supplies beginning in 2015. The five year projection appears below. a. Calculate Aquatic Supplies's sustainable and actual growth rates in these years. b. What do these numbers suggest to you? Aquatic Supplies Co. Five Year Projected Income Statements and Balance Sheets Income Statement (in $ millions) Pro Forma Forecasts 2015 - 2019 2014 Assumptions 2015 2016 2017 2018...

2. Problem 2 is adapted from the Problem 39 at the end of Chapter 11. Please...

2. Problem 2 is adapted from the Problem 39 at the end of Chapter 11. Please solve this problem in Excel and submit your Excel spreadsheet. The problem is as follows: The state of Virginia has implemented a Standard of Learning (SOL) test that all public school students must pass before they can graduate from high school. A passing grade is 75. Montgomery County High School administrators want to gauge how well their students might do on the SOL test,...

Please refer to Individual Problem 20-5 in Chapter 20. If the client pays the cost for...

Please refer to Individual Problem 20-5 in Chapter 20. If the client pays the cost for Form A for all forms processed, what is the average gain or loss earned across all forms processed? A. Lose $0.10 per form B. Break even C. Gain $0.10 per form D. Gain $0.15 per form Which of the following actions can be an example of a signal designed to reduce the impact of asymmetric information? A. A money-back guarantee B. Students pursue graduate...

Using excel and the data in chapter 14 data set 2, complete the analysis and interpret...

Using excel and the data in chapter 14 data set 2, complete the analysis and interpret the results. It is a 2 x 3 experiment: There are two levels of severity, where the Level 1 is severe and Level 2 is mild, and there are three levels of treatment, where Level 1 is Drug #1, Level 2 is Drug #2, and Level 3 is Placebo. This is an ANOVA with replication because each participant received all three levels of treatment,...

Question