JANUARY FEBRUARY MARCH APRIL MAY JUNE
5,000 4,000 6,000 6,000 5,000 4,000
Develop an aggregate plan using a spreadsheet. Assume 20 working days in each month
2) 5. 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 per month, while each part-time employee can pro-duce 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.
Other Requirements: please show work