1 answer

Please help with the missing numbers above Also Total hiring cost $ _?(enter response as whole...

Question:

The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stoPlan B: Vary the workforce to produce the prior months demand. The firm produced 1,300 units in June. The cost of hiring addPlease help with the missing numbers above

Also

Total hiring cost $ _?(enter response as whole number)

Total layoff cost $ _?(enter response as whole number)

Total inventory carrying cost $ _?(enter response as whole number)

Total stockout cost $ _?(enter response as whole number)

Total cost, excluding normal time labor costs, for Plan B $ _?(enter response as whole number)

The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $20 per unit per month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,100 units per month and subcontract additional units at a $60 per unit premium cost. Subcontracting capacity is limited to 800 units per month. (Enter all responses as whole numbers). Demand 1300 Ending Inventory 0 Subcontract (Units) 200 Month 1 July 2 August 3 September 4 October Production 1,100 1,100 1,100 1150 0 50 1100 0 0 1600 0 500 5 November 1900 1,100 1,100 1,100 0 800 6 December 1900 0 800 The total cost, excluding normal time labor costs, for Plan A = $ 141000. (Enter your response as a whole number.)
Plan B: Vary the workforce to produce the prior month's demand. The firm produced 1,300 units in June. The cost of hiring additional workers is $30 per unit produced. The cost of layoffs is $65 per unit cut back. (Enter all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of 1,300 in July to 1300 in August requires a layoff (and related costs) of 0 units in August). Hire (Units) Layoff (Units) Demand 1300 Ending Inventory Stockouts (Units) Production Month 1 July 2 August 3 September 4 October 1150 1100 NONOOD 1600 5 November 1900 6 December 1900

Answers

Based on the given data, we solve for Plan B using POM-QM as shown below:

We enter the required data as shown below:

Period Demand Regular time Capacity Overtime Capacity Subcontract Capacity Unit costs Value 1 2 3 4 1300 1150 1100 1600 1900

On solving, we get

Demand Regular time Capacity Regular time production Inventory (end PD) Shortage (end PD) Units increase Units decrease Initi

Based on above, we tabulate the required data in the table format as per question:

Month Demand Production Hire (Units) 0 Layoff (units) 0 Ending Inventory 0 150 200 Stockouts (Units) 0 0 0 0 0 0 1 July 2 Aug

As seen from above,

Total hiring cost $ 24000

Total layoff cost $ 13000

Total inventory carrying cost $ 7000

Total stockout cost $ 60000

Total cost, excluding normal time labor costs, for Plan B $ 104000

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!

.

Similar Solved Questions

1 answer
A) D om medles, rubella (MMR) There is aware that the foo t outinely used during...
A) D om medles, rubella (MMR) There is aware that the foo t outinely used during the of Need to a patient 5 percent dextrose in water solution B) 0.9 percent odium chloride (normal saline) c) Stavile water D) Hapurin sodium A male patient needs to receive a unit of whole blood. What type of intraven...
1 answer
What is the arclength of #(t^2lnt,t-lnt)# on #t in [1,2]#?
What is the arclength of #(t^2lnt,t-lnt)# on #t in [1,2]#?...
1 answer
Statisitics
A researcher wishes to study how the average weight Y (in kilograms) of children changesduring the first year of life. He plots these averages versus the age X (in months) anddecides to fit a least-squares regression line to the data with X as the explanatory variable and Y as the response variable....
1 answer
Question 6 10 pts A major retail company plans to build 30,000 square building that would...
Question 6 10 pts A major retail company plans to build 30,000 square building that would cost $8 million to develop. It is expected to lease for $22 per foot (absolute net) with $5 per foot in operating expenses. If the company develops the property and does a sale-leaseback, what price will they g...
1 answer
E9-1 Preparing a Classified Balance Sheet [LO 9-1, LO 9-7] The following is a list of...
E9-1 Preparing a Classified Balance Sheet [LO 9-1, LO 9-7] The following is a list of account titles and amounts (in millions) reported at December 27, 2015, by Hashey, Inc. a leading manufacturer of games, toys, and interactive entertainment software for children and families: $1,104 Equipment 739 ...
1 answer
As part of a study for the Department of Labor Statistics, you are assigned the task...
As part of a study for the Department of Labor Statistics, you are assigned the task of evaluating the improvement in productivity of small businesses Data for one of the small businesses you are to evaluate is shown below. The data are the monthly average of last year and the monthly average this y...
1 answer
Question 10 (4 points) Saved Verify the following chemical equation is balanced: 2 Mg + O2...
Question 10 (4 points) Saved Verify the following chemical equation is balanced: 2 Mg + O2 + 2 Mgo With 2 moles of O2 how many moles of MgO would be produced? (Write only the number of moles in the blank to answer the question! For example write 3 not 3 moles of oxygen)...
1 answer
5. A school is holding a raffle and states that 15 out of 2,500 tickets bought...
5. A school is holding a raffle and states that 15 out of 2,500 tickets bought in the raffle are winners. What is the frequency of a winning ticket? What is the relative frequency? Frequency: 2,500 Relative Frequency: 0.6% Frequency: 2,500 Relative Frequency: 6 % Frequency: 15 Relative Frequency:6 %...
1 answer
Term, ag, is equal to and the 11 term, 41, is equal to 58. Find the...
term, ag, is equal to and the 11 term, 41, is equal to 58. Find the value of the 14" term, 14. If applicable, For a given geometric sequence, the 8 write your answer as a fraction. xs ?...
1 answer
NH,(8) + HCl(g) NH,Cl(s) A 6.55 g sample of NH, gas and a 6.55 g sample...
NH,(8) + HCl(g) NH,Cl(s) A 6.55 g sample of NH, gas and a 6.55 g sample of HCl gas are mixed in a 1.50 L flask at 25°C. Identify the limiting reagent. HCI ONH,CI Ο ΝΗ, How many grams of NH CI will be formed by this reaction? mass: What is the pressure in atmospheres of the gas rem...
1 answer
Application Problem 6-11A a-c DejaVu Company has been in business for several years and has the...
Application Problem 6-11A a-c DejaVu Company has been in business for several years and has the following information for its operations in the current year: Total credit sales Bad debts written off in the year Accounts receivable balance on December 31 (after writing off the bad debts above) $3,186...
1 answer
Based off Java Homework 2 Analyzing Runtimes of Algorithms Homework Objectives Be able to understand the...
Based off Java Homework 2 Analyzing Runtimes of Algorithms Homework Objectives Be able to understand the part of the code • Be able to analyze the efficiency of the given part of the code Introduction We have shown the Big-O Notation. Use Big-O notation to analyze the codes. Task #1 Big-O base...
1 answer
14.4.29-T Question Help The following table shows the number of wins eight teams had during a...
14.4.29-T Question Help The following table shows the number of wins eight teams had during a football season. Also shown are the average points each team scored per game during the season. Construct a 90% prediction interval to estimate the number of wins for teams that scored an average of 21 poin...
1 answer
Describe the screening test procedure for tuberculosis (TB) in hospitals?
Describe the screening test procedure for tuberculosis (TB) in hospitals?...
1 answer
Question 4 Liquid water enters a feedwater heater at inlet 1 with inlet conditions 15 MPa,...
Question 4 Liquid water enters a feedwater heater at inlet 1 with inlet conditions 15 MPa, 40°C at 60 kg/s. Another stream of water in saturated mixture enters the heater at inlet 2 at temperature of 175 °C. The heater operates at steady state and heat transfer to surrounding can be neglecte...
1 answer
Why can't cells be replaced in your spinal cord when injured, often leaving to permanent disability?
Why can't cells be replaced in your spinal cord when injured, often leaving to permanent disability?...
1 answer
The population of Concord in 1980 was 400 greater than half the population Euclid
the population of Concord in 1980 was 400 greater than half the population Euclid. The sum of the two populations was 29,600 less than twice the population of Euclid. What was the population of each city in 1980?...
1 answer
Yolo Windows, a manufacturer of windows for commercial buildings, reports the following account information for last...
Yolo Windows, a manufacturer of windows for commercial buildings, reports the following account information for last year (all costs are in thousands of dollars): Information on January 1 (Beginning): Direct materials inventory $ 88 Work-in-process inventory 117 Finished goods inventory 1,620 Inform...