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

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 03:00

Put each of them in order. you are a young entrepreneur with a startup business. you now seek credit from the bank to expand it. what are the steps you will have to take? 1. you support your loan application with relevant documents. 2. you fill out the loan application form at the bank 3. you get an approval for the loan and the money is disbursed to your business account 4. you use the credit to further your business plan. 5. you have an interview with the loan officer and you explain your business plan.

Answers: 1

Answer

Business, 22.06.2019 08:00

Companies in the u.s. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. in 2011 hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. the following data show the number of cars in service (1000s) and the annual revenue ($ millions) for six smaller car rental companies (auto rental news website, august 7, 2012). excel file: data14-09.xls if required, enter negative values as negative numbers. a. select a scatter diagram with the number of cars in service as the independent variable. b. what does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. use the least squares method to develop the estimated regression equation (to 3 decimals). ŷ = + x d. for every additional car placed in service, estimate how much annual revenue will change. by $ e. fox rent a car has 11,000 cars in service. use the estimated regression equation developed in part (c) to predict annual revenue for fox rent a car. round your answer to nearest whole value. $ million hide feedback partially correct

Answers: 1

Answer

Business, 22.06.2019 12:30

Suppose you win a small lottery and have the choice of two ways to be paid: you can accept the money in a lump sum or in a series of payments over time. if you pick the lump sum, you get $2,950 today. if you pick payments over time, you get three payments: $1,000 today, $1,000 1 year from today, and $1,000 2 years from today. 1) at an interest rate of 6% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 2) at an interest rate of 9% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 3) years after you win the lottery, a friend in another country calls to ask your advice. by wild coincidence, she has just won another lottery with the same payout schemes. she must make a quick decision about whether to collect her money under the lump sum or the payments over time. what is the best advice to give your friend? a) the lump sum is always better. b) the payments over time are always better. c) it will depend on the interest rate; advise her to get a calculator. d) none of these answers is good advice.

Answers: 2

Answer

Business, 22.06.2019 12:50

You are working on a bid to build two city parks a year for the next three years. this project requires the purchase of $249,000 of equipment that will be depreciated using straight-line depreciation to a zero book value over the three-year project life. ignore bonus depreciation. the equipment can be sold at the end of the project for $115,000. you will also need $18.000 in net working capital for the duration of the project. the fixed costs will be $37000 a year and the variable costs will be $148,000 per park. your required rate of return is 14 percent and your tax rate is 21 percent. what is the minimal amount you should bid per park? (round your answer to the nearest $100) (a) $214,300 (b) $214,100 (c) $212,500 (d) $208,200 (e) $208,400

Answers: 3

Answer

You know the right answer?

Jack's distillery blends scotches for local bars and saloons. One of his customers has requested a s...

Questions