7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast fordemand (in cases) for the next six months.MonthMayJunJulForecast4,000 4,800 5,600Aug Sep7,200Oct6,4005,000Use the following information to develop aggregate plans.Regular production costRegular production capacityOvertime production costSubcontracting costHolding costBeginning inventory$10 per case5,000 cases$16 per case$20 per case$1 per case per month0Develop an aggregate plan using each of the following guidelines and compute the total cost for eachplan. Which plan has the lowest total cost?a. Use level production. Supplement using overtime as needed.b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting(500 cases per period maximum) to handle variations in demand.c. Use overtime up to 750 cases per period and inventory to handle variations in demand.

Given Data:Forecast Demand:May: 4,000Jun: 4,800Jul: 5,600Aug: 7,200Sep: 6,400Oct: 5,000Costs:Regular…

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

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

16. Complete the following schedule and then answer Problems 16 and 17. Forecast requirements In transit On Hand 1 35 50 Projected available balance 30 Planned Shipments Shipping quantity = 50, Lead time = 1, Safety stock = 25 2 30 Period 3 45 What will the planned shipments be for periods 2, 3, and 4? a) 25 units for each period b) 50 units for periods 2 and 4; zero units for period 3 4 65 c) 50 units for each period d) 100 units in period 2, zero units in period 3, and 50 units in period 4 e) 75 units in period 2, 35 units in period 3, 20 units in period 4 17. What is the projected available balance for period 4? a) 50 units b) 55 units c) 60 units d) 65 units e) 75 units 5 30
Give typed full explanation
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
1. Net sales for the hosiery department in May wee $30,620. Book inventory at the end of the month showed that $97,831 should be on hand. Physical inventory showed $97,560. Determine shortage or overage percent. Present your answer with a percent sign, rounded to two decimal places (i.e. 19.64%). 2. Using the data below, determine the closing book inventory. Not all information given may be needed. Present your answer with a dollar sign, comma separator, rounded to the dollar. (i.e. $19,567) Opening inventory $89,760 Gross purchases $43,620 RTV $860 Cash discounts $320 Markdowns $5,246 Markdown cancellations $318 Employee discounts $784 Gross sales $49,318 Customer returns $2,945 Net markups $760 3. Calculate the shortage or overage percent, given the following information. Present your answer with a percent sign, rounded to two decimal places (i.e. 19.64%). NOTE. There is another question in this quiz using the same data. Opening inventory…
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
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%
1. Determine the inventory order quantity for Diamant’s distributor.2. Compare the optimal order quantity with a seasonally adjusted forecast for demand. Doesthe order quantity seem adequate to meet the seasonal demand pattern for Diamonds(i.e., is it likely that shortages or excessive inventories will occur)?
c4 need urgent in 15 minutes
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
Q2) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1400 Beginning inventory 200 units 2 1000 Stockout cost $50 per unit 3 1500 Inventory holding cost $8 per unit at end of quarter 4 1300 Hiring workers $5 per unit Laying off workers $10 per unit Unit cost $30 per unit Overtime $10 extra per unit Which of the following production plans is better: Plan A—chase demand by hiring and layoffs; or Plan B—produce at a constant rate of 1200 and obtain the remainder from overtime? Finish the calculation. image
Exercise 1: You are the operations manager at the company Servicios de Salud, Inc., which provides care services to the elderly. An important aspect of your job is ensuring that nursing homes have a healthy inventory of nutritional drinks for residents. Below is the historical demand for the product for one year: Month Historical demand (boxes) Forecasted demand (boxes) January 300 February 340 March 370 April 410 ¿? May 470 ¿? June 570 ¿? July 630 ¿? August 720 ¿? September 640 ¿? October 460 ¿? November 420 ¿? December 390 ¿? a. Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner. b. Discuss any trends or patterns observed in the calculated moving average demand values. c. Make an interpretation of the results and their implications for forecasting…

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