Develop an aggregate plan using a spreadsheet

Assignment Help Operation Management
Reference no: EM13232377

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: EM13232377

Questions Cloud

Explain salt has no reaction to concentrated h2so4 : a water soluble salt forms a precipitant during Group 3 analysis. An acidic solution of this precipitant and NaBiO3 yields a pinkish color. This same salt has no reaction to concentrated H2SO4 or AgNO3, what is the chemical formula for this salt?
Smart objectives for company mission statements : Product quality is our number one priority and every customer will be a satisfied customer - Conduct a SWOT analysis for a company that you would like to work for after graduation. Assess the company against the strengths, weaknesses
Write the code to read the name of a baseball team : Write the code to read the name of a baseball team, the number of games won, and the number of games lost, and display the name of the team and the percentage of games won.
Characteristics axial age philosophical-religious movements : What does Jaspers consider the important characteristics of “Axial Age” philosophical and religious movements, and what is his explanation of how such similar movements arose within a relatively short period in quite separated parts of the world?
Develop an aggregate plan using a spreadsheet : 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.
Compute the equilibrium constant for the unknown reaction : Given the following equilibrium constant at 25 C, calculate the equilibrium constant for the unknown reaction below.
State isopentenyl diphosphate and dimethylallyl diphosphate : Assume that the following terpenoid is derived biosynthetically from isopentenyl diphosphate and dimethylallyl diphosphate, each of which was isotopically labeled at the diphosphate-bearing carbon atom (C1). Click on the carbons that would be isot..
What arguments make for single language for all programming : What arguments can you make FOR the idea of a single language for all programming domains? "For" the idea, not the against!
Will these changes help to maintain your organization : Describe at least one new approach that is a specific result of the changes in the current economic environment. How is this change unique to these times? Will these changes help to maintain your organization's competitive edge?

Reviews

Write a Review

Operation Management Questions & Answers

  Determine the break-even point for each range

If estimated demand is 90 to 120 customers per day, how many machines should be purchased?

  Metal works considering the of a new line of products

An engineer at the Metal works is considering the introduction of a new line of products. In order to produce the new line, the company needs either a major or minor renovation of the current platn

  Determine upper and lower control limits

Machine's output is known to be approximately Normal with mean of 2.0 litter and standard deviation of 0.01 litter. Output is monitored using means of samples of 5observations. Determine upper and lower control limits that will include roughly 95...

  What information is surprising and why

On the Direct Marketing Assoction websit, what is intersting, how can companies use the website, what information is surprising and why?

  Illustrate what will be ending inventories in each period

Demands for each of periods is given in illustrate what follows. All periods have same number of working days. Elucidate how much should company make each period. Illustrate what will be ending inventories in each period. Do you see any problems w..

  Mixed integer programming

The Wiethoff Company has a contract to produce 10000 garden hoses for a customer-Because these machines are from different manufacturers and employ differing technologies, their specifications are not the same.

  Estimate benefit cost ratio for the project

A recent project nominated for consideration at your company has a four-year cash flow of $20,000; $25,000; $30,000; and $50,000. The cost of the project is $75,000.

  What is the probability that second item will be defective

A production process is known to produce a particular item in such a way that 5% of these are defective. If two items are randomly selected as they come off the production line, what is the probability that the second item will be defective?

  Computing expected total procurement cost

Handi Inc., a cell phone manufacturer, procures a standard display from LCD Inc. via an options type of supply contract . At the start of q uarter 1 (Q1) Handi pays LCD $20 per option.

  What is the overall profitability

Using the traditional method, which bases decisions solely on a product's contribution to profits and over-head, what is the optimal product mix and what is the overall profitability?

  Illustrate what was poka-yoke shingo created

Existing method involved assemblers taking individual springs from a box containing several hundred also then placing two of m behind an ON button also two more behind an OFF button. Illustrate what was poka-yoke Shingo created

  Find out replacement chips for its product lines

Find out replacement chips for its product lines here is demand over past 12 quarters. Use decomposition technique to forecast 4 quarters of 2010.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd