Develop an aggregate plan using a spreadsheet

Assignment Help Operation Management

Reference no: EM1393197

Helter Industires, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand. For the current four-month rolling schedule, there are three temps on staff and 12 full-time employees. The temps can be hired when needed and can be used as needed, wheras the full-time emplyees must be paid whether they areneeded or not. Each full-time employee can produce 205 suits, while eact part-time employee can produce 165 suits per month.

Demand for bathing suits for the next four months is as follows

May June July August

3,200 2,800 3,100 3,000

Beginning inventory in May is 403 complete (a complete two-piece includes both top and bottom) bathing suits. Bathing suits cost $40 to produce and carrying cost is 24 percent per year.

Develop an aggregate plan using a spreadsheet.

Reference no: EM1393197

Questions Cloud

Information about excel functions : Could you please explain in words how you figure out deciles, quartiles, kurtosis, skewness in Excel? How do you find the sum count, largest, and smallest in Excel?

Confidence interval for the population mean service charge : Construct a 95% confidence interval for the population mean service charge if a customer's account falls below the $1,500 minimum.

Determine the marginal cost and cpi : Determine the marginal cost for bottle of wine and what will be the reduction in number of crashes at that intersection achieved by the mayor?

How to enhance communication with subordinates : How can you enhance communication with subordinates. Write down steps you have utilized enhance communication with subordinates.

Develop an aggregate plan using a spreadsheet : Helter Industires, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand.

Policies restricting the use of cell phones : According to the National Restaurant Association, 20% of fine-dining restaurants have instituted policies restricting the use of cell phones. From a sample of 100 fine-dining restaurants,

Evaluating hearing impairment : Describe the international standard used for evaluating hearing impairment and how it is used for calculations

Determining confidence interval for true mean weight : Develop a 90% confidence interval for the true mean weight. What sample size would be necessary to estimate the true weight with an error of +/- 0.03 grams with 90% confidence?

Organizational development practitioner : Discuss methods to diagnose employee stress and the specific OD interventions aimed at alleviating

User Account

All Pages