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 desired lot size, A firm that operates 300 days in a year and uses a...

A firm that operates 300 days in a year and uses a level material usage approach has collected the following data: Annual Demand = 30,000; Daily Demand = 100; Daily production= 300

Intermittent and continuous operations, Explain intermittent and continuous...

Explain intermittent and continuous operations. Under what type of situation it would be used in automobile industry?

Explain the major risk factors of the disease, Select one chronic disease s...

Select one chronic disease such as diabetes or heart disease. Assume that you are working for a county public health department with staff nurses and physicians. You want to run a

I have some charts that i need help to put it in excel, I have soem charts ...

I have soem charts that were done i word how do I gt them to you for someone to put in excel for me

Operations function in an organisation - method study, Operations Function ...

Operations Function in an Organisation - Method Study  A procedure that has stood the test of time in the study of work entails six steps (often referred to by the acronym, SR

Calculate a simple exponential smoothing forecas, 1. The actual demand for ...

1. The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks of this year are as follows: Week Actual # of Patients 1. 65 2. 62 3. 70 4. 4

How to formulate a linear programming model, George Johnson recently inheri...

George Johnson recently inherited a large sum of money; he wants to use a portion of this money to set up a trust fund for his two children. The trust fund has two investment optio

Define conflict conceptualized differently under the unitary, The National ...

The National Labour Relations Act has been criticized as an outdated piece of legislation that is hindering, rather than helping, American cope with the realities of the new global

Explain government grants, Assume that the company received no government g...

Assume that the company received no government grants and that all the funding for the company has come from VCs. Add an earlier seed round to replace the government funds, and mak

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