Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have excel homework that is broken down in 2 tabs of an excel spreadsheet. it is a pretty basic excel solver assignment. I need
I have excel homework that is broken down in 2 tabs of an excel spreadsheet. it is a pretty basic excel solver assignment. I need this done ASAP, preferably in the next few hours. Attached is the spread sheet. The instruction/situation is written on each spreadsheet along with the questions/assignment below that. Not sure if this is considered math or accounting...
A 1 B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM Manufacturing desks and chairs 2 3 Inputs 4 5 6 7 8 Desks Chairs Desks Chairs Unit margins Wood usage per unit Decisions 9 10 Units produced 11 12 instructions in cell I16 Constraint on wood 13 Wood used Wood available 14 15 16 Constraint on chairs 17 a furniture company manufactures desks and chairs. Each desk uses four units of wood and each chair uses 3 units. Adesk contributes $400 to profit and a chair contributes $250. Marketing restrictions requirethat the number of chairs produced by at least twice the number of desks produced. there are 2000 total units of wood available. Chairs produced 18 19 20 Chairs required a) use solver to maximize company profits Objective to maximize 21 Profit 22 23 b)confirm graphically that the solution in part a maximizes company's profits c)use solver table to see what happens to the decision variables and the total profit when the availability of wood varies from 1000 to 3000 in 100 unit increments. Based on your findings, howmuch would the company be willing to pay for each extra unit of wood over its current 2000 units? How much profit would it lose if it lost any of its current 2000 units? Problem 2.2 AN A B 1 2 3 Momiss River pollutants 4 Cost/ton 5 6 7 8 9 10 C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF instructions in cell L6 Factory 1 Factory 2 Factory 3 Factory 1 Factory 2 Factory 3 Reduction Required at least 30 tons and the amount of p2 by at least 40 tons. P1 P2 Processed a)use solver to determine how minmize the cost of reducting pollution by the desired amounts. Are the LP assumptions (proportionality, additivity, divisibility) reasonable to this problem? Total cost b)Use solver table to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what happens to the amounts of waste processed by the three factories and the total cost if both requirements (currently 30 and 40 tons respectively) are increased by the SAME percentage. Revise your model so that you can use solver table to investigate these changes when the percentage increase varies from 10% to 100% in increments of 10%. Do the amounts processed at the three factories and the total cost change in a linear manner? 11 12 Problem 2.14Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started