Problem and accompanying excel windows

Assignment Help Basic Computer Science
Reference no: EM13951368

Question 1                                                                                                                                          

A heuristic solution is

Question 2                                                                                                                                   

How many decision variables are there in a transportation problem which has 5 supply points and 4 demand points?

Question 3                                                                                                                                     

 The following questions are based on this problem and accompanying Excel windows.

Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

Let          X1 = Number of Beds to produce

                X2 = Number of Desks to produce

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

Refer to Exhibit 3.1. Which cells should be changing cells in this problem?

Question 4                                                                                                                               

How many constraints are there in a transportation problem which has 5 supply points and 4 demand points? (ignore the non-negativity constraints)

Question 5                                                                                                                             

The following questions are based on this problem and accompanying Excel windows.

ones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

Let          X1 = Number of Beds to produce

                X2 = Number of Desks to produce

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

Which cells should be the constraint cells in this problem?

Question 6                                                                                                                         

The following questions are based on this problem and accompanying Excel windows.The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.



Computer

Model



Profit per

Model ($)

Maximum

demand for

product



Wiring Hours

Required

Assembly

Hours

Required

Inspection

Hours

Required

Plain

30

80

.4

.5

.2

Fancy

40

90

.5

.4

.3

 

 

Hours Available

50

50

22

           

Let

X1 = Number of Plain computers to produce

 

X2 = Number of Fancy computers to produce

 

 

MAX:

30 X1 + 40 X2

Subject to:

.4 X1 + .5 X2£ 50 (wiring hours)

 

.5 X1 + .4 X2£ 50 (assembly hours)

 

.2 X1 + .2 X2£ 22 (inspection hours)

 

X1£ 80 (Plain computers demand)

 

X2£ 90 (Fancy computers demand)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Byte Computer Company

 

 

2

 

 

 

 

 

3

 

Plain

Fancy

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Wiring

0.4

0.5

 

50

9

Assembly

0.5

0.4

 

50

10

Inspection

0.2

0.3

 

22

11

Plain Demand

1

 

 

80

12

Fancy Demand

 

1

 

90

           

Which cells should be the constraint cells in this problem?

Question 7                                                                                                                            

Numeric constants should be

Question 8                                                                                                                                   

What is the significance of an absolute cell reference in Excel?

Question 9                                                                                                                                     

An LP problem with a feasible region will have

Question 10                                                                                                                                  

Problems which have only integer solutions are called

Question 11                                                                                                  

The following questions are based on this problem and accompanying Excel windows.Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

Let

X1 = Number of Beds to produce

 

X2 = Number of Desks to produce

   

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used?

Question 12                                                                                                                                    

The following questions are based on this problem and accompanying Excel windows.Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

Let

X1 = Number of Beds to produce

 

X2 = Number of Desks to produce

   

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

Question 13                                                                                                     

The following questions are based on this problem and accompanying Excel windows.Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced.

Let

X1 = Number of Beds to produce

 

X2 = Number of Desks to produce

   

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

Which of the following statements represent the carpentry, varnishing and limited demand for desks constraints?

Question 14                                                                                                                            

The following questions are based on this problem and accompanying Excel windows.

The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.

Let

X1 = Number of Beds to produce

 

X2 = Number of Desks to produce

   

The LP model for the problem is

MAX:

30 X1 + 40 X2

Subject to:

6 X1 + 4 X2£ 36 (carpentry)

 

4 X1 + 8 X2£ 40 (varnishing)

 

X2£ 8 (demand for desks)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Jones Furniture

 

 

2

 

 

 

 

 

3

 

Beds

Desks

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Carpentry

6

4

 

36

9

Varnishing

4

8

 

40

10

Desk demand

 

1

 

8

           

Which of the following statements represent the carpentry, varnishing and limited demand for desks constraints?

Question 15                                                                                                                                 

The constraints X1³ 0 and X2³ 0 are referred to as

Question 16                                                                                                                               

The following questions are based on this problem and accompanying Excel windows.

The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.



Computer

Model



Profit per

Model ($)

Maximum

demand for

product



Wiring Hours

Required

Assembly

Hours

Required

Inspection

Hours

Required

Plain

30

80

.4

.5

.2

Fancy

40

90

.5

.4

.3

 

 

Hours Available

50

50

22

           

Let

X1 = Number of Plain computers to produce

 

X2 = Number of Fancy computers to produce

 

 

MAX:

30 X1 + 40 X2

Subject to:

.4 X1 + .5 X2£ 50 (wiring hours)

 

.5 X1 + .4 X2£ 50 (assembly hours)

 

.2 X1 + .2 X2£ 22 (inspection hours)

 

X1£ 80 (Plain computers demand)

 

X2£ 90 (Fancy computers demand)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Byte Computer Company

 

 

2

 

 

 

 

 

3

 

Plain

Fancy

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Wiring

0.4

0.5

 

50

9

Assembly

0.5

0.4

 

50

10

Inspection

0.2

0.3

 

22

11

Plain Demand

1

 

 

80

12

Fancy Demand

 

1

 

90

           

What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

Question 17                                                                                                                                  

The following questions are based on this problem and accompanying Excel windows.

The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.



Computer

Model



Profit per

Model ($)

Maximum

demand for

product



Wiring Hours

Required

Assembly

Hours

Required

Inspection

Hours

Required

Plain

30

80

.4

.5

.2

Fancy

40

90

.5

.4

.3

 

 

Hours Available

50

50

22

           

Let

X1 = Number of Plain computers to produce

 

X2 = Number of Fancy computers to produce

 

 

MAX:

30 X1 + 40 X2

Subject to:

.4 X1 + .5 X2£ 50 (wiring hours)

 

.5 X1 + .4 X2£ 50 (assembly hours)

 

.2 X1 + .2 X2£ 22 (inspection hours)

 

X1£ 80 (Plain computers demand)

 

X2£ 90 (Fancy computers demand)

 

X1, X2³ 0

   

 

A

B

C

D

E

1

 

Byte Computer Company

 

 

2

 

 

 

 

 

3

 

Plain

Fancy

 

 

4

Number to make:

 

 

 

Total Profit:

5

Unit profit:

30

40

 

 

6

 

 

 

 

 

7

Constraints:

 

 

Used

Available

8

Wiring

0.4

0.5

 

50

9

Assembly

0.5

0.4

 

50

10

Inspection

0.2

0.3

 

22

11

Plain Demand

1

 

 

80

12

Fancy Demand

 

1

 

90

           

What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of wiring used?

Question 18                                                                                                                                   

Models which are setup in an intuitively appealing, logical layout tend to be the most

Question 19                                                                                                                                     

Which command is equivalent to =SUMPRODUCT(A1:A3,B1:B3)?

Question 20                                                                                                                           

What does the Excel =SUMPRODUCT(A1:A5,C6;C10) command do?

Reference no: EM13951368

Questions Cloud

How many hours are you scheduled to work each week : How many hours are you scheduled to work each week? Answer to the nearest hour.  How applicable is this work experience to your future employment goals?
Explain the basis for your answer : Which variance(s) would you investigate? Explain the basis for your answer.
Critical thinking what crime in the cyber realm : Kizza (2014) addressed network attacks and intrusions broadly as "cybercrime" and attributed them largely to moral and ethical deficiencies of the perpetrators. Lessig (2006) approached law in the network largely in terms of computer "code" that d..
Define an information system and types of information system : Provide three examples of information systems used in real life (from your experience or from the sites you visited) and tell what type of information systems they (for example, an information system used by a cashier in a grocery store is a trans..
Problem and accompanying excel windows : Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing.
Perform the bea at what point does breakeven occur : calculate the net present value of these costs and benefits also calculate the overall return on investment of the project and then present a breakeven analysis , perform the BEA at what point does breakeven occur?
Write an algorithm that gets as input three data values : Write an algorithm that gets as input three data valuesx,y, andz and outputs the average of these values if the value ofx is positive.
What is his weight at the surface of the earth : Four stars of different mass arrive on the Main Sequence of the Hertzsprung-Russell Diagram at the same time. Which star has a mass just about the same as the mass of the Sun?
Discuss the importance of internal customer satisfaction. : IT infrastructure groups are often responsible for direct customer interaction and associated customer service. Note ways IT organizations can improve the quality and perception of their service

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd