subject
Business, 20.10.2020 20:01 kohat485

A company produces a variety of flash drives and uses sales dollars as its aggregate production measure. The company is planning its workforce and production levels over the next year. The demand is estimated as dollar sales for the next six months is given. Month Workdays Demand
January 23 350,000
February 22 390,000
March 24 230,000
April 25 130,000
May 23 480,000
June 22 600,000
The workforce level is 500 workers at the beginning of current year and the inventories will amount to $100,000. The firm would like to have at least $80,000 of inventory at the end of June. The inventory holding costs are based on a 25% annual interest charge. It was observed that each worker accounted for an average of $50,000 of production per year that consists of 250 working days in the previous year. The cost of hiring is $300 per worker, and the cost of firing is $500 per worker if this industry.
a) Formulate the problem with all variables, an objective function, and all required constraints as a linear programming (LP) problem.
b) Solve for the optimal solution using Excel Solver Simplex LP. Submit your Excel solution.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 11:30
10.     lucy is catering an important luncheon and wants to make sure her bisque has the perfect consistency. for her bisque to turn out right, it should have the consistency of a. cold heavy cream. b. warm milk. c. foie gras. d. thick oatmeal. student d   incorrect
Answers: 2
question
Business, 22.06.2019 12:30
Provide an example of open-ended credit account that caroline has. caroline blue's credit report worksheet.
Answers: 1
question
Business, 22.06.2019 13:00
Reliability and validity reliability and validity are two important considerations that must be made with any type of data collection. reliability refers to the ability to consistently produce a given result. in the context of psychological research, this would mean that any instruments or tools used to collect data do so in consistent, reproducible ways. unfortunately, being consistent in measurement does not necessarily mean that you have measured something correctly. to illustrate this concept, consider a kitchen scale that would be used to measure the weight of cereal that you eat in the morning. if the scale is not properly calibrated, it may consistently under- or overestimate the amount of cereal that’s being measured. while the scale is highly reliable in producing consistent results (e.g., the same amount of cereal poured onto the scale produces the same reading each time), those results are incorrect. this is where validity comes into play. validity refers to the extent to which a given instrument or tool accurately measures what it’s supposed to measure. while any valid measure is by necessity reliable, the reverse is not necessarily true. researchers strive to use instruments that are both highly reliable and valid.
Answers: 1
question
Business, 22.06.2019 23:00
Which of the following is true of website content? it should be refreshed periodically to keep customers coming back. once the content has been written and proofread it shouldn't be changed. grammatical errors are not a problem because the customer visits the site to purchase a product, not check the site's grammar. it should be limited to text and shouldn't include multimedia.
Answers: 1
You know the right answer?
A company produces a variety of flash drives and uses sales dollars as its aggregate production meas...
Questions
question
Mathematics, 15.04.2021 04:50
question
Mathematics, 15.04.2021 04:50
question
Mathematics, 15.04.2021 04:50
question
Mathematics, 15.04.2021 04:50
question
Mathematics, 15.04.2021 04:50
Questions on the website: 13722362