Use the following scenario and data for all questions The following is the Bill of Material (BOM) of a simple product. E(2) Item A B D(2) с CDEFO B(2) G G(1) E(4) Assume the firm has made a commitment to ship 200 units of the final product (A) to one of its customers in the 9th week. Based on the partial information given in the following table, complete the material requirement planning for this order. Lead Time (Week) 2 The correct MRP table for item A should be E(2) On Hand 0 0 50 100 200 250 0 C(4) E(3) E(2) G(2) Scheduled Receipt No 100 in week 1 50 in week 2 No No 200 in week 3 No

Use the following scenario and data for all questions The following is the Bill of Material (BOM) of a simple product. E(2) Item A B D(2) с CDEFO B(2) G G(1) E(4) Assume the firm has made a commitment to ship 200 units of the final product (A) to one of its customers in the 9th week. Based on the partial information given in the following table, complete the material requirement planning for this order. Lead Time (Week) 2 The correct MRP table for item A should be E(2) On Hand 0 0 50 100 200 250 0 C(4) E(3) E(2) G(2) Scheduled Receipt No 100 in week 1 50 in week 2 No No 200 in week 3 No

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

Required information Skip to question George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week Units Total Etching Cost 1 9 $ 21 2 12 25 3 13 30 4 9 20 5 11 25 6 18 34 72 $ 155 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y = a + bX.
|Product D is stocked only at the AMC Chemical Company's Dallas warehouse and at the company's plant warehouse in Akron. The sales director has forecast product sales from the Dallas warehouse to be 40 units per week for the next 8 weeks. Product D is manufactured at the firm's Akron plant using 2 units of ingredient X per unit of product D. Information: Ingredient X Projected available balance: 4 Units Schedule receipt in week 1: 320 units Safety stock quantity: 2 Product D in Dallas Product D in Plant Warehouse Warehouse Projected available balance: 85 Units Safety stock quantity: 5 units Lead time: 2 weeks Lot for lot size quantity Projected available balance: 2 Units Schedule receipt in week 1: 46 units Safety stock quantity: 8 units units Lead time: 1 week Lead time: 4 weeks Lot for lot size quantity Lot size quantity: 320 units Prepare the DRP records for product D at the Dallas warehouse and the plant warehouse as well as the MRP record for ingredient X (Assume ingredient X is…
a. Meaning of ABC analysis?
The manager of a bulk foods establishment sells a trail mix for $9 per pound and premium cashews for $14 per pound. The manager wishes to make an 200-pound trail mix-cashew mixture that will sell for $11 per pound. How many pounds of each should be used? Question content area bottom Part 1 A. 80 lb of trail mix 120 lb of cashews B. 100 lb of trail mix 100 lb of cashews C. 140 lb of trail mix 60 lb of cashews D. 120 lb of trail mix 80 lb of cashews
Part B Three-period Four-period Units Units Demanded Period weighted moving weighted moving Demanded Three-period weighted moving average forecast average forecast average forecast Four-period weighted moving average forecast 24 2 25 60 28 50 49 S50 4 32 26.33 46 4.90 39,80 40 41 5 35 29.50 28.6 38 35 38 32.83 31.7 30 32 28 25 26,93 250 es 7 41 36.00 34.9 24 20 8 46 39.00 38 49 43.00 41.8 10 10 53 46.67 45.4 50.50 49.2 1 2 3 4 5 6 7 8 9 10 11 1. Make a comparative analysis out of your answers in the plotted data. (3-5 sentences)
Question 6 of 10 Moving to another question will save this response. Question 6 The following transactions relate to the SHEHNILA CORP. for the month of November 2015: Product - A Product – B Production 10,000 units 8,000 units Beginning Inventory 1,000 units 900 units Ending Inventory 2,000 units 100 units Unit Cost applicable to inventories and Production Direct Material Rs. 4 per unit Rs. 3 per unit Direct Labour Rs. 10 per unit Rs. 20 per unit Factory Overhead Rs. 7 per unit Rs. 14 per unit Actual FOH was Rs. 182,400, under or over applied factory overhead is to be adjusted in Cost of Goods Sold. Calculate Conversion Cost.
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $40 $600 Aug. 13 Purchase 5 units at $41 205 Nov. 30 Purchase 11 units at $42 462 Available for sale 31 units $1,267 There are 9 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.
Question 3 Regular output capacity is 130 units per month. Regular cost per unit = K600. Overtime cost per unit K900. Beginning inventory is 0 units. We have the forecast of engine demand shown below: a) Develop a chase plan that matches the forecast. Calculate the cost of the plan. b) Develop a level plan that uses inventory to absorb fluctuations. Compare the costs of the level plan to the costs of the chase plan from Part (a). Inventory carrying cost per unit per month = 20. Backlog cost per unit per month = K900. There should be no backlog in the final month. Month Forecast 1 120 2 3 135 140 4 120 End of assignment 1 5 125 6 125 7 140 = 8 135 Total 1,040
Question 5 Which pattern would you use in the following situation: you have a Product class which knows its own inventory. It should behave differently when it has inventory vs when it doesn't (e.g. a getPrice method returns "$5.99" or "Out of Stock"). Think about which class should be responsible for choosing the behavior in this case. 1) Strategy 2) Observer 3) State Question 8 MVC's big advantage is that you don't need to tie communications between a UI and a data model to a specific implementation. True / False?
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%