Southeast Soda​ Pop, Inc., has a new fruit drink for which it has high hopes. John​ Mittenthal, the production​ planner, has assembled the following cost data and demand​ forecast:   demand forecast.                 Quarter Forecast 1 1,900 2 1,200 3 1,600 4 800 ​Costs/Other Data Previous​ quarter's output=1,200 cases Beginning inventory=0 cases Stockout cost of backorders=​$160 per case Inventory holding cost=​$40 per case at end of quarter Hiring employees=​$35 per case Terminating employees=​$80 per case Subcontracting cost=​$65 per case Unit cost on regular time=​$30 per case Overtime cost=​$20 extra per case Capacity on regular time=1,900 cases per quarter John's job is to develop an aggregate plan. The three initial options he wants to evaluate​ are:   • Plan A​: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B​: a level strategy. • Plan C​: a level strategy that produces 1,100 cases per quarter and meets the forecast demand with inventory and subcontracting. Part 2 ​a) Which strategy is the​ lowest-cost plan?   Try hiring and layoffs​ (to meet the​ forecast) as necessary ​(enter your responses as whole​ numbers).   Hiring and Layoff Plan Quarter Forecast Production Hire ​(Units) Layoff ​(Units)     1,200     1 1,900 enter your response here enter your response here enter your response here

PLEASE ANSWER BOTH QUESTIONS without excel     a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively  b) Find the MAD, MSE and MAPE

Problem 9a: Jones Surgicenter uses 90,000 bags of IV solution annually. The optimal safety stock (which is on hand initially) is 1,000 bags. Each bag costs the center $1.50, inventory carrying costs are 20 percent, and the cost of placing an order with the supplier is $15.  Problem 9b: Continuing with the previous question, what is the total inventory cost, TIC? Do not include the dollar sign in your answer.

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

Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 165,400 1,500 100,750 4,400 241,400 2,800 163,800 2,300 139,550 1,200 86,200 2,000 125,000 1 2 3 4 5 6 7 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. $ 28,000 + $48.5 X (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram $ 15,000 X+ $53.14 X X

Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 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 Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text 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.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6

This historical demand for 4 periods demand is 70, 60, 80, and 90 respectively. What is the two-period weighted moving average forecast for fifth period assuming equal weights of 0.5 each O a. None is correct O b. 81.20 O. 70.1 Od. 0.0 O e. 85.00

snip

2

With the attached as reference, how can you justify the use of RFID to manage inventory?