The MPC system at "Advanced Manufacturing Components" company is run weekly to update the master production schedule and MRP records. At the start of week 1, the planned order release schedule for end products A and B is: Planned order releases: Week Product A 1 2 3 4 10 25 5 56 20 Product B 20 20 One unit of component C is required to manufacture one unit of product A. Three units of component C is required to manufacture one unit of product B. Purchasing lead time for component C is 1 week, a fixed order quantity of 55 units is used, and no safety stock is maintained for this item. Inventory balance (stock quantity) for component C is 30 units at the start of week 1 and there's a purchase order for 40 units due to be delivered (receipt) at the beginning of week 1. Complete the MRP record for component C as it would appear at the beginning of week 1. 5 10

The MPC system at "Advanced Manufacturing Components" company is run weekly to update the master production schedule and MRP records. At the start of week 1, the planned order release schedule for end products A and B is: Planned order releases: Week Product A 1 2 3 4 10 25 5 56 20 Product B 20 20 One unit of component C is required to manufacture one unit of product A. Three units of component C is required to manufacture one unit of product B. Purchasing lead time for component C is 1 week, a fixed order quantity of 55 units is used, and no safety stock is maintained for this item. Inventory balance (stock quantity) for component C is 30 units at the start of week 1 and there's a purchase order for 40 units due to be delivered (receipt) at the beginning of week 1. Complete the MRP record for component C as it would appear at the beginning of week 1. 5 10

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
) The following data have been prepared for master production scheduling purposes in IKEA Australia: End product A: Beginning inventory of 60, Period forecast of 10, Lot size of 30, and 30 hours in lot size. End product B: Beginning inventory of 20, Period forecast of 5, Lot size of 20, and 20 hours in lot size. End product C: Beginning inventory of 30, Period forecast of 15, Lot size of 50, and 50 hours in lot size. Capacity: 38 hours/ week (i) Prepare the master production schedule for these items during the next four periods using the Ethan Allen master production scheduling method. (ii) Suppose that the master production schedule is frozen for the next three periods. What specific impact would the policy have on the IKEA's performance?
A) What is the theoretical minimum number of workstations? a. 3 workstations b. 3.5 workstations c. 3.83 workstations d. 4 workstations e. 5 workstations B) Which of the following statements is FALSE? a. Tasks A, B, and C can be started as soon as possible. b. All of the tasks A, B and C should be finished first before task F can be started. c. All of the tasks A through H should be finished first before task I can be started. d.All of the tasks B, E, C and F should be finished first before task H can be started. Answer the two questions please.
Please do not give solution in image format thanku Let xi = 1 if Project i is selected, i = 1,2,3,4,5; and 0 otherwise: Which answer below indicates that if Project 2 is selected, then Project 4 must be selected? Group of answer choices None of the above x2 + x4 = 1 x2 + x4 ≤ 1 x4 ≤ x2 x2 ≤ x4
Courtney Kamauf schedules production of a popularRustic Coffee Table at Kamauf Enterprises, Inc. The table requires a top, four legs, 1 8 gallon of stain, 1 16 gallon of glue, 2 short braces betweenthe legs and 2 long braces between the legs, and a brass cap that goeson the bottom of each leg. She has 100 gallons of glue in inventory,but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are pur-chased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for each item. Schedule the order releases necessary to pro-duce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8.
The precedence diagramming method (PDM) is a network diagramming technique in which boxes represent activities Select one: True False Profits are revenues minus expenditures Select one: True False Defining activities involves identifying the specific activities that the project team members and stakeholders must perform to produce the project deliverables. Select one: True False
Alvis Construction Supply Company has a department that manufactures wood trusses (wood frames used in the construction industry). The following information is for the production of these trusses for the month of February: Work-in-process inventory, February 1 4,300 trusses Direct materials: 100% complete $ 10,780 Conversion: 30% complete $ 15,558 Units started during February 18,300 trusses Units completed during February and transferred out 17,300 trusses Work-in-process inventory, February 29 Direct materials: 100% complete Conversion: 30% complete Costs incurred during February Direct materials $ 59,340 Conversion $ 92,392 Required Using the weighted-average method, calculate the following: 1-a. Costs per equivalent unit. (Round your answers to 4 decimal places.) 1-b. Cost of goods completed and transferred out. (Round "Cost per EU" to 4 decimal places. Round final answer to nearest whole dollars.) 1-c. Costs remaining in the…
The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers used to cover the requirements over all seven days of the week. The company has 6 cabs but needs all six of them on duty only on Fridays. The estimated requirements are as follows: Day Mon Tue Wed Thu Fri Sat Sun Requirements 6 4 4 4 6 3 3 Prepare a schedule that minimizes the total number of drivers needed and minimizes the amount of slack capacity. In case of ties for assignment, it is preferred to give weekend days off. Identify the slack capacity for each day of the week. In addition, please identify the number of people working less than full-time (i, e., working less than five days a week. This is employee scheduling program. No employee can be off on Friday and please do not change the requirement in the question. Thank you.
A college provides free tutoring services for its students 7 days a week, and the daily requirements for tutors are: Day M T W Th F S Su Requirements 5 4 7 3 6 3 4 Find the minimum number of tutors required if each tutor works 4 days a week and has 3 consecutive days off. Give preference to Saturday and Sunday off in case of a tie. (Hint: Look for group of 3 days with the lowest requirements). Specify the work schedule for each tutor. How much slack does your schedule generate for each day?
A linear programming computer package is needed. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 400,000 72,000 160,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. If the promotional budget is limited to $20,500, By how much would audience contact increase if an extra $100 were allocated to the promotional budget? (Round your answer to the nearest whole number.)
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The optimum solution is: Number of trucks to be produced per day = ? (round your response to two decimal places).
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. Part 2 The optimum solution is: Number of trucks to be produced per day = ? enter your response here