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...
-
Medical costs are substantial and rising. But will they be the most substantial expense over your lifetime? Not likely. Will it be housing or food? Again, not likely. The answer is taxes. On average,...
-
A unity feedback system has the loop transfer function where T is a time delay and K is the controller proportional gain. The block diagram is illustrated in Figure P10.35. The nominal value of K =2....
-
How much do we need to invest each year to have \($100,000.00\) in a college fund when our child turns 18 years old? New parents often seek similar advice from their financial advisors to establish...
-
Introduction Home Safety, Inc.s management has been trying for months to acquire one of its largest competitors in the home security industryLock-It-Up Company. Before agreeing to the acquisition,...
-
The role of the CFO has continued to expand since the passage of the Sarbanes - Oxley Act, with CFOs taking the central role in overseeing corporate compliance with the act and reestablishing public...
-
Using the same data set as in Exercise 3 and for house price growth, run several regression models with one, two, three, and four lags of price growth in the right-hand side of the model. Analyze the...
-
XY Mine Pty Ltd has four directors: Archy, Bruce and two nominees of QLD Ltd, the company that owns the other 50% of the issued shares in XY Mines. In 2019, the mine operated by XY Mine was hit by...
-
The City of Leonard decides to lease school desks for its school system rather than buy them because the lessor will do all scheduled maintenance. On January 1 , 2 0 2 4 , the school system leases 5...
-
Completion Complete each statement. 1. ____________________ is used when you want to shut down a cluster server for maintenance or upgrades, such as adding memory or replacing a failing component....
-
Morton Company s budgeted variable manufacturing overhead is $ 4 . 5 0 per direct labor - hour and its budgeted fixed manufacturing overhead is $ 2 7 0 , 0 0 0 per year. The company manufactures a...
-
Identify the correctly punctuated sentence below. Question 1 Selected answer will be automatically saved. For keyboard navigation, press up/down arrow keys to select an answer. a Your presentation...
-
Consider the real-time transport of audio across a network. (a) What are the advantages of digitising the audio? (b) What are the disadvantages and how can they be mitigated? (c) What...
-
Using python need help solving Write the modifyList() function to delete the first element of names and change the last element to Ava. Examples: modifyList( [Gertrude, Sam, Ann, Joseph] ) returns...
-
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...
-
A cost sheet and partial finished goods ledger card for Leather Originals, a manufacturer of leather furniture, are provided in the Working Papers. Work independently to complete the following...
-
Krasnoy Tire, a maker of tires for cars, trucks, and tractors, is trying to determine how to account for various factory costs. The costs include the following: a. Wages earned by a factory...
-
Wilmington, Inc., manufactures heating systems. The company maintains a materials ledger for all direct materials. Instructions: 1. Prepare a materials ledger card for T-5 thermostats. The thermostat...
Study smarter with the SolutionInn App