Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Applied Statistics Expert

The Austin, Texas plant of Computer Products produces disk units for personal and small business computers. Gerald Knox, the plant's production planning director, is looking over next year's sales forecast for these products and will be developing an aggregate capacity plan for the plant based on this forecast. The quarterly sales forecasts for the disk units are as follows:

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

1,800

2,340

1,980

1,800

Ample machine capacity exists to produce the forecast. Each disk unit takes an average of 20 labor-hours. In addition, you have collected the following information:

a. Inventory holding or carrying cost is $100 per disk unit per quarter. The holding cost is based on the inventory at the end of each quarter.

b. The plant works the same number of days in each quarter, 12 five-day weeks, 6 hours per day.

c. Beginning inventory is zero disk units.

d. In a backlog situation, the customer will wait for his order to be filled but will expect a price reduction each quarter he waits. The price reduction is $300 per disk for the first quarter the customer waits, $700 for the second quarter the customer waits, and $900 for the third quarter the customer waits. In filling orders, backlogged items will always be filled before current quarter items,

e. The cost of hiring a worker is $800 while the cost of laying off a worker is $950.

f. The straight time labor rate is $20 per hour for the first quarter and increases to $22 per hour starting in the second quarter.

g. Overtime work is paid at time and a half (150%) of the straight time work.

h. Outsourcing (contract work) is paid at the rate of $475 per disk unit for the labor and you provide the material

i. Demand during the fourth quarter of the prior year was 1,980 units. 

j. Because there is a scheduled plant shut-down at the beginning of next year, the company wants to have the beginning inventory for next year at 360 units. This can be considered as additional fourth quarter demand. There will be no holding cost associated with these 360 units. 

k.  Assume that workers hired in any quarter will not need any training to reach full production in that quarter.

l. Compare the following three sales and operations plans.

i) Computer Products is considering a modified "matching" demand planning model for meeting the disk production. The company will hire and layoff workers to match the demand requirements each quarter as long as the capacity of the resulting workforce does not exceed 2,250 units per quarter. If it cannot meet the demand in a quarter because of this restriction, it will backlog the shortage until the next quarter. Ignoring the material cost, what is the total cost to produce the disks for the year? All workers will be fully utilized each quarter, in other words, there is no under utilization.

ii) As an alternative, the company will maintain a workforce capable of producing the demand during the fourth quarter of last year. If there are more workers in a quarter than required to produce the demand for that quarter, only the units required will be produced in that quarter and there will be underutilization. If demand is greater in a quarter than can be produced by the available workforce using straight time, the excess units will be outsourced. What is the total cost of this option, excluding the material cost?

iii) As an alternative, the company will establish in quarter one and then maintain a workforce capable of producing 2,160 units in a quarter. If there are more workers in a quarter than required to produce the demand for that quarter, only the units required will be produced in that quarter and there will be underutilization. If demand is greater in a quarter than can be produced by the available workforce using regular time labor, the excess units will be completed by using overtime, not to exceed 25% of the available straight time hours, and then backlogged until the next quarter when they will be produced using regular time labor. What is the total cost of this option, excluding the material cost?

Applied Statistics, Statistics

  • Category:- Applied Statistics
  • Reference No.:- M91060189

Have any Question?


Related Questions in Applied Statistics

Quantitative methods in health statistical analysis report

Quantitative Methods in Health Statistical Analysis Report - Question 1 - Are you a Lark or an Owl? Studies indicate that about 10% of us are morning people (Larks) while 20% are evening people (Owls) and the rest are no ...

Assessment - analytical reportobjectives - this assessment

Assessment - Analytical Report Objectives - This assessment addresses Unit Learning Outcomes: Discriminate the most appropriate descriptive and inferential statistics to use in a given health context, Analyse health data ...

Go to the institute for healthcare improvement ihi website

Go to the Institute for Healthcare Improvement (IHI) website for their Improvement Map (URL located in the Webliography). Select an improvement process of your choice. Present at least 3 quality paragraphs to the class a ...

Assignment - research topicpurpose the purpose of this task

Assignment - Research topic Purpose: The purpose of this task is to ensure you are progressing satisfactorily with your research project, and that you have clean, useable data to analyse for your final project report. Ta ...

Using minitab to construct linear regression modelsscatter

Using Minitab to Construct Linear Regression Models Scatter Plot To obtain a simple scatter plot using Minitab: One of the first steps in the analysis of the study data is to create a scatter plot that compares the quant ...

Business analytics and statistics research report -this

Business Analytics and Statistics Research Report - This assignment is based on fictional data. You are creating a business report for the CEO of a retail company called, Athlete Panda. It must be professional in present ...

The scientific method assessment task - data analysis

The Scientific Method Assessment Task - Data Analysis Assignment QUESTION 1 - Single-factor experiments Use Minitab for this question. The data in Q1 tab of 60902_AssessmentTask3Data_Spring2018.xlsx records blood cholest ...

Business statistics assignment -the purpose of this

Business Statistics Assignment - The purpose of this assignment is to improve your understanding in choosing between and using methods to assess the relationship between variables and make comparisons across different se ...

Question 1 for the prostate data set fit a model with lpsa

Question 1. For the prostate data set, fit a model with lpsa as the response, and the other variables as predictors. (a) Suppose a new patient with the following values arrives: lcavol = 1.45000, lweight = 3.59801, age = ...

Go to the webliography source for the national cancer

Go to the Webliography source for the National Cancer Institute's Surveillance, Epidemiology, and End Results (SEER) Program. In the Fast Stats, create your own cancer statistical report, "Stratified by Data Type," and u ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As