
Concept explainers
A firm that produces electric golf carts has just received an order for 200 carts, which must be ready for delivery at the start of week 8. Information concerning the product structure, lead times, and quantities on hand is shown in the following table. Use this information to do each of the following:
a. Construct a product tree.
b. Construct an assembly time chart.
c. Develop a material requirements plan that will provide 200 golf carts by week 8 assuming lot-for-lot ordering.
a)

To construct: A product tree
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
Construct a product tree:
b)

To construct: An assembly time chart
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
Construct an assembly time chart:
c)

To prepare: Materials Requirement planning using the provided information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
The company needs to provide 200 golf carts by week 8.
Develop a material requirement planning for golf cart:
- It is given that the company needs to provide 200 golf carts by week 8.
- Beginning inventory is 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units in week 8 (200-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 200 units in the beginning of Week 8. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 7.
Develop a material requirement planning for top:
- Golf cart is the parent for top. Hence, the planned order release of the golf cart would be the gross requirement of the top. As number of units required is 1 for top, the planned order release row of golf cart should be multiplied with 1 to attain the gross requirement column of top.
- Beginning inventory is 40 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units in week 7 (200-40).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 160 units in the beginning of Week 7. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 6.
- Projected on hand inventory for week 8 is 0 units. Calculation is as follows:
Develop a material requirement planning for supports (4):
- Top is the parent for supports. Hence, the planned order release of the top would be the gross requirement of the supports. As number of units required is 4 for supports, the planned order release row of top should be multiplied with 4 to attain the gross requirement column of support.
- Beginning inventory is 200 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 440 units in week 6 (640-200).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 440 units in the beginning of Week 6. Hence, they need to order for 440 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
- Projected on hand inventory for week 7 is 0 units. Calculation is as follows:
Develop a material requirement planning for cover:
- Top is the parent for cover. Hence, the planned order release of the top would be the gross requirement of the cover. As number of units required is 1 for cover, the planned order release row of top should be multiplied with 1 to attain the gross requirement column of cover.
- Beginning inventory is 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units in week 6 (160-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 160 units in the beginning of Week 6. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Develop a material requirement planning for base:
- Golf cart is the parent for base. Hence, the planned order release of the golf cart would be the gross requirement of the base. As number of units required is 1 for base, the planned order release row of golf cart should be multiplied with 1 to attain the gross requirement column of base.
- Beginning inventory is 20 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units in week 7 (200-20).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 180 units in the beginning of Week 7. Hence, they need to order for 180 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 6.
- Projected on hand inventory for week 8 is 0 units. Calculation is as follows:
Develop a material requirement planning for motor:
- Base is the parent for motor. Hence, the planned order release of the base would be the gross requirement of the motor. As number of units required is 1 for motor, the planned order release row of base should be multiplied with 1 to attain the gross requirement column of motor.
- Beginning inventory is 300 units.
- Gross requirement for week 6 is 180 units. As the beginning inventory is sufficient to satisfy the demand, there is no necessary to place an order.
- Projected on hand inventory for week 7 is 120 units. Calculation is as follows:
Develop a material requirement planning for body:
- Base is the parent for body. Hence, the planned order release of the base would be the gross requirement of the body. As number of units required is 1 for body, the planned order release row of base should be multiplied with 1 to attain the gross requirement column of body.
- Beginning inventory is 50 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 130 units in week 6 (180-50).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 3 weeks. Company requires 130 units in the beginning of Week 6. Hence, they need to order for 130 units (as the lot size is lot-for-lot) before three weeks (as the lead-time is 3 weeks). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 7 is 0 units. Calculation is as follows:
Develop a material requirement planning for seats (2):
- Base is the parent for seats. Hence, the planned order release of the base would be the gross requirement of the seats. As number of units required is 1 for seats, the planned order release row of base should be multiplied with 1 to attain the gross requirement column of seats.
- Beginning inventory is 120 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 240 units in week 6 (360-120).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. Company requires 240 units in the beginning of Week 6. Hence, they need to order for 240 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks). Thus, company need to order the required units in week 4.
- Projected on hand inventory for week 7 is 0 units. Calculation is as follows:
Develop a material requirement planning for frame:
- Body is the parent for frame. Hence, the planned order release of the body would be the gross requirement of the frame. As number of units required is 1 for frame, the planned order release row of body should be multiplied with 1 to attain the gross requirement column of frame.
- Beginning inventory is 35 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 95 units in week 3 (130-35).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 95 units in the beginning of Week 3. Hence, they need to order for 95 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 2.
- Projected on hand inventory for week 4 is 0 units. Calculation is as follows:
Develop a material requirement planning for controls:
- Body is the parent for controls. Hence, the planned order release of the body would be the gross requirement of the controls. As number of units required is 1 for controls, the planned order release row of body should be multiplied with 1 to attain the gross requirement column of controls.
- Beginning inventory is 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 130 units in week 3 (130-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 130 units in the beginning of Week 3. Hence, they need to order for 130 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 2.
Develop a material requirement planning for wheel assemblies (4):
- Body is the parent for wheel assemblies. Hence, the planned order release of the body would be the gross requirement of the wheel assemblies. As number of units required is 4 for wheel assemblies, the planned order release row of body should be multiplied with 4 to attain the gross requirement column of wheel assemblies.
- Beginning inventory is 240 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 280 units in week 3 (520-240).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 280 units in the beginning of Week 3. Hence, they need to order for 280 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 2.
- Projected on hand inventory for week 4 is 0 units. Calculation is as follows:
Want to see more full solutions like this?
Chapter 12 Solutions
Operations Management (Comp. Instructor's Edition)
Additional Business Textbook Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
Horngren's Accounting (12th Edition)
Principles of Microeconomics (MindTap Course List)
Essentials of MIS (13th Edition)
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Intermediate Accounting (2nd Edition)
- Sarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting research on the attendance history for cultural events in the area over the past ten years. The following data has been collected on the number of attendees who registered for events at the cultural center. Year Number of Attendees 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 You have been hired as a consultant to assist in implementing a forecasting system that utilizes various forecasting techniques to predict attendance for Year 11. a) Calculate the Three-Period Simple Moving Average b) Calculate the Three-Period Weighted Moving Average (weights: 50%, 30%, and 20%; use 50% for the most recent period, 30% for the next most recent, and 20% for the oldest) c) Apply Exponential Smoothing with the smoothing constant alpha = 0.2. d) Perform a Simple Linear Regression analysis and provide the adjusted…arrow_forwardRuby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 70 units and is valued at $90 per unit. Inbound shipments from vendor 1 will average 390 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 2 weeksweeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. Part 2 a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $enter your response here.arrow_forwardSam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: > Demand 75 bags/week > Order cost = $52.00/order > Annual holding cost = 20 percent of cost > Desired cycle-service level = 80 percent >Lead time = 5 weeks (30 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forward
- Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 2,250 rolls. The cost per roll is $625, and the annual holding cost is 20 percent of the cost. Each order costs $75. a. How many rolls should Yellow Press order at a time? Yellow Press should order rolls at a time. (Enter your response rounded to the nearest whole number.)arrow_forwardPlease help with only the one I circled! I solved the others :)arrow_forwardOsprey Sports stocks everything that a musky fisherman could want in the Great North Woods. A particular musky lure has been very popular with local fishermen as well as those who buy lures on the Internet from Osprey Sports. The cost to place orders with the supplier is $40/order; the demand averages 3 lures per day, with a standard deviation of 1 lure; and the inventory holding cost is $1.00/lure/year. The lead time form the supplier is 10 days, with a standard deviation of 2 days. It is important to maintain a 97 percent cycle-service level to properly balance service with inventory holding costs. Osprey Sports is open 350 days a year to allow the owners the opportunity to fish for muskies during the prime season. The owners want to use a continuous review inventory system for this item. Refer to the standard normal table for z-values. a. What order quantity should be used? lures. (Enter your response rounded to the nearest whole number.)arrow_forward
- In a P system, the lead time for a box of weed-killer is two weeks and the review period is one week. Demand during the protection interval averages 262 boxes, with a standard deviation of demand during the protection interval of 40 boxes. a. What is the cycle-service level when the target inventory is set at 350 boxes? Refer to the standard normal table as needed. The cycle-service level is ☐ %. (Enter your response rounded to two decimal places.)arrow_forwardOakwood Hospital is considering using ABC analysis to classify laboratory SKUs into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two bin system (C items). The following table shows the annual dollar usage for a sample of eight SKUs. Fill in the blanks for annual dollar usage below. (Enter your responses rounded to the mearest whole number.) Annual SKU Unit Value Demand (units) Dollar Usage 1 $1.50 200 2 $0.02 120,000 $ 3 $1.00 40,000 $ 4 $0.02 1,200 5 $4.50 700 6 $0.20 60,000 7 $0.90 350 8 $0.45 80arrow_forwardA part is produced in lots of 1,000 units. It is assembled from 2 components worth $30 total. The value added in production (for labor and variable overhead) is $30 per unit, bringing total costs per completed unit to $60 The average lead time for the part is 7 weeks and annual demand is 3800 units, based on 50 business weeks per year. Part 2 a. How many units of the part are held, on average, in cycle inventory? enter your response here unitsarrow_forward
- assume the initial inventory has no holding cost in the first period and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. What is the total cost? ENTER your response is a whole number (answer is not $17,000. That was INCORRECT)arrow_forwardRegular Period Time Overtime Supply Available puewag Subcontract Forecast 40 15 15 40 2 35 40 28 15 15 20 15 22 65 60 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit 20 units $100 $150 $200 Carrying cost per unit per month 84arrow_forwardassume that the initial inventory has no holding cost in the first period, and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. The total cost is? (enter as whole number)arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning


