Reference no: EM131330766
Case Study: 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 programming 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
|
|
Develop appropriate formulas to automatically change sheet
: ACCT 321- I recommend you begin with the attached excel spreadsheets, but develop the appropriate formulas to automatically change the balance sheet, income statement and cash flows when you change your inputs.
|
Calculate the forecast for period
: The next two questions involve The Grand Bakery which produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week:
|
Engaged in other long-term client projects
: A company provides IT services to companies that need additional temporary IT support. Currently, the company has about 90% of its staff engaged in other long-term client projects.
|
Discuss about the globalization and outsourcing
: The purpose of this short research paper is to ensure proper understanding and application of APA style as required in all Ashford courses.Using the Ashford Online Library, develop an annotated bibliography on one of the following factors that ha..
|
Case study-multiperiod production planning
: 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 h..
|
How long does an average key search take with a single pc
: How many key bits are used, if the 8 characters are randomly chosen 7-bit ASCII characters (i.e., the most significant bit is always zero)? How long does an average key search take with a single PC?
|
Litigation process as a representative
: Recommend a plan or strategy to be followed by safety professionals if they become involved in the litigation process as a representative of an employer organization.
|
Consider supply management options
: The aggregate planning problem: A. Should only consider supply management options B. Only affects marketing and production, but human resources is not involved in decisions
|
Tqm approach for fulfilling customer expectations
: Describe how to use a TQM approach for fulfilling customer expectations associated with a new product, and apply principles of TQM in managing a product introduction
|