Dog onstionstionestionOn-hand inventory at end of week 1: 60Week2360160Forecasted demandBooked ordersProjected ending inventoryMaster production scheduleAvailable to promise9003210235Print439010041056240 390110120Done880728017083002808602809340300 KComplete the following master schedule record.Click the icon to view the master schedule record.Complete the master production schedule (enter your responses as whole numbers).On-hand inventory at end of week 1: 60WeekForecasted demandBooked ordersProjected ending inventoryMaster production schedule23601609003210235439010041052401106390120880728017083002808609340300

Answered: Image /qna-images/answer/6084c7d4-7054-4bd9-8678-8680a5569b07.jpg

Answered: Complete the master production schedule…

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

|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…
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 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-sout (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) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
Q3. What is inventory management? Explain in brief 4 functions of inventory management.
A Figure 16.19 B (1) C(2) LT = 1 LT = 2 TABLE 16.1 D (1) INVENTORY RECORD DATA ITEM LT = 3 DATA CATEGORY Lat sizing rule Lead time Scheduled rece pts FOQ = S00 units 3 weeks POQ (P=3) L4L 1 week 2 weeks Nane 200 (week 1) None Beginning (on hand) inventory 20 425 POQ tum: 8 Lat sie: POQP - 3) Description. Lead time: 1wek Week 10 Gross 100 200 120 180 60 requirements Scheduled Projected on hand inventory Hanned receipti Hanned order reteases L4L tam: C Lat sue: LAL Description Lead time 2 weks Week 10 Gross 200 400 240 120 requirements Scheduled cepts Projected on hand imventory Hanned recets Manned ordur releases
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
Define INVENTORY CONTROL?
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.
Q4// A company producing compressors, decided to make a particular item in batches. The following information is available: • Receiving and inspecting = 10$ per order Verifying and payment of bill = 10$ per order • Other ordering and set up cost = 25$ per order • Consumption rate of item = 65 item per month %3D • Insurance = 3 $ per item in year • Storage and handling cost = 2$ per item in year • Taxes = 3 $ per item in year • Other inventory carrying cost = 4$ per item in year • Item cost = 5$ per item Calculate the Economic Batch Quantity, the number of lots, the total cost of one year requirement and what is the cycle time of order.
Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
Year Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1 503,425 10,300 12,400 2 643,056 12,400 11,200 3 690,432 11,200 10,670 4 734,509 10,670 11,200 5 758,734 ? 10,987 REQUIRED Determine the inventory turnover for year 5. Determine the number of days the finished goods stay in inventory in Year 1. There was no improvement in inventory turnover in Year 5 compared to Year 1. This statement is not correct. Write YES or NO for the answer
Question 7 Firm develop new products to a.gain market share and build brand equity b.keep their research and development teams gainfully employed c.take up slack in capacity d.gain first mover advantage and eliminate waste Question 8 Economic order quantity (EOQ) assumes all of the following conditions apply .demand is known and is constant over time .there are no shortages allowed.lead time for the receipt of orders is constant.Order quantity is received all at once true or false? question 10 Trade-offs in the new product development relate to A.Product / service design, time to market and profitability B.Proft. Expenditure and market share C.Time. cost and quality D.Market reach, product / service design and timing
Subject: Logistic management Q): What are the concern of inventory control & overall objective of inventory management? Q): What are the system of inventory counting?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS