Planned sales-planned reductions-planned eom stock

Assignment Help Operation Management
Reference no: EM131139321

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: EM131139321

Questions Cloud

Segments of consumer population and consumption situations : Interpret the combined impact of external and internal influences on consumer purchasing patterns, specific to the coffee industry. Critique consumer attitudes toward the product or service. Determine linkages between segments of the consumer populat..
Improving process in the healthcare sytstem : If we can improve processes so that less mistakes are made, costs can go down so that more people can be hired at facilities, which will alleviate the work fatigue, which will increase quality of care. With appropriate staff, with the ability to work..
Three branch plants with excess production capacity : A certain corporation has three branch plants with excess production capacity. Fortunately, the corporation has a new product ready to begin production, and all three plants have this capability, so some of the excess capacity can be used in this way..
What are components of group diversity : What are the characteristics of effective teams? How do roles, needs, and diversity affect teamwork? Provide specific examples.What are components of group diversity?
Planned sales-planned reductions-planned eom stock : 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. Planned sales + Plan..
Consider the critical path method : Consider the Critical Path Method: Do you use it at work? If so, please share who uses it and describe how it helps you to make decisions. If not, do you think it is a helpful tool? Where could you use it? If you are a full-time student, describe how..
Wholesaler of disposable medical supplies : You are a rookie salesperson with Associated Medical Supplies, Inc., a wholesaler of disposable medical supplies. As a new salesperson, you are finding it difficult to convince accounts to switch from their current suppliers. What is the smallest siz..
Analyze combined impact of external and internal influences : Analyze the combined impact of external and internal influences on consumer purchasing patterns. Explain key trends of consumer behavior that are central to marketing planning and implementation. Evaluate how internal influences and trends relate to ..
Current multifactor productivity : Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. ..

Reviews

Write a Review

Operation Management Questions & Answers

  The chipping away at intel case study

After reading the "Chipping Away at Intel" case study, what was a pressure for change (internal, external, or environmental)? Give an example of a similar pressure for change that was experienced by another organization. Explain the difference betwee..

  Pre-breakup optimal capital structure

When the Bell System was broken up, the old AT&T was split into a new AT&T in addition to seven regional telephone companies. The specific reason for forcing the breakup was to increase the degree of competition in the telephone industry. Do you thin..

  Yield curve is downward sloping-yield curves for Tbond

If the yield curve is downward sloping, which of the following statements is correct? (hint: graph the yield curves for a Tbond, a AAA bond, and a B bond)

  Explain how the researchers implemented the design

Evaluate the research questions using the Research Questions and Hypotheses Checklist as a guide. Identify the type of qualitative research approach used and explain how the researchers implemented the design.

  What are the internal and external factors

What are the internal and external factors (HR/Business) that will affect the global organization today when doing business overseas.

  Compare and contrast the three organizational structures

Compare and contrast the three organizational structures discussed in the text: functional, project, and matrix. Provide examples that show the difference between the three, including some of the advantages and disadvantages of each.

  Which of the following takes the position that an election

Which of the following takes the position that an election should "provide a laboratory in which an experiment may be conducted, under conditions as nearly ideal as possible

  Analyze the characteristics of service quality

Demonstrate thoughtful consideration of the ideas and concepts that are presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sur..

  Training seminars must be stimulating and a challenge

To improve your listening skills, you should stop talking, your surroundings should be controlled, be listening for main points, and an open mind must be kept. Training seminars must be stimulating and a challenge.

  What are economies of scale in a manufacturing plant

What is operations management? Why is it important? Is a good knowledge of operations management more important in service or manufacturing industries? Explain your answer.

  Identify the stages of team development

Describe a situation in which you were part of a formal work group and one of the members of the group did not contribute much work to the project. How did the other group members deal with this person? How did this person's behavior affect the at..

  What are primary functions of human resources department

Within your post, support your responses with information from at least one peer-reviewed/scholarly source (not older than 3-5 years) from CSU Global online library or the Internet, and provide the full citation at the end. What are the primary funct..

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