Question: I was wondering how one would do this. Please solve the following problem using Microsoft Excel and please identify all variables and constraints in the

I was wondering how one would do this. Please solve the following problem using Microsoft Excel and please identify all variables and constraints in the problem as well as screenshots of your solutions in excel.

2-9: A company produces two products, A and B. The sales volume for A is at least 80% of the total sales of both A and B. However the company can not sell more than 100 units of A per day. Both products use one raw material which the maximum daily availability is 240 lbs. The usage rate of raw material are 2lbs per unit of A and 4 lbs per unit of B. The profit per units of A and B are $20.00, and $50.00 respectively. determine the optimal mix for the company.

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!

Solve the following problem using Microsoft Excel. Copy your answers from Excel into the Table provided on the next page. Upload only this Word file; do not upload Excel file on Blackboard. This...

Formulating and Solving Linear Programming Models 3. An airline company has decided to place orders for Airbus A321 planes that will service the Orange County-San Francisco route. The company must...

ITEC355-001 Homework 1.pdf Open with Preview ITEC-355-001 Homework 1 General Instructions This assignment is worth 7% of your total grade and evaluates your ability to solve a capacity/optimization...

Please solve the following problem showing all steps, using what is asked in thr question. Also add screenshots of the data from the software or program used. Inventory - Lot Sizing - AMPL Consider a...

Please, I want to solve this HW in boring detail Please solve the following problem as a CSP. Futoshiki is a Japanese logic puzzle that is very simple, but can be quite challenging. You are given an...

Note: Please solve this question manually using microsoft word. Do not use excel solver to solve it Write out the decision variables, constraints and objective function The Darby Company manufactures...

A manufacturer of rotary pumps is planning production for the next four months. The forecast demand for the rotary pumps is shown in the following table. Rotary pump SEP OCT NOV DEC Standard 650 875...

Please solve the following question using excel commands like solver, Analytic Solver, or sensitivity analysis. 5. Reconsider the model given in Problem 5.2. While doing what-if analysis, you learn...

please solve the following( please solve the excel problem using excel referance with the excel formula) example (=D3,F6...) The spreadshect below has data on Microsoft and the SEP 500 from 1986 to...

What precautions must one take when using ratio analysis to make financial decisions? Which ratios would be most useful for a financial managers internal financial analysis? For an analyst trying to...

Draw the electrical networks corresponding to the following incidence matrices. (a) (b) (c) (d) (e) 0101 1001 0110 1010 1010 0011 0101 -1 0 00 0 0 01 0 -0 0 00011 01010 10001 01100 10100 00000101...

Townsend Chemical Company makes a variety of cosmetic products, one of which is a skin cream designed to reduce the signs of aging. Townsend produces a relatively small amount (15,000 units) of the...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...