Beginning inventory = 200 unitsEnding inventory = 200 unitsSales forecast:12 34Quantity200 300 200 400 300Using the information above, what is the required monthlyproduction to achieve a level production plan?a. 220 Units.O b. 240 Units280 UnitsO d. 340 Units

In order to meet fluctuating demand requirements across a planning horizon of between six months and…

Answered: Using the information above, what is…

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

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
JAN FEB MAR APR MAY BEGINNING INV PERIOD JUN TOTAL BEGINNING WORKERS AVGE. MONTHLY OUTPUT PER WORKER INV. HOLDING COSTS COST/CATEGORY TOTAL COST PER CATEGORY 5,000 8 4,000 0.3 DEMAND 24,000.00 32,000.00 32,000.00 48,000.00 60,000.00 44,000.00 240,000.00 UNITS WORKERS UNITS/WORKER PER CASE/MONTH REG. PROD 0.00 $0.80 CHASE- HIRE/FIRE HIRING COST SUBCONTRACTING FIRING/LAYOFF $1.15 COST COST OVERTIME/ SUBCONTRACT ENDING INV. $1,000 $1.15 $1,500 0.00 $0.30 PER WORKER PER CASE PER WORKER WORKERS HIRE FIRE 0.00 $1,000.00 COST OF PLAN= 0.00 $1,500.00 $
Beginning inventory and purchases Units Unit Cost Total Cost Jan 1 60 $7 $420 April 1 45 $10 $450 July 1 70 $8 $560 September 1 40 $6.50 $260 If ending inventory is 105 units, what is the weighted average of each unit in inventory?
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.
a) b) c) Month January February March Forecast 120 135 140 April 120 May 125 June 125 July 140 August 135 Regular Output Overtime Output Inventory holding cost Backorder cost Hiring Cost Develop a Level Output Plan and identify the total short units in each period and overall in production cycle Develop Chase Output Plan(s) to address the shortage identified in the Level Output Plan. Recommend the most cost-effective plan Capacity Units per $ per Month Unit 500 130 Unlimited 750 50 250 $ per Worker 3000
7. Given the following data, calculate the projected available balance and the planned MPS receipts. The lot size is 100. The demand time fence is 2 weeks. Week Forecast Customer Orders Projected Available Balance MPS 60 1 50 60 2 50 30 3 50 65 4 50 25
Subject: Logistic management Q): calculate inventory turn over ratio, Where sales is 2,000,000COGS is 65% of sales And average inventory is 125,435 What will be inventory ratio in days and weeks
find the MPS start quantity in week 5, and the projected on-hand inventory in week 5. **I need clear a clear step by step solution please** thank you :) Order Policy: 80 units Lead Time: 2 weeks Item B Week Quantity on Hand Forecast 60 1 50 2 3 4. 5 6. 8. 40 40 40 40 40 35 35 Customer orders (booked) | 60 Projected on Hand MPS quantity 20 15 45 10 12 5. MPS start Available-to-promise
Q 6. For the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 15 units per day, and the desired ending inventory is 9000 units. Month 1 3 4 Total Working Days 20 24 12 19 Forecast Demand 28,000 27,500 28,500 28,500 Planned Production Planned Inventory 11,250 [3+2] 2.
Warehouse: 4. What is stock receipt? What consideration should be taken in the stock receipt?
Case Study 4: Inventory Management. I) A Furniture manufacturing company uses 1200 units of an item annually and the cost price is $250 per unit. The ordering costs are $600 per order and holding costs are $4.00 per item per annum. Required: Calculate the economic order quantity. Determine the number of orders per annum. Determine the annual stock holding cost. Determine the annual ordering cost.
a) b) C) d) Suppose we wish to set up a production plan for the JC Company for the next six months. We are given the following information: Number of working days Demand forecast Beginning Inventory Workforce size Labor hours required per unit: Safety stock: Straight-time cost per hour (first 8 hrs) Overtime cost per hour Inventory holding cost (unit/month) Jan 22 2000 157,000 156,000 155,000 158,000 Feb March April 19 21 21 1800 1200 1100 0 30 5 25% of the demand forecast $3,00 $5,00 $1,00 May 22 1100 June 20 1400 JC Company is planning to produce using a constant workforce (given above) on regular time and they will use overtime to meet additional output requirements. Calculate the total cost of this plan.

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

Using the information above, what is the required monthly production to achieve a level production plan?