Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor- hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least 25 trained craftspeople.
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor- hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least 25 trained craftspeople.
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...
Related questions
Question
Please calculate the correct values for apprentices hired and craftspeople fired for each month, also calculate the total cost, thank you!
![king Glass
mework
Week 4: Modeling - 202310 BAD305-OS Introd....
New Exercise Bank Content Qu. 07-07
Click here for the Excel Data File
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have
forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor-
hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training
at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and
learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained
craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance
pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least
25 trained craftspeople.
Complete this question by entering your answers in the tabs below.
Required A Required B
Apprentices hired
Craftspeople fired
Build and solve a linear programming spreadsheet model to maximize the profit over all 12 months.
a. How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements
for this next year at the minimum possible cost?
b. Determine the total cost.
January
5
0
February
7
0
How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements for this next year at the minimum possible cost?
Note: Leave no cells blank. Enter zero (0) whenever required.
March
M McGraw Hill - Connect
7
3
April
5
0
May
0
0
June
0
2
ezto.mheducation.com
July
Saved
< Required A
0
2
M Question 4 - Week 4 Homework- Connect
August
0
0
September
Required B >
0
0
October
1
0
November
0
0
December
C
8
0
Das](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F03244c92-a045-4a82-adda-2cbd44aad997%2F9f07aef9-dda6-4176-9f08-de611876af2d%2Fat64gln_processed.jpeg&w=3840&q=75)
Transcribed Image Text:king Glass
mework
Week 4: Modeling - 202310 BAD305-OS Introd....
New Exercise Bank Content Qu. 07-07
Click here for the Excel Data File
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have
forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor-
hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training
at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and
learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained
craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance
pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least
25 trained craftspeople.
Complete this question by entering your answers in the tabs below.
Required A Required B
Apprentices hired
Craftspeople fired
Build and solve a linear programming spreadsheet model to maximize the profit over all 12 months.
a. How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements
for this next year at the minimum possible cost?
b. Determine the total cost.
January
5
0
February
7
0
How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements for this next year at the minimum possible cost?
Note: Leave no cells blank. Enter zero (0) whenever required.
March
M McGraw Hill - Connect
7
3
April
5
0
May
0
0
June
0
2
ezto.mheducation.com
July
Saved
< Required A
0
2
M Question 4 - Week 4 Homework- Connect
August
0
0
September
Required B >
0
0
October
1
0
November
0
0
December
C
8
0
Das
![king Glass
mework
Week 4: Modeling - 202310 BAD305-OS Introd....
New Exercise Bank Content Qu. 07-07
Click here for the Excel Data File
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have
forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor-
hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training
at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and
learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained
craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance
pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least
25 trained craftspeople.
Complete this question by entering your answers in the tabs below.
Required A Required B
Apprentices hired
Craftspeople fired
Build and solve a linear programming spreadsheet model to maximize the profit over all 12 months.
a. How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements
for this next year at the minimum possible cost?
b. Determine the total cost.
January
5
0
February
7
0
How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements for this next year at the minimum possible cost?
Note: Leave no cells blank. Enter zero (0) whenever required.
March
M McGraw Hill - Connect
7
3
April
5
0
May
0
0
June
0
2
ezto.mheducation.com
July
Saved
< Required A
0
2
M Question 4 - Week 4 Homework- Connect
August
0
0
September
Required B >
0
0
October
1
0
November
0
0
December
C
8
0
Das](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F03244c92-a045-4a82-adda-2cbd44aad997%2F9f07aef9-dda6-4176-9f08-de611876af2d%2Fwps2zmp_processed.jpeg&w=3840&q=75)
Transcribed Image Text:king Glass
mework
Week 4: Modeling - 202310 BAD305-OS Introd....
New Exercise Bank Content Qu. 07-07
Click here for the Excel Data File
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They have
forecasted their labor needs over the next 12 months as shown in the following table. Each trained craftsperson provides 200 labor-
hours per month and is paid a wage of $3,000 per month. Hiring new craftspeople requires advertising, interviewing, and then training
at a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing and
learning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trained
craftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severance
pay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least
25 trained craftspeople.
Complete this question by entering your answers in the tabs below.
Required A Required B
Apprentices hired
Craftspeople fired
Build and solve a linear programming spreadsheet model to maximize the profit over all 12 months.
a. How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements
for this next year at the minimum possible cost?
b. Determine the total cost.
January
5
0
February
7
0
How many apprentices should be hired and how many craftspeople should be fired in each month to meet the labor requirements for this next year at the minimum possible cost?
Note: Leave no cells blank. Enter zero (0) whenever required.
March
M McGraw Hill - Connect
7
3
April
5
0
May
0
0
June
0
2
ezto.mheducation.com
July
Saved
< Required A
0
2
M Question 4 - Week 4 Homework- Connect
August
0
0
September
Required B >
0
0
October
1
0
November
0
0
December
C
8
0
Das
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.