1. Develop an aggregate plan for the following forecastPeriod3 4 5 6 7Total128Forecast1902302602802101701602601801,940There are 20 workers who can produce 10 units per period at a cost of P6.00 per unit.There is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period.Backlog cost is P10.00 per unit per period.Will the present workforce able to produce the forecast?b. What is the total cost of the plan?a.

Total worker = 20 Production = 10 unit per period Cost= P6.00 per unit. Inventory Carrying cost =…

1. Develop an aggregate plan for the following forecast 3 4 5 6 7 8 9 Total Period 1 2 Forecast 190 230 260 280 210 170 160 260 180 1,940 here are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. here is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. acklog cost is P10.00 per unit per period. a. Will the present workforce able to produce the forecast? b. What is the total cost of the plan?

1. Develop an aggregate plan for the following forecast 3 4 5 6 7 8 9 Total Period 1 2 Forecast 190 230 260 280 210 170 160 260 180 1,940 here are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. here is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. acklog cost is P10.00 per unit per period. a. Will the present workforce able to produce the forecast? b. What is the total cost of the plan?

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

Greenfield Equipment is performing demand forecasting. Actual demand for Week 1 – 550, Week 2 – 490, Week 3 – 560, week 4 – 435, and Week 5 – 656. You have been asked to perform exponential smoothing with a delta of 0.3. Week 5 forecast was 519. What is week 6 forecast? Provide answer rounded to 1 decimal place.
Hi, I need help solving for this Operations Management problem. Thank you.
Answer the question
strategy can be used to adjust the capacity for seasonable demand.
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3
State an example of industries where the demand forecasting is dependent on the demand of other products ?
The term in the airline industry may be used to refer to s situation where an empty seat is recorded on a flight. Select one: a. Marginal cost b. Overhead cost c. Marginal loss d. Revenue loss Widner Industries reports annual sales of Ghc160 million, cost of goods sold of Ghc120 million, inventory of Ghc20 million, and net income of Ghc5 million. What is Widner's annual inventory turns? Select one: a. 8 turns per year b. 6 turns per year c. 0.17 turns per year d. 4 turns per year
A company has the following actual and forecasted demand history for eight periods: Period Actual Forecast 1 26 25 31 32 3 45 42 4 50 70 53 64 6. 72 70 78 81 90 88 For which period, the tracking signal exceeds 1.50 first? O a 5 O b.3 Oc.4 Od 2
Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
2
Given an actual demand this period of 100, a forecast value for this period of 130, and an alpha of 0.6, what is the exponential smoothing forecast for next period? (Round answer to the nearest whole number.) O A. 100 OB. 130 C. 82 O D. O E. 112 118
Dwayne Cole, owner of Florida firm that manufactures display cabinets, develops an 8-month aggregate plan. Demand and capacity (in units) are forecast as follows: Сараcity Jan Feb Mar Apr Маy Jun Jul Aug Source (Units) Regular 235 255 290 300 300 290 300 290 Time 30 19 Overtime 20 Subcontract 12 24 26 24 30 28 30 16 15 17 17 19 20 Demand 255 294 321 301 330 320 345 340 The cost of production each unit is $1000 on regular time, $1300 on overtime, and $1800 on a subcontract. Inventory carrying cost is $200 per unit per month. There is no beginning or ending inventory in stock, and no backorders are permitted from period to period. Let the production workforce vary by using regular time first, then overtime and then subcontracting. a) Set up a production plan that minimizes cost by producing exactly what the demand in each month. This plan allows no backorders or inventory. What is this plan's cost? b) Through better planning, regular time production can be set at exactly the same amount,…