Question: 5. Formulate a linear programming model and solve the following. Write out your model and solve using Excel Solver. Paste your excel model and Solver

5. Formulate a linear programming model and solve

5. Formulate a linear programming model and solve the following. Write out your model and solve using Excel Solver. Paste your excel model and Solver solution (15 points) A manager wants to know how many units of each product to produce on a daily basis in order to achieve the highest contribution to profit. Production requirements are as follows: Product Material 1 (pounds) 2 1 6 Material 2 (pounds) 3 5 A B Material 3 (hours) 3.2 1.5 2.0 Material 1 costs $5/pound, material 2 costs $4/pound, and labor costs $10/hour. Product A sells for $80/unit, Product B sells for $90/unit, and Product C sells for $70/unit. Available resources are 200 pounds of product A, 300 pounds product B, and 150 hours of labor. Lastly, marketing has given the manager very specific output requirements. The output of product A should not be more than one-third of the total number of units produced; the ratio of units of Product A to Product B should be 3:2; and there is a standing order of 5 units of Product A each day

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!

Please, i need a complete answer. From Q(a). to (c). thanks. Question 1 Telefonika is a telecommunication company, located in the Accra Mall, selling mobile phones and accessories. Most of their new...

Q1.The demand of an item produced by a company is highly seasonal. Current inventory of the item is 165,000 units and ending inventory should be 200,000 units. The manufacturing manager wants to...

Questions Q1. The demand of an item produced by a company is highly seasonal. Current inventory of the item is 165,000 units and ending inventory should be 200,000 units. The manufacturing manager...

The Big Bang Novelty Company (BBNC) makes 3 types of noisemakers: Toot, Wheet, and Honk. A Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 20 minutes, has two...

Question 2 (Investing \& Marketing Problem): Barstool publishes two types of guides on a monthly basis: a sport events guide and a frozen pizza guide. Barstool distributes the guides free to...

11.6. Reconsider Example 11.2 (Hospital Emergency Room) to determine if additional nurses will be required to staff the revised daily shift requirements shown below: Sun. Mon. Tues. Wed. Thurs. Fri....

11.6. Reconsider Example 11.2 (Hospital Emergency Room) to determine if additional nurses will be required to staff the revised daily shift requirements shown below: Day Sun. Mon. Tues. Wed. Thurs....

Please read the whole question very carefully and upload the solutions to all questions asked. Kindly attach Excel files or Screenshots of your work done on Excel. Also, answer all the questions...

Question 2 A. The Managing Director of Palace Decor is faced with the problem of assigning five senior managers to six regions. From past experience, he knows that the efficiency of the sales and...

Explain how government intervention might improve the efficiency of cell phones use. Talking on a hands-free cell phone while driving might seem safe, but people who used hands-free cell phones in...

Pat Statsdud is about to write a multiple-choice exam but as usual knows absolutely nothing. Pat plans to guess one of the five choices. Pat has been given one of the professors previous exams with...

An assessable capital gain is considered to be statutory income rather than ordinary income Yes No Which of the following is the most likely residency test to apply when a Australian resident...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...