subject
Business, 12.02.2020 02:46 robjaykay

Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A sells for $101 a unit, product B sells for $67 a unit, and product C sells for $97.50 a unit. Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. Also, there is a weekly demand of at least 10 units of product C each week. Formulate the given problem scenario as a linear program, and solve the problem using Microsoft Excel Solver. For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible. Also, the Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 05:00
What is a sort of auction for stocks in which traders verbally submit their offers?
Answers: 3
question
Business, 22.06.2019 11:30
Margaret company reported the following information for the current year: net sales $3,000,000 purchases $1,957,000 beginning inventory $245,000 ending inventory $115,000 cost of goods sold 65% of sales industry averages available are: inventory turnover 5.29 gross profit percentage 28% how do the inventory turnover and gross profit percentage for margaret company compare to the industry averages for the same ratios? (round inventory turnover to two decimal places. round gross profit percentage to the nearest percent.)
Answers: 2
question
Business, 22.06.2019 16:50
Identify and describe a variety of performance rating scales that can be used in organizations including graphical scales, letter scales, and numeric scales.
Answers: 2
question
Business, 22.06.2019 19:00
It is estimated that over 100,000 students will apply to the top 30 m.b.a. programs in the united states this year. a. using the concept of net present value and opportunity cost, when is it rational for an individual to pursue an m.b.a. degree. b. what would you expect to happen to the number of applicants if the starting salaries of managers with m.b.a. degrees remained constant but salaries of managers without such degrees decreased by 20 percent
Answers: 3
You know the right answer?
Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A se...
Questions
question
Arts, 06.12.2019 03:31
question
Geography, 06.12.2019 03:31
Questions on the website: 13722363