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

Statistical Process Control (SPC), I have an excel assignment for the SPC, ...

I have an excel assignment for the SPC, so I want to know if you could do it and how much will it cost?

Define what kind of problem would apply a systems analysis, What kind of pr...

What kind of problem would you apply a systems analysis to? Why?

Explain what is the coefficient of determination, A large school district i...

A large school district is revaluating its teachers' salaries. They have decided to use regression analysis to predict mean teacher salaries at each elementary school. The research

Number of defects - control chart, Number of Defects - Control Chart S...

Number of Defects - Control Chart Sometimes the attribute of concern is the number of defects (c) in an item rather than the number of defective items in a sample: for example

Formulate an integer programming model using excel solver, New fire station...

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into

Explain role of the small business administration, Analyze funding opportun...

Analyze funding opportunities for small businesses, including the role of the Small Business Administration (SBA). Then, evaluate the effectiveness of these funding opportunities i

Define what is the probability that the laptop will perform, An undergradua...

An undergraduate business student has purchased a laptop computer for use during exams. This laptop is perfectly reliable except for two parts: its microchip, which has a failure r

Emba, How many stamping machines are required?

How many stamping machines are required?

Compute the value of cash flow based on discount rate, Calculate the presen...

Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows 1. Year 1 = $100,000 2. Year 2 = $150,000 3. Year 3 = $200,0

Linear Programming , A paper mill produces two grades of paper viz., X and ...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

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