Description
Question is attached as a file, it is from the book!!!!!! Also please note that the 3rd file is the format that is required for the excel. Please use the two separated spreadsheet that is in the preformatted excel file.
Please use original file. you must have access to the text book, if not please let me know prior to bidding.
Practical Management Science (5th Edition) winston/albright
- Problem 20, page 61: Make sure to review Section 2.4 of the textbook to guide you through the skills needed to solve this problem.
- Problem 22, page 61: Make sure to review Section 2.5 of the textbook to guide you through the skills needed to solve this problem.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is the answer. Thanks
Lemonade stand
Inputs
Fixed cost
Quantity sold
Unit price
Unit cost
$50
300
$0,50
$0,20
Current profit
$40
Part (a): Use Goal Seek (set profit = 0, with cell B10 as the changing cell)
New quantity sold
New profit
166,67
$0
Part (b): Use a one-way data table
Quantity Sold
125
150
175
200
225
250
275
300
325
350
Profit
-12,50
-5,00
2,50
10,00
17,50
25,00
32,50
40,00
47,50
55,00
Comment: As the quanity sold increase, profit of the
company increases. There is a positive relationship in
between profit and quantity sold.
Unit Variable Cost
Part (c): Use a two-way data table (unit cost along top, quantity sold along side)
$0,05
$0,10
$0,15
$0,20
$0,25
$0,...