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

Other questions on the subject: Business

image
Business, 22.06.2019 19:50, kipper5760
Bulldog holdings is a u. s.-based consumer electronics company. it owns smaller firms in japan and taiwan where most of its cell phone technology is developed and manufactured before being released worldwide. which of the following alternatives to integration does this best illustrate? a. venture capitalism b. franchising c. joint venture d. parent-subsidiary relationship
Answers: 2
image
Business, 22.06.2019 20:00, kickdoedon
During the month of march 2017, weimar world, a tax-preparation service, had the following transactions. * billed $496,000 in revenues on credit * received $164,000 from customers' accounts receivable * incurred expenses of $194,000 but only paid $87,700 cash for these expenses * prepaid $32,220 for computer services to be used next month what was the company's accrual basis net income for the month? select one: a. $302,000 b. $264,080 c. $ 41,860 d. $408,300 e. none of the above
Answers: 3
image
Business, 22.06.2019 20:20, caleelwittmann31
This activity is important because as a marketing manager, you must allocate resources to reach your target market. during the strategic marketing process, managers move through three important phases to determine how to optimally allocate resources: a planning phase, an implementation phase, and an evaluation phase. in this interactive exercise, you are asked to review various strategic marketing actions and determine where in the strategic marketing process the action would occur. the goal of this exercise is to demonstrate your understanding of the strategic marketing process and related marketing actions.
Answers: 2
image
Business, 22.06.2019 23:40, coreycbg1127
Joint cost cheyenne, inc. produces three products from a common input. the joint costs for a typical quarter follow: direct materials $45,000 direct labor 55,000 overhead 60,000 the revenues from each product are as follows: product a $75,000 product b 80,000 product c 30,000 management is considering processing product a beyond the split-off point, which would increase the sales value of product a to $116,000. however, to process product a further means that the company must rent some special equipment costing $17,500 per quarter. additional materials and labor also needed would cost $12,650 per quarter. a. what is the gross profit currently being earned by the three products for one quarter? $answer b. what is the effect on quarterly profits if the company decides to process product a further? $answer
Answers: 2
You know the right answer?
Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a s...

Questions in other subjects:

Konu
Mathematics, 01.03.2021 06:10
Konu
World Languages, 01.03.2021 06:10