Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

For Mowen/hansen/heitgers Cornerstones Of Managerial Accounting, 6th Edition, [instant Access]

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

6th Edition

1305280768, 9781305280762

More Books

Students also viewed these Accounting questions

Question

What factors infl uence our perceptions?

Answered: 1 week ago