Storefront C costs 1000month and it can handle 4 fermentation tanks Storefront

Storefront c costs 1000month and it can handle 4

• Homework Help
• 7

This preview shows page 2 - 5 out of 7 pages.

Storefront C costs \$1,000/month and it can handle 4 fermentation tanks. Storefront A has a demand score of 3,000 points. Storefront B has a demand score of 5,000 points. Storefront C has a demand score of 1,500 points. The demand score is used to determine how many people will come into the store. The higher the score, the higher demand. At least, that is what they were told. If they purchase the off site brewing facility, they dedicate the entire floor space to serving and can double the demand at any one of the store fronts. Off site brewing costs \$2,000/month. This solver is set up a little differently than the other solvers. You need to test all 6 combinations of store fronts and whether or not they by the off site facility. To do this, you need to put in a 1 for the store front you want to use. For Example: Store Fronts Off A B C Site 1 0 0 1 By putting a 1 in the box for Store Front A and 1 in the Off Site brewing mean you are testing to see if buying Store front A and Off Site brewing. One you have made these choices, you can go to Data>Solver>Solve and see what you get. Store Fronts Off A B C Site 0 1 0 0 By putting a 1 in the box for Store Front B and zeros in everything else, means you are only purchasing Store Front B. You need to choose the storefront and off site brewing. Making this whole thing automated takes to long and can give you wrong answers.

Subscribe to view the full document.

Q1) Based on the choice of Store Front and Off Site brewing, what are the profits and prestige for each brewing facility when you maximize for profit? Store Front Off Site Profit Prestig e A No \$95000 1009.8 0 A Yes \$21100 0 2149.2 0 B No \$12500 0 1233 B Yes \$17900 0 1956.6 0 C No \$61000 613.80 C Yes \$17600 0 1634.4 Q2) If you want to maximize profit, which Store Front and Off site brewery combination do you choose? Store Front A wit h an Off Site brewery. Q3) After selecting the Store Front and Off Site facility, what types and how much beer do they make? Beer A Beer B Beer C Beer D Beer E Beer F Beer G Beer H 8 9 54 9 54 6 54 6 Beer J Beer K Beer L Beer M Beer N Beer O Beer P Beer Q 43 2 2 2 2 2 2 2 Q4) Suppose that they want to look into maximizing the Prestige of their brewery’s beer. What is their prestige score and profit for each store front and off site brewing facility combinations? Store Front Off Site Profit Prestig e A No 95000 1015.2 A Yes 21100 0 2149.2 0 B No 12500 0 1357.2 0 B Yes 17900 0 1956.6 0
C No 61000 619.20 C Yes 17200 0 1648.8 0 Q5) Based upon maximizing Prestige, which Store Front and Off Site facility do they choose?

Subscribe to view the full document.

• Winter '16
• viginia

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern