Question: Red Q10 (25 points) Prepare an Excel spreadsheet and use Solver. Sonkai Zhang at Zhang Vineyards Inc, makes three varieties of moderate-priced table wines: Red,

Red Q10 (25 points) Prepare an Excel spreadsheet and use Solver. Sonkai Zhang at Zhang Vineyards Inc, makes three varieties of moderate-priced table wines: Red, White, and Ros. The raw materials, labour, and profit contribution per case of each of these wines is summarized below. Profit Grapes - Grapes - Sugar Labour Wine Contrib. B (lbs) (man hours) (bushels) (bushels) Kper case) 4 $14 0 1 3 White 0 0 4 1 $27 Ros 2 $20 2 2 2 The winery has 1800 bushels of Variety A grapes, 840 bushels of Variety B grapes, 800 pounds of sugar, and 760 man-hours of labour available during the next season. The firm operates to achieve maximum profit contribution Required: a.) Identify the decision variables, objective function, constraints on an Excel spreadsheet. Use the Solver algorithm to obtain an optimal solution. b.) For Variety B grapes, if Sonkai could have one more bushel of Variety grapes to use in determining the optimal solution, what would be the profit contribution (do a sensitivity analysis)

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!

Prepare an Excel spreadsheet and use Solver. Sonkai Zhang at Zhang Vineyards Inc. makes three varieties of moderate-priced table wines: Red, White, and Ros. The raw materials, labour, and profit...

AUSTRALIAN WINE MAKING INDUSTRY The wine industry in Australia commenced in 1790 around the coastal areas of Sydney. The industry was further expanded in the mid-1800s with more grape wines planted...

These questions are about Management Accounting. The theory question in the "Management Accounting" is based on the "kilgors Group Activity s2 2016". Need some help on the Management Accounting, this...

Please help me with question 10 . I have done all the others but I have no idea what to answer for Q10. l. 10. Part 1 Red Shirts (25 points) {BINOMIA L] The probability that a randomly-selected...

Albert Enterprises is a manufacturing company that builds heavy equipment repair parts for the construction industry. Albert is providing the following information for preparing their budgets for the...

wing information for preparing their budgets for the first quarter of 2 0 2 3 . Sales: November, 2 0 2 2 Actual Sales were $ 1 , 5 0 0 , 0 0 0 and December, 2 0 2 2 Actual Sales were $ 2 , 1 0 0 , 0...

Albert Enterprises Balance Sheet December 3 1 , 2 0 2 2 Assets 1 2 / 3 1 / 2 0 2 2 Cash $ 1 1 0 , 0 0 0 Accounts Receivable $ 1 , 7 7 0 , 0 0 0 Raw Materials $ 1 6 3 , 2 0 0 Finished Goods $ 5 4 0 ,...

Sales: November, 2 0 2 2 Actual Sales were $ 1 , 5 0 0 , 0 0 0 and December, 2 0 2 2 Actual Sales were $ 2 , 1 0 0 , 0 0 0 Budgeted Sales for the first 5 months of 2 0 2 3 are: January 3 0 , 0 0 0...

What is the difference between ideal values and real values?

To fit correctly, a metal bar must be cut to be between 45 and 50 centimeters in length. A random sample of40 metal bars was selected, and the bars were measured. The sampled bars yielded a grand...

Question 9 of 1 0 1 View Policies Current Attempt in Progress Wildhorse Co , completed its first year of operations on December 3 1 , 2 0 2 2 . Its initial income statement showed that Wildhorse had...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....