Average monthly sales and average monthly on order

Assignment Help Financial Management
Reference no: EM131185159

If the Open to buy for each month is :

February: $30,400.00 March: $31,250.00 April: $127,800.00 May: $162,000.00 June: $377,550.00 July: $127,500.00

Using the figures provided you will calculate the following for the XYZ store.

1. Average monthly sales 2. Average monthly on order 3. Markdown % for each month

*** Planned sales + Planned reductions +Planned EOM Stock = Total monthly needs -BOM Stock =Planned purchases -Merchandise on order =Open to buy (At Retail)***

Planned sales   On order     Employee Discount      MD$        Shortages    EOM           BOM

Feb.                 $300,000       $125,000              2%       $8,000          2%       $200,000    $160,000

Mar.                 $200,000          $30,000                 3%       $12,000        4%       $80,000      $40,000

Apr.                 $300,000          $150,000              4%       $4,000          5%       $110,000    $90,000

May                 $200,000          $100,000              0%       $3,000          7%       $90,000      $60,000

June                 $400,000          $150,000              5%       $18,000        2%       $210,000    $150,000

July                  $200,000          $30,000                 7%       $25,000        3%       $70,000      $30,000

Reference no: EM131185159

Questions Cloud

The cost of debt equals the risk-free rate : Assume a firm's debt is risk-free, so that the cost of debt equals the risk-free rate, Rf Define BA as the firm's asset beta- that is, the systematic risk of the firm's assets. Define B E to be the beta of the firm's equity. Use the capital asset pri..
Company has expected unlevered-after-tax cash flow : Your company has an expected unlevered, after-tax cash flow for the next two years of $281,000. Then (from year 3) it will decrease to $278,400, and stay constant forever. The company also has a constant debt of $4 million. The interest rate paid by ..
What is the price of put option with the same exercise price : A stock is currently selling for $56 per share. A call option with an exercise price of $60 sells for$6.56 and expires in three months. If the risk-free rate of interest is 2.60%per year, compounded continuously, What is the price of a put option wit..
What is the value of one warrant : A bond with 20 detachable warrants has just been offered for sale at $1,000. The bond matures in 25 years and has an annual coupon of $48. Each warrant gives the owner the right to purchase two shares of stock in the company at $45 per share. Ordinar..
Average monthly sales and average monthly on order : If the Open to buy for each month is : February: $30,400.00 March: $31,250.00 April: $127,800.00 May: $162,000.00 June: $377,550.00 July: $127,500.00. Using the figures provided you will calculate the following for the XYZ store. Average monthly sale..
What is the tax advantage of merger each year for webster : Tax benefits and price Hahn Textiles has a tax loss carry forward of $800,000. Two firms are interested in acquiring Hahn for the tax loss advantage. Reilly Investment Group has expected earnings before taxes of $200,000 per year for each of the next..
Demonstrate the importance of cost management : You manage an operating budget of approximately $500,000. You have been instructed to cut your budget by 10 percent two months after you had agreed to a barebones budget for the upcoming year. What do you do if you know that the cuts will affect pati..
Difference between fixed-variable and semivariable costs : As policymakers and healthcare managers consider various ways to contain the rising costs of health care, it is useful to examine the patterns and elements of health care costs that are needed to run the United States delivery system. Explain the dif..
Taxable income and corporation income : Corporation Growth has $87,000 in taxable income, and Corporation Income has $8,700,000 in taxable income. Use the tax rates from Table 2.3. (Do not round intermediate calculations.). What is the tax bill for each firm? Firms Taxes Corporation Growth..

Reviews

Write a Review

Financial Management Questions & Answers

  Solved using rate of return analysis

The problem below must be solved using rate of return analysis. Type B equipment has an installed cost of $9,000, a uniform annual benefit of $1,600, a salvage value of $3000, and a useful life of 6 years. Type A equipment has an installed cost of $1..

  What is the probability that european call option on stock

A stock price follows a geometric Brownian motion with an expected return of 15% and a volatility of 30%. The current price is $39. What is the probability that a European call option on the stock with an exercise price of $40 and a maturity date in ..

  The futures price for gold for three month contract on gold

The spot price for gold is $1,300 per ounce. The dividend yield on the S&P 500 is 5.4%. The risk-free interest rate is 7.5%. The futures price for gold for a 3-month contract on gold should be __________.

  What will the expected growth rate be next year

Exim Inc. reported a return on capital of 12% on its existing assets and a reinvestment rate of 60% in the most recent year. It expects to improve its return on capital to 15% next year on both its existing and new investments, while maintaining its ..

  Transfer fee charged on any balances transferred

Your Christmas ski vacation was great, but it unfortunately ran a bit over budget. All is not lost, because you just received an offer in the mail to transfer your $ 10,000 balance from your current credit card, which charges an annual rate of 18.6 %..

  Compute the levered bheta

We have the Washington firm on which we have the following information. Its bheta unlevered is 3, its D/E is 4/1, and its tax rate is .3. Additionally we know that the default free rate is 5% and the stock market has returned 11 % over a long period ..

  Pension plan is obligated to make disbursements

A pension plan is obligated to make disbursements of $1 million, $2 million, and $1 million at the end of each of the next three years, respectively. The annual interest rate is 10%. If the plan wants to fully fund and immunize its position, how much..

  Brokerage account-time to reach a financial goal

You have $44,524.78 in a brokerage account, and you plan to deposit an additional $4,000 at the end of every future year until your account totals $270,000. You expect to earn 12% annually on the account. How many years will it take to reach your goa..

  Gain access to document needed to support transaction

Imagine that you were a preparer of a client's return and are unable to gain access to a document needed to support a transaction. You had asked the client numerous times for this item and you were finally presented with an email from the CEO stating..

  Compute the cost of not taking the cash discounts

Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not round intermediate calculations. Input your final answers as a percent rounded to 2 decimal places.) Cost of Lost Discount

  Considering substantial investment in the stock

Kruger Associates is considering a substantial investment in the stock of McIntyre Enterprises. McIntyre currently (time 0) pays a dividend of $1.50 per share. This dividend is expected to grow at 15 percent per year for the next 3 years and 10 per- ..

  What are some indications that investors are risk averse

What are some indications that investors are risk averse? How would you as a portfolio manager support these investors? What kind of recommendations would you make? What would you recommend as a portfolio manager to reduce the risk for a risk adverse..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd