Reference no: EM132917471
The Pizza Man is a local shop that plans to make its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's owners know that customers will buy by the slice andany kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizzas. Each variety has its own requirement of sauce, cheese, dough, and toppings (in ounces as shown in the table), and each has its own selling price.
Plain Meat Vegetables Supreme Available
Dough 5 5 5 5 200
Sauce 3 3 3 3 90
Cheese 4 3 3 4 120
Meat 0 3 0 2 75
Vegetables 0 0 3 2 40
Price $8 $10 $12 $15
The Pizza Man would like to determine what the right combination of pizzas to make (using its existing stock of ingredients) to maximize revenue from its sales.
a) Write the Linear Program formulation for the above optimization problem. Make your fo1mulation clear by defining the variables, constraints, objective function etc. clearly.
b) Solve it using Excel solver. Please attach your Solver model and output (including Answer and Sensitivity Report) as a separate document with a snapshot of solver dialog box and all formulas.
c) What is the maximum sales revenue? What mix of pizzas should be made to achieve this sales revenue?
d) Which ingredients are economically scarce (i.e. they are limiting our profits)?
|
What is the original price of each handbag
: A reseller bought 50 handbags that cost P40,000.00. The reseller availed 10 % trade discount for this transaction. What is the original price of each handbag
|
|
What data you are planning to collect
: The data collection plan, also called research procedures, is a significant piece of Chapter 3. It describes to the reader what data you are planning to collect
|
|
Bridge between healthcare administrators
: How do you believe nurse informaticists helps provide the bridge between healthcare administrators or decision makers and the staff nurse at the bedside?
|
|
Implementation of health care technology
: Why is the system selection process so vital to the use and implementation of health care technology? Provide details.
|
|
Write the linear program formulation
: The Pizza Man is a local shop that plans to make its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's
|
|
What is the irr that brian lee management can expect
: Management of Brian Lee, If the appropriate discount rate is 14 percent, what is the IRR that Brian Lee management can expect on this project?
|
|
Nature and dimensions of corporate culture
: You will analyze the nature and dimensions of the corporate culture at the various stages of organizational growth.
|
|
How much is the cost of the obsolete inventories
: DNB Enterprise's closing inventories valued at cost RM600,000. How much is the cost of the obsolete inventories
|
|
Advocacy and community practice proposal
: Explain how to apply a social media tool to develop a local initiative. The social media tool may be the use of Facebook, Skype, Twitter, a blog, or others
|