MBA-FPX5016 Assessment 2 instructions

How does the Wilson approach handle demand forecasting and inventory planning for new product launches?

A firm has 56 units of product X on hand. Forecasts of demand are for 20 units per week. An MPS quantity of 100 units is planned to arrive in period 3. Customer orders are 24 for period 1, 18 for period 2, and 15 for period 3. What is the projected on-hand inventory at the end of period 2? Multiple Choice 14 32 12 20 impossible to say without more information

Please do not write in column A Problem 6 Given the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per month, and subcontracting is used if additional units are needed to meet the forecast. Regular time cost $ 40.00 per unit Overtime cost $ 60.00 per unit subcontracting cost $ 80.00 per unit holding cost $ 10.00 per unit per month Production Inventory Costs Month Forecast Level Production Overtime Subcontracting Total Holding Cost Regular Time Overtime Subcontracting Total Cost 1 563 0 2 608 3 648 4 668 5 666 6 688 Totals

Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table 3 shows the information that he able to obtain from the sales & marketing department. After doing the planning, Mr Zulhakim need to present it to his manager. Factory developed a demand forecast based on Table 3 with supplier charges about RM300.00 per unit. The demand forecast is stated as week but, in this planning, it is being considered as an annual quantity for the operation. Ordering cost is RM150.00. Annual holding cost is 10 percent of a purchased price. (b) Develop the ATP of this plan. Initial inventory on hand is 50 units obtained from Year 2021. Lot size for MPS can be obtained by using EOQ model. Table 3: Demand and Customer confirmed order quantity 8 9 10 2 3 10 40 10 00 30 20 40 20 30 Period (Week) 1 4 5 6 7 Forecast (units) Customer orders (booked) (unit) 20 8. 2

please help me with Question 3 thanks! Demand forecasts for 2021 are as follows: Month Demand Jan 140,000 Feb 78,900 Mar 85,800 Apr 89,100 May 123,600 Jun 136,350 Jul 120,450 Aug 106,950 Sep 121,950 Oct 135,750 Nov 87,000 Dec 93,300 Each worker can produce 900 products per month and is paid $1500 per month. Assume that at the end of last year, the company has 100 employees working on the production line. Hiring and layoff (firing) decisions are made at the beginning of each month, and associated costs are charged at that time. It costs the company $400 to hire and $800 to lay off a worker. The company incurs holding cost for the amount of ending inventory in each month, and incurs backorder cost at the end of each month for any unfilled orders. The company incurs $2 per month for holding one unit in inventory and $4 per unit backorder. 1 Prepare a level aggregate plan. Under this level aggregate plan, how…

You are responsible of developing the six-month aggregate production plan at Sodas Galore, a manufacturer of soft drinks. Your company makes three types of sodas: regular, diet and super-caffeinated. All three types are made using the same production process, and the switching costs can be ignored as they are so minimal. The S&OP team case created the following forecast of demand for the next six months. In addition to the sales forecast, the company has also developed planning values that are also shown in the next table. Month Sales Forecast (cases) Softdrinks Planning Values January 24,000 Current workforce 8 workers 32,000 Average monthly output per worker 32,000 Inventory holding cost 46,000 Regular wage rate February 4,000 cases per month $.30 per case per month $20.00 per hour March April May 60,000 Regular production hours/month 44,000 Overtime wage rate 160 hours June $30.00 per hour 240,000 Hiring cost $1,000 per worker $1.15 per case Total Subcontracting cost Firing/layoff…

Given the following forecast and cost information,        determine the total cost of a plan that uses regular time       production output of 600 units per month, overtime is        used when needed up to a maximum of 60 units per       month, and subcontracting is used if additional units are needed to meet the forecast       Regular time cost  $                            40.00 per unit   Overtime cost  $                            60.00 per unit (60 max)   subcontracting cost  $                            80.00 per unit   holding cost   $                            10.00 per unit per month    month 1 forecast 563 month 2 forecast 608 month 3 forecast 648 month 4 forecast 668 month 5 forecast 666 month 6 forecast 688   Show in Excel

The schedular at ZamTech uses MPS time-phased records for planning and item production. The planner is currently working on a schedule for a strut assembly, one of ZamTechs top-selling spare parts.The planner uses a production lot size of 170 and a safety stock of 15 for the strut assembly. The planner has the following forecasts (Ft) and orders (Dt) for the next 8 weeks, as shown in Table 1. Table 1 Week 1 2 3 4 5 6 7 8 Ft 130 130 130 140 140 140 145 145 Dt 45 38 18           Required: a) Help the master production scheduler to fill in the MPS time-phased record shown in Table 2 for the strut assembly. There are 120 units on hand. Table 2   1 2 3 4 5 6 7 8 Ft                 Dt                 EIt-1                 Pt                 EIt                 ATPt                 b) Can the planner accept the following orders? Update the MPS time-phased record for accepted orders, in Table 3. Table 3 Order Quantity Desired week 1 120 4 2 144 6 3 100 2…

Weighted moving average using Excel:3.1 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.55, 0.1, 0.1, 0.1, 0.1, 0.053.2 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.2, 0.2, 0.2, 0.15, 0.15, 0.13.3 Plot the two weighted moving average forecasts together with the actual demand. Comment on the obtained graph.3.4 Using the forecasting error measures seen in class, evaluate the forecasting error of each method. Accordingly which method is better?

production planning and control please help

Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)

PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month period.  Month Demand Forecast     1     492               488     2     470   484     3     485               480     4     493               490     5     498               497     6                 492   493 Required: Compute for the MAD, MSE, and MAPE.

Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand inventory of 110 units. There is a 2-week demand time fence and a12-week planning time fence. The following table gives the original forecast and theactual customer orders for the next 12 weeks:Week 1 2 3 4 5 6 7 8 9 10 11 12Forecast 80 80 80 70 70 70 70 70 70 70 70 70Demand 83 78 65 61 49 51 34 17 11 7 0 0a. Given this information, develop a realistic master schedule, complete with ATPlogic.b. Tell how you would respond to each of the following customer order requests.Assume these are independent requests, and do not have cumulative effects.■ 20 units in week 3■ 40 units in week 5■ 120 units in week 7