# Inventory Proposal Part Two of Three

Submitted By samvu33
Words 1865
Pages 8
Inventory Proposal Part Two of Three
Team A
QRB 501
March 07, 2012
Terrance Feravich

The research discussion is toward the data collection, which converts times series data for McDonald’s Fast Food Restaurant inventory analysis and University of Phoenix summer seasonal index. The raw data represents inventory data over a four year time. In this assignment the B team will illustrate statistical information, discuss the inventory systems and problems, explain the problem this team is addressing, and show a table on how the data has been converted into dices. Below are the inventory indexes from the previous assignment in week two.
McDonald’s Inventory Analysis by Ratio Index
|Year |2000 |2001 |2002 |2003 |
|Liquidity Analysis | | | | |
|Current Ratio |0.70 |0.81 |0.71 |0.76 |
|Quick asset ratio |0.66 |0.76 |0.66 |0.71 |
|Accounts receivable turnover |17.88 |16.86 |18.01 |23.34 |
|Days supply of receivables |20.41 |21.65 |20.26 |15.64 |
|Inventory turnover |35.82 |36.04 |35.07 |33.34 |
|Days supply of inventory |10.19 |10.13 |10.41 |10.95 |
|Working capital turnover…...

### Similar Documents

#### Club It Part Two

...Club IT is a downtown music venue managed and owned by two ambitious people which are Ruben Keys and Lisa Tejada. Club IT is a fun and relaxing environment, where friends, co-workers, and family can get together and have a good time listening to a live band and different variety of music. People often come to Club IT to learn new dance steps and have an overall good time with the atmosphere. The new club owners’ goal with Club IT is to become successful with managing their information. After remodeling the new club Ruben and Lisa have realize their information management is tanking. Ruben and Lisa also would like to have multiple customers to try out the club and become regulars in order for the club to be successful. Their overall mission is to have a club where people can come, relax and have a good time with their friends and family. Club IT is basically targeting the more mature crowd, that are able to come to the club and have a good time without starting any type of issues with other guest. Since there’s a live band on Friday and Saturday nights, the targeting age for these nights are normally 25 and up. In addition, Ruben and Lisa would like for the customers that are legal age to be able to enjoy the environment as well, so they also hired a DJ to play different types of music. Their customer demographics are for the young and the old, just for anyone that likes to have fun. Since the club is located downtown, which is a centralize location, this makes it easy for...

Words: 784 - Pages: 4

#### Inventory Proposal

...Team “B” is presenting an inventory proposal to address the problem University of Phoenix is encountering regarding the Summer Historical Inventory Data and the benefits expected to achieve by implementing a solution. Time series data is converted to indices and analyzed using the slope-intersect formula to calculate the busy and slow months. To close, a histogram, and a forecast of future inventory costs will be presented. Proposal The University of Phoenix is one of the largest campus and internet-based schools in the country. The school’s online and campus classes require the university to have on hand enough supplies to satisfy an extremely large number of students, instructors, and faculty members. With new classes beginning every five, six, and nine weeks online in conjunction with semester and summer sessions at campus sites; classes involves several instructors and students that deem it necessary to have on hand a large amount of supplies in stock. This problem forced the university to develop a much needed system to ensure the needed supplies are on hand for it faculty and students as needed. Team “B” used the information given in the University of Phoenix Summer Historical Inventory to create indices for each month during the four year period. Below is the table used for the calculations (see figures 1-3): Figure 1. The table used for the calculations: | | | Actual Demands (in units) | | | | | | | | | Month | Year 1 | Year 2 | Year 3...

Words: 1035 - Pages: 5

#### Financial Statements Part Two

...Financial Statements Part Two Home Depot is a retailer that operates in the home improvement industry. The company sells building materials and home improvement products. Part Two of the Financial Statements paper will assess the financial statements of Home Depot to ascertain how effective the company’s management is in achieving its goals and mission statement to the stakeholder’s. The analysis will use vertical analysis, trend analysis, and ratio analysis to achieve to support the findings. A vertical analysis is a report that reports each amount on a financial statement as a percentage of another item. In performing the vertical analysis we need to look at the economic conditions of 2008. Mortgages started failing in the early months of 2008. Several guarantee’s of mortgage loans were placed under governmental conservatorship including Fannie Mae and Freddie Mac, which resulted in the U.S. Treasury Department supplying funds to help stabilize these companies, raising the national debt ceiling in the process (Money-Zine.com, 2011.) As a retail supplier of home improvement and home building materials, Home Depot was hit hard by the economic condition resulting in the company’s retail sales declining by 7.8 percent and its adjusted earnings per share declining by 22 percent in 2008. In the 2008 Home Depot Annual report, the company Chairman and the Chief Executive Officer, Francis S. Blake, advised that he viewed this year as not being a very ordinary year...

Words: 1221 - Pages: 5

#### Inventory Proposal

...Inventory Proposal Learning Team C was tasked with preparing a project proposal that would analyze and present data on an inventory management problem that Amazon Incorporated (Amazon) could face. The Summer Historical Inventory Data shown below was used in the calculations: Month Year 1 Year 2 Year 3 Year 4 1 18,000 45,100 59,800 35,500 2 19,800 46,530 30,740 51,250 3 15,700 22,100 47,800 34,400 4 53,600 41,350 73,890 68,000 5 83,200 46,000 60,200 68,100 6 72,900 41,800 55,200 61,100 7 55,200 39,800 32,180 62,300 8 57,350 64,100 38,600 66,500 9 15,400 47,600 25,020 31,400 10 27,700 43,050 51,300 36,500 11 21,400 39,300 31,790 16,800 12 17,100 10,300 31,100 18,900 The following proposal includes a short description of Amazon, a short discussion of the inventory system problem that Amazon might face, and the benefits if the problem is solved. Team C used the dataset provided to calculate monthly indexes (using year 1 month 1 as the base), quarterly indexes (using year 1 quarter 1 as the base), and annual indexes of the four years. The busy and slow periods for each were identified. Histograms were constructed for the monthly, quarterly, and annual values. A regression equation, rate of change, and a forecast for year 7 inventory costs, using rate of change as the interest rate, were calculated as part of the analysis for the annual section. Amazon Amazon is a large, internet based business that has been able to maintain its success partially due to the...

Words: 1264 - Pages: 6

#### Inventory Proposal

... it should commensurate with level of criticality of information. 2.1 Conceptual Framework: Fig: 2.1 Negative Impact Result of Inventory Management Positive Impact Inventory Management Inventory Management Positive Impact Inventory Management Inventory Management Control System Positive Impact Inventory Management . Our study will begin with the definition of inventory management. As mentioned above figure, there will be result of positive impact and negative impact of inventory management for the sample organization without using the control system. Finally, study will compare and measure the overall result of inventory management. CHAPTER-3 RESEARCH METHODOLOGY 3.1 Population and Sample We have selected two organizations on the basis of our internship study. We assumed that we will be comfort to take the primary data for the study rather than other 31 banks and other trading house. 3.2 Study Area To meet the objective, we will visit the service sector ie. Nabil bank and Sripadi Trading organization. Both of them are service sector but they produce different intangible product and they are different due to the establish procedure, their function and their objective. 3.3 Research Design Field visit Report writing Data collection Proposal writing Research frame work Questionnaire Literature Review Topic Selection Fig: 3.1 Our study begins with the topic selection and study of previous article...

Words: 2525 - Pages: 11

#### Inventory Proposal

... | 51,300 | 36,500 | 11 | 21,400 | 39,300 | 31,790 | 16,800 | 12 | 17,100 | 10,300 | 31,100 | 18,900 | Monthly Average: | 38,113 | 40,586 | 44,802 | 45,896 | Index Ratio | 100 | 106.4896 | 117.5511 | 120.422 | Using the Year 5 Monthly Inventory index to analyze the inventory data shown in figure 1, displays a slow trend starting in May and lasting into August. This trend begins at the end of the spring season into the beginning of the summer season. Based on the chart above in figure 2 Alternate Seasonal Index, the busy months for year two is January, February, March, August, September, October , November, and December. In year three the months are similar except August is a slow month and April was a busy month, year four busy months are January, February, March, April, July, August, September, October, and December. Lastly year five the forecast year busy months are the same as year four except July and August is a slow month in this year and November is very busy in year five. This shows when business increase the most in every year, as you can see the months fluctuate as the years go by the beginning of the summer started to become busy in year four and five. Using the Average Monthly Inventory Index by Year graph and its slope-intercept formula from the trend line, there is an average annual increase of 7.23% in monthly units of inventory using year 1 as the base. Conclusion Inventory is an important part of the Rafferty’s......

Words: 1575 - Pages: 7

#### Inventory Proposal

...Inventory Proposal Inventory should be closely followed especially for companies that rely heavily on seasonal sales. Companies will often times use forecasting models to predict future sales and the amount of inventory needed to make their sales quotas. SSMA retail outlet will evaluate their current data from the past four years to identify any inventory issues by using indices to analyze the data and histograms to forecast future inventory cost saving models. SSMA is a small retail outlet store that sells a variety of summer clothing throughout the year. The new owners have decided to install an inventory system to keep better track of the inventory, however, a complete analysis of the previous data must be completed and a forecasting model must be completed in order to determine how much inventory will be needed in order to increase net profit. The store is located in an outlet mall that relies heavily on tourists; therefore, sales are very seasonal. The summer data shows that they have an uptick in inventory during the high summer months and the owners should determine by using indices and histogram models to assist in predicting future sales. Inventory management problem SSMA past data will help predict trends and assist in decision making processes to determine inventory loss, inventory shelf life, future sales and or clearance items. This type of information is critical and valuable for small retail stores and will need this data in order to recognize key...

Words: 530 - Pages: 3

#### One, Two, Three

...Philippines – United States relations are bilateral relations between the Republic of the Philippines and the United States of America. As one of the oldest Asian partners and closest strategic major non-NATO allies of the United States, the Philippines has consistently been the most pro-American nation in the world, with 90% of Filipinos viewing the U.S. and 91% viewing Americans favorably in 2002, and 90% of Filipinos viewing U.S. influence positively in 2011. Pursuant to the 1947 Military Bases Agreement, the United States maintained and operated major facilities at Clark Air Base until November 1991, and at Subic Bay Naval Complex and several small subsidiary installations in the Philippines until November 1992. In July 1991, negotiators from the two countries reached agreement on a draft treaty providing for the clean-up and turnover of Clark to the Philippine government in 1992, and for the lease of Subic Bay Naval Base by the U.S. for 10 years. By 1991, operations at Clark had already been scaled back because of the end of the Cold War, with the last combat aircraft leaving in 1990, before the base was heavily damaged by the 1991 eruption of Mount Pinatubo. On September 16, 1991, the Philippine Senate rejected the bases treaty by a slim margin, and despite further efforts to salvage the situation, the two sides could not reach an agreement. As a result, the Philippine Government informed the U.S. on December 6, 1991, that it would have one year to complete withdrawal...

Words: 3154 - Pages: 13

#### One Two Three

...: There was some kind of shooting at the high school…gunmen in black trenchcoats were firing at people…the friend knew all the kids who wore trenchcoats, and all were accounted for except Dylan and his friend Eric…and Dylan and Eric hadn't been in class that morning…and no one knew where they were. My husband had told himself that if he found the coat, Dylan couldn't be involved. He'd torn the house apart, looking everywhere. No coat. When there was nowhere left to look, somehow he knew the truth. It was like staring at one of those computer-generated 3-D pictures when the abstract pattern suddenly comes into focus as a recognizable image. I barely got enough air in my lungs to say, "I'm coming home." We hung up without saying goodbye. My office was 26 miles from our house. All I could think as I drove was that Dylan was in danger. With every cell in my body, I felt his importance to me, and I knew I would never recover if anything happened to him. I seesawed between impossible possibilities, all of them sending me into paroxysms of fear. Maybe no one knew where Dylan was because he'd been shot himself. Maybe he was lying in the school somewhere injured or dead. Maybe he was being held hostage. Maybe he was trapped and couldn't get word to us. Maybe it was some kind of prank and no one was hurt. How could we think for even a second that Dylan could shoot someone? Shame on us for even considering the idea. Dylan was a gentle, sensible kid. No one in our family had......

Words: 584 - Pages: 3

#### Part Two

...Part 1: Programming Solution Proposal Carl Same PRG/211 14 June 2014 Victer Echeverri Part 1: Programming Solution Proposal * Describe how you determined the problem that must be solved. The Tukwila Army recruiting center in Seattle, Washington process hundreds of applicants monthly to keep up with the demand for new recruits to the United States Army and the Army reserve. The demand for new recruits require a tremendous amount of management by the Army recruiters which is one of the reason of this proposal. This proposal will encompass all the needs of an Army recruiting center from tracking new applicants, manage prospect, and track future soldiers that are waiting to attend basic combat training. This program will also help higher echelon keep track of recruits by being able to see what each recruiter is doing in real time. The benefits of this program will increase efficiency and more reliable than using manual tracking method to keep up with future Soldiers. One great feature of this program will be sharing, it’s the concept where other recruiter will be able to see what other recruiters are working on and be able to pick up where other recruiter left off without the need of the authorization of the originator, and the originator will still receive credit for that recruit. * Describe the role of the personnel involved in the project. The complexity of this program require a group that is strong mentally, some people have a hard time working with...

Words: 717 - Pages: 3

#### One, Two, Three

Words: 672 - Pages: 3

#### Inventory Proposal Part Two of Three

...Inventory Proposal Part Two of Three Team A QRB 501 March 07, 2012 Terrance Feravich The research discussion is toward the data collection, which converts times series data for McDonald’s Fast Food Restaurant inventory analysis and University of Phoenix summer seasonal index. The raw data represents inventory data over a four year time. In this assignment the B team will illustrate statistical information, discuss the inventory systems and problems, explain the problem this team is addressing, and show a table on how the data has been converted into dices. Below are the inventory indexes from the previous assignment in week two. McDonald’s Inventory Analysis by Ratio Index |Year |2000 |2001 |2002 |2003 | |Liquidity Analysis | | | | | |Current Ratio |0.70 |0.81 |0.71 |0.76 | |Quick asset ratio |0.66 |0.76 |0.66 |0.71 | |Accounts receivable turnover |17.88 |16.86 |18.01 |23.34 | |Days supply of receivables |20.41...

Words: 1865 - Pages: 8

#### New System Proposal Two

...New System Proposal Two Robert L. Rossi, Jr. IT/205 May 25, 2014 Rafael Orta New System Proposal Two The flow diagram that is provided with the new system proposal shows how the flow of data will be processed and controlled. The areas that needed improving are Sales & Marketing, Finance & Accounting, Human Resources, Operations (Quality and Supply Chain) and Information Technology & Security. The diagram is a brief description of the process that data/information will flow. Nonetheless, the diagram has arrows pointing to the next section but all information will flow from top to bottom. The position titles that are in the diagram are the only ones that will have this information available to them. Floor level employees and first level management will be limited to this information. At the top of the diagram I have the CEO, CIO, and CFO. These are your top three senior management and they should have all information available to them at all times. After doing more research I was made aware that Riordan does not have a COO but instead a CFO. If this company also had a COO then they would be in this top level management as well. The data information then goes to each department umbrella. From there it then flows to those that are top level managers in that department. This is to help keep information / data organized and flowing properly. This will also help senior level management make decisions that are needed. This change in the system and...

Words: 541 - Pages: 3

#### Project Plan Proposal Part Three

...Project Plan Proposal Part Three PM/586 Project Quality Management February 2, 2014 James Aiken Project Plan Part 3 Introduction The most significant factor in a research is the development of successful strategies and techniques towards the execution of the whole project. This research aspect has the ability to determine your business success. If you successfully and appropriately designed a concrete approach, you will definitely establish a reputable name in the world of commerce and trade. This can be achieved in three ways namely; (1) analyzing and determining the strengths and weaknesses of your project, (2) defining your project’s goals as well as the techniques to achieve them; and (3) acknowledge all the weaknesses in the project and start building a plan to get over all these inconsistencies (DeBenedetti, 2015). Execution Strategy Proposed All of the resources used in this project are hailed to be permanent as far as the purpose of this project is concerned. Below are the two most critical questions that you should address when you want to develop a surefire strategy to improve your resources. 1. What are the types of people you need to be able to meet your strategic goals; and, 2. What initiatives or programs you plan to implement to be able to gain trust and loyalty among employees? Basically, you must seek answer to the previously stipulated questions. Doing so might not be easy but it is always possible. This can be done through...

Words: 1511 - Pages: 7

#### Project Plan Proposal Part Two

...Project Plan Proposal Part Two PM/586 Project Quality Management January 26, 2014 James Aiken Project Plan Part Two Introduction The process of developing a project budget is one of the most important aspects in a project. It can help you manage and gain control over your expenses. This way, you can be ascertained that you are not bridging on the red line of overspending. Indicating a budget for the entire project can benefit a researcher like you if and only if you perfected the technique in designing a project budget. To be able to create a win-win project budget, simply follow all these steps. First, check the availability of the funds. Determine how much money you are willing to spend for this project. Second, anticipate all the possible mandatory expenses that this project would incur. Third, identify the necessary elements and concepts of the project budget. Fourth and last, put all these ideas or plans on a clean sheet of paper (Dodge, 2015). Point out all the readily- accessible resources It is good to note that Head Start Directories give off a wide array of resource and contact data. Each directory offers a short but accurate and complete description along with the most significant facts and details leading to the acquisition of other relevant information ("The Voice of Head Start in Georgia. ", 2007). These directories also provide a comprehensive system or database that allows us to peep through the real setting of the Head Start Community...

Words: 1094 - Pages: 5