Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer this question its urgent SITUATION 3B - UTILIZATION OF A CONSTRAINED RESOURCE - DATA ANALYTICS WITH EXCEL SOLVER 1. Find the optimal product
please answer this question its urgent SITUATION 3B - UTILIZATION OF A CONSTRAINED RESOURCE - DATA ANALYTICS WITH EXCEL SOLVER 1. Find the optimal product mix for Belair Bistro considering all products made by Pierre. In your analysis, you must consider the following constraints: i. You cannot produce more than the estimated demand for the product W ii. You must produce at least 75 croissants each day The number of quiches should equal the number of sandwiches. The total Direct Labour minutes cannot exceed 3,404 minutes. iv. Below is the current production of Belair Bistro. Cookies $1 OM per unit DL Minutes OM/DUM Demand Current Production Macaron box $12) 18 $0.67 80 Ple $5.70 10 $0.57 37 40 Muffin Croissant $0.70 $1.20 1 6 50.70 $0.20 60 85 45 75 Danish Bread $1.201 $0.95 0.6 $0.17 $1.58 30 140 30 100 Quiche Sandwich $3 $1.25 8 3 $0.39 $0.42 25 35 201 20 Scones Creme Brule S0.45 $240 12 6 $0 35 $0.40 20 24 20 20 Cake $14 25 $0 56 36 30 $0 33 751 75
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started