Reference no: EM131314459
Multiperiod Production Planning at Zeta, p.362
Attached is the case study. This needs to be completed in Excel and any diagrams need to be able to edited, they cannot be cut and pasted into the excel spreadsheet. ALSO please show your work in excel, utilizing solver. I need to be able to see how you came up with the answer. If completed correctly I will tip extremely well
1. Discuss the process of maximizing profits by determining how much of three products to produce each month given different demands, costs, and constraints.
*note there is one typo in the case - the first line of the second paragraph should read "The company can produce only up to 75,000..." not 7,500.
2. Create a linear programing that maximizes expected profits. Use Solver to determine how much of each product to make each month. Remember, there is no reason to make more than what is demanded and you can only make 75,000 total products each month. Calculate the total profit for the 6 months by subtracting the costs for each product by the sales. Assume you can sell everything you can make as long as it's less than the demand.
3. At a cost of 1 million dollars you can increase your maximum production from 75,000 a month to 80,000 a month. Is this investment worth it? Compare the maximum profit you found above with one in which the constraint of total production increases to 80,000 a month.
|
Month
|
LG
|
MG
|
HG
|
|
1
|
50,000
|
25,000
|
15,000
|
|
2
|
45,000
|
20,000
|
18,000
|
|
3
|
35,000
|
35,000
|
20,000
|
|
4
|
40,000
|
30,000
|
22,000
|
|
5
|
46,000
|
28,000
|
21,000
|
|
6
|
60,000
|
32,000
|
|
|
Minimum rate of return
: The Good Life Insurance Co. wants to sell you an annuity which will pay you $600 per quarter for 30 years. You want to earn a minimum rate of return of 5.5 percent. What is the most you are willing to pay as a lump sum today to buy this annuity?
|
|
Find pressure difference between inlet and outlet sections
: The total drag on the object is measured to be 800 N/m of length normal to the direction of flow, and frictional forces at the walls are neglected, find the pressure difference between inlet and outlet sections.
|
|
What is the likely future role of domestic monetary policy
: In a world which is becoming increasingly dominated by the free flow of capital, what is the likely future role of domestic monetary policy?
|
|
Establishes a point about either cause or effect of change
: Write a 4-5 paragraph draft of your own academic essay that establishes a point about either cause or effect of this relevant change. Develop your main point about change using your own ideas, observations, and experience.
|
|
Create a linear programing that maximizes expected profits
: Create a linear programing that maximizes expected profits. Use Solver to determine how much of each product to make each month. Remember, there is no reason to make more than what is demanded and you can only make 75,000 total products each month..
|
|
Analyse interaction of the internal and external influences
: BSB0118 - 4 - Assume you are the Vice President of Corporate Planning. You have boon asked by tho CEO to perform a SWOT analysis to help determine whether a corporate goal should be to increase sales revenue by 10% each year for the next five year..
|
|
Identify qualities that you believe are most important
: From the characteristics mentioned in the chapter, identify qualities that you believe are most important for a friend to possess. Is there a characteristic that you consider important that is not mentioned in the text?
|
|
How fiscal policy might be used to combat inflationary gap
: Under what economic circumstances might economists recommend fiscal intervention in a market economy?
|
|
For downstream velocity profile find the value of v2
: The upstream velocity, v1, is uniform across the cross section. For the downstream velocity profile as shown, find the value of v2.
|