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.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 17:10

Titus manufacturing, inc. provided the following information for the year: purchases - direct materials $91,000 plant utilities and insurance 68,000 indirect materials 11,170 indirect labor 4270 direct materials used in production 99,000 direct labor 117,500 depreciation on factory plant & equipment 4000the inventory account balances as of january 1 are given below. direct materials $44,000 work-in-progress inventory 10,000 finished goods inventory 50,000what is the ending balance in the direct materials account? $135,000 $36,000 $110,170 $6000

Answers: 3

Answer

Business, 21.06.2019 21:00

Identify the accounting assumption or principle that is described below. (a) select the accounting assumption or principle is the rationale for why plant assets are not reported at liquidation value. (note: do not use the historical cost principle.) (b) select the accounting assumption or principle indicates that personal and business record-keeping should be separately maintained. (c) select the accounting assumption or principle assumes that the dollar is the "measuring stick" used to report on financial performance. (d) select the accounting assumption or principle separates financial information into time periods for reporting purposes. (e) select the accounting assumption or principle measurement basis used when a reliable estimate of fair value is not available. (f) select the accounting assumption or principle dictates that companies should disclose all circumstances and events that make a difference to financial statement users.

Answers: 3

Answer

Business, 22.06.2019 04:00

Which law would encourage more people to become homeowners but not encourage risky loans that could end in foreclosure? options: offering first time homebuyers tax-free accounts to save for down payments requiring all mortgages to be more affordable, interest-only loans outlawing home inspections and appraisals by mortgage companies limiting rent increases to less than 2% a year

Answers: 2

Answer

Business, 22.06.2019 10:20

Asmartphone manufacturing company uses social media to achieve different business objectives. match each social media activity of the company to the objective it the company achieve.

Answers: 1

Answer

You know the right answer?

A company produces a variety of flash drives and uses sales dollars as its aggregate production meas...

Questions