I need help making a KANBAN excel data sheet with the formulas. This is for a Supply chain mgmt course- Procurement

Here is the assignment and even the answers. I have until 9:30 PM Tonight- US Eastern time. See attached word document for the assignment instructions.

Assignment Instructions

1. For this assignment, assume that you are working with the procurement and production departments to figure out how much inventory to put in the Kanbans to support a manufacturing production line that uses mostly hardware. Follow the steps below to complete the assignment.

2. Now, calculate the number of Kanban containers using the formula on page 130 of Benton 4th edition.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Apex Corporation learns that a federal administrative agency is considering a rule that will have a negative impact on the firms ability to do business. Does the firm have any opportunity to express...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

Research Report Students name Professors name Institution Date Contents Title .. 3 Abstract 3 Acknowledgement .3 Introduction .4 Main body of Report/Methodology 5 Various kinds of isolation.6...

Q:

Draw a total setup outline and decide the expense for the most economical design, i.e., the one where the complete expense of the correspondences circuits and equpment is the least. (b) The...

Q:

African Journal of Procurement, Logistics & Supply Chain Management (https://damaacademia.com/ajplscm/) Volume 1, Issue 3, pp.36-49, March 2019 Published by: Dama Academic Scholarly & Scientific...

Q:

informs Vol. 34, No. 3, May-June 2004, pp. 191-205 issn 0092-2102 \u0001 eissn 1526-551X \u0001 04 \u0001 3403 \u0001 0191 doi 10.1287/inte.1030.0068 2004 INFORMS Inventory Decisions in Dell's Supply...

Q:

Hello, I am in need of help with a huge assignment. I am responsible for only one part of this, but I would like to understand what everything means in the end. At any rate, please let me know if...

Q:

Planning Demand and Supply in a Supply Chain Capacity Planning and Assignment 1 utdallas.edu/~metin Outline Capacity Planning Product-to-plant Assignment utdallas.edu/~metin 2 Deterministic Capacity...

Q:

QUESTION: I WOULD LIKE TO KNOW WHERE WOULD I FIND THIS INFORMATION WITHIN THE ANNUAL REPORT TO FIND THE ANSWER TO THIS ASSIGNMENT AND? You are a financial analyst for a Fortune 500 company and you...

Q:

In 250 - 300 word explanation supporting your position Using the annual report from Walmart, discuss the risks the company faces and the actions they take to mitigate those risks. Refer to the...

Q:

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

Q:

Nick purchased a $100,000 participating whole-life insurance policy on his life. To date, he has paid $50,000 in total premiums and received $10,000 in dividends. The policy currently has a net cash...

Q:

Fran Zora has been auditing Manitoba Telecom Services for the past five years. She has gathered a lot of externally generated evidence because of its persuasiveness and reliability as evidence. Which...

Q:

Calculate the line integral o f the vector field vec ( F ) = 8 xvec ( i ) along the line between the points ( 2 , 0 ) and ( 6 , 0 ) . Enter a n exact answer. C vec ( F ) * d v e c ( r ) =

Q:

Consider a steady, turbulent boundary layer on an isothermal flat plate of temperature Ts- The boundary layer is "tripped" at the leading edge x = 0 by a fine wire. Assume constant physical...

Q:

Saturated ethylene glycol at 1 atm is heated by a horizontal chromium-plated surface which has a diameter of 200 mm and is maintained at 480 K. Estimate the heating power requirement and the rate of...

Q:

Example 16.1 (Section 16.1) showed that for sound waves in air with frequency 1000 Hz, a displacement amplitude of 1.2 X 10-8 m produces a pressure amplitude of 3.0 X 10-2 Pa Water at 20C has a bulk...

Q:

A major earthquake centered on Lorna Prieta, California, near San Francisco, occurred at 5:04 P.M. local time on October 17, 1989 (in UTC, Coordinated Universal Tune, 0h 4m 15s on October 18, 1989)....

Q:

Use information from Table 16.2 to answer the following questions about sound in air. At 20oC the bulk modulus for air is 1.42 X 105 Pa and its density is 1.20 kg/m3. At this temperature, what are...

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

8. Explain how you would propose to utilize reversal theory in enhancing athletic performance in the face of alarmingly high precompetitive state anxiety.

Q:

2. Discuss and clarify Selyes notion of stress relative to your answer to question number one.

Q:

2. Using the two-dimensional coping framework, write three specific coping strategy/ style examples that would fit into each quadrant of figure 9.2. Which are the most difficult to write and why?

Previous Question Next Question