Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 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,200 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. Click here for the Excel Data File 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. Complete this question by entering your answers in the tabs below. Required A Required B 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 Note: Leave no cells blank. Enter zero (0) whenever required. January February March April May June July August September October November December Apprentices hired Craftspeople fired Required A Required B > Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 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,200 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. Click here for the Excel Data File 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. Complete this question by entering your answers in the tabs below. Required A Required B Determine the total cost. Total cost < Required A Required B A1 1 2 4 6 7 8 9 10 11 Home 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Paste Insert X Draw Arial В I U✔ A Craftsman Wage per month! Apprentice Wage per month Hiring Cost Severance Pay Labor Hours/Craftsman/Month Starting Trained Craftsmen Maximum Layoffs Page Layout Apprentices Hired Craftsmen Fired Required Labor Hours x✔ fx Craftsman Wage per month B C $3,000 $2,200 $2,500 $1,500 200 20 10% Jan ✓ 10 3400 Feb Formulas 4000 au AA D Mar V 4200 E Apr 4200 Data F May 3000 Review G Jun 2800 View H Jul 3000 Automate 2 Wrap Text Merge & Center Aug 4000 2 Sep Developer 4500 K Oct 5000 General Tell me $%9 L Nov 5200 M Dec 4800 89 N Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 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,200 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. Click here for the Excel Data File 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. Complete this question by entering your answers in the tabs below. Required A Required B 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 Note: Leave no cells blank. Enter zero (0) whenever required. January February March April May June July August September October November December Apprentices hired Craftspeople fired Required A Required B > Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 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,200 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. Click here for the Excel Data File 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. Complete this question by entering your answers in the tabs below. Required A Required B Determine the total cost. Total cost < Required A Required B A1 1 2 4 6 7 8 9 10 11 Home 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Paste Insert X Draw Arial В I U✔ A Craftsman Wage per month! Apprentice Wage per month Hiring Cost Severance Pay Labor Hours/Craftsman/Month Starting Trained Craftsmen Maximum Layoffs Page Layout Apprentices Hired Craftsmen Fired Required Labor Hours x✔ fx Craftsman Wage per month B C $3,000 $2,200 $2,500 $1,500 200 20 10% Jan ✓ 10 3400 Feb Formulas 4000 au AA D Mar V 4200 E Apr 4200 Data F May 3000 Review G Jun 2800 View H Jul 3000 Automate 2 Wrap Text Merge & Center Aug 4000 2 Sep Developer 4500 K Oct 5000 General Tell me $%9 L Nov 5200 M Dec 4800 89 N
Expert Answer:
Answer rating: 100% (QA)
Well first set up the problem and then provide the solution This problem can be solved using a linear programming approach in a spreadsheet but Ill de... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these programming questions
-
What is Data Warehouse and explain data warehouse Architecture ? Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare...
-
In 2018, Gig Harbor Heavy Metal, Inc. announced an after tax profit of $587,990. In 2019, it announced an after tax profit of $571,222. What is the percent change in after tax profits from 2018 to...
-
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 trained craftspeople. They have forecasted their labor needs over the next 12 months as shown in...
-
Assume that you are purchasing shares in a company in the variety store and gas bar supply business. Suppose you have narrowed the choice to BFI Trading Ltd. and Lin Corp. and have assembled the...
-
When you step out of a swimming pool on a hot, dry day in the Southwest, you feel quite chilly. Why?
-
As your instructor directs, a. Identify other visuals besides tables that you might use to help analyze each of the data sets in Figures 8.28 and 8.29. b. Identify and create a visual for one or more...
-
During a brainstorming session, a suggestion is made that the most likelihood of fraud in a particular division is in the area of acquisition and payment cycle. Outline five audit steps to help find...
-
Ethics and pricing. Instyle Interior Designs has been requested to prepare a bid to decorate four model homes for a new development. Winning the bid would be a big boost for sales representative Jim...
-
Important Instructions: - Underline the keywords in your answer - Separate each idea with a paragraph. - Your answer should demonstrate your understanding of the various dimensions of the con...
-
Dry Quick (DQ) is a medium-sized, private manufacturing company located near Timmins, Ontario. DQ has a June 30 year-end. Your firm, Poivre & Sel (P&S), has recently been appointed as auditors forDQ....
-
American companies are starting to test the extent of their pricing power. Faced with rising costs for materials, transportation and workers, companies are charging more for products from metal...
-
Assume that Harris Company acquires $ 2 , 4 0 0 cash from creditors and $ 3 , 0 0 0 cash from investors. Required b . If Harris has a net income of $ 2 , 4 0 0 and then liquidates, what amount of...
-
In its first year of operations, Roma Company reports the following. Earned revenues of $65,000 ($57,000 cash received from customers). Incurred expenses of $35,500 ($27,250 cash paid toward them)....
-
Some argue that given the existence of control charts, acceptance sampling is not needed. What do you think about this argument? If you were to construct an acceptance sampling plan, how would you...
-
Can someone answer this derivatives question in its entirety? Can you please show how you got the answers? Suppose the spot CAD/GBP exchange rate is 1.62, the 1-year continuously compounded rate in...
-
In short essay explain why student with bachelor's degree in finance need to complete Master of Business Administration in finance concentration? Why MBA in finance is important in the real-world?...
-
Calculate the Land Transfer Tax payable by the purchaser for the following properties: a) Single family residence in London, ON, purchase price $210,000.00 b) Single family residence in Kingston, ON,...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
The Hammaker Company's newest product has had the following sales during its first five months: 5, 17, 29, 41, 39. The sales manager now wants a forecast of sales in the next month a. Use the...
-
Vincent Cuomo is the credit manager for the Fine Fabrics Mill. He is currently faced with the question of whether to extend $100,000 of credit to a potential new customer, a dress manufacturer....
-
Consider the M/M/s model. For each of the following two cases, generate a data table that gives the values of L, Lq, W, Wq, and P{W > 5} for the following mean arrival rates: 0.5, 0.9, and 0.99...
-
Initially, a 200-gallon tank is filled with pure water. At time \(t=0\), a salt concentration with 3 pounds of salt per gallon is added to the container at the rate of 4 gallons per minute, and the...
-
You make 2 quarts of salsa for a party. The recipe calls for 5 teaspoons of lime juice per quart, but you had accidentally put in 5 tablespoons per quart. You decide to feed your guests the salsa...
-
Consider the epidemic model leading to the system in Expression (3.153). Choose the constants as \(a=2.0\) days \(^{-1}, d=3.0\) days \(^{-1}\), and \(r=1.0\) day \(^{-1}\). What are the eigenvalues...
Study smarter with the SolutionInn App