Question

Hint: The simplest way to complete assignment is to use an existing model....determine if the number of elements is larger/smaller (smaller would be to delete columns/rows...arer would be to insert columns/rows... then update formula's using the same logic as the original model. Problem A - Product Mix (40 points) An apparel manufacturer has 3 types of handbags: Fanny-pack with a $10 profit/bag, Backpack with a s9 profit/bag, cross-overtlong strap) with a $7 profit/bag. The manufacturer wants to make as many handbags as possible that maximize profit. Fortunately/unfortunately for the manufacturer, there is waaaaay more demand for any of the handbags they make/market. The resources consumed per bag are as follows: Fanny-pack Backpack Cross-over ces eather abor Hours chine Hours The quantities available are shown in the following table: uantity Available Resources 12000 eather abor Hours 21000 16500 etal 19500 ine Hours Build a Product Mix Model 1. Shade the objective Function cell with the color 'light red berry 2. Describe the Objective Function. 2. Shade the decision variable cells with the color tight green 2. Describe the decision variablets), 3. Shade the cells that contain 'constraints' on the right side of the equation with the color light blue Z. Describe all constraints. 4. Solve using Standard LP/Quadratic s. Answer the following question: What production quantities maximize profit?

Answer 1

0 Ansuer contidey, let namber el ann pack Produad Number ot back pack Pyody Given that 7. hence objective function' Hazim)3c thep ; t So, Conswaints 2ty32 4 12000 urat 2yt2t. 200 ( , fon given table Solving these inequab'huweget xfanny pac 3000 y Back Pack usoo

Thut 一 子015008