a. How much should be produced each period?b. What is ending inventory for each period?c.If inventory carrying cost is $3 per case per period based on ending inventory, what is the totalcost of carrying inventory?d. What is the total plan cost and why?4. The opening backlog is 1200 units. Forecast demand is shown below.a. Calculate the weekly production for level production if the backlog is to be reduced to1000 units,b. Calculate the projected backlog for each week.Week24312001200Forecast 1200DemandPlannedProductionProjectedBacklog1200110051100252061000Total5. A firm plans to make 400 wagons, 200 carts, and 100 sleds. The resource bill shown belowdisplays the amount of critical resources needed to make one average unit of product family:Wood (Board Feet)Labor (Standard Hours)ProductWagon0.750.501.00CartSled30Calculate the total wood AND labor needed to make the total number of items in the productfamily.

Since you have posted multiple questions, we will provide the solution only to the first question as…

Answered: 4. The opening backlog is 1200 units.…

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

What is CAPACITY REQUIREMENTS FORECASTING?
a) GOT7 Soda Pop, Inc., has a new fruits drink. The production planner has assembled the following cost data and demand forecast as follow: [GOT7 Soda Pop, Inc., mempunyai minuman buah-buahan yang baru, Perancang pengeluaran telah mengumpul data tentang kos dan ramalan permintaan seperti berikut:] Quarter Demand 1,800 First Second 1,200 Third 1,600 Fourth 1,300 Table 1: Cost and demand forecast [Jadual 1: Kos dan ramalan permintaan] Previous quater's output 1,300 cases Beginning inventory 0 cases Stockout cost Inventory holding cost Hiring employees Terminating employees Subcontracting cost Unit cost on regular time Overtime cost RM150 RM40 per case at the end of quater RM40 per case RM80 per case RM60 per case RM30 per case RM15 extra per case You as the production planner need to develop an aggregate planning. You are required to: [Anda sebagai perancang pengeluaran perlu membangunkan perancangan agregat Anda dikehendaki untuk:] i) Assess plan A: strategy that hires and fires…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.
Solve all this question compulsory........
Enter the correct shirt order number from the Payoff Table: 1. Maximin Rule: ____ Shirt order 2. Maximax Rule: ____ Shirt order 3. Expected Payoff Rule: ____ Shirt order Decision $ Payoff Table by Game Outcome Shirt Order Win Lose Tie Options Prob=0.5 0.4 0.1 0 0 0 0 1000 800 -200 200 2000 1600 -1500 100
ssume you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.)
1
Sheet 9: Q8 Planning model Q8. Use below table to to find the profit of the company, (production plan is 3000) Y slope 2500 2000 5500 65000 7500 95000 Unit price 15.5 Units 3000 Fixed cost 19000 Y(pkp) X(pkp) alope Var cot sotal cost Sale
JAYB, manager of a Fabrication company, has the following aggregate demand requirements and other data for the upcoming four quarters. Table 5: Forecast and cost information [Jadual 5: Maklumat Ramalan dan kos] Quarter [Suku] Demand [Permintaan] Previous quarter's output [Keluaran suku sebelumnya] 1,500 units 1 1,400 Beginning inventory [Inventori awal] 200 units 2 1,000 Hiring workers [Pengambilan pekerja] RM6 per unit 3 1,500 Laying off workers [Pembuangan pekerja] RM11 per unit 4 1,300 Unit cost [Kos unit] RM30 per unit With the information given, JAYB wants you to calculate the total cost of using chase strategy by hiring and layoff workers.
Jata
Qty Standard Labor Hour Raw Material В Standard Labor 2 Hours Raw Material INDEPENDENT DEMAND Period 1 2 3 4 5 6 Total Product A 1,000 1,000 1,000 1,000 1,000 1,000 6,000 Product B 500 500 ,500 500 16. Products A and B are produced on two different dedicated production lines. If both lines work on the same shift schedule, the ratio of workers on line A to workers on line B is A. 2:1 В. 2:3 С. 2:5 D. 4:1
The Donald Fertilizer Company produces industrial chemi-cal fertilizers. The projected manufacturing requirements (inthousands of gallons) for the next four quarters are 90, 60,90, and 140, respectively. A level workforce is desired, relyingonly on anticipation inventory as a supply option. Stock-outs and backorders are to be avoided, as are overtime andundertime.a. Determine the quarterly production rate required to meettotal demand for the year, and minimize the anticipationinventory that would be left over at the end of the year.Beginning inventory is 0.b. Specify the anticipation inventory that will be produced.c. Suppose that the requirements for the next four quartersare revised to 60, 90, 140, and 90, respectively. If total de-mand is the same, what level of production rate is needednow, using the same strategy as part (a)?

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