(Mt) – discussion 3

Complete assignment
Level 3 – Determining Inventory Levels for CKG AutoAnother profitable facet of CKG Auto’s business is supplying parts …

Complete assignment
Level 3 – Determining Inventory Levels for CKG AutoAnother profitable facet of CKG Auto’s business is supplying parts for auto repairs. The most critical component of the parts supply business is having enough of the right parts on hand so that repair shops can receive same-day delivery. The key to profits is minimizing the number of parts that need to be warehoused while also ensuring that sufficient parts are on hand to meet orders. Because each warehouse distribution center serves a different set of customers with different needs, each center must be considered separately. Distribution centers have a five-day lead time for ordering parts. The lead time must be taken into consideration when determining target inventory levels.The costs involved in warehousing the parts include the working capital tied up in the inventory (the cost of each part) as well as the space to store the part. These costs can be substantial. On the other hand, alternative “generic” parts are often available from rival suppliers, and keeping the auto repair centers supplied and customers satisfied is critical.One of the most problematic items to supply and store are bearings. This part is both high volume and relatively large, taking up considerable warehousing space. A bearing is also relatively expensive. Analyzing bearing needs is a good place for CKG to start, specifically in one of its largest distribution centers such as Central New Jersey, which serves 10 major customers. You have been asked to analyze the bearing inventory level requirements for this center, including simulating demand based on 30-day historical extremes, calculating a target inventory level based on this simulation, and then comparing simulated values to actual values from the past five days from the targeted warehouse.Complete the following:1. Open the workbook named Parts.xlsx located in the Chapter 2 folder, and then save it as CKG Parts Analysis.xlsx.2. Modify the format of the data on the BearingData worksheet so that zero values are displayed with a 0 instead of the default dash, aligned on the right side of the column.3. On the BearingData worksheet, take the existing 30-day data for these bearings for each customer to calculate the high and low limits of the bearing demand by customer.4. On a new worksheet named Simulation, use the high and low limits you just calculated to simulate daily requirements for each customer to obtain a combined daily requirement. Assume that the daily requirements will vary for each customer randomly between the high and low limits you have calculated from the existing 30-day data for that customer. Generate the data for approximately 100 instances (days), and then copy the results as values to another new worksheet in the workbook. Keep the original analysis intact on the Simulation worksheet so you can use it again later. Name the new worksheet Simulation Data 1. Be sure that your worksheets have titles and cell formatting.5. On the Simulation Data 1 worksheet, in an adjacent column, calculate the total demand by day for all 10 customers. Then, use this daily demand total data to calculate the daily mean, mode, median, and standard deviation for the combined requirements of all 10 customers. Use cell shading to clearly identify your calculation area.6. Extend your analysis (on the same worksheet) to include a ranking of the data (1 to 100) so that the day with the least total demand has a rank of 1. Again, use cell shading to clearly identify columns with your calculations.7. To the right of the data, create a listing of the top and bottom five daily combined demands from the 100 simulated instances. Clearly identify this listing using borders and shading.8. Recommend a target inventory level needed for a five-day period based on the following; to be on the cautious side, assume each day’s supply will be equal to the average daily demand for all locations combined, plus three standard deviations: • Because the mean and standard deviations might not already be integers, round the daily demand up to the nearest whole number. • Then, use this calculated daily demand (average plus 3 standard deviations) to calculate demand over a five-day period. Place this recommendation just below the top/bottom analysis, again clearly identifying it. Add the label Bearing Recommended to identify the cell containing the actual value.9. The warehouse manager has tracked a total of five different parts over the past five days, recording for each shipment the value of the part and the number of days it was in storage. One of these tracked parts is the bearing you have just analyzed. The data has been compiled in a workbook named Demand.xlsx. Each line item represents a single shipment of one item. Copy the data from the Demand.xlsx workbook, located in the Chapter 2 folder, to your workbook and place it on a worksheet named Actual Demand.10. On the same worksheet, summarize the data to determine the number shipped by part, the total values of those shipments by part, and the average number of days that part was stored, using the format shown in Table 2.16.(attached is table 2.16)In the # Items Shipped column, write a formula to determine the number of bearings shipped. Write the formula so that it can be copied down the column to automatically determine the number of timing belts shipped, the number of air filters shipped, and so on. In the Total Dollar Value of Items Shipped column, write a formula to determine the value of all bearings shipped. Again, write the formula so that it can be copied down the column to automatically determine the value of timing belts, air filters, and so on. In the Average #Days Held in Inventory column, write a formula to determine the average number of days bearings shipped were held in inventory; again, write the formula so that it can be copied down the column. Be sure that these formulas will work even if the data is updated in the future.11. Based on the recommended inventory level you previously calculated for bearings, would you have had enough bearings in the warehouse to cover these orders? Place your answer in a cell below your analysis on the Actual Demand worksheet. Clearly identify this answer and highlight it in yellow.12. Double-check all values and formulas for correct implementation. Include sufficient formatting and titles to clearly identify the worksheet elements.13. Save and close the CKG Parts Analysis.xlsx workbook.Gross, Debra; Akaiwa, Frank; Nordquist, Karleen. Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach (New Perspectives) (Page 153). Cengage Textbook. Kindle Edition.

6 pages

Ethical Behaviors In Unions And Union Ethics Training
• The union was created for the main reason of looking out for the welfare of the workers and ensure it is able to repre …

Ethical Behaviors In Unions And Union Ethics Training
• The union was created for the main reason of looking out for the welfare of the workers and ensure it is able to represent them effectively in

8 pages

Cj340 Unit 8 Applied Criminal Justice
Identify and describe ways that terrorism has impacted the police mission in the U.S.? Be sure to provide examples. Descri …

Cj340 Unit 8 Applied Criminal Justice
Identify and describe ways that terrorism has impacted the police mission in the U.S.? Be sure to provide examples. Describe at least two disagreements that exist regarding the appropriate law enforcement behavior to fight terrorism and maintain personal liberties? 2. What role does social stigma play in police ethics? Describe this role. Give specific examples from your reading, or your experiences, where social stigma played a role in furthering police corruption and when it played a role in reducing it. 3. Are the ethical forces behind police corruption the same as those involved in police abuses of force? Identify four components of public corruption within the criminal justice field, and describe the strategies used to control this corruption. Support your answer. 4. Define and discuss individual conscience and police assignments using specific examples. Explain how training can prepare would be police officers for the ethical dilemmas they will face. Provide examples.

Joint Commission Accreditation
Health care Providers may volunteer to be accredited by an external body. The Centers of Medicare and Medicaid provide an …

Joint Commission Accreditation
Health care Providers may volunteer to be accredited by an external body. The Centers of Medicare and Medicaid provide an updated list of approved accrediting organizations. For this discussion, we are focusing on the acute care hospital. Below is a categories in The Joint Commission Standards Manual and accreditation process topics that you will be researching Staffing Effectiveness Indicators•Select two journal articles from The Source that were published within the past 5-8 years pertaining to your assigned topic.•Identify and summarize the two articles chosen. Your response should reflect the standard, how it is utilized and why it is important to health care, any best practice mentioned, summary of any forms or template shared, and any other information that surprised you.Initial Post: Your initial post should be 300 words. Utilize a minimum of two scholarly sources to support your points. Cite and reference your sources in APA format

Project Charter, management homework help
Chose a project idea examples: small local companies merging, company relocating several small locations to on …

Project Charter, management homework help
Chose a project idea examples: small local companies merging, company relocating several small locations to one location or new software integration to an organization. Discuss the justification for the project and how it relates to the strategic plan of the organization. Identify the stakeholders for the project, including the project sponsor, who will sign the project charter. Use the sixth edition of the APA Manual as your standard for all referencing. Because this is to be a usable project management plan, it is suggested that you use parenthetical citations throughout the document.Please see attached documents for more information.APA Format750 wordsAdditional help may be required as this is a multi-phase assignment

• WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
• Assignment status: Already Solved By Our Experts
• (USA, AUS, UK & CA PhD. Writers)
• CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Why Choose Us?

How It Works

• Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the “PAPER DETAILS” section.
• Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
• Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
• From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

About AcademicWritersBay.com

AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master’s degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.