Quantitative Assignment

User Generated

xnl83

Business Finance

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

Lemonade stand Inputs Fixed cost Quantity sold Unit price Unit cost Current profit Part (a): Use Goal Seek (set profit = 0, with cell B10 as the changing cell) New quantity sold New profit Part (b): Use a one-way data table Quantity sold Profit Part (c): Use a two-way data table (unit cost along top, quantity sold along side) Part (d): Use the Auditing toolbar to show the precedents of cell B9. Copy shop Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Months per year Copies per copier per year Profit model Copiers rented (trial value) Daily demand (trial value) Copies made Annual profit Part (a): Use two-way data table (copies rented along top, daily demand along side) Part (b): Use Goal Seek (set Profit = 0 with B27 as the changing cell) Copiers rented Daily demand Copies made Annual profit Part (c) Copiers rented (trial value) Daily demand Copies made Annual profit Two-way data table to get data for graph nonade stand. She believes unning the stand is $50.00. sell 300 cups per week e cost of producing a cup IS, what level of sales break even? :, discuss how a change discuss how a change ost jointly affect profit. tools to show which profit directly. c. Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influence profit. d. Use Excel's Formula Auditing tools to show which cells in the spreadsheet are directly affected by the percentage of seats full. 22. You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year. a. For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand. b. If you rent three copiers, what daily demand for copies will allow you to break even? c. Graph profit as a function of the number of copiers for a daily demand of 500 copies; for a daily demand of 2000 copies. Interpret your graphs. 23. Georgia McBeal is trying to save for her retirement. She believes she can earn 10% on average each year dway play, I Love ter! It will cost e are 8 shows will run for e theater each night. n average of $1.50 ns. The theater eats to be full / many weeks earn a 100% press NPV function =NPV(dis age Calculates NPV of a stream of cash flows at the ends of consecutive years, starting in year 1 1 PROBLEMS Level A c. Give joint of w d. Use 20. Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup of lemonade is $0.20. cel pe 22. You cost $0.0 of 1 Yo the a. Given her other assumptions, what level of sales volume will enable Julie to break even? b. Given her other assumptions, discuss how a change in sales volume affects profit. c. Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit. d. Use Excel's Formula Auditing tools to show which cells in your spreadsheet affect profit directly. 21. You are thinking of opening a Broadway play, I Love са a.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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,...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags