Question: Your Excel file must be executable. If your excel model is ran, it should provide the same results you submit. That means the spreadsheet has

Your Excel file must be executable. If your excel

Your Excel file must be executable. If your excel model is ran, it should provide the same results you submit. That means the spreadsheet has correct embedded formulae and Solver dialog boxes have all the inputs. If 'Solve' is clicked and your spreadsheet does not produce the reported results, a zero score will be assigned to quiz 3. Name the Excel file as Quiz 3_Last Name.xlsx. A winemaker in California's Napa Valley must decide how much of two types of wine she will produce from a particular variety of grapes. Each bottle of table wine (T) yields $8 profit, while each bottle of dessert wine (D) produces $3 profit. The labor hours and bottling process time in minutes used for type of wine are given in the table below. Resources available include 200 labor hours and 80 hours of bottling process time. Marketing department estimates that table wine is in more demand than the dessert wine, and requires that the table wine should be produced in at least triple the quantity of the dessert wine. Table (T) Dessert (D) Labor(mins) 12 36 Process(mins) 18 6 Input and solve the profit-maximization model using Excel Solver. After running Solver, generate sensitivity report. Provide your answer in the sensitivity report worksheet. 1) In the optimal strategy, how many bottles of table wine will be produced? How many dessert wine will be produced? What is the maximum profit? 2) By implementing the optimal strategy, how many labor hours and processing time will be used? Report the slack/surplus for each constraint. 3) Which constraints are binding constraints

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!