GIANT is a company that produces bicycles and sells them to retailers in China and Hong...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
GIANT is a company that produces bicycles and sells them to retailers in China and Hong Kong markets. "Flying" (Figure 1) is one of the bestselling bicycle models and it is made according to the bill of materials (BOM) diagram (Figure 2) shown below. The quantity is also shown at each component, for example in below, Wheel (2u) means 2 units are required in production of one bicycle (1u) and Tire (1u) means 1 unit is required in production of one wheel. Tire Reflector Seat Seat post Sprockets Chain Frame Handlebar Grips Chainrings Pedals Brakes Valve Fork Spokes Rim Level O (Finished product) Bicycle (1u) Bill of materials for a bicycle Level 1 (Components) Wheel (2u) Frame (1u) Handlebar (1u) Seat (lu) Level 2 (Subcomponents) Rim (1u) Tire (1u) Spokes (36u) Reflector (1u) Valves (1u) Pedals (2u) Chainrings (3u) Sprockets (5u) Chain (1u) Brakes (2u) Grips (2u) Seat post (1u) 70 units of model "Flying" are needed in week 3, 150 units in week 5, and 100 units in week 7. The lead time for assembly of Model "Flying" is one week and there is no on-hand inventory. The table below shows additional data for the key components Wheel, Tire, and Spokes. Wheel Tire Spokes Lot size (unit) Lot-for-lot 300 Lot-for-lot (L4L) (L4L) Lead-time (week) 2 Safety stock (unit) 0 0 50 Beginning inventory 40 80 (unit) Scheduled receipts 150 units in 250 units in none week 2 week 3 Tires are sold to a retailer who requires 500 units in week 7, while for Spokes are also sold to a retailer who requires 50 units in week 2, 100 units in week 4 and 80 units in week 7. The minimum production quantity of Spokes is 500 units. a) Based on the given data, calculate the missing values in the MRP worksheets below, a1 to a20. (10 marks) Product: Model "Flying", Lead time: 1 week, On-hand inventory: 0 MPS Data Week number 1 2 3 4 5 6 7 8 Required date 70 150 100 Order release date 70 150 100 Item: Wheel Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units As BOM 1 2 3 140 (al) 000 0 290 Lot size: Lead time: Safety stock: 5 7 (a2) 200 1010000 290 200 290 200 200 units weeks units 8 0 Item: Tire Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units As BOM 2 290 40 40 40 (a3) (a4) (a5) Lot size: Lead time: Safety stock: 6 7 200 (a9) (a6) (a7) (a8) 100 100 100 400 (a10) 600 units week units ∞ 200 Item: Spokes Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units AS BOM 2 3 45 (all) (a16) 80 80 80 (a15) 50 (a12) (a17) (a13) (a18) (a14) Lot size: Lead time: Safety stock: (a19) 6 50 50 500 units week units 7 8 80 50 (a20) 80 500 GIANT is a company that produces bicycles and sells them to retailers in China and Hong Kong markets. "Flying" (Figure 1) is one of the bestselling bicycle models and it is made according to the bill of materials (BOM) diagram (Figure 2) shown below. The quantity is also shown at each component, for example in below, Wheel (2u) means 2 units are required in production of one bicycle (1u) and Tire (1u) means 1 unit is required in production of one wheel. Tire Reflector Seat Seat post Sprockets Chain Frame Handlebar Grips Chainrings Pedals Brakes Valve Fork Spokes Rim Level O (Finished product) Bicycle (1u) Bill of materials for a bicycle Level 1 (Components) Wheel (2u) Frame (1u) Handlebar (1u) Seat (lu) Level 2 (Subcomponents) Rim (1u) Tire (1u) Spokes (36u) Reflector (1u) Valves (1u) Pedals (2u) Chainrings (3u) Sprockets (5u) Chain (1u) Brakes (2u) Grips (2u) Seat post (1u) 70 units of model "Flying" are needed in week 3, 150 units in week 5, and 100 units in week 7. The lead time for assembly of Model "Flying" is one week and there is no on-hand inventory. The table below shows additional data for the key components Wheel, Tire, and Spokes. Wheel Tire Spokes Lot size (unit) Lot-for-lot 300 Lot-for-lot (L4L) (L4L) Lead-time (week) 2 Safety stock (unit) 0 0 50 Beginning inventory 40 80 (unit) Scheduled receipts 150 units in 250 units in none week 2 week 3 Tires are sold to a retailer who requires 500 units in week 7, while for Spokes are also sold to a retailer who requires 50 units in week 2, 100 units in week 4 and 80 units in week 7. The minimum production quantity of Spokes is 500 units. a) Based on the given data, calculate the missing values in the MRP worksheets below, a1 to a20. (10 marks) Product: Model "Flying", Lead time: 1 week, On-hand inventory: 0 MPS Data Week number 1 2 3 4 5 6 7 8 Required date 70 150 100 Order release date 70 150 100 Item: Wheel Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units As BOM 1 2 3 140 (al) 000 0 290 Lot size: Lead time: Safety stock: 5 7 (a2) 200 1010000 290 200 290 200 200 units weeks units 8 0 Item: Tire Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units As BOM 2 290 40 40 40 (a3) (a4) (a5) Lot size: Lead time: Safety stock: 6 7 200 (a9) (a6) (a7) (a8) 100 100 100 400 (a10) 600 units week units ∞ 200 Item: Spokes Minimum order quantity: Immediate Parent(s): Week number Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned order receipts Planned order releases units AS BOM 2 3 45 (all) (a16) 80 80 80 (a15) 50 (a12) (a17) (a13) (a18) (a14) Lot size: Lead time: Safety stock: (a19) 6 50 50 500 units week units 7 8 80 50 (a20) 80 500
Expert Answer:
Answer rating: 100% (QA)
Gross requirements and scheduled receipts are given Projected available ... View the full answer
Related Book For
Business Statistics
ISBN: 978-0321925831
3rd edition
Authors: Norean Sharpe, Richard Veaux, Paul Velleman
Posted Date:
Students also viewed these accounting questions
-
A company that produces video equipment, including video cameras and televisions, is attempting to forecast what new products and product innovations might be technologically feasible and that...
-
A company that produces cell phones claims its standard phone battery lasts longer on average than other batteries in the market. To support this claim, the company publishes an ad reporting the...
-
A company that produces widgets has found its demand function to be q = -1,500p + 90,000. a. For each dollar increase in the wholesale price, how many fewer widgets are demanded? b. How many widgets...
-
Consider the circuit shown in (Figure 1). Suppose that v 240 V,v 2 110 V, and v 3 450 V Figure 1 of 1 a) Use the mesh-current method to find the magnitude of the total power developed in the circuit...
-
How can changes in the central bank loan (discount) rate and reserve requirements affect the operations of depository institutions? What happens to the legal reserves of the banking system when the...
-
3. Compute the variable manufacturing overhead spending and efficiency variances. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect...
-
Using one beam element and one spring element, find the natural frequencies of the system shown in Fig. 12.30. p. A,I,E 8k - El m = pAl m FIGURE 12.30 Cantilever beam carrying spring and mass at free...
-
1. Explain how Davis suggests that the development of prisons represents a humane and progressive step, and how the next step in humane punishment may be beyond incarceration. 2. How does Davis...
-
What are some advanced strategies for building resilience against stress, and how can these strategies be implemented in high-stress environments ?
-
The following is the post-closing trial balance for Kennesaw Company, Inc (KCI), a merchandising company, at December 31, 2024. Account Title Cash Accounts Receivable Allowance for Uncollectible...
-
1. (a) Label Earth's layers as shown in the diagram below. (1 pt each; 4 pts total) X Y W: X: Y: Z: W (b) Explain how these layers formed (early in Earth's history). (7 pts) Z
-
Formulate a continuous non-dimensional model for population growth where the population is measured as follows: Time (in years) Population (in millions) 0 0.1 1 0.145 2 0.206 3 0.289 0.391 Table 1:...
-
This page is reserved for your bank's Income Stement. Please see directions for Question 4. BHC NAME: US Bank National Association BHC Mineapolis Minesota BHC ID#: 1119794 1 Number of institutions...
-
On March 3, 2020, the Board of Governors of the Federal Reserve System unexpectedly decided to cut interest rates (the Federal Funds Rate) by 50 basis points to a target range of 1-1.25%. At the same...
-
Find an equation for the plane that is tangent to the given surface at the given point. z = y-x (2,6,2) Find the equation for the tangent plane to the surface z = y-x at the point (2,6,2). Use a...
-
Find r(t) if r' (t) = (6t (1-3),te,4 sin (1-2)) and r(2)=(2,-3,1) Suppose an object moves in space such that it position at time t hours is given by r(t) = (6t+1)i+t'j-ek. Find the velocity and...
-
Q1. On March 19, 2020, the Australian Financial Review reported: UBS will de-list its Australian exchange-traded funds (ETFs) in a strategic retreat from the burgeoning market, as $2 billion was...
-
Why is it important to understand the macro-environment when making decisions about an international retail venture?
-
Are the following data time series? If not, explain why. a) Quarterly earnings of Microsoft Corp. b) Unemployment in August 2010 by education level. c) Time spent in training by workers in NewCo. d)...
-
You are planning a trip home at the end of the semester and need to make plane reservations soon. However, youve just had a preliminary interview with a consulting firm that seemed to go very well....
-
A states environmental agency worries that a large percentage of cars may be violating clean air emissions standards. The agency hopes to check a sample of vehicles in order to estimate that...
-
The property of a system depends upon its state. State True (T) or False (F)
-
In a control volume, mass, momentum and energy may flow. State True (T) or False (F)
-
Temperature is an intensive property. State True (T) or False (F)
Study smarter with the SolutionInn App