Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

9. Explain how the optimal solution and the optimal value is changed if later it is determined that the break-even point is $64,000 profit must

image text in transcribed

9. Explain how the optimal solution and the optimal value is changed if later it is determined that

the break-even point is $64,000

profit must be $64,000 or more

The Business Situation The Mason Wine Company produces two kinds of wine - Mason Blanc and Mason Merlot. The wines are produced in 1,000-gallon batches. The profit for a batch of Blanc is $12,000 and the profit for a batch of Merlot is $9,000. The wines are produced from 64 tons of grapes that the company has acquired. A 1,000-gallon batch of Blanc requires 4 tons of grapes and a batch of Merlot requires 8 tons. However, the production is limited by the availability of only 50 cubic yards (yd) of storage space for aging and 120 hours of processing time. Each batch of each type of wine requires 5 yd' of storage space. The processing time for a batch of Blanc is 15 hours and the processing time for a batch of Merlot is 8 hours. The wine company will not produce more or less than the range of amounts demanded for each type. Demand for each type of wine is for at least 1 batch but is limited to not more than 7 batches. Even so, the demand for Blanc is the same as or is higher than the demand for Merlot. Company executives do not want to depend on just one type of wine so they have mandated minimum production levels of both types of wine. Specifically, at least 20% of the total wine production must be Merlot. Likewise, at least 20% of the total wine production must be Blanc. Moreover, the amount of the Merlot produced should not be more than half of the total production. Also, the break-even point on profit is $54,000. Therefore, company requires that it must make at least $54,000 in profit to do better than just break even (that is, profit must be $54,000 or more). The company wants to set the production levels, in terms of the number of 1,000- gallon batches of both the Blanc and Merlot wines to produce so as to earn the most profit possible. (NOTE: Partial [i.e., fractional] batches can be produced; they refer to pending production. If fractional, round the optimal solution values to two (2) decimal places.) The Business Situation The Mason Wine Company produces two kinds of wine - Mason Blanc and Mason Merlot. The wines are produced in 1,000-gallon batches. The profit for a batch of Blanc is $12,000 and the profit for a batch of Merlot is $9,000. The wines are produced from 64 tons of grapes that the company has acquired. A 1,000-gallon batch of Blanc requires 4 tons of grapes and a batch of Merlot requires 8 tons. However, the production is limited by the availability of only 50 cubic yards (yd) of storage space for aging and 120 hours of processing time. Each batch of each type of wine requires 5 yd' of storage space. The processing time for a batch of Blanc is 15 hours and the processing time for a batch of Merlot is 8 hours. The wine company will not produce more or less than the range of amounts demanded for each type. Demand for each type of wine is for at least 1 batch but is limited to not more than 7 batches. Even so, the demand for Blanc is the same as or is higher than the demand for Merlot. Company executives do not want to depend on just one type of wine so they have mandated minimum production levels of both types of wine. Specifically, at least 20% of the total wine production must be Merlot. Likewise, at least 20% of the total wine production must be Blanc. Moreover, the amount of the Merlot produced should not be more than half of the total production. Also, the break-even point on profit is $54,000. Therefore, company requires that it must make at least $54,000 in profit to do better than just break even (that is, profit must be $54,000 or more). The company wants to set the production levels, in terms of the number of 1,000- gallon batches of both the Blanc and Merlot wines to produce so as to earn the most profit possible. (NOTE: Partial [i.e., fractional] batches can be produced; they refer to pending production. If fractional, round the optimal solution values to two (2) decimal places.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Cornerstones of Financial and Managerial Accounting

Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen

2nd edition

978-1111879044

Students also viewed these Finance questions