A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There are 8 hours of production per day a) The firm would like to begin development of an aggregate plan. For this plan, plan 5, the firm wishes to maintain a constant workforce of 6, using subcontracting to meet remaining demand. Evaluate this plan. To determine whether this plan is desirable, first calculate demand per day for each month (enter your responses rounded to the nearest whole number). MES Table 1 Avg Dem Per Prod. Day Inventory carrying cost Other data $5 per unit per month Production Demand Month Days 22 Forecast 900 Subcontracting cost per unit $10 per unit Average pay rate Overtime pay Rate 1 January 2 February 3 March 4 April 5 May 6 June $5 per hour ($40 per day) $7 per hour (above 8 hrs per day) 1.6 hrs per unit $300 per unit 18 700 21 800 Labor-hours per unit Cost of increasing daily production rate (hiring & training) Cost of decreasing daily production rate (layoffs) 21 1,200 22 1,500 20 1,100 $600 per unit The production rate per day =Ounits. (Enter your response as a whole number.) Fill in the table below. (Enter your responses as whole numbers,) 寶TT Subcontract Month 1 January Regular Demand Production 900 (Units) 2 February 700 3 March 800 4 April 1,200 5 May 6 June 1,500 1,100 The total regular production cost = S (Enter your response as a whole number.) The total subcontracting cost = S. (Enter your response as a whole number.) Total cost with plan 5 = S (Enter your response as a whole number.) b) Juarez has yet a sixth plan. A constant workforce of 7 is selected, with the remainder of demand filled by subcontracting. Evaluate this plan.
A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There are 8 hours of production per day a) The firm would like to begin development of an aggregate plan. For this plan, plan 5, the firm wishes to maintain a constant workforce of 6, using subcontracting to meet remaining demand. Evaluate this plan. To determine whether this plan is desirable, first calculate demand per day for each month (enter your responses rounded to the nearest whole number). MES Table 1 Avg Dem Per Prod. Day Inventory carrying cost Other data $5 per unit per month Production Demand Month Days 22 Forecast 900 Subcontracting cost per unit $10 per unit Average pay rate Overtime pay Rate 1 January 2 February 3 March 4 April 5 May 6 June $5 per hour ($40 per day) $7 per hour (above 8 hrs per day) 1.6 hrs per unit $300 per unit 18 700 21 800 Labor-hours per unit Cost of increasing daily production rate (hiring & training) Cost of decreasing daily production rate (layoffs) 21 1,200 22 1,500 20 1,100 $600 per unit The production rate per day =Ounits. (Enter your response as a whole number.) Fill in the table below. (Enter your responses as whole numbers,) 寶TT Subcontract Month 1 January Regular Demand Production 900 (Units) 2 February 700 3 March 800 4 April 1,200 5 May 6 June 1,500 1,100 The total regular production cost = S (Enter your response as a whole number.) The total subcontracting cost = S. (Enter your response as a whole number.) Total cost with plan 5 = S (Enter your response as a whole number.) b) Juarez has yet a sixth plan. A constant workforce of 7 is selected, with the remainder of demand filled by subcontracting. Evaluate this plan.
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 13P: The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal...
Related questions
Question
please answer within 30 minutes.
Transcribed Image Text:A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There are 8 hours of production per day.
a) The firm would like to begin development of an aggregate plan. For this plan, plan 5, the firm wishes to maintain a constant workforce of 6, using subcontracting to meet remaining demand. Evaluate this plan.
To determine whether this plan is desirable, first calculate demand per day for each month (enter your responses rounded to the nearest whole number).
Table 1
Avg Dem Per
Prod. Day Inventory carrying cost
Other data
$5 per unit per month
Production
Demand
Month
Days
22
Forecast
Subcontracting cost per unit $10 per unit
Average pay rate
Overtime pay Rate
$5 per hour ($40 per day)
$7 per hour (above 8 hrs per
day)
1.6 hrs per unit
$300 per unit
1 January
2 February
900
18
700
3 March
21
800
Labor-hours per unit
Cost of increasing daily
production rate (hiring &
training)
Cost of decreasing daily
production rate (layoffs)
4 April
21
1,200
5 May
22
1,500
6 June
20
1,100
S600 per unit
The production rate per day = units. (Enter your response as a whole number.)
Fill in the table below. (Enter your responses as whole numbers.)
Regular
Production
Subcontract
Month
Demand
(Units)
1 January
2 February
900
700
3 March
800
4 April
1,200
5 May
1,500
6 June
1,100
The total regular production cost = S (Enter your response as a whole number.)
The total subcontracting cost = $ (Enter your response as a whole number.)
Total cost with plan 5 = S (Enter your response as a whole number.)
b) Juarez has yet a sixth plan. A constant workforce of 7 is selected, with the remainder of demand filled by subcontracting. Evaluate this plan.
The production rate per day =| Tunits. (Enter vour response as a whole number.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning