Given the following production plan, compute the monthly production, ending inventory/(backlog) and workforce levels using a...
Given the following production plan, compute the monthly production, ending inventory/(backlog) and workforce levels using a level production strategy. Assume that a worker can produce 30 units per month and the beginning inventory in June is 400 units, and the firm desires to have 200 units of inventory at the end of November.
| Month | June | Jul | Aug | Sep | Oct | Nov |
| Demand | 1500 | 2800 | 4200 | 3600 | 2350 | 1400 |
| Production | ||||||
| Ending Inventory | ||||||
| Workforce |
Homework Answers
Below is the screenshot of the formula applied -
Below is the screenshot of the result -
Add Answer to:
Given the following production plan, compute the monthly
production, ending inventory/(backlog) and workforce levels using a...
Given the following production plan: Briefly explain the differences between a Chase Production Strategy and a...
Given the following production plan: Briefly explain the differences between a Chase Production Strategy and a Level Production Strategy, then use: (a) chase production strategy and (b) level production strategy to compute the monthly production, ending inventory or backlog, and workforce levels. A worker is capable of producing 50 units per month. Assume the beginning inventory as of January is 500 units, and the firm desires to have 200 units inventory at the end of June. Demand production EI workforce...
$75 $15 1 $20 Materials = Holding costs = Marginal cost of backorder = Hiring and...
$75 $15 1 $20 Materials = Holding costs = Marginal cost of backorder = Hiring and training cost = Layoff costs = Straight time labor cost/hr. $250 $300 Beginning Workers Beginning inventory = Productive hours/worker/day = Paid straight hrs/day = Working days per month = Units per worker per month El ng Inventory goal (December) 110 2200 7.25 8 20 100 1000 $18 Question 8 1 pts Given the following production plan, use a level production strategy to compute the...
A disk drive manufacturer is in need of an aggregate plan for July to December. The...
A disk drive manufacturer is in need of an aggregate plan for July to December. The company has gathered the following data: Month Demand Month Demand July 400 Oct 700 Aug 500 Nov 800 Sep 550 Dec 700 Item Cost Materials $35/disk Inventory $8/disk/month Subcontracting $80/disk Stock-out $15/disk Regular time labor $12/hour Overtime labor $18/hour (above 8 hrs) Hiring cost $40/worker Layoff cost $80/worker Other data include: Item Data Current workforce (June) 8 people Labor hours per disk 4 hrs...
Using the information below, develop and aggregate plan by varying the workforce to produce the prior...
Using the information below, develop and aggregate plan by varying the workforce to produce the prior month's demand. Utilize inventory and subcontract strategies along with the varying the workforce strategy. Compute the cost of this plan. 2. Subcontract cost $5O/unit Holding# $10/month Stock-out cost-$ S0/unit Hiring cost $40worker Layoffs cost $80/worker Initial inventory 100 units Units last period ?1400 units(December) Month Demand Forecast Jan 1200 Feb 1400 Mar 1600 Apr 1800 May 1800 June 2000 July 2000 Aug 1800
1. ABC Company needs to plan workforces and production levels for the six-month period of January...
1. ABC Company needs to plan workforces and production levels for the six-month period of January to June to produce the famous ABCzappers. The following table shows forecasted demand for zappers. At the end of December there are 200 workers employed. Ending inventory in December is expected to be 500 zappers, and management would like to have 750 zappers on hand at the end of June. The cost of hiring one worker is expected to be $500, the cost of...
How do I calculate the one time adjustment of workforce to support the level production plan?...
How do I calculate the one time adjustment of workforce to support the level production plan? Problem information: Month: 1 2 3 4 5 6 7 8 9 10 11 12 Demand: 500 800 1000 1400 2000 3000 2700 1500 1400 1500 2000 1200 Management at the Kerby Corporation has determined the following aggregated demand schedule in Units. An employee can produce an average of 10 units per month. Each worker on the payroll costs $2,000 in regular time wages...
Q1. Prestige, Inc. needs an aggregate plan for its product line. As part of trying to...
Q1. Prestige, Inc. needs an aggregate plan for its product line. As part of trying to maintain a lean production system, management prefers a constant workforce, no overtime, and constant production level. Relevant data follows: Item Data | Units Data Item | Data | Units Production time required labor hours per unit 4.5 Units % of monthly forecast 0% Hiring cost $10,000 Item Ending inventory target Shortage cost per person Straight time labor cost per hour $75 per unit Laying...
Sales and Operations Planning ABC Manufacturing is developing their 2020 SOP. The sales plan is already...
Sales and Operations Planning ABC Manufacturing is developing their 2020 SOP. The sales plan is already developed, using the forecast obtained from Demand Management and is as follows: (the numbers are in 1000’s) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 420 375 425 600 200 100 150 250 420 390 420 450 Other problem parameters are: Initial worker level = 500, Initial inventory = 100,000, Required ending inventory = 220,000, Cost per unit = $50,...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 114,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 114,000 July $ 59,000 February 107,000 August 59,000 March 39,000 September 69,000 April 39,000 October 99,000 May 34,000 November 119,000 June 49,000 December 137,000 Total annual sales = $924,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to...
The washing machine plant is interested in determining work force and production levels for the next...
The washing machine plant is interested in determining work force and production levels for the next 8 months. Forecasted demands for Jan‐Aug. are: 420, 280, 460, 190, 310, 145, 110, 125. Starting inventory at the end of December is 200. The firm would like to have 100 units on hand at the end of August. Suppose we are told that over a period of 40 days, the plant had 38 workers who produced 520 units. Assume we are given the following number of working...
$75 $15 1 $20 Materials = Holding costs = Marginal cost of backorder = Hiring and training cost = Layoff costs = Straight time labor cost/hr. $250 $300 Beginning Workers Beginning inventory = Productive hours/worker/day = Paid straight hrs/day = Working days per month = Units per worker per month El ng Inventory goal (December) 110 2200 7.25 8 20 100 1000 $18 Question 8 1 pts Given the following production plan, use a level production strategy to compute the...
Using the information below, develop and aggregate plan by varying the workforce to produce the prior month's demand. Utilize inventory and subcontract strategies along with the varying the workforce strategy. Compute the cost of this plan. 2. Subcontract cost $5O/unit Holding# $10/month Stock-out cost-$ S0/unit Hiring cost $40worker Layoffs cost $80/worker Initial inventory 100 units Units last period ?1400 units(December) Month Demand Forecast Jan 1200 Feb 1400 Mar 1600 Apr 1800 May 1800 June 2000 July 2000 Aug 1800
1. ABC Company needs to plan workforces and production levels for the six-month period of January to June to produce the famous ABCzappers. The following table shows forecasted demand for zappers. At the end of December there are 200 workers employed. Ending inventory in December is expected to be 500 zappers, and management would like to have 750 zappers on hand at the end of June. The cost of hiring one worker is expected to be $500, the cost of...
Q1. Prestige, Inc. needs an aggregate plan for its product line. As part of trying to maintain a lean production system, management prefers a constant workforce, no overtime, and constant production level. Relevant data follows: Item Data | Units Data Item | Data | Units Production time required labor hours per unit 4.5 Units % of monthly forecast 0% Hiring cost $10,000 Item Ending inventory target Shortage cost per person Straight time labor cost per hour $75 per unit Laying...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago