Inventory Proposal Essay

1329 words - 6 pages

Inventory Proposal

Name

QRB/501

August 22, 2012
Instructor

Inventory Proposal

In reviewing the Summer Historical Inventory Data (SHID) Team A has determined that not enough information is provided to make sound business decision. Using poor information to make decision can hinder an organization further than its current problems. SHID shows highs over the summer months. Team A had identified that crude oil companies experence similar spike in sales. Certain times of the year the usage of crude oil experiences highs, summer month because of travel. By examining the SHID and adding some needed variables, Team A will be able to make the sound decision that the organization ...view middle of the document...

So, we started breaking down the information into small segments to get a better grasp of the company’s sales performance over time. The simple chart listed as Figure 2 represents the total demand in sales over a four year period.
| | | |
|4 Year Totals | |
|Year |Total | |
|1 |457350 | |
|2 |487030 | |
|3 |537620 | |
|4 |550750 | |

Figure 2
With this chart we can see there is an increase in sales each year. Understanding this is helpful because it begins to shed light on the company’s true performance.
Monthly Break Down
The SHID displays data in months over period four years. This information is used to determine the company’s busy and slow months of the years. However, the data presented is in a format difficult to simply view and understand. (Refer to Figure 1) Once the data is placed on an Excel sheet and broken down for each year, we can see the strong and weak months. Below is listing of each year using scatter shot on Microsoft Excel.
Year 1
[pic]

Year 2
[pic]
Year 3
[pic]

Year 4
[pic]
You can see for the year’s one, three, and four the strongest months are May, June, July and August. The second year was steady year, with the month of August being the best month. The second year was better than the first year. Year 2’s average sales were $40,586.00 which was slightly higher than the first year with an average of $38,113.00. But there were no high sales over consecutive months. There is no method for determining why the 2nd year did not follow the same trend as the other years. Despite the second year being somewhat off, the trend for all years shows strong sales early and slowly tapering off towards the end of the year.
To show the probability of data in SHID Team A has chosen to incorporate a histogram, Figure 3. “Histograms illustrate the process distribution and are used to make predictions about a stable process. If the system is unstable, the histogram will have little predictive value” (PQ systems, 2012). Understanding the trending information of what Team A is predicting for the future value of our organization, we can evaluate a series of numbers for accuracy. Constructing the bars in this histogram is a way to evaluate a series of quantitative information other than probabilities. Team A is trying to show the frequency of occurrence in our data so we decided to use this graph to illustrate our statistical...

Other Essays Like Inventory Proposal

Activity Based Costing Essay

1518 words - 7 pages shows 30% savings in wages which represents $257 K it also shows the steps in details to improve each activity involved in this proposal. On the other hand there is no schedule for implementation and also the managerial resources needed to pull it off knowing that managerial resource are scarce. Manage Work-In-Progress And Finished Goods Inventory Space This proposal saves annually $808 K however it has a price tag of $583 K which is the cost

Service Request Sr-Rm-004, Part 2 Essay

1215 words - 5 pages objective in implementing a new inventory management process is to increase revenue and financial stability. Automation of the inventory management system will lessen human discrepancies/errors thus minimizing lost revenue/cost. The system will also minimize the time the current staff would need to enter manually inventory data allowing the company to effectively use those resources in other areas of the organization. This proposal outlines the need

Proposal for Riordan Manufacturing Ops 571

1102 words - 5 pages Proposal for Riordan Manufacturing OPS/571 August 21, 2012 PRODUCTION STRUCTURE FAN Fan Mold for blades and housing Fan Motor HDPE Pellets (Polymers) Other Miscellaneous items Forecast Order Order Motors and Put in Storage No Motors in Storage Area? Ye s Ye s Polymers in Storage area? Custom No Order Polymers and Put in Storage Standard or Custom? Melt polymers and inject into molds Research

Supply Chain Management

3848 words - 16 pages segments: do-it-yourself consumers, who need special in-store guidance; and interior decorators, who need speedy checkouts and convenient delivery or pickup. Nan explained that the team has been considering applying time-based logistics strategies to furniture. Such an arrangement had the potential to improve product availability for in-store customers while reducing overall inventory. HomeHelp’s close relationship with professional decorators

Bis220 Propossal

775 words - 4 pages -inventory. Finally, it is recommended by the above proposal to instill a collaboration program to keep the sales department in touch with all other areas of the organization so sales reps will really be able to build a good relationship with the customers. References Destination CRM. (2010, February). What Is CRM? Retrieved from http://www.destinationcrm.com/Articles/CRM-News/Daily-News/What-Is-CRM-46033.aspx Grauer, R. T., Poatsy, M. A

Kota Fibre Ltd

1519 words - 7 pages 30 days compared with previous method. By doing this exercise, there will be lots of cash leakages that can be avoided. In exhibit 6, This proposal states that Hibachi Chemicals of Yokohama supply us with polyester pellets on a just in time basis from their plant in Majala(20 km away). Those pellets account for 35% of our raw-material purchases and it would reduce our inventory of pellets from 60 days outstanding to only 2 or 3 days. When

Ops/571 Week 6

1666 words - 7 pages New Process Design The operational focus at Riordan’s China plant is on quantity concerning the production of the fans. The necessary amount of inventory is maintained through the production forecast. Nonetheless, the amount of inventory is not adequately measured because only 93% of deliveries are in a timely manner. Therefore, Riordan should seek substitute manufacturers in addition to its current unit to have an adequate amount of inventory

Case Study

4191 words - 17 pages proposal was developed, including the meeting with JeanJean. The team felt that Woodmere could benefit greatly from accepting the HomeHelp challenge. Each HomeHelp store will transmit POS data on furniture sales at the close of each day. HomeHelp will not carry any Woodmere inventory in its regional warehouses and will carry only a limited amount of furniture and display items in each store. The POS transmission will include furniture items

Riordan Manufacturing Inventory Process

3057 words - 13 pages the effectiveness of the inventory process. Inventory accuracy will help to eliminate the yearly reconciliation. Prompt shipment notification to customers and the billing department will eliminate shipping and billing delays.The systems' upgrade proposal should eliminate all manual data entries. All raw materials should arrive to the plants with a coded purchase order that is marked accordingly and can be easily scanned into the new system. Marked

Revenue Cost Structure Proposal

1283 words - 6 pages conducive to the kind of innovation that reduces variable costs as well as the aforementioned recommendation in response to cost of production to increase profits. Methods to reduce costs The proposal has offered several suggested methods to reduce costs and maximize profits. Reducing inventory will reduce costs and increase profits. Reducing price will in the short-term increase profits and increase demand. Reducing production costs are

Information Systems Paper

1275 words - 6 pages “Information Systems Proposal” July 9, 2012 Axia University BIS 220 – “Introduction to Computer Applications and Systems” Alicia Snedeker A&R Records Inc. Table of Contents 1. Introduction 2. Table 3. Benefits of Information Systems 4. Drawbacks of Information Systems 5. Conclusion Operating a business is hard and what makes it harder is not being familiar with the information systems being used. A

Related Papers

Inventory Proposal Essay

2546 words - 11 pages CHAPTER-1 INTRODUCTION 1.1 Background Successful inventory management involves crating a purchasing plan that will ensure that items are available when they are needed but that neither too much nor too little is purchased and keeping track of existing inventory and its use. Two common inventory management strategies are the just -in-time method, where companies plan to receive items as they are need rather than maintaining high inventory

Bath & Body Works Inc, Inventory Proposal For Qu

1282 words - 6 pages Inventory Proposal with Summer Historical Inventory Data Introduction Bath and Body Works (BBW) is a franchise owned by Limited Brands Incorporated. BBW sells personal care, beauty, and home fragrance products that are sold under the Bath and Body Works, CO Bigelow, and White Barn Candle brand names. Bath and Body Works is a very successful business and has grown to become one of the largest personal care retailers in the United States

Industrial Problem Analysis

1673 words - 7 pages bolts. etc.) and ensuring the usage by everyone in desired quantity. But this proposal is rejected by the top level management. Because the materials held in SMD WIP Inventory are expensive materials. The cost of holding excess quantity would exceed the cost of probable stopping of production. (The calculations were done previously and as these calculations are not relevant to our case, details are not given.) 1. To give extra reels of each kind

Inventory System Essay

671 words - 3 pages Inventory System of Conching Food Industries (Timog, Manila) Group name: Babes Company Leader: Avegail A. Ferasol Members: Rosemarie S. Francisco Mary Joy A. Curaza Elaine P. Madrigal Chapter 1 Introduction In today’s modern age where computer becomes a way of life, it is very useful to the process of the inventory system in different companies. All business rely on inventory system because it tells what will be the profit of each product