Given the information in the following 4 weeks at Carya Cordiformis Plant, prepare a master schedule by finding the numbers a through k. Note that row 4 is projected beginning inventory of a week, not ending inventory. ( Week Forecast Customer orders Projected beginning inventory MPS ATP Lot size = 100 1 70 79 156 d h 2 70 45 a e i 3 62 24 b f j 4 80 11 с g k

Given the information in the following 4 weeks at Carya Cordiformis Plant, prepare a master schedule by finding the numbers a through k. Note that row 4 is projected beginning inventory of a week, not ending inventory. ( Week Forecast Customer orders Projected beginning inventory MPS ATP Lot size = 100 1 70 79 156 d h 2 70 45 a e i 3 62 24 b f j 4 80 11 с g k

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 busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
A manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheet
Prepare a master schedule. The forecast foreach week of an eight-week schedule is 50 units. The MPS rule is to schedule production if theprojected on-hand inventory would be negative without it. Customer orders (committed) are asfollows.Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory
Given the forecast and booked orders shown in the table, and a beginning inventory of 25, what should the master production schedule quantity be for period 4? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
2. RoadHog Inc. is a small manufacturer of motorcycle accessories. It makes muffler with fins on a linethat is also used to make a variety of other products. Because it is costly to set up the line to produce themin batches, RoadHog has an incentive them in batches. However, while customer demand is known over a6-planning horizon, it is not necessarily constant from week to week. The unit cost, fixed setup cost andmonthly holding cost are given in the table.Data for the RoadHog Dynamic Lot SizingWeek 1 2 3 4 5 6Demand 30 50 60 25 20 40Setup Cost 150 150 150 150 150 150Holding cost 3 3 3 3 3 3a. Find the production plan and the total cost for lot for lot scheduling.b. Find the production plan and the total cost for lot for the fixed order quantity (FOQ = 100)scheduling.c. Find the production plan and the total cost for the fixed order period scheduling (Use FOP = 3weeks).d. Which strategy is the best?
Determine an A-B-C classification for these items: Which items are A, B, and C - explain how you derive the answers? Use a table or excel spreadsheet to illustrate your work. Item Unit Cost Annual Volume (000)1 300 252 90 303 30 604 50 105 15 706 100 407 10 60 Hint:Determine the Annual Dollar Value (Unit Cost * Annual Volume) for each item and the sum of the individual Annual Dollar Values. Arrange the items in descending order based on Annual Dollar Values. Then, determine the percentage of items and the percentage of…
i was reading this answer and the way its calculated is a longer process then what someone else wrote can you check if ishould use this one that bartleby has given me or the other one: Step 1: Basic Information The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula Economic Order Quantity = √2RO ÷ C R = Annual Requirment C = Carrying or Holding cost O = Ordering Cost Step 2: Solution Economic Order Quantity = √2RO ÷ C Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25 Economic Order Quantity = √28,235.294117647 Economic Order Quantity = 168.0336100834 pounds R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum. C = Carrying or Holding cost i.e. £4.25 O = Ordering Cost i.e. £20 Quantity to be ordered = 168.03 pounds. Supplier = Vendor 1 should be used as the cost per pound for 168 pounds is £32.25 (as per table…
Many automobiles can be ordered in one of two engine sizes (examples are theLincoln LS, the Lexus Coupe, and the Jaguar S Type) but are virtually identical inevery other way. How might these automakers use the concept of postponement intheir production planning?
Electro Fans has j ust received an order for one thousand 20-inch fans d ue week 7. Each fan consists of a housing assembly, two grill s, a fan assembly, and an electrical unit.The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob.The following ta ble gives lead times, on-hand inventory, and scheduled receipts.a) Construct a product structure.b) Construct a time-phased product structure.c) Prepare a net material requirements plan.
How Tyler should plan on ordering the flour for his bakery. Based on the attached: How much should Tyler plan on ordering the flour for his bakery? When should Tyler order the flour for his bakery
Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?