Abby has always dreamed of having her own ice cream shop. Now as a young entrepreneur she has decided to pursue her dream, but she needs some help in determining the financial viability of her plan. She has come up with a list of income and expense parameters and needs a simple program to input these parameters and calculate the monthly profit or loss as well as performing some variable cost what-if analysis.

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
icon
Related questions
Question
100%
Abby has always dreamed of having her own ice cream shop. Now as a young entrepreneur she has decided to pursue her dream, but she needs some help in determining the financial viability of her plan. She has come up with a list of income and expense parameters and needs a simple program to input these parameters and calculate the monthly profit or loss as well as performing some variable cost what-if analysis.
shop.py
57 Percent: 6 Expenses: 2024.6 Profit/Loss: -24.6
58 Percent: 8 Expenses: 2062.8 Profit/Loss: -62.8
59 Varying the Income +/-10%:
-110.0
60 Percent: -10 Income: 1800.0 Profit/Loss:
61 Percent: -8 Income: 1840.0 Profit/Loss: -70.0
62 Percent: -6 Income:
63 Percent: -4 Income:
64 Percent: -2 Income:
65 Percent: 0 Income:
66 Percent: 2 Income:
67 Percent: 4 Income:
68 Percent: 6 Income:
1880.0 Profit/Loss: -30.0
1920.0 Profit/Loss: 10.0
1960.0 Profit/Loss: 50.0
2000.0 Profit/Loss: 90.0
2040.0 Profit/Loss: 130.0
2080.0 Profit/Loss: 170.0
2120.0 Profit/Loss: 210.0
69 Percent: 8 Income: 2160.0 Profit/Loss: 250.0
70
71 Bonus:
72 Add functionality that will that use the current expenses and sales volume but
73 vary the sale price until the "break-even" point is found. If the initial calculation
74 is positive then reduce the price iteratively and if negative, increase the price
75 iteratively (think loop). Note that your algorithm doesn't have to find the exact
76 break even point, only the point where it changes from negative to positive or
77 positive to negative
X
+
78
79 10. Find Break-Even
80
81 Enter Selection (0 to Exit): 10
82 Break-Even occurs with a selling price of: 5.7
83
84
MacBook Pro
Search or type URL
A-Z
470
HUT
Transcribed Image Text:shop.py 57 Percent: 6 Expenses: 2024.6 Profit/Loss: -24.6 58 Percent: 8 Expenses: 2062.8 Profit/Loss: -62.8 59 Varying the Income +/-10%: -110.0 60 Percent: -10 Income: 1800.0 Profit/Loss: 61 Percent: -8 Income: 1840.0 Profit/Loss: -70.0 62 Percent: -6 Income: 63 Percent: -4 Income: 64 Percent: -2 Income: 65 Percent: 0 Income: 66 Percent: 2 Income: 67 Percent: 4 Income: 68 Percent: 6 Income: 1880.0 Profit/Loss: -30.0 1920.0 Profit/Loss: 10.0 1960.0 Profit/Loss: 50.0 2000.0 Profit/Loss: 90.0 2040.0 Profit/Loss: 130.0 2080.0 Profit/Loss: 170.0 2120.0 Profit/Loss: 210.0 69 Percent: 8 Income: 2160.0 Profit/Loss: 250.0 70 71 Bonus: 72 Add functionality that will that use the current expenses and sales volume but 73 vary the sale price until the "break-even" point is found. If the initial calculation 74 is positive then reduce the price iteratively and if negative, increase the price 75 iteratively (think loop). Note that your algorithm doesn't have to find the exact 76 break even point, only the point where it changes from negative to positive or 77 positive to negative X + 78 79 10. Find Break-Even 80 81 Enter Selection (0 to Exit): 10 82 Break-Even occurs with a selling price of: 5.7 83 84 MacBook Pro Search or type URL A-Z 470 HUT
amed
e
3
=
she
e her
S
ining
of
me up
and
s and
ram to
ters
onthly
as
riable
S.
auto-
y
shop.py
+
28 8. Profit/Loss Calculation
29 9. "What If" analysis with 10% variance
30
31 Enter Selection (0 to Exit):
32
33
34 Menu items 1 - 7 should display the current value of the category and allow
35 the user to change it.
36
37 Menu item 8 should display a single value indicating the amount of profit or
38 loss. It should then, while holding the income fixed, vary the expenses from
39 to 10 percent in 2 percent increments and outputting the values and the
40 resulting profit or loss in a table. Finally, while holding the expenses
41 fixed, vary the income parameters from to + 10 percent in 2 percent increments.
42
X
43 Sample Output:
44 Enter Selection (0 to Exit): 8
45 The Ice Cream Shop will have a monthly profit/loss of 90.0 or 4.0 per serving.
46
I
47 Enter Selection (0 to Exit): 9
48 Varying the Expenses +/-10%:
49 Percent: -10 Expenses: 1719.0 Profit/Loss: 281.0
50 Percent: -8 Expenses: 1757.2 Profit/Loss: 242.8
51 Percent: -6 Expenses:
52 Percent: -4 Expenses:
53 Percent: -2 Expenses:
54 Percent: 0 Expenses:
55 Percent: 2 Expenses:
56 Percent: 4 Expenses:
↓
1795.4 Profit/Loss: 204.6
1833.6 Profit/Loss: 166.4
1871.8 Profit/Loss: 128.2
90.0
1910.0 Profit/Loss:
1948.2 Profit/Loss: 51.8
1986.4 Profit/Loss:
13.6
C
MacBook Pro
Search or type URL
☆
A-Z
RT
Transcribed Image Text:amed e 3 = she e her S ining of me up and s and ram to ters onthly as riable S. auto- y shop.py + 28 8. Profit/Loss Calculation 29 9. "What If" analysis with 10% variance 30 31 Enter Selection (0 to Exit): 32 33 34 Menu items 1 - 7 should display the current value of the category and allow 35 the user to change it. 36 37 Menu item 8 should display a single value indicating the amount of profit or 38 loss. It should then, while holding the income fixed, vary the expenses from 39 to 10 percent in 2 percent increments and outputting the values and the 40 resulting profit or loss in a table. Finally, while holding the expenses 41 fixed, vary the income parameters from to + 10 percent in 2 percent increments. 42 X 43 Sample Output: 44 Enter Selection (0 to Exit): 8 45 The Ice Cream Shop will have a monthly profit/loss of 90.0 or 4.0 per serving. 46 I 47 Enter Selection (0 to Exit): 9 48 Varying the Expenses +/-10%: 49 Percent: -10 Expenses: 1719.0 Profit/Loss: 281.0 50 Percent: -8 Expenses: 1757.2 Profit/Loss: 242.8 51 Percent: -6 Expenses: 52 Percent: -4 Expenses: 53 Percent: -2 Expenses: 54 Percent: 0 Expenses: 55 Percent: 2 Expenses: 56 Percent: 4 Expenses: ↓ 1795.4 Profit/Loss: 204.6 1833.6 Profit/Loss: 166.4 1871.8 Profit/Loss: 128.2 90.0 1910.0 Profit/Loss: 1948.2 Profit/Loss: 51.8 1986.4 Profit/Loss: 13.6 C MacBook Pro Search or type URL ☆ A-Z RT
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Probability Problems
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education