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 12:30
Suppose that two firms produce differentiated products and compete in prices. as in class, the two firms are located at two ends of a line one mile apart. consumers are evenly distributed along the line. the firms have identical marginal cost, $60. firm b produces a product with value $110 to consumers.firm a (located at 0 on the unit line) produces a higher quality product with value $120 to consumers. the cost of travel are directly related to the distance a consumer travels to purchase a good. if a consumerhas to travel a mile to purchase a good, the incur a cost of $20. if they have to travel x fraction of a mile, they incur a cost of $20x. (a) write down the expressions for how much a consumer at location d would value the products sold by firms a and b, if they set prices p_{a} and p_{b} ? (b) based on your expressions in (a), how much will be demanded from each firm if prices p_{a} and p_{b} are set? (c) what are the nash equilibrium prices?
Answers: 3
question
Business, 22.06.2019 18:00
During the holiday season, maria's department store works with a contracted employment agency to bring extra workers on board to handle overflow business, and extra duties such as wrapping presents. maria's is using during these rush times.
Answers: 3
question
Business, 22.06.2019 18:30
You should typically prepare at least questions for the people who will host you during a job shadow. a. 3 b. 4 c. 5 d. 2
Answers: 1
question
Business, 22.06.2019 19:40
The martinez legal firm (mlf) recently acquired a smaller competitor, miller and associates, which specializes in issues not previously covered by mlf, such as land use and intellectual property cases. given the increase in the firm's size and complexity, it is likely that its internal transaction costs willa. decrease. b. increase. c. become external transaction costs. d. be eliminated.
Answers: 3
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, 12.01.2022 14:20
Questions on the website: 13722367