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

Explain income wages, Robert and mar Lou have 3 children they income wages ...

Robert and mar Lou have 3 children they income wages total 25,764.39 there federal income tax withheld was 3,580.31 social withheld was 1,082.10 medical tax was 373.58 what form sh

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?

How many cells must be used to represent each constraint, In excel how many...

In excel how many cells should be used to represent each constraint?

Explain what would his average inventory be, Mark Achin sells 3,600 electri...

Mark Achin sells 3,600 electric motors each year. The cost of these is $200 each, and demand is constant throughout the year. The cost of placing an order is $40, while the holding

Column minima method, Column Minima Method: Step 1: Determine  the  ...

Column Minima Method: Step 1: Determine  the  smallest cost in  the first  column  of the  transportation  table. Let it be  C1j  . allocate  Xi1= min ( ai bi ) in the cell

Explain what order should these jobs be done, A machine shop has two machin...

A machine shop has two machines, M1 and M2. Four jobs A, B, C, and D need to be processed through machines M1 first and M2 second. Job A will take one hour on machine M1 and three

Is focused factory concept applicable in service sector, Is the 'focused fa...

Is the 'focused factory' concept described by Skinner applicable in the service sector? Answer:  Yes, think of Schmenner's service-process matrix and the lower quadrant entitled

Explain car lots wants to enforce the contract, Wally and Beaver were gener...

Wally and Beaver were general partners in a car dealership. Using the partnership name, Wally entered into a contract to purchase 30 used cars from Car Lots. Car Lots was not aware

Explain demand for each season is going to be, In the past, Arup Mukherjee'...

In the past, Arup Mukherjee's tire dealership in Pensacola sold an average of 1,000 radicals each year. In the past 2 years, 240 and 260, respectively were sold in fall, 360 and 30

Explain statistical differences between men and women, What rule of thumb o...

What rule of thumb or guidelines would you recommend for deciding whether statistical differences between men and women, or non-minorities and minorities, reflect discrimination oc

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