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

  What is the effective yield of a T-Bill selling

What is the effective (annual) yield of a T-Bill selling at $97,645 with par value $100,000 and time to maturity of

  What are mortgage-backed securities

Exam question: Mortgage-backed securities. What are mortgage-backed securities and what was the idea behind their construction? Why did they not work as intended? How did these securities affect the banks, which issued them, during financial crisis o..

  About the earnings per share

Assume a stock selling for $44.89 has a dividend yield of 3.1 percent and a PE ratio of 20.1. What is the earnings per share (EPS) for the company?

  Company had cash and marketable securities worth

Winston Electronics reported the following information at its annual meetings. The company had cash and marketable securities worth $1,235,770, accounts payables worth $4,160,760, inventory of $7,121,760, accounts receivables of $3,489,160, notes pay..

  Provide a detailed description of the firms

Provide a detailed description of the firms-  Describe their primary activities and markets - Provide a three year ratio analysis with the financial statement - balance sheets, income statement, cash flow.

  How much would friend receive from sale of promissory note

How much would your friend receive from the sale of the promissory note?

  What must the expected return on this stock be

A stock has a beta of 1.25, the expected return on the market is 12 percent, and the risk-free rate is 2 percent. What must the expected return on this stock be?

  Analyzing stock market risk premiums over time

Assume you are analyzing stock market risk premiums over time. Which one of these would be the computation to use to compute the standard error of those premiums?

  About how cash flows are re-invested

What is the net present value's assumption about how cash flows are re-invested? a. they are reinvested at the IRR b. They are reinvested only at the end of the project c. They are reinvested at the SPR d. They are reinvested at the firm's discount r..

  Policy of quantitative easing benefit or hurt smaller

Did the Federal Reserve's policy of quantitative easing benefit or hurt smaller and more entrepreneurial firms over the past five years? What evidence supports your position?

  More attractive in terms of reacquainting the old bonds

Barton Simpson, the chief financial officer of Broadband, Inc., could hardly believe the change in interest rates that had taken place over the last few months. The interest rate on A2 rated bonds was now 6 percent. Compare the price in part A to the..

  Calculate the future value of the same investment

Calculate the future value of an investment, given the following characteristics: (a) PV: $30,000, (b) NPER: 25, (c) Rate: 5%. Using the information from Problem 1, calculate the future value of the same investment using daily compounding

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