Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello would like help solving this problem with solver in Excel. I'm not sure what to plug in for the set objective, by changing variable

image text in transcribed

Hello would like help solving this problem with solver in Excel. I'm not sure what to plug in for the set objective, by changing variable cells, subject to constraints. Below is my work that I have.

image text in transcribed

Product mix, constrained resource. Wechsler Company produces three products: A110, B382, and C657. All three products use the same direct material, Voxx. Unit data for the three products are: Product B382 $112 A110 $168 C657 140 Selling price Variable costs Direct materials Labor and other costs Quantity of Voxx per unit 48 56 8 lb. 30 54 5 lb. 18 80 3 lb. The demand for the products far exceeds the direct materials available to produce the products. Voxx costs $6 per pound, and a maximum of 5,000 pounds is available each month. Wechsler must produce a minimum of 200 units of each product. 1. How many units of product A110, B382, and C657 should Wechsler produce? A20 f B E F . 1 J K L L M N 0 P Q Products B382 C657 112 140 Solver Parameters 168 48 30 18 56 54 80 1 2 A110 3 Selling price 4 Direct materials 5 Labor & other costs 6 Contribution 7 Quantity of Voxx per unit (lbs) 8 Contribution/pound of mat. 9 Min 10 Number of units produced 11 Set Objective: $A$20 64 28 5 42 3 3 8 To: O Max O Min O Value of: 0 8 6 200 14 200 200 By Changing Variable Cells: 1 12 Subject to the Constraints: 13 Add Change Delete 14 6 per pound 15 Max of 5,000 pounds per month 16 minimum of 200 units of each must be produced 17 18 19 1. How many units of each product should be produced? 20 21 Reset All Load/Save 22 Make Unconstrained variables Non-Negative 23 GRG Nonlinear Select a Solving Method: Options 24 25 26 27 Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. 28 29 30 31 Help Solve Close 32 33

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glomont Auditing And Attestation AICPA Released Questions CPA Exam Review 2022

Authors: Glomont, American Institute Of Certified Public Accountants, AICPA

1st Edition

B0BF31GQMC, 979-8353524045

More Books

Students also viewed these Accounting questions

Question

Is it clear what happens if an employee violates the policy?

Answered: 1 week ago