5. Formulate a level sales and operations plan for a company with the followingpredicted demand:MonthDemand6,30029,00036,00049,000515,00066,000Total51,300The beginning workforce is 125 employees. The monthly output per employee is150 units. The costs to hire and lay off a worker are $2,500 and $4,000, respectively.The cost to carry an item in inventory for one month is estimated at $10, and thestockout cost is $25 per unit. Show the production schedule, the inventory levels,and the changes in workforce from period to period. Compute the plan's cost.

Aggregate planning is a strategic process used in business and operations management to determine…

Answered: 5. Formulate a level sales and…

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

snip
What is the BOM stock needed for the shoe department for April if the sales are planned at $64,000 and the stock to sales ratio is 18.3?
OQ17
Handerson Corporation makes a product with the following standard costs: Direct materials Direct labor Variable overhead Standard Quantity or Hours 8.5 kilos 0.4 hours 0.4 hours Standard Price or The company reported the following results concerning this product in August. Actual output Raw materials used in production Purchases of raw materials Rate $ 6.00 per kilo $ 20.00 per hour $ 6.00 per hour 3,200 units 29,030 kilos 31,600 kilos Actual direct labor-hours 1,160 hours Actual cost of raw materials purchases $ 195,920 $ 22,736 Actual variable overhead cost $ 7,540 Actual direct labor cost The company applies variable overhead on the basis of direct labor-hours. The direct materials purchases variance is computed when the materials are purchased. The materials price variance for August is: Multiple Choice $5,440 F
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders occur. There are 100 workers on January 31. You are given the following demand forecast: February, 90,000; March 65,000; April 110,000; May, 55,000. Productivity is four units per worker hour, eight hours per day, 20 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $10 per unit-month; straight-time labor, $10 per hour; overtime, $15 per hour; backorder, $20 per unit a. Find the total cost of this plan?
Don't mind the number i already wrote
An investment proposal will have weekly fixed costs (FC) of $5,000, variable costs (v) of $35 per unit of output, revenue (R) of $55 per unit of output, and an effective capacity of 25 units per week. What is the monthly break-even quantity (QBEP)? Express in units. Assume a 4-week month. Multiple Choice 250 100 1,000 667
The Morning Brew Coffee Shop sells Regular, Cappuccino, and Vienna blends of coffee. The shop's current daily labor cost is $320, the equipment cost is $125, and the overhead cost is $225. Daily demands, along with price and material costs per beverage, are given below: Regular Vienna Cappuccino Coffee coffee Beverages sold 400 100 200 Price per beverage $2.00 Material per beverage ($) $0.50 $3.00 $0.75 $4.00 $1.25 Harald Luckerbauer, the manager at Morning Brew Coffee Shop, would like to understand how adding Eiskaffee (a German coffee beverage of chilled coffee, milk, sweetener, and vanilla ice cream) will alter the shop's productivity. Her market research shows that Eiskaffee will bring in new customers and not cannibalize current demand. Assuming that the new equipment is purchased before Eiskaffee is added to the menu, Harald has developed new average daily demand and cost projections. The new equipment cost is $200, and the overhead cost is $350. Modified daily demands, as well…
1.Describe the overall frameworks for resource planning in both goods-producing and service-providing organizations. 2.Explain options for aggregate planning 3.Explain the three basic strategies for aggregate planning.
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $125 per unit, inventory carrying costs of $30 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $60 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). Ending Subcontract Month Demand Production Inventory (Units) 1 July 1200 1,200 2 August 1300 1,200 3 September 1200 1,200 4 October 1700 1,200 November 1650 1,200 December 1400 1,200 The total cost, excluding normal time labor costs, for Plan A = $ (Enter your response as a whole number.)
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: May 2,100 January February 1,450 1,700 1,700 June 2,300 July 1,900 March April 1,700 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $65 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the following plan. This exercise contains only Plan E. Plan E: Keep the current workforce, which is producing 1,600 units per month, and subcontract to meet the rest of the demand. Subcontract cost is $75 per unit. Month 10 December 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August Demand 1,450 1,700 1,700 1,700 2,100 2,300 1,900 1,300 Production (Units) 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 Plan E Ending Subcontract (Units) Inventory 200 The total subcontracting cost = $ (Enter your response as…
The table below contains monthly (six months) demand estimates and working days per month. Month Demand Production Days JAN 1,500 20 FEB 1,200 24 MAR 1,000 25 APR 1,600 25 MAY 1,100 20 JUN 1,300 26 For the implementation of “Level” strategy, the average demand (in units/day) over the six- month planning horizon is equal to; a. 40 b. 50 c. 55 d. 75

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