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

  Setting product-promotional and pricing strategies

When it comes to selling products in different countries, it is important to get as much information possible in terms of local taste, demand and culture. This determines how the company should approach the market locally. This will be our subject fo..

  What is the average number of jobs waiting for service

Gubser Welding, Inc., operates a welding service for construction and automotive repair jobs. Assume that the arrival of jobs at the company's office can be described by a Poisson probability distribution with an arrival rate of three jobs per 8-hour..

  Cost of holding a unit of inventory

In the basic EPQ model, if the cost of holding a unit of inventory for a year doubles, and all other values remain constant, will the EPQ value increase or decrease and by what percentage? Show Work

  Assignment on cost and quality

Create a Work Breakdown Structure (WBS), and assign resources and cost by using a project management tool. As the IT project manager, you have been assigned a project to deploy ten (10) wireless access points in your company's warehouse and break ..

  Identify leadership styles associated with path-goal theory

Identify four leadership styles associated with path-goal theory. Explain each style and relate it to styles described in other theories. Can leaders exhibit more than one style?

  Monsanto engages in poor ethical behavior

Every business wants to earn a profit as we have often discussed. At what point, however, does corporate lobbying mean that that a company like Monsanto engages in poor ethical behavior?

  What is the hitech act

What is the HITECH Act? What steps do we need to take in medical IT?

  Concerning the creation of tables

Concerning the creation of tables from an REA diagram, which of the following is false?

  Using probability analysis-decision tree model

A General Manger of Harley-Davidson has to decide on the size of a new facility. The GM has narrowed the choices to two: large facility or small facility. The company has collected information on the payoffs. It now has to decide which option is the ..

  What are enterprise architecture components

What are enterprise architecture components and how do they relate to/support a business process?

  Explain the different forecasting and reliability methods

Write at least a 4 pages essay (paragraphs of at least 5 sentences each), double spaced, 12-point font, explaining the importance of forecasting and reliability to the decision making of an of an organization. Be sure to include definitions and ..

  Total cost of moving the current order

Trucking company A says it will only charge 70 cents per ton per mile per widget to load on to a truck that holds 57,000 pounds. (Remember, it takes a lot of labor to load each truck!). What is the total cost of moving the current order of 20,250 ..

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