subject
Business, 22.08.2020 18:01 QueenElizabeth353

Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a special blend of scotch targeted as a bar scotch. The customer wants the blend to involve two scotch products, call them A and B. Product A is a higher quality scotch while product B is a cheaper brand. The customer wants to make the claim the blend is closer to high quality than the alternative. The customer wants 50 1500 ml bottles of the blend. Each bottle must contain at least 48% of Product A and at least 500 ml of B. The customer also specified that the blend have an alcohol content of at least 85%. Product A contains 95% alcohol while product B contains 78%. The blend is sold for $12.50 per bottle. Product A costs $7 per liter and product B costs $3 per liter. The company wants to determine the blend that will meet the customer's requirements and maximize profit. Solve the problem using excel solver. X1 = Number of liters of product A in total blend delivered X2 = Number of liters of product B in total blend delivered MIN: 7 X1 + 3 X2 Subject to: X1 + X2 = 1.5 * 50=75 (Total liters of mix) X1 ≥ 0.48 * 1.5 * 50=36 (X1 minimum) X2 ≥ 0.5 * 50=25 (X2 minimum) .0.95 X1 + 0.78 X2 ≥ 0.85 * 1.5 * 50=63.75 (85% alcohol minimum) X1, X2 ≥ 0 I just need help building the excel spreadsheet and formulas for solver

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 06:10
P11.2a (lo 2, 4) fechter corporation had the following stockholders’ equity accounts on january 1, 2020: common stock ($5 par) $500,000, paid-in capital in excess of par—common stock $200,000, and retained earnings $100,000. in 2020, the company had the following treasury stock transactions. journalize and post treasury stock transactions, and prepare stockholders’ equity section. mar. 1 purchased 5,000 shares at $8 per share. june 1 sold 1,000 shares at $12 per share. sept. 1 sold 2,000 shares at $10 per share. dec. 1 sold 1,000 shares at $7 per share. fechter corporation uses the cost method of accounting for treasury stock. in 2020, the company reported net income of $30,000. instructions a. journalize the treasury stock transactions, and prepare the closing entry at december 31, 2020, for net income. b. open accounts for (1) paid-in capital from treasury stock, (2) treasury stock, and (3) retained earnings. (post to t-accounts.) c. prepare the stockholders’ equity section for fechter corporation at december 31, 2020.
Answers: 1
question
Business, 22.06.2019 12:40
Evan company reports net income of $232,000 each year and declares an annual cash dividend of $100,000. the company holds net assets of $2,130,000 on january 1, 2017. on that date, shalina purchases 40 percent of evan's outstanding common stock for $1,066,000, which gives it the ability to significantly influence evan. at the purchase date, the excess of shalina’s cost over its proportionate share of evan’s book value was assigned to goodwill. on december 31, 2019, what is the investment in evan company balance (equity method) in shalina’s financial records?
Answers: 2
question
Business, 22.06.2019 19:00
All of the following led to the collapse of the soviet economy except a. a lack of worker incentives. c. inadequate supply of consumer goods. b. a reliance on production quotas. d. the introduction of a market economy.
Answers: 1
question
Business, 22.06.2019 20:00
Ajax corp's sales last year were $435,000, its operating costs were $362,500, and its interest charges were $12,500. what was the firm's times-interest-earned (tie) ratio? a. 4.72b. 4.97c. 5.23d. 5.51e. 5.80
Answers: 1
You know the right answer?
Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a s...
Questions
question
Mathematics, 15.11.2019 05:31
Questions on the website: 13722363