Business, 06.03.2020 09:47 daebreonnakelly

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.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 00:50

Cool beans is a locally owned coffee shop that competes with two large coffee chains, planeteuro and frothies. alicia, the owner, hired two students to count the number of customers that entered each of the coffee shops to estimate what percent of people who are interested in coffee are visiting each shop. after a week, the students found the following results: 589 visited cool beans, 839 visited planeteuro, and 1,290 visited frothies. the students were surprised that cool beans had 139 visits on monday which represented 59% of all people who visited one of the three coffee shops on mondays. how many people visited one of the three coffee shops during the week?

Answers: 2

Answer

Business, 22.06.2019 13:30

You operate a small advertising agency. you employ two secretaries, a graphic designer, three sales representatives, and an office coordinator. 1. what types of things would you consider when determining how to compensate each position? describe two (2) considerations. 2. what type of compensation plan would you use for each position?

Answers: 1

Answer

Business, 22.06.2019 20:30

Before the tools that have come from computational psychiatry are ready to be used in everyday practice by psychiatrics, what is needed

Answers: 1

Answer

Business, 22.06.2019 23:00

Draw a flowchart for a process of interest to you, such as a quick oil-change service, a factory process you might have worked in, ordering a pizza, renting a car or truck, buying products on the internet, or applying for an automobile loan. identify the points where something (people, information) waits for service or is held in work-in-process inventory, the estimated time to accomplish each activity in the process, and the total flow time. evaluate how well the process worked and what might be done to improve it.

Answers: 2

Answer

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