Refer to the following hypothetical situation to come up with a linear programming solution maximizing profit for a local ice-cream shop. The objective: On average, you get $1 in revenue from every pound of ice cream you sell. You get $5 for every ice cream cake (neglect the cake size here) you sell in the market. You need to bring in as much revenue as you can to keep your shop running on a day-to-day basis. The decisions: You need to figure out what mix of ice creams (per pound) and the number of ice cream cakes to produce each month to maximize total profit. The constraints: It costs $0.5 or 50 cents to produce a pound of ice cream and $4 to produce one ice cream cake (on average). You have a budget of $100 per day to devote to producing new products for sale. You must also store this stuff in your 10 cubic meter freezer. Every pound of ice cream takes up .1 cubic meters once packed, and every cake (on average) takes up 0.25 cubic meters. You can't store these products elsewhere or they will spoil. Part 1. Represent this problem as a polytope and graph the feasible region for this problem. Use excel to plot the graph. Part 2. Use Excel to solve this optimization problem using linear programming.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Refer to the following hypothetical situation to come up with a linear programming solution maximizing profit for a local ice-cream shop.
1. The objective: On average, you get $1 in revenue from every pound of ice cream you sell. You get $5 for every ice cream cake (neglect the cake size here) you sell in the market. You need to bring in as much revenue as you can to keep your shop running on a day-to-day basis.
2. The decisions: You need to figure out what mix of ice creams (per pound) and the number of ice cream cakes to produce each month to maximize total profit.
3. The constraints: It costs $0.5 or 50 cents to produce a pound of ice cream and $4 to produce one ice cream cake (on average). You have a budget of $100 per day to devote to producing new products for sale. You must also store this stuff in your 10 cubic meter freezer. Every pound of ice cream takes up .1 cubic meters once packed, and every cake (on average) takes up 0.25 cubic meters. You can't store these products elsewhere or they will spoil.

Part 1. Represent this problem as a polytope and graph the feasible region for this problem. Use excel to plot the graph.

Part 2. Use Excel to solve this optimization problem using linear programming.

Handwritten will work, but part 2 must be in excel

Expert Solution

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions