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

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

Explain self-preservation is not the highest value, Are there situations in...

Are there situations in which self-preservation is not the highest value?

Find associated costs and revenues increase the capacity, A small firm inte...

A small firm intends to increase the capacity of a bottleneck operation by adding a new machine. Two alternatives, A and B, have been identified, and the associated costs and reven

Explain what elements interest in the negotiations, Assuming that I am the ...

Assuming that I am the negotiator who is tasked with a salary (on call time, step increases, overtime for captains and majors) and benefits (insurance while employed, insurance aft

Explain what is the minimum number of workstations, An assembly line with a...

An assembly line with a number of tasks is to be balanced. The sum of the task times is 62 minutes. The line will operate for 6 hours per day. What is the minimum number of worksta

Breadth of supplier base - many or few suppliers, Breadth of Supplier Base ...

Breadth of Supplier Base - Many or Few Suppliers The traditional approach to supplier selection is to prepare a tender document and request a quotation from a range of suitabl

Explain what is the role of safety stock in an mrp system, 1) Discuss the m...

1) Discuss the meaning of MRP such as planned order release and scheduled order receipts? 2) Many practitioners currently update MRP weekly or biweekly. Would it be more valuabl

MBA, MBA, Operation Management Q3. What do you understand by “line balancin...

MBA, Operation Management Q3. What do you understand by “line balancing”? What happens if balance doesn’t exist?

Explain major strategic operational competitive dimension, Which of the fol...

Which of the following is not a major strategic operational competitive dimension that forms a company's competitive position?

Objectivise and benefits of work study, Objectivise and Benefits of Work St...

Objectivise and Benefits of Work Study Objectivise of Work Study a)Provide more and improved physical means to motivate the workers. b)Improve the basic process by resear

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