Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
Question 1
The Rotary Club is holding a pizza sale to finance outreach projects. The Club made an agreement to purchase pizza from Pizza Hut at a 30% discount which the Rotary Club can then resell for a profit. It is expected that of the 500 families in the community, at most 70% will buy pizza. Based on a survey of their personal preferences, the students believe that they should order
no more than 120 cheese pizzas, no more than 150 pepperoni pizzas, and no more than 100 vegetarian pizzas. They also want to make sure that at least 20% of the total pizzas are cheese and at least 50% of the pizzas are pepperoni. The standard price (before discount) for the cheese, pepperoni and vegetarian is $12, $15 and $14, respectively. The Rotary Club makes a profit of 10%, 15% and 20%, respectively, for each cheese, pepperoni, and vegetarian pizza they resell.
a) Formulate a linear programming model that would determine the optimal solution. An explanation for the derivation of EACH equation should be provided.
b) Set up and solve the linear programming model using EXCEL. (Both the excel set up and answer report are required)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Required Information [The following information applies to the questions displayed below.] Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department's cost records, Professor Morton found the following total cost associated with Finance 101 over the last five terms: Term Fall, last year winter, last year Summer, last year Fall, this year winter, this year Professor Morton knows there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes. Total Cost (in dollars) 16,000 14,000 12,000 10,000 Required: 1. Prepare a scattergraph plot. (Plot total cost on the vertical axis and number of sections offered on the horizontal axis.) Instructions: 1. On the graph below, use the point tool (Fall last year) to plot number of sections offered on the horizontal axis and total cost on the vertical…arrow_forward56 Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every five weeks to take orders. Because the orders are shipped directly from Italy, they take four weeks to arrive. Charlie's Pizza uses an average of 250 pounds of pepperoni each week, with a standard deviation of 10 pounds. Charlie's prides itself on offering only the best-quality ingredients and a high level of service, so it wants to ensure a 99 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 490 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would vou order? Note: Use Excel's NORM.S.INV( function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.arrow_forward5. (Scenario Based Question) Your response to Simeon's phonecall: Hello, I need to speak to a manager now! Netflix has taken money out of my account when I cancelled the subscription ages ago. They have still charged me for their services. This has left me with no money. This is fraud! I need this money refunded straight away otherwise I will not be able to afford groceries for my kids this week. Please refund this money now! * (Write your response to the customer as if you were a COP at Monzo talking to Simeon, for example "Hi Simeon....". Show us your empathy and analytical problem solving skills, and how by being customer centric you'd help get the customer to a logical solution in this scenarioarrow_forward
- 云 < cO # 3 QUESTION 6 A measure of the importance of trade is: OA. Trade as a percentage of employment rate. OB. Trade as percentage of GDP. O C. The dollar value of trade adjusted for inflation. OD. The real value of trade. QUESTION 7 given goods A and B and a budget , if the relative price of A were to increase, the budget line would: A. Shift out in parallel fashion. OB. Shift in a relative fashion. C. Become steeper. OD.Become flatter OUESTION8 MAR 12 tv 08 F3 F2 DD F7 F4 F5 F6 F8 24 2. ) 9 7. 6arrow_forwardWindCo Inc. owns several delivery vans that could be sold very quickly in the event that the company runs into financial trouble. These delivery vans should be considered ______. Question 38 options: A) long-term assets B) fixed assets C) current assets D) current liabilities E) accounts receivablearrow_forwardThe goal of EPR (Extended Producer Responsibility) laws is to: Question 43 options: reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs. motivate manufacturers to design products that are more easily repaired, reused, and recycled. Neither reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs nor motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct. Both reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs & motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct.arrow_forward
- Question 4 Jetair was founded in September 2007 and is one of a growing number of low-cost airlines in the country of Salta. Jetair's strategy is to operate as a low-cost, high-efficiency airline, and it does this by: Operating mostly in secondary cities to reduce landing costs. ● Using only one type of aircraft in order to reduce maintenance and operational costs. These planes are leased rather than bought outright. Having only one category of seat class. Having no pre-allocated seats or in-flight entertainment. Focusing on e-commerce with customers, both booking tickets and checking in for flights online. The airline was given an 'on-time arrival' ranking of seventh best by the country's aviation authority, which ranks all 50 of the country's airlines based on the number of flights which arrive on time at their destinations. 48 Jetair flights were cancelled in 2013 compared to 35 in 2012. This increase was due to an increase in the staff absentee rate at Jetair from 3 days per staff…arrow_forwardTopic: Threats and controls of the disbursement cycle Lourdes works at the manufacturing company General Grains, Inc., where she serves as an inventory control employee. One of her tasks is to create orders for the necessary raw materials for manufacturing. Therefore, she periodically checks inventory levels from a computer in her office within the warehouse. Once she identifies the items that need to be restocked, she reviews the list of suppliers, selects one, and creates a purchase order from her computer, adding a new entry to the purchase orders file. Additionally, she prints a copy of the purchase order and sends it via mail to the supplier. As a final step, Lourdes sends an email to the accounts payable officer and the receptionist, providing them with a link that grants access to the purchase order from their respective computer terminals. All company computers are networked to a centralized accounting system, giving all involved parties access to the same information. When the…arrow_forwardGodaarrow_forward
- Scenario analysis allows a firm to ask what - if type questions in capital budgeting. Question 22Select one: True Falsearrow_forwardsolve question (c) with complete explanation asaparrow_forwardQUESTION 12 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the answer using the criterion of minimax regret? Alternatives Large Inventory Small Inventory Probability O A) -$2,000 O B) $130,000 O C) $0 O D) $20,000 O E) $153,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 .30arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education 
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.