Question: would love to understnad how to solve this problem on excel thank you 6. Shown below is a flowchart that provides selling prices, demand, production
would love to understnad how to solve this problem on excel thank you
6. Shown below is a flowchart that provides selling prices, demand, production times, and material cost information for two products a company produces. The company has worked to reduce setup times to such short times that they can be disregarded. The resources are available 7.5 hours per day for 5 days a week. a. Where is the constraint, if the company has one? b. What feasible product mix will provide the company its highest contribution to profit and overhead? 6. Shown below is a flowchart that provides selling prices, demand, production times, and material cost information for two products a company produces. The company has worked to reduce setup times to such short times that they can be disregarded. The resources are available 7.5 hours per day for 5 days a week. a. Where is the constraint, if the company has one? b. What feasible product mix will provide the company its highest contribution to profit and overhead
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
