7-3. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecastfor demand (in cases) for the next eight months.month Aprforecast 4500May4400Jun6200Jul6400Aug5800Sep6600Oct7200Nov6900Use the following information to develop aggregate plans.Regular production cost: $10.00 per caseRegular production capacity: 5,000 casesOvertime production cost: $16 per caseSubcontracting cost: $20 per caseHolding cost: $1 per case per monthBeginning inventory: 0Develop an aggregate plan using each of the following guidelines and compute the total cost foreach plan. Which plan has the lowest total cost?(a) Use level production of 5,000 case per month. Supplement using overtime as needed(b) Use a combination of overtime (500 cases per month for the first five months), inventory, andsubcontracting (500 cases per month from September to November, if necessary) to handlevariations in demand. Note that suitable amounts of overtime for the last three months shouldbe found to determine the total cost.

Given information to develop aggregate plans:Regular production cost: $10.00 per caseRegular…

Answered: 7-3. Nowjuice, Inc., produces Shakewell…

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

1. Develop an aggregate plan for the following forecast Period 3 4 5 6 7 Total 1 2 8 Forecast 190 230 260 280 210 170 160 260 180 1,940 There 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.
Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole number
Table 5.1: The demand forecast developed for the year ended 31 December 2022. Month Production days Demand forecast Jan 16 150 Feb 16 150 Mar 23 250 Apr 21 250 May 22 400 Jun 22 500 Jul 21 600 Aug 20 750 Sep 20 450 Oct 20 250 Nov 16 150 Dec 16 150 1. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). 2. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number).
March demand was pridicted at 590 units of gear cycles of trevaa Itd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same.
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.
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. 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. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
Solve the following questions Q1. A. From the following forecast determine the monthly inventory balances required to follow a plan of letting the inventory absorb all fluctuations in demand. In this case, we have a constant work force, no idle time or overtime, no back orders, no use of subcontractors, and no capacity adjustment. Assume that the firm does not use safety stock or cushion inventory to meet the demand. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month Forecasted demand 90 220 210 400 612 700 378 220 200 110 100 260 Production days 22 18 21 20 22 20 21 22 20 25 19 20
The forecast demand for fudge for the next four months is 120, 160, 20, and 60 pounds. a. What is the recommended production rate if a level strategy is adopted with no backorders or stock outs? b. What is the ending inventory for Month 4 under this plan? c. What is the level production rate with no ending inventory in month 4.
Prepare a master production schedule with the information given as follows. The forecast for each week of am eight week schedule is 50 units. The MPS rule is to schedule production if the projected on hand inventory would be negative without it. Customer orders are as follows. Production lot size is 75, safety stock is 10 and no beginning on hand inventory. Calculate available to promise (ATP) quantity for each period. Week Customer Orders 1 52 2 35 3 20 4 12 Period Forecast Cust.Ord. SS Proj. OH MPS ATP
21. Given the forecast and booked orders shown in the table below, and a beginning inventory of 45, what is the master production schedule quantity for period 4 if you want to end period 4 with 0 inventory? Period 1 2 3 4 Forecasted Demand 70 65 60 55 Booked Orders 80 60 30 50 Projected ending inventory Master production schedule 70 60 65 Available to Promise 0 Group of answer choices 35 30 20 25
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
Demand for the last four months was: July,20 units; August, 25 units; September, 34 units; October, 36 units. If the naive method was used to forecast the demand, what would MSE be for these months? O 5.33 O 17.34 O 1.25 O Correct answer is not provided. O 55

SEE MORE QUESTIONS

Recommended textbooks for you

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

SEE MORE TEXTBOOKS