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 20:30
Partnerships are the most common type of business firms in the world. t/f
Answers: 3
question
Business, 22.06.2019 03:20
Look at this check register. calculate the current balance. check date transaction (+) deposit balance 5/1 5/3 $82.92 debit 8.00 78.24 005 monthly fee phone bill paycheck 1 125.00 5/15 5/17 5/20 atm 40.00 56.50 006 t ennis lessons the current balance is?
Answers: 1
question
Business, 22.06.2019 12:10
In year 1, the bennetts' 25-year-old daughter, jane, is a full-time student at an out-of-state university but she plans to return home after the school year ends. in previous years, jane has never worked and her parents have always been able to claim her as a dependent. in year 1, a kind neighbor offers to pay for all of jane's educational and living expenses. which of the following statements is most accurate regarding whether jane's parents would be allowed to claim an exemption for jane in year 1 assuming the neighbor pays for all of jane's support? a.no, jane must include her neighbor's gift as income and thus fails the gross income test for a qualifying relative.b.yes, because she is a full-time student and does not provide more than half of her own support, jane is considered her parent's qualifying child.c.no, jane is too old to be considered a qualifying child and fails the support test of a qualifying relative.d.yes, because she is a student, her absence is considered as "temporary." consequently she meets the residence test and is a considered a qualifying child of the bennetts.
Answers: 2
question
Business, 22.06.2019 19:30
Consider the following two projects. both have costs of $5,000 in year 1. project 1 provides benefits of $2,000 in each of the first four years only. the second provides benefits of $2,000 for each of years 6 to 10 only. compute the net benefits using a discount rate of 6 percent. repeat using a discount rate of 12 percent. what can you conclude from this exercise?
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, 18.03.2021 02:00
question
Mathematics, 18.03.2021 02:00
question
Mathematics, 18.03.2021 02:00
question
Biology, 18.03.2021 02:00
question
Mathematics, 18.03.2021 02:00
question
Mathematics, 18.03.2021 02:00