Make an aggregate plan using a spreadsheet, Operation Management

Assignment Help:

Helter Industries, 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, whereas the full-time employees must be paid whether they are needed or not. Each full-time employee can produce 205 suits, while exact 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.


Related Discussions:- Make an aggregate plan using a spreadsheet

Describe a diet is being prepared for the university, A diet is being prepa...

A diet is being prepared for the University of Arizona dorms. The objective is to feed the students at the least cost, but the diet must have between 1,800 and 3,600 calories. No m

Explain what output rate will be achieved, An assembly line with 30 activit...

An assembly line with 30 activities is to be balanced. The total amount of time to complete all 30 activities is 42 minutes. The longest activity takes 2.4 minutes and the shortest

Explain how much safety inventory does the store carry, Demand during lead-...

Demand during lead-time for HP printers at a Sam's club store is normally distributed, with a mean of 500 and a standard deviation of 150. The store manager continuously monitors i

Define why is it deemed necessary to protect the environment, Why is it dee...

Why is it deemed necessary to protect the environment? What does it mean to society? To business? To the individual? To future populations?

Define construct the linear programming model, A farmer has 10 acres to pla...

A farmer has 10 acres to plant in wheat and barley. He has to plant at least 7 acres. However, he has only $1200 to spend and each acre of wheat costs $200 to plant and each acre o

Define which of the following are valid range names in excel, Which of the ...

Which of the following are valid range names in Excel? Total Profit TotalProfit Total_Profit All of these b and c only

The transformation process model and systems thinkin, #qu1) Using the trans...

#qu1) Using the transformation process model and systems thinking concepts, explain the key operations TGL works. Pay particular attention to flow of materials and the role played

Advantages and disadvantages of the parallel sourcing, What are the advanta...

What are the advantages and disadvantages of the parallel sourcing? Advantages of parallel sourcing: Best of both worlds for example, have your cake and eat this too for

Write Your Message!

Captcha
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