Question Details

[answered] Linear Programming Models NOTE: UNLESS EXPRESSLY STATED CAR


Attached is a file. All problems need to be completed in Excel showing all work and equations.?


Linear Programming Models

 

NOTE: UNLESS EXPRESSLY STATED CARRY YOUR ANSWERS TO TWO (2) DECIMAL PLACES. Scenario 1: The All Season Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 6.25 hours of wiring and 7.75 hours of drilling. Each fan must go through 5.25 hours of wiring and 4.05 hours of drilling. During the

 

next production period, 315 hours of wiring time are available and up to 350 hours of drilling

 

time may be used. Each air conditioner sold yields a profit of $62.50. Each fan assembled may be sold for a $51.75 profit. Question 1: Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans and that yields the highest profit. Feel free to use

 

the Excel template provided or the corner point method.

 

Question 2: Round your Solution Values to a whole number and calculate the profit using the

 

rounded solution.

 

Scenario 2: All Season?s management realizes that it forgot two critical constraints (see Question #1 above). In particular, management decides that there should be a minimum number of air conditioners and fans produced in order to fulfill a contract to a good customer.

 

Question 3: If All Season decides that at least 37 air conditioners and 17 fans should be produced, what would be the optimal solution if an additional 10 hours of Wiring and 20 additional hours of Drilling were added to the production time? Use the Excel template provided or the corner point method.

 

Question 4: Round your Solution Values to a whole number and calculate the profit using the

 

rounded solution.

 

Scenario 3: The ABC Corporation manufactures three electrical products; humidifiers, fans and air cleaners. The manufacturing process is composed of three processes: wiring, packaging and assembly. During the next production period, 2500 hours of wiring time are available, 80

 

hours of packing and up to 1625 hours of assembly time may be used. The following table presents the production requirements per unit: Bill of Labor

 

Product

 

Humidifiers

 

Air Cleaners

 

Fans Wiring

 

3 hrs.

 

2 hrs.

 

2.25 hrs. Assembly

 

4 hrs.

 

5 hrs.

 

3.10 hrs. Dr. Mike?s MBA 6300 Homework #6 Page 1 Packaging

 

2.25 hrs.

 

1.75 hrs.

 

2.50 hrs. Standard Costs

 

Product

 

Humidifiers

 

Air Cleaners

 

Fans Material

 

$22.50

 

$28.15

 

$8.55 Labor

 

$9.50

 

$8.35

 

$7.25 Overhead

 

$28.50

 

$19.75

 

$11.25 Selling Price

 

$78.50

 

$74.35

 

$44.50 Question 5: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the highest profit. Feel free to use the Excel template provided or the corner point method. Question 6: Round your Solution Values to a whole number and calculate the profit using the rounded solution.

 

Scenario 4: Management did not like the solution presented in Scenario 3 above and, based on its open order file, placed additional constraints on the model. First there was an open order for at least 11 humidifiers, and 11 air cleaners, which have to be made, additionally after checking the inventory decided that 8 additional fans should be made. Question 7: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the highest profit. Feel free to use the Excel template provided or the corner point method.

 

Question 8: Round your Solution Values to a whole number and calculate the profit using the

 

rounded solution.

 

Scenario 5: Using the data and constraints presented in Scenarios 3 & 4 and the fact that have hired two additional people to work in the Packaging Department which adds 80 hours to the time available and the constraint that no more than 25 humidifiers could be produced: Question 9: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the greatest profit. Feel free to use the Excel template provided or the corner point method.

 

Question 10: Round your Solution Values to a whole number and calculate the cost using the rounded solution.

 

Scenario 6: The ABC Corporation management has hired a cost accountant to make some recommendations regarding the cost allocation of labor used to produce air cleaners. The average

 

wages of personnel performing particular processes are presented in the table below. Assembly

 

$13.75 Wiring

 

$15.75 Packaging

 

$10.25 Material Handling

 

$12.75 Additional investigation into manufacturing costs reveal that at least 15% of the man?hours must be allocated to performing material handling tasks, 45% must be allocated to wiring and Dr. Mike?s MBA 6300 Homework #6 Page 2 assembly and 40% must be allocated to wiring and packaging. If a block of 60 man?hours is analyzed answer the following questions: Question 11: Formulate and develop a LP model to find the best combination of labor hours and that yields the lowest cost. use the corner point method.

 

Question 12: The prior analysis revealed a flaw in the data; the accountants ignored the constraint that a minimum of twelve (12) man?hours had to be allocated to Wiring. Formulate and develop a LP model accounting for this new constraint.

 

Question 13: The prior analysis revealed another flaw in the analysis; the accountants failed to identify that packaging is over allocated thus they want to add another constraint stating that packaging must be allocated a maximum of ten (10) man?hours. Formulate and develop a LP model accounting for this new constraint. Dr. Mike?s MBA 6300 Homework #6 Page 3

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001013225.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now