The forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50, and 30 units. The marketing department has booked orders totaling 20, 25, 10, and 20 units for delivery in the first (current), second, third, and fourth weeks. Currently, 30 hand drills are in stock. The policy is to order in lots of 60 units. Lead time is one week.a. Develop the MPS record for the hand drills.b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order?

The forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50, and 30 units. The marketing department has booked orders totaling 20, 25, 10, and 20 units for delivery in the first (current), second, third, and fourth weeks. Currently, 30 hand drills are in stock. The policy is to order in lots of 60 units. Lead time is one week.a. Develop the MPS record for the hand drills.b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order?

Name: The forecasted requirements for an electric hand drill for the next 6
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: The forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50, and 30 units. The marketing department has booked orders totaling 20, 25, 10, and 20 units for delivery in the first (current), second, third, and fou

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

1. A company that produces 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. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree. b) Determine the low level codes for all the components. c) Develop a material requirements plan that will provide 200 golf carts by week 8 assuming lot for lot ordering.
1. A company that produces 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. Parts list for golf cart Lead time Quantity on hand Golf cart Top Base 1 1 1 0 40 20 Top Supports(4) Cover 1 1 200 0 Base Motor Body Seats (2) 2 3 2 300 50 120 Body Frame Controls Wheel assemblies(4) 1 1 1 35 0 240 You are required to: a) Construct a product tree.
Dohini Manufacturing company had following 12 months of data on purchasing cost and number of purchase orders. Required: 1. Determine the high point and low point. 2. Calculate the variable rate for purchasing cost based on the number of purchase orders. (Round to nearest cent) 3. Calculate the fixed monthly cost of purchasing.(Round to nearest dollar). 4. Write the cost formula for the purchasing activity showing the fixed cost and the variable rate. 5. If Dohini manufacturing company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for the that month?(Round to nearest dollar) 6. What if Dohini manufacturing wants to estimate purchasing cost for the coming year and expects 5340 purchase orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesn't equal the fixed cost calculated in Requirement 3?(Round to nearest dollar)
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
Demand forecast for product A is twenty units per week. There is a scheduled receipt of 100 units for week 3. There are orders of twenty-four for week 1, eighteen for week 2, and fifteen for week 3. If the company has a stock of fifty-six units of product, what is the projected on-hand inventory on week 27 OA 14 B.32 12 OC. 12 OD. 20 OE. None of the above.
1.A firm has 77 units of a product on hand. Forecasts of demand are 26 units per week. An MPS quantity of 90 units is planned to arrive in period 3. Customer orders are 29 for period 1, 27 for period 2, and 19 for period 3.What is the projected on-hand inventory at the end of period 3? (use excel to show formulas)
Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)
Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0
PROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows: Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…
a. How much should be produced each period? b. What is ending inventory for each period? c. If inventory carrying cost is $3 per case per period based on ending inventory, what is the total cost of carrying inventory? d. What is the total plan cost and why? 4. The opening backlog is 1200 units. Forecast demand is shown below. a. Calculate the weekly production for level production if the backlog is to be reduced to 1000 units, b. Calculate the projected backlog for each week. Week 2 4 3 1200 1200 Forecast 1200 Demand Planned Production Projected Backlog 1200 1100 5 1100 25 20 6 1000 Total 5. A firm plans to make 400 wagons, 200 carts, and 100 sleds. The resource bill shown below displays the amount of critical resources needed to make one average unit of product family: Wood (Board Feet) Labor (Standard Hours) Product Wagon 0.75 0.50 1.00 Cart Sled 30 Calculate the total wood AND labor needed to make the total number of items in the product family.
Complete the following: • Lead time = 1 week • Demand Time Fence is at the end of Week #2 MPS Lot Size = 60 On-Hand is 40 Forecast Customer Orders PAB MPS ATP 1 40 2 35 38 43 3 37 37 Week 4 29 32 S 41 31 6 52 26