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

  Product process matrix for analysis

Product Process Matrix For Analysis

  Discuss customer integration and satisfaction ?change

Discuss Customer Integration and Satisfaction?Change. The initial post must include in text citations, 250 words, APA format and a reference list. Conclusion should have a question for other students to answer and ponder.

  Nutritional requirements are met while minimizing feed costs

The Beef-up ranch feeds cattle for midwestern farmers and delivers them to processing plants in Topeka, Kansas and Tulsa, Oklahoma. The ranch must determine the amounts of catlle feed to buy so that variouis nutritional requirements are met while min..

  Describe the six categories of cost.

Describe the six categories of cost. Additionally, discuss which ones are used in making an incremental cost analysis and why.

  Wholesalers as channel members or sell directly to retailers

Janet Hains is an entrepreneur and former afterschool programmer administrator. She has been monitoring the education industry for potential trends that may provide an opportunity for her to utilize her experience in starting a new business. Assess t..

  Tough time in the world nowadays both locally and globally

Women are having a tough time in the world nowadays both locally and globally. Review the resources for the week and select an issue to discuss and please propose some actions we can take to make the situation better.

  New product development here is the questionfirst identify

new product development. here is the questionfirst identify the steps that a musician would have to take in order to

  What benefits or opportunities does diversity provide

What benefits or opportunities does diversity provide. After a brief research regarding diversity in a healthcare organization, identify some of the best practices for managing and leading in the midst of diversity. These best practices might come..

  Spurred by effective curbs in the acute care setting

Spurred by effective curbs in the acute care setting, Congress authorized DHHS to design and implement reformed payment systems in many settings for ambulatory patients. What is the impact these reimbursement systems have had on:

  Discussion on the standardization of the life safety code

Assume you are sitting around the table in the fire station and having a discussion on the standardization of the life safety code or fire and building codes which would be applied on a national level. Is a national code a good idea or bad idea? Why ..

  Discuss the key factors that impact location decisions

Discuss the key factors that impact location decisions. As an example, if locating a facility in India, what location decisions would a fast-food chain have to consider as compared to the location decisions of a software company?

  Develop brand equity for their products

What is your understanding of the term: Brand Equity? How do marketers develop brand equity for their products/services relative to competition? Provide an example of a brand/product/service.

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