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, 21.06.2019 17:40
Carlos would like to start saving for his son’s college expenses. which type of savings account should carlos open? ida money market 529 plan basic savings account
Answers: 2
question
Business, 22.06.2019 11:40
In early january, burger mania acquired 100% of the common stock of the crispy taco restaurant chain. the purchase price allocation included the following items: $4 million, patent; $3 million, trademark considered to have an indefinite useful life; and $5 million, goodwill. burger mania's policy is to amortize intangible assets with finite useful lives using the straight-line method, no residual value, and a five-year service life. what is the total amount of amortization expense that would appear in burger mania's income statement for the first year ended december 31 related to these items?
Answers: 2
question
Business, 22.06.2019 16:50
Slow ride corp. is evaluating a project with the following cash flows: year cash flow 0 –$12,000 1 5,800 2 6,500 3 6,200 4 5,100 5 –4,300 the company uses a 11 percent discount rate and an 8 percent reinvestment rate on all of its projects. calculate the mirr of the project using all three methods using these interest rates.
Answers: 2
question
Business, 22.06.2019 20:10
With signals from no-claim bonuses and deductibles, a. the marginal cost curve for careful drivers lies to the left of the marginal cost curve for aggressive drivers b. auto insurance companies insure more aggressive drivers than careful drivers because aggressive drivers have a greater need for the insurance c. the market for car insurance has a separating equilibrium, and the market is efficient d. most drivers pay higher premiums than if the market had no signals
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, 19.05.2021 01:40
Questions on the website: 13722366