The owner of a newsstand estimates the weekly fixed cost to be $50. The owner expects to sell 300 newspapers per week at $1.50 per newspaper. The variable cost per c newspaper is $0.50.
a. What level of sales volume will allow the owner to break even?
b. How does a change in sales volume (range 100-500 in increments of 50) affect profit?
c. How does a joint change in sales volume (range 100-500 in increments of 50) and variable cost (range $0.20 and $1 in increments of $0.1) affect profit?
| 1 | per unit | |||||||||
| Sales | $1.50 | |||||||||
| Variable cost | $0.50 | |||||||||
| Contribution | $1.00 | |||||||||
| Fixed Cost | $50 | |||||||||
| Break Even Point = | Fixed cost/Contribution per unit | |||||||||
| = | $50/1 | |||||||||
| = | 50 | Units | ||||||||
| 2 | Units | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 |
| Sales | $150.00 | $225.00 | $300.00 | $375.00 | $450.00 | $525.00 | $600.00 | $675.00 | $750.00 | |
| Variable cost | $50.00 | $75.00 | $100.00 | $125.00 | $150.00 | $175.00 | $200.00 | $225.00 | $250.00 | |
| Contribution | $100.00 | $150.00 | $200.00 | $250.00 | $300.00 | $350.00 | $400.00 | $450.00 | $500.00 | |
| Fixed Cost | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
| Profit | $50.00 | $100.00 | $150.00 | $200.00 | $250.00 | $300.00 | $350.00 | $400.00 | $450.00 | |
| Note: Profit will increase constantly $50 as an increase in units by 50 units | ||||||||||
| 3 | Units | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 |
| Sales | $150.00 | $225.00 | $300.00 | $375.00 | $450.00 | $525.00 | $600.00 | $675.00 | $750.00 | |
| Variable cost | $20.00 | $45.00 | $80.00 | $125.00 | $180.00 | $245.00 | $320.00 | $405.00 | $500.00 | |
| Contribution | $130.00 | $180.00 | $220.00 | $250.00 | $270.00 | $280.00 | $280.00 | $270.00 | $250.00 | |
| Fixed Cost | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
| Profit | $80.00 | $130.00 | $170.00 | $200.00 | $220.00 | $230.00 | $230.00 | $220.00 | $200.00 | |
| Note: Profit will increase as an increase in units but after 350 units | ||||||||||
| profit will stop increasing to 400 units and after that profit will start decreasing. | ||||||||||
The owner of a newsstand estimates the weekly fixed cost to be $50. The owner expects...
The owner of a newsstand in a college community estimates the weekly demand for a certain magazine as follows. Quantity Demanded 10 11 12 13 14 15 Probability 0.20 0.15 0.30 0.10 0.05 0.20 Find the number of issues of the magazine that the newsstand owner can expect to sell per week. (Enter your answer to two decimal places.) issues
Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week of running the stand is $50.00.Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20. A. Given her other assumptions, using Excel, find the level of sales volume that will enable them to break even. B. Given her other assumptions, draw a break even graph and discuss...
Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week of running the stand is $50.00.Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20. A. Given her other assumptions, using Excel, find the level of sales volume that will enable them to break even. B. Given her other assumptions, draw a break even graph and discuss...
On consecutive Sundays, Mac, the owner of a local newsstand, purchases a number of The Supply Chain Digest, a popular weekly magazine. He pays $25 for each copy and sells it for $75 per copy. Copies he has not sold during the week can be salvaged for $2 each. Mac’s newsstand sees a weekly demand for the magazine to be approximately uniformly distributed with the range [50, 75]. Since Mac is a very close associate of his publisher, he conveys...
please show the excel file created and equations used to do so.
thank you!
Problem 2: Freddie's Newsstand - decision making Consider the following problem being faced by a newsboy named Freddie. One of the daily newspapers that Freddie sells from his newsstand is the Financial Journal. A distributor brings the day's copies of the Financial Journal to the newsstand early each morning. Any copies unsold at the end of the day are returned to the distributor the next morning....
The price per cup is still S0.50, and the fixed cost is $50. The variable cost per cup from the materials except lemons, such as water and cup, amounts to $0.05. One lemon is enough to produce two cups of lemonade. The store, from which she buys lemons, offers a volume discount as follows. For the total purchase fewer than 100 lemons, each lemon costs $0.40 For the total purchase fewer than 200, each costs $0.38, For the total purchase...
1) At the break even point of 400 units, variable cost were $400 and fixed costs were $200. how much will the 401st unit sold contribute to operating profit before income taxes? 2) Break even would not change if : a) sales price increases, b) fixed cost decrease, c) sales volume decrease, d) variable cost per unit increase 3) what is break even point in dollars? sales price: $100, variable cost per unit: $40, total fixed cost :$ 120,000 4)...
Anna Sheen, upon graduating from a Boston-area university with a degree in journalism and operations research, returned to her hometown of Hamptonshire, Pennsylvania, to start a daily newspaper. The Hamptonshire Express emphasized local news, which Sheen believed was not adequately covered by big-city newspapers such as the The Philadelphia Inquirer, Pittsburgh Post-Gazette, and The New York Times. Working in leased space that cost approximately $10 per day, Sheen wrote stories and articles daily around news and feature material that she...
The owner of Brooklyn Restaurant is disappointed because the restaurant has been averaging 10,000 pizza sales per month, but the restaurant and wait staff can make and serve 12,500 pizzas per month. The variable cost or example, ingredients) of each pizza is $1.50. Monthly fixed costs (for example, depreclation, property taxes, business license, and managers salary) are $11,000 per month. The owner wants cost information about different volumes so that some operating decisions can be made Read the requirements. Requirement...
additional instructions to follow:
4. Samantha and Sabrina are opening a soda stand. They believe the fixed cost per week of running the stand is $50.00. Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20 Given her other assumptions, and using Excel, find the level of sales volume a. that will enable them to break even. Given her other assumptions, draw a...