Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?

Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?

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

Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?
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%.
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?
The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…
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…
Calculate the weighted average cost of capital for Foggy Futures Weather Forecasters.The firm is in the 25% tax bracket. The optimal capital structure is listed below:SOURCE OF CAPITAL WEIGHTDebt 20%Preferred Stock 30%Common Stock 50% DebtThe firm can issue $1000 par value, 9% coupon interest bond with a 15 year maturity date. The bond has an average discount of $20 and flotation costs of $30 per bond. The selling price is $1,000Preferred Stock The firm can sell preferred stock with a dividend that is 10% of the current price of $95. The cost of issuing and selling the stock is expected to be $7 per shareCommon Stock The firm's common stock is currently selling for $100 per share. The firm expects to pay cash dividends of $12 per share next year. The dividends have been growing at 8%. The stock was discounted by $7, and the flotation costs amounted to $5 per share.
A few years ago, Michael purchased a home for $394,000. Today, the home is worth $520,000. His remaining mortgage balance is $166,000. Assuming Michael can borrow up to 80 percent of the market value of his home, what is the maximum amount he can borrow?
It is often difficult to estimate the expected future dividend growth rate for use in estimating the cost of existing equity using the DCF or DG approach. In general, there are three available methods to generate such an estimate: • Carry forward a historical realized growth rate, and apply it to the future. • Locate and apply an expected future growth rate prepared and published by security analysts. • Use the retention growth model. Suppose Johnson is currently distributing 45% of its earnings in the form of cash dividends. It has also historically generated an average return on equity (ROE) of 20%. Johnson’s estimated growth rate is %.
A local finance company quotes a 16 percent interest rate onone-year loans. So, if you borrow $26,000, the interest for the year will be $4,160. Because you must repay a total of $30,160 in one year, the finance company requiresyou to pay $30,160y12, or $2,513.33, per month over the next 12 months. Is this a15 percent loan? What rate would legally have to be quoted? What is the effectiveannual rate?
Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.