Answered step by step
Verified Expert Solution
Link Copied!

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...

image text in transcribed 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.14

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Stacey Whitecotton, Robert Libby, Fred Phillips

4th edition

1259964957, 1260413985, 1260565440, 978-1260413984

More Books

Students also viewed these Accounting questions