hello I need help with number 13 please and I need it only in excel 12. A firm that produces electric golf carts has just received an order for 200 carts, which must beready 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 thefollowing: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 assuminglot-for-lot ordering.Parts List for Electric Golf CartElectric golf cartLead TimeQuantity on Hand1Тop140Supports (4)1200Cover1Base120Motor2300Body350Frame135Controls1Wheel assemblies (4)1240Seats (2)212013. Refer to Problem 12. Assume that unusually mild weather has caused a change in the quantity andtiming of orders for golf carts. The revised plan calls for 100 golf carts at the start of week 6, 100at the start of week 8, and 100 at the start of week 9.a. Develop a master schedule for this revised plan.b. Determine the timing and quantities for orders for tops and bases.c. Assume that equipment problems reduce the firm's capacity for assembling bases to 50 unitsper week. Revise your material plan for bases to reflect this, but still meet delivery dates.

Product Structure tree: a. Develop a master schedule for this revised plan. (Leave no cells blank -…

Answered: hello I need help with number 13 please…

Business

Operations Management

hello I need help with number 13 please and I need it only in excel

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

The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 3 1 1 1 1 3 1 3 Amount on hand 0 9 10 24 10 33 4 0 a. If 17 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don't need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 15. What is the latest week that the order can be started and still be ready to ship on time? The latest week is
Your stockroom manager, Mehmet Altag, arrivedat your desk just a fter you had completed the net requirementsplan for product A ( You are product pla nner for product A (in Problem A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8 using lot-for-lot. IP).) The field service manager, Mark Moon, has just called and told you that the requirements for B and Fshould each be increased by I 0 units for his repair requi rements in the field.a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants…
NB: Answer all the questions within 30 mins Table 1 Activity Predecessor Duration (weeks) A - 5 B A 4 C A 5 D B 6 E C 3 F D, E 4 Use Table 1 to calculate the following: Draw the resultant Gantt chart. Construct the PERT/CPM chart for the tasks as they appear in Table 1.[1] HINT: Do not forget the Start Date and Finish Date for each task. Indicate at minimum three dependent task patterns. Indicate all the multiple successor tasks. Indicate all the multiple predecessor tasks. Show the critical path of this project. Justify why the given critical path is valid.
Problem 13-3 (Static) The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton Hand Direct Components End 1 − L(2), C(1), K(3) L 2 10 B(2), J(3) C 3 15 G(2), B(2) K 3 20 H(4), B(2) B 2 30 J 3 30 G 3 5 H 2 − Click here for the Excel Data File a. If 40 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.)
Solve asap! To develop a WBS structure for a project “Design and Manufacturing of shaft in the Mechanical workshop”, (b) select resources, and (c) develop a Linear responsibility chart.
Exercise 8-37, 8-38, 8-39 & 8-40 (Static) (LO 8-2, 3, 5) Skip to question [The following information applies to the questions displayed below.]Pacific Ink had beginning work-in-process inventory of $744,960 on October 1. Of this amount, $304,920 was the cost of direct materials and $440,040 was the cost of conversion. The 48,000 units in the beginning inventory were 30 percent complete with respect to both direct materials and conversion costs. During October, 102,000 units were transferred out and 30,000 remained in ending inventory. The units in ending inventory were 80 percent complete with respect to direct materials and 40 percent complete with respect to conversion costs. Costs incurred during the period amounted to $2,343,600 for direct materials and $3,027,840 for conversion. Exercise 8-37 (Static) Compute Costs per Equivalent Unit: Weighted-Average Method (LO 8-3) Required: a. Compute the equivalent units for the materials and conversion cost calculations. b.…
You are product planner for product A (in Problem(A part structure, lead time (weeks), and on-handquantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8using lot-for-lot. IP).) The field service manager, Mark Moon,has just called and told you that the requirements for B and Fshould each be increased by I 0 units for his repair requi rements inthe field.a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I 0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants his 10 units ofB and F in week 6 and the 10 production units of A in week 8.
Create an AOA diagram based on the information Task A, duration 6, dependent on noneTask B, duration 5, dependent on noneTask C, duration 3, dependent on noneTask D, duration 12, dependent on Task B and Task C Task E, duration 2, dependent on Task ATask F, duration 5, dependent on Task BTask G, duration 1, dependent on Task BTask H, duration 9, dependent on Task E and Task FTask I, duration 7, dependent on Task GTask J, duration 7, dependent on Task HTask K, duration 3, dependent on Task ITask L, duration 5, dependent on Task D
A. Draw the diagram of the production line. B. How many workstations should be set up in this production line? And, which tasks should be performed in each workstation?
An end item’s demand forecasts for the next 10 weeks are30, 30, 30, 30, 20, 20, 30, 30, 30, and 30 units. The current on-hand inventory is 100 units. The order policy is to produce inlots of 75. The booked customer orders for the item, startingwith week 1, are 15, 38, 7, 5, 0, 3, 10, 0, 0, and 0 units. The leadtime is 2 weeks.a. Develop an MPS for this end item.b. The marketing department has received five orders forthis item in the following sequence:Order 1 is for 20 units to be delivered in period 1Order 2 is for 75 units to be delivered in period 4Order 3 is for 90 units to be delivered in period 6 Order 4 is for 75 units to be delivered in period 7Order 5 is for 90 units to be delivered in period 10 Assuming that the prospective MPS you developed in part (a)does not change, which orders would you be able to acceptbased on the available to promise (ATP)?
At a local university, the Student Commission on Programming and Entertainment (SCOPE) is preparing to host its first rock concert of the school year. To successfully produce this rock concert, SCOPE has listed the requisite activities and related information in the following table (duration estimates measured in days). Immediate Most Activity Predecessor(s) Optimistic Probable Pessimistic A: Negotiate contract with - 10 11 12 selected musicians B: Reserve site - 8 10 12 C: Manage travel logistics A 2 7 9 for music group D: Screen & hire B 4 5 6 security personnel E: Arrange advertising C 7 7 7 & ticketing F: Hire parking staff A, D 8 9 16 G: Arrange concession sales E 6 7 11
At a local university, the Student Commission on Programming and Entertainment (SCOPE) is preparing to host its first rock concert of the school year. To successfully produce this rock concert, SCOPE has listed the requisite activities and related information in the following table (duration estimates measured in days). Immediate Most Activity Predecessor(s) Optimistic Probable Pessimistic A: Negotiate contract with - 10 11 12 selected musicians B: Reserve site - 8 10 12 C: Manage travel logistics A 2 7 9 for music group D: Screen & hire B 4 5 6 security personnel E: Arrange advertising C 7 7 7 & ticketing F: Hire parking staff A, D 8 9 16 G: Arrange concession sales E 6 7 11 Which project network is correct? IMG is attached Compute the expected duration and variance of each activity. If required, round your answer to two decimals. If your answer is zero, enter “0”.…