Question: please provide an excel sheet and solver on how to format this problem 2. Dredes Inc, makes desks that are made up of 1 top,

please provide an excel sheet and solver on howplease provide an excel sheet and solver on how to format this problem
please provide an excel sheet and solver on how
2. Dredes Inc, makes desks that are made up of 1 top, 2 sides, and 4 legs. We need to make at least 15,000 desks to fulfill the demand of our customers. 1) One top requires 4 feet of wood, one side requires 2 feet of wood, and one leg requires 1 foot of wood and we have 180,000 feet of wood available. 2) Each top takes 8 minutes to make a top, each side takes 3 minutes to make, and each leg takes 2 minutes to make. We have 300,000 minutes available. 3) Each top takes up 2 units of space, each side takes up 2 units of space, and each leg takes up.1 units of space before it is assembled in our inventory. We have 80,000 units of space available. Answer the following using solver: a) How many tops should we make? How many tops should we buy? How many sides should we make? How many sides should we buy? How many legs should we make? How many legs should we buy? b) Without re-running Solver, what happens to our cost if we require that we buy at least one leg? c) Without re-running solver, what happens to our cost if we need to make 16,000 tops (instead of 15,000)? Make the top - $7 Buy the top - $10 Make the side - $3 Buy the side - $5 Make a leg - $2 Buy a leg - $3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!