The options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook  sells each book  through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time and the rest on overtime. The capacity of the publication operation is determined primarily by the total labor hours worked. Therefore, machine capacity does not limit the capacity of the production operation. Because of labor rules, no employee works more than 10 hours of overtime per month. The various costs are shown in Table (b) Currently, Outlook has no limits on subcontracting, inventories, and stockouts/backlog. All stockouts are backlogged and supplied from the following months’ production. Inventory costs are incurred on the ending inventory in the month. The Marketing manager’s goal is to obtain the optimal aggregate plan that allows Outlook to end June with at least 500 unit (i.e., no stockout at the end of June and a least 500 units in inventory). Table a: Period Demand 0   1 1600 2 3000 3 3200 4 3800 5 2200 6 2200             Table b: Item Cost Material cost Rs.10/unit Inventory holding cost Rs.2/unit/month Marginal cost of stockout/backlog Rs.5/unit/month Hiring and training costs Rs.300/worker Layoff cost Rs.500/worker Labor hours required 4/unit Regular time cost Rs.4/hour Overtime cost Rs.6/hour Cost of subcontracting Rs.30/unit   Operational Analytics Understand the problem statement. Come up with a solution in your own words. (Without data analysis

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...
icon
Related questions
Question

The options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a).

Outlook  sells each book  through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time and the rest on overtime. The capacity of the publication operation is determined primarily by the total labor hours worked. Therefore, machine capacity does not limit the capacity of the production operation. Because of labor rules, no employee works more than 10 hours of overtime per month. The various costs are shown in Table (b)

Currently, Outlook has no limits on subcontracting, inventories, and stockouts/backlog. All stockouts are backlogged and supplied from the following months’ production. Inventory costs are incurred on the ending inventory in the month. The Marketing manager’s goal is to obtain the optimal aggregate plan that allows Outlook to end June with at least 500 unit (i.e., no stockout at the end of June and a least 500 units in inventory).

Table a:

Period

Demand

0

 

1

1600

2

3000

3

3200

4

3800

5

2200

6

2200

           

Table b:

Item

Cost

Material cost

Rs.10/unit

Inventory holding cost

Rs.2/unit/month

Marginal cost of stockout/backlog

Rs.5/unit/month

Hiring and training costs

Rs.300/worker

Layoff cost

Rs.500/worker

Labor hours required

4/unit

Regular time cost

Rs.4/hour

Overtime cost

Rs.6/hour

Cost of subcontracting

Rs.30/unit

 

Operational Analytics

  1. Understand the problem statement.
  2. Come up with a solution in your own words. (Without data analysis)
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Differential Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.