Question: 2. [25 marks] The Excel output and sensitivity report from a linear programming problem are shown below. Northern Woodworks Profit Solution cutting Assembly Finishing

2. [25 marks] The Excel output and sensitivity report from a linear programming problem are shown below. Northern Woodworks Profit Solution cutting Assembly Finishing Variable Cells Tables Chairs Doors $350.00 $300.00 $320.00 122 78 OFV 0 $66,100.00 Time available (mins) 12 665 295 16 13 2712

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!

descriptive profile of Qantas airways (e.g., nature of the business, level of competition it faces, target customers, recent financial performance etc.)

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog...

2. [25 marks] The Excel output and sensitivity report from a linear programming problem are shown below. Northorn MInndiainrle (a) (4 marks) What is the optimal manufacturing plan and corresponding...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

1. Consider the sensitivity report below for problems 1-5. The optimal solution to this linear program is x1 = 34, x2 = 40. x1 = 6, x2 = 11. x1 = 3, x2 = 6. x1 = 0, x2 = 0. x1 = 7.33, x2 = 6. 2....

SkeinSports is limited by the number of hours available in each department. The number of hours available for cutting, sewing, finishing and inspection are 540, 500, 790 and 120 hours respectively in...

Consider the sensitivity report below for problems 1-4. 1. Which of the following constraints are binding? Packing only Additive only Extrusion and Packaging Extrusion only All constraints are...

Question 2 An office furniture company produces ergonomie computer workstations on rollers. Each consists of a tubular frame with adjustable shelves for the keyboard, monitor, computer, printer, and...

BUSINESS 275, WINTER 2016 ASSIGNMENT #2: LINEAR PROGRAMMING Administrative Matters 1.1 Deadline This assignment is due by 11 AM on Wednesday, March 23, 2016 in the correct labeled drop box outside...

The Nordgren family started off with 100 gallons of water in storage and used 4 gallons of water each day. How many gallons of water will have left after 8 days? Type in the number only.

Explain how load curves help select the size and number of generating units.

G 1 . ) ( 2 pts each part ) Determine the limits . If the answer is or , state so . If the answer is finite, indicate the equation of the hor - izontal asymptote ( like y = 5 ) . You do not need to...

Payback Period and Net Present Value If a project with conventional cash flows has a payback period less than the projects life, can you definitively state the algebraic sign of the NPV? Why or why...

You've observed the following returns on Crash-n-Bum Computer's stock over the past five years: 7 percent, -13 percent, 21 percent, 34 percent, and 15 percent. a. What was the arithmetic average...

Assume the facts in E13-5 except that Matt Broderick Company has chosen not to accrue paid sick leave until used, and has chosen to accrue vacation time at expected future rates of pay without...

The trial balance and the other information for consulting engineers Mustang Rovers Consulting Limited follow: Additional Information: 1. Service revenue includes fees received in advance from...

Genius Computers sells computers and offers an assurance-type warranty that covers all repair costs, including parts and labor, for one year after the date of purchase. Genius also sells a service-...

Can we put that she will be making weekly payroll deductions inthe amount of $52.75 to the housing equalling $211.00 monthly

Find the values of nCr and nPr when (a) r = 5 and n = 15, (b) r = 2 and n = 10, (c) r = 8 and n = 10.

Five factories reported the following numbers of minor accidents in a year: Does this suggest that some factories have more accidents thanothers? Factory Number of accidents 23 45 18 34 28 1 234 5

Carn Bay Components make batches of a basic product in Toronto and transfer it to their main manufacturing plant in Chicago. When the product is made, an acceptance quality level of 1% defective is...

How might the three types of needs discussed in this section relate to the goals of many politicians? Would some needs be more important than others?

Would the cultural differences in the effects of praise be likely to affect areas of daily life other than educational situations?

The largest study of human sexual behavior conducted since the work of Alfred Kinsey began in 1983 and was spearheaded by: a. Alfred Kinsey, Jr. b. Janus and Janus c. Sharf and Titus d. Maron and...