Reference no: EM131314830
The Aggregate Planning Problem.
Emily's Cookie Company makes a variety of chocolate chip cookies in their plant in Chicago. Based on orders received and forecasts ofbuying habits, it is estimated that the demand for the next four months is 850, 1,260, 510,and 980, expressed in thousands of cookies. Each worker can produce 308 cookies per day.Assume that the number of workdays in each of the next four months is 20 days. There arecurrently 100 workers employed, and there is no starting inventory of cookies. Workers arepaid $5500 per month. The cost of hiring one worker is $150; the cost of firing one workeris $200; the cost of holding one cookie in inventory for one month is 8 cents. Backlogs(stockouts) are permitted only in months 1 through 3, at a cost of 20 cents per cookie permonth, and backorders must be filled the following month; no backlogs are permitted atthe end of month 4. Emily can subcontract up to 20,000 cookies per month at a cost of$300 per thousand cookies. At the end of month 4, there must be at least 10,000 cookies in inventory.
Using Microsoft Excel, solve:
a) as a linear programming problem.
b) as a mixed integer programming problem, where all variables representing theworkforce size per period (Wt), the number of employees hired at the beginning of each period (Ht), and the number of employees laid off at the beginning of each period (Lt)must be integers.
|
Article summary - the emerging cyber security threats
: Please carefully read the attached article and summarize in a 3 to 5 page using APA format, Article - The emerging Cyber Security threats
|
|
Navigating the revised code
: Navigating the Revised Code Linda is a former big four auditor who chose to stay home with her children once she started a family. She has maintained her CPA all the while and now perform part- time bookkeeping services for local businesses.
|
|
Dhs claimed that the department
: After Hurricane Katrina, criticism directed at DHS claimed that the Department should actually prepare for all possible kinds of hazards and not just terrorist attacks (remember - it's mission was broadened to "all-hazards" before Katrina happened..
|
|
Calculate the current return
: Calculate the current return on American Water Works Co Inc AWK:US 71.59 USD and compare it to returns on bonds. Which is better to invest in presently a stock or a bond in this company and why?
|
|
The aggregate planning problem
: Emily's Cookie Company makes a variety of chocolate chip cookies in their plant in Chicago. Based on orders received and forecasts ofbuying habits, it is estimated that the demand for the next four months is 850, 1,260, 510,and 980, expressed in t..
|
|
Do an analysis of the companys short term activity ratios
: As a first step, you perform a liquidity analysis. You then do an analysis of the company's short-term activity ratios. Your calculations and appropriate industry norms are listed.
|
|
What is the required rate of return on equity
: Southern Healthcare and BestWell are for-profit HMOs that operate in Florida and Georgia. Currently, both are identical in every respect except that Southern is unleveraged while BestWell has $10 million of 5 percent bonds. Both HMOs report an EBIT o..
|
|
How abstraction and encapsulation enable evolutionary chang
: Now make a more complex change. The bank will allow a fixed number of free transactions (deposits or withdrawals) every month, and charge for transactions exceeding the free allotment. The charge is not levied immediately but at the end of the mon..
|
|
Prepare an american expatriate to a target country
: Country Culture Project (total 500 points): Your objective is to prepare an American expatriate (and their family) for an assignment to a target country (Japan).
|