Preview

Juilas Food Booth Mat 540

Satisfactory Essays
Open Document
Open Document
608 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Juilas Food Booth Mat 540
Julia’s Food Booth
Strayer University
Quantitative Methods MAT 540
December 12, 2012
Dr. L. Joseph

Introduction

Julia is a senior at Tech, and she’s investigating different ways to finance her final year at school. She is considering leasing a food booth outside the Tech stadium at home football games. Tech sells out every home game, and Julia knows, from attending the games herself, that everyone eats a lot of food. She has a booth, and the booths are not very large. Vendors can sell either food or drinks on Tech property, but not both. Only the Tech athletic department concession stands can sell both inside the stadium. She thinks slices of cheese pizza, hot dogs, and barbecue sandwiches are the most popular food items among fans and so these are the items she would sell.

If Julia clears at least $1,000 in profit for each game after paying all her expenses, she believes it will be worth leasing the booth.

A. Formulate a linear programming model for this case.

Decision Variables

Representing “x1” as pizza slices, “x2” as hot dogs, and “x3” as barbeque sandwich

The Objective Function

The objective is to maximize total profit. Profit is calculated for each variable by subtracting cost from the selling price.

For Pizza slice, Cost/slice=$6/8=$0.75

Products |Costs |Sell Prices |Profits | |Pizza |0.75 |1.50 |0.75 | |Hot dog |0.45 |1.50 |1.05 | |Barbeque Sandwich |0.90 |2.25 |1.35 | |

The model is for the first home game,

Maximize Z = $0.75x1 + $1.05x2 + $1.35x3

Where

Z = Total profit

$0.75x1 = profit from pizza

$1.05x2 = profit from hot dog

$1.35x3 = profit from barbeque sandwich

Model Constraints

1. Budget $0.75x1 + $0.45x2 + $0.90x3 = 2.0
5. More than or equal zero X1, X2, X3 >= 0

Graphical Solution of a Maximization Model Maximize Z = $0.75x1 + $1.05x2 + $1.35x3 Subject to: $0.75x1 + $0.45x2 + $0.90x3 = 2.0
X1, X2, X3 >= 0
Solution
[pic]
X1 =



References: Taylor, B. M. (2010). Taylor, B. M. (2010). Introduction to management science (11 editions). Upper Saddle River, NJ: Pearson/Prentice Hall.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Mat540 Assignment 3

    • 418 Words
    • 2 Pages

    The objective is to maximize total profit. Profit is calculated for each variable by subtracting cost from the selling price.…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MAT 540 Quiz 1

    • 1771 Words
    • 8 Pages

    A university is planning a seminar. It costs $3000 to reserve a room, hire an instructor, and bring in the equipment. Assume it costs $25 per student for the administrators to provide the course materials. If we know that 20 people will attend, what price should be charged per person to break even?…

    • 1771 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MAT 540 Quiz 1

    • 887 Words
    • 4 Pages

    A university is planning a seminar. It costs $3000 to reserve a room, hire an instructor, and bring in the equipment. Assume it costs $25 per student for the administrators to provide the course materials. If we know that 20 people will attend, what price should be charged per person to break even?…

    • 887 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Short Info On Excel Solver Excel Solver is a tool to model and solve linear and nonlinear programming problems. To access it, open Excel, choose the tab “Data” and select “Solver” from the “Analysis” group. If it is not there, you have to install it, by clicking the “File” tab (or the Office button), then “Options”, then “Add-Ins”, and then “Manage Add-Ins”. Check “Solver” there. To solve the model, you have to first program in on a spreadsheet. In the attached “excel-example.xls” we solve the linear programming problem max 3x1 + 2x2 s.t. 2x1 + x2 ≤ 3 x1 + 2x2 ≤ 4 x1 ≥ 0, x2 ≥ 0. The decision variables x1 , x2 are in cells B2:C2. They are called “Changing Variable Cells” in the Solver. You do not have to put any numbers there, but it is convenient to put something to see whether other calculations work well. The coefficients of the constraint matrix A are in B5:C6. The vector b is in E5:E6, and the vector c is in B9:C9. You have to put these data to the spreadsheet. The cells D3:D4 and D9 are calculated cells. They contain formulas to calculate the values of the constraint left hand side Ax and of the objective function cT x. See how they are coded. If you input different values to “changing cells” you get different values in the calculated cells. Now you can go to “Solver”. Specify “Objective” (or “Target Cell”) as D9 (by just clicking on D9). Check “Max”, because you want to maximize. Specify “Changing Cells” as B2:C2 (by selecting with the mouse). Go to the “Constraints” window. Click “Add”. On the left hand side put the cell(s) on the left hand side of the relation. On the right hand side put the cell(s) on the other side of the relation. Select the relation in the middle. This is your constraint. Add other constraints in the same way. Select “Assume Nonnegative”, because both x1 , x2 are greater than or equal to 0. Select “Simplex LP” because you solve a linear model. In the older version of Excel, these selections (“Nonnegative Variables” and “Assume Linear Model”)…

    • 405 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Thaifoon Restaurant Case

    • 2432 Words
    • 10 Pages

    Moreover, the restaurant would open 52 weeks annually. Lunch bill would amount to $12 while dinner would amount to $25 per person. Therefore, for the seats of 30, the restaurant would have revenue of $360 ($12*30) for lunch per turn; and $750 ($25*30) for dinner per turn. Thus, the annual revenue would be $600,600 ($360*5*52+$750*13*52).…

    • 2432 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Mr, Ib

    • 556 Words
    • 3 Pages

    Food and Beverages at Southwestern University Football Games Southwestern University (SWU), located 30 miles southwest of the Dallas/Fort Worth metroplex, has witnessed tremendous growth in its football program. With that growth, fueled by the hiring of legendary coach Bo Pitterno, has come more fame, the need for a bigger stadium, and more complaints about seating, parking, long lines, and concession stand prices. Southwestern University s president, Dr. Marty Starr, was not only concerned about the cost of expanding the existing stadium versus building a new stadium, but also about the ancillary activities. He wants to be sure that these various support activities generate revenue adequate to pay for themselves. Consequently, he wants the parking lots, game programs, and food service to all be handled as profit centers. At a recent meeting discussing the new stadium, Starr told the stadium manager, Hank Maddux, to develop a break-even chart and related data for each of the centers. He instructed Maddux to have the food service area break-even report ready for the next meeting. After discussion with other facility managers and his subordinates, Maddux developed the table below. This table shows the expected percent of revenue by item, the suggested selling prices, and his estimate of variable costs. Selling Variable Percent Item Price/Unit Cost/Unit Revenue Soft drink $1.50 $ .75 25% Coffee 2.00 .50 25% Hot dogs 2.00 .80 20% Hamburgers 2.50 1.00 20% Misc. snacks 1.00 .40 10% Maddux s fixed costs are interesting. He estimated that the prorated portion of the stadium cost would be: salaries for food services at $100,000 ($20,000 for each of the five home games); 2,400 square feet of stadium space at $2 per square foot per game; and six people in each of the six booths for 5 hours at $7 an hour. These fixed cost will be proportionately allocated to each of the products based on percentages provided in the…

    • 556 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    References: |Cooper, C. L., & Argyris, C. (Eds.). (1998). The concise Blackwell encyclopedia of management (2nd ed.). Malden, Massachussetts: Blackwell |…

    • 1656 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    miss

    • 851 Words
    • 4 Pages

    Tatu is a senior at Tech, and she’s investigating different ways to finance her final year at school. She is considering leasing a Food Kiosk outside the Tech stadium at home football games. Tech sells out every home game, and Tatu knows, from attending the games herself, that everyone eats a lot of food. She has to pay $1,000 per game for a Kiosk, and the Kiosks are not very large. Vendors can sell either food or drinks on Tech property, but not both. Only the Tech athletic department concession stands can sell both inside the stadium. She thinks slices of cheese pizza, hot dogs, and barbecue sandwiches are the most popular food items among fans and so these are the items she would sell.…

    • 851 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    quant assignment

    • 1146 Words
    • 5 Pages

    QAUNTITATIVE TECHNIQUES SOLUTION FOR THE CASE CUTTING CAFETERIA COSTS LPP MODEL FOR CAFETERIA COST CUTTING Objective: To reduce the purchase of potato and green beans, so as to meet the conditions of the various constraints to achieve the goal of minimizing the purchase cost. Constraint conditions: Potatoes Green Beans Protein 1.5 g per 100 g → 1.5% 2 g per 100 g → 2% Iron 0.3 mg per 100 g → 0.3% 1.2 mg per 100 g → 1.2% Vitamin C 12 mg per 100 g → 12% 10 mg per 100 g → 10%…

    • 1146 Words
    • 5 Pages
    Satisfactory Essays
  • Better Essays

    The financials for the past four years reflect the fixed costs of property rental, insurance and equipment at $3,250 per month. Variable expenses had incremental increases as food sales increased. Certain ingredients are more expensive than others, and replacement was based on consumption. The deli is run by the two owners with occasional help from two children when customer demand peaked. Specializing in Panini (grilled sandwiches); the cost of sandwiches varies from $4.50 to $9.50 dependent upon ingredients. The average cost for sandwiches is $6.25. The lower-demand higher priced sandwiches can create higher fixed costs for unsold products and ingredients. The deli must increase the elasticity of products and to increase revenue. This can be a challenge because repeat customers tend to order favorites of a selected sandwich. However, the deli must consider that people selecting items from an assortment show greater variety in choices (Salisbury & Feinberg, 2012). The deli can increase revenues by increasing the elasticity and price of its products with greater variety.…

    • 1043 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    1. “Product mix” example 2. “Diet” example 3. “Investment” example 4. “Marketing” example 5. “Transportation” example 6. “Blend” example 7. Product mix (maximization) 8. Sensitivity analysis (4–7) 9. Diet (minimization) 10. Product mix (minimization) 11. Product mix (maximization) 12. Product mix (maximization) 13. Product mix (maximization) 14. Ingredients mix (minimization) 15. Transportation (maximization) 16. Product mix (maximization) 17. Ingredients mix blend (minimization) 18. Crop distribution (maximization) 19. Monetary allocation (maximization) 20. Diet (minimization), sensitivity analysis 21. Transportation (maximization) 22. Transportation (minimization) 23. Warehouse scheduling (minimization) 24. School busing (minimization) 25. Sensitivity analysis (4–24) 26. Ingredients mixture (minimization) 27. Interview scheduling (maximization) 28. Multiperiod investments mixture (maximization) 29. Insurance policy mix (maximization) 30. Product mix (maximization) 31. Advertising mix (minimization), sensitivity analysis 32. Blend (maximization) 33. Multiperiod borrowing (minimization) 34. Multiperiod production scheduling (minimization) 35. Blend (maximization), sensitivity analysis 36. Assignment (minimization), sensitivity analysis 37. Transportation (minimization) 38. Scheduling (minimization) 39. Production line scheduling (maximization) 40. College admissions (maximization) 41. Network flow (minimization) 42. Blend (maximization) 43. Trim loss (minimization) 44. Multiperiod investment (maximization) 45. Multiperiod sales and inventory (maximization) 46. Multiperiod production and inventory (minimization) 47. Employee assignment (maximization) 48. Data envelopment analysis 49. Data envelopment analysis 50. Network flow (maximization) 51. Multiperiod workforce planning (minimization) 52. Integer solution (4–51) 53. Machine…

    • 10952 Words
    • 44 Pages
    Satisfactory Essays
  • Good Essays

    Hoskisson, R.E, Eden, L., Lau, C.M., and Wright, M. (2000), Academey of Management Journal. 43(3): p.267-294…

    • 927 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Ivan Wong

    • 1384 Words
    • 6 Pages

    References: 1. Robbins, S.P. and Coulter, M. Management, 11th ed., Upper Saddle River, New Jersey: Pearson, 2012.…

    • 1384 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    AC Nielsen, Lisbon, Portugal; Ã Ã Cranfield School of Management, UK; †Henley Management College, UK…

    • 4675 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    Tea Industry

    • 22227 Words
    • 89 Pages

    By Professor Philip M. Parker, Ph. D. Chaired Professor of Management Science INSEAD (Singapore & Fontainebleau, France)…

    • 22227 Words
    • 89 Pages
    Satisfactory Essays