Answered: What is the break-even volume per…

What is the break-even volume per evening performance? How much wine would you expect to sell each evening at the break-even point?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
You are the owner of Caché, a chain of women's clothing boutiques. Your state has a sales tax of 7%, and your city has an additional sales tax of 1.5%. Each quarter you are responsible for making these tax deposits to the city and state. Last quarter your stores had total revenue, including sales tax, of $488,250. a) How much of this revenue was sales (in $) and how much was sales tax (in $)? sales sales tax b) How much sales tax (in $) should be sent to the city? c)How much sales tax (in $) should be sent to the state?
4.1REQUIREDStudy the information given below and calculate the following if the sales manager’s proposal is accepted:4.1.1 Break-even quantity.4.1.2 The number of units that must be sold to achieve the company’s profit objective. INFORMATIONSirloin Enterprises manufactures a product that sells for R9 each. The company presently produces and sells 90 000 units per year. Total variable manufacturing costs and selling costs are R405 000 and R81 000 (10% of sales) respectively. Fixed costs are R226 440 for manufacturing overheads and R97 200 for selling and administrative activities.The sales manager has proposed that the price be increased to R10.80 per unit. The company’s profit objective is 10% of sales. 4.2 ENO Ltd, a pharmaceutical company, is seeking finance for the development of a vaccine aimed at reducing the spread the Corona virus. The company is seeking funding only from the public in the form of equity as well as long-term borrowing.In light of the above, critically discuss…
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
George Fine, owner of Fine Manufacturing, is consideringthe introduction of a new product line. George has consideredfactors such as costs of raw materials, new equipment, andrequirements of a new production process. He estimates that thevariable costs of each unit produced would be $8 and fi xed costswould be $70,000.(a) If the selling price is set at $20 each, how many unitshave to be produced and sold for Fine Manufacturingto break even? Use both graphical and algebraicapproaches.(b) If the selling price of the product is set at $18 per unit,Fine Manufacturing expects to sell 15,000 units. Whatwould be the total contribution to profi t from this productat this price?(c) Fine Manufacturing estimates that if it off ers the productat the original target price of $20 per unit, the companywill sell about 12,000 units. Which pricing strategy—$18per unit or $20 per unit—will yield a higher contributionto profi t?(d) Identify additional factors that George Fine shouldconsider in deciding…
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
Williams & Williams Co. produces plastic spray bottles and wants to earn a before-tax profit of$200,000 next quarter. Variable cost is $0.50 per bottle, fixed costs are $400,000, and the selling priceis $1 per bottle. How many bottles must the company sell to meet its profit goal?
Choose the correct letter of answer If your objective is to maximize the profit for products x and y which earns a contribution margin of P2 and P3 respectively, your objective function must be: *a. P = 3x + 2yb. P = 2x + 3yc. P = x + y d. none of the above
Financial ratio analysis is conducted by three main groups of analysts: credit analysts, stock analysts, and managers. What is the primary emphasis of each group, and how would that emphasis affect the ratios on which they focus? Why would the inventory turnover ratio be more important for someone analyzing a grocery store chain than an insurance company? Over the past year, M.D. Ryngaert & Co. had an increase in its current ratio and a decline in its total asset’s turnover ratio. However, the company’s sales, cash, and equivalents, DSO, and fixed assets turnover ratio remained constant. What balance sheet accounts must have changed to produce the indicated changes? Profit margins and turnover ratios vary from one industry to another. What differences would you expect to find between the turnover ratios, profit margins, and DuPont equations for a grocery store and a steel company? How does inflation distort ratio analysis comparisons for one company over time (trend analysis) and…
You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
2. Analyze the situation and answer the following questions. Ed and Barbara Bonneau started their wholesale sunglass distribution firm 30 years ago with $1,000 of their own money and $5,000 borrowed from a country banker in Ed’s hometown. The firm grew quickly, selling sunglasses and reading glasses to such companies as Wal-Mart, Eckerd Drugs, and Phar-Mor. In addition, the Bonneaus enjoyed using the company to do good things. For example, they had a company chaplain, who was available when employees were having family problems, such as a death in the family.Although the company had done well, the market had matured recently and profit margins narrowed significantly. Wal-Mart, for example, was insisting on better terms, which meant significantly lower profits for the Bonneaus. Previously, Ed had set the prices that he needed to make a good return on his investment. Now, the buyers had consolidated, and they had the power. Ed didn’t enjoy running the company as much as he had in the…
The fixed costs of Chun Company are $309,000 and the total variable costs for its only product are 45% of the sales price, which is $100. Chun currently sells 7,400 units per month and is looking to sell more. Consider each of the following independently: Part A The marketing manager is considering lowering base salaries of salespeople by a collective amount of $39,000 per month while increasing the sales commission by $8 per unit. He believes this will increase monthly sales by 130 units. If so, what would the effect of this change in compensation have on monthly income? INCREASE OR DECREASE of $BLANK Part B Management believes monthly sales can be increased by 570 units if additional quality control steps are taken. These steps would mean an increased variable cost per unit of $10. What is the expected effect on the company's monthly income of adding these additional quality control steps? (DECREASE OF 48,350, DECREASE OF 54050, DECREASE OF 48892, OR INCREASE BY 25650)