Please calculate the correct values for apprentices hired and craftspeople fired for each month, also calculate the total cost, thank you! king GlassmeworkWeek 4: Modeling - 202310 BAD305-OS Introd....New Exercise Bank Content Qu. 07-07Click here for the Excel Data FileAllen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They haveforecasted 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 trainingat a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing andlearning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trainedcraftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severancepay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least25 trained craftspeople.Complete this question by entering your answers in the tabs below.Required A Required BApprentices hiredCraftspeople firedBuild 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 requirementsfor this next year at the minimum possible cost?b. Determine the total cost.January50February70How 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.MarchM McGraw Hill - Connect73April50May00June02ezto.mheducation.comJulySaved00October10November00DecemberC80Das king GlassmeworkWeek 4: Modeling - 202310 BAD305-OS Introd....New Exercise Bank Content Qu. 07-07Click here for the Excel Data FileAllen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They haveforecasted 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 trainingat a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing andlearning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trainedcraftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severancepay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least25 trained craftspeople.Complete this question by entering your answers in the tabs below.Required A Required BApprentices hiredCraftspeople firedBuild 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 requirementsfor this next year at the minimum possible cost?b. Determine the total cost.January50February70How 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.MarchM McGraw Hill - Connect73April50May00June02ezto.mheducation.comJulySaved00October10November00DecemberC80Das

Question

Please calculate the correct values for apprentices hired and craftspeople fired for each month, also calculate the total cost, thank you! king GlassmeworkWeek 4: Modeling - 202310 BAD305-OS Introd....New Exercise Bank Content Qu. 07-07Click here for the Excel Data FileAllen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They haveforecasted 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 trainingat a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing andlearning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trainedcraftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severancepay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least25 trained craftspeople.Complete this question by entering your answers in the tabs below.Required A Required BApprentices hiredCraftspeople firedBuild 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 requirementsfor this next year at the minimum possible cost?b. Determine the total cost.January50February70How 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.MarchM McGraw Hill - Connect73April50May00June02ezto.mheducation.comJulySaved< Required A02M Question 4 - Week 4 Homework- ConnectAugust00SeptemberRequired B >00October10November00DecemberC80Das king GlassmeworkWeek 4: Modeling - 202310 BAD305-OS Introd....New Exercise Bank Content Qu. 07-07Click here for the Excel Data FileAllen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 21 trained craftspeople. They haveforecasted 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 trainingat a cost of $2,500 per hire. New hires are called apprentices for their first month. Apprentices spend their first month observing andlearning. They are paid $2,000 for the month, but provide no labor. In their second month, apprentices are reclassified as trainedcraftspeople. The union contract allows for firing a craftsperson at the beginning of a month, but $1,500 must be given in severancepay. Moreover, at most 10 percent of the trained craftspeople can be fired in any month. Allen would like to start next year with at least25 trained craftspeople.Complete this question by entering your answers in the tabs below.Required A Required BApprentices hiredCraftspeople firedBuild 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 requirementsfor this next year at the minimum possible cost?b. Determine the total cost.January50February70How 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.MarchM McGraw Hill - Connect73April50May00June02ezto.mheducation.comJulySaved< Required A02M Question 4 - Week 4 Homework- ConnectAugust00SeptemberRequired B >00October10November00DecemberC80Das

Accepted Answer

Aggregate planning is a marketing activity that does an aggregate plan for the production process,…