Home / Questions / In the ERP lesson, we have computed the cashtocash cycle time (CCT) for Dell Computers i
In the ERP lesson, we have computed the cashtocash cycle time (CCT) for Dell Computers in 2003 for 91.36 days, which is an indication for Dell to have efficient and effective operational cycles.
1)Search HP’s (www.HP.com) and Apple’s (www.apple.com/about/) websites and from their investor information sites to obtain the annual financial statements for the recent past five years (20112015). Compute the CCTs for these five years. Use 365 days for a year.
2)Compute the average CCT for each company. Which company has a better average CCT?
3)Is there any trend for the CCT for each company? If yes, which one has a better trend, i.e., slope?
For the Lawn King’s case, suppose we have seen the three year sales data as shown in the file “Lawn King’s three year sales.xlsx”. Assume that the three year sales are realized as presented.
Use Excel to draw the chart for the three year sales time series data. Describe what components you observe from this time series data. (2 points)
Based on the sales pattern you describe in 1), assume that you choose the deseasonalized linear regression (i.e., decomposition using least square regression) to perform forecast for the fourth year sales; i.e., use these three year sales data to perform the following: (10 points)
Compute the seasonal indices (multiplicative factors)
Use these indices to compute the deseasonalized sales
Use the deseasonalized sales to perform linear regression
Use the yintercept and slop to forecast the fourth year sales (t=37 to 48). What are the yintercept and slop? Show the forecast result.
Adjust the fourth year sales forecast by seasonal indices (rounded to integer numbers.) Show the forecast result in graph and in table.
Compute and plot the MADs and tracking signals (TS) for the above forecasts, what are the MAD and TS at the end of year 3? (2 points)
Following problem 2, assume that the production plans for years 1, 2 and 3 have been performed. Based on the sales forecast for year 4 from above, do the following for year 4. Also assume all cost data remain the same and hold the following conditions for year 4. Present your production plan using the following table.
Beginning September Workforce = 80
Beginning Inventory = 16,000
End monthly minimum inventory = 2000.
August Ending Inventory = 17,000
August Ending Workforce = 90
Create a production plan based on pure chase strategy. (5 points)
Create a production plan based on level strategy with minimal overtime. (5 points)
Run Solver to get the optimal production plan. (5 points)
Compare costs for all three options. (3 points)
Strategy
Hiring cost
Firing cost
Regular time cost
Overtime cost
Inventory cost
Total cost
Below is the MPS for the weeks in September and October. Answer the following questions. Assume the ending inventory in August is 120.
Month
September
October
Week
36
37
38
39
40
41
42
43
Forecast
150
150
150
150
125
125
125
125
Booked Orders
160
170
180
140
110
90
75
35
Projected Inventory=120
Master Production Schedule
400
400
400
400
AvailabletoPromise
What are the projected inventories (projected onhands) at the end of weeks 36, 37, 38, and 39? (2 points)
Month
September
October
Week
36
37
38
39
40
41
42
43
Forecast
150
150
150
150
125
125
125
125
Booked Orders
160
170
180
140
110
90
75
35
Projected Inventory 120
Master Production Schedule
400
400
400
400
AvailabletoPromise
What are the ATPs (availabletopromise) at the end of weeks 36, 38, 40, and 42? Assume the discrete approach is used. From the resulting ATPs, if a customer requires 250 units, which week can you promise to deliver this quantity (i.e., enough to ship in one time)? (4 points)
Month
September
October
Week
36
37
38
39
40
41
42
43
Forecast
150
150
150
150
125
125
125
125
Booked Orders
160
170
180
140
110
90
75
35
Projected Inventory 120
Master Production Schedule
400
400
400
400
AvailabletoPromise
What are the ATPs (availabletopromise) at the end of weeks 36, 38, 40, and 42? Assume the cumulative logic is used. From the resulting ATPs, if a customer requires 450 units, which week can you promise to deliver at the earliest (i.e., enough to ship in one time)? (4 points)
Month
September
October
Week
36
37
38
39
40
41
42
43
Forecast
150
150
150
150
125
125
125
125
Booked Orders
160
170
180
140
110
90
75
35
Projected Inventory 120
Master Production Schedule
400
400
400
400
AvailabletoPromise
In the case for Turbo Charge Engines, Inc., assume the MPS has been revised to the following table.
Weeks
1
2
3
4
5
6
7
8
9
10
11
12
MPS Production Qty
180
150
170
100
150
200
175
200
180
220
Perform the MRP explosion for these three items: 72120, 7212001, and 7212002. Assuming all other information remains the same.(12 points)
From 1), is there any action imminent in week 1, i.e. planned order releases in week 1 or earlier? (2 points)
From 1), based on the above MRP explosion, what are the project onhand at the end of week 12 for these three items: 72120, 7212001, and 7212002? (2 points)
The Klone Computer Company is trying to decide which of the several lotsizing procedures to use for its MRP system. The following information pertains to the typical component parts of its computers:
Setup cost = $150/order
Inventory carrying cost (charged at the end of week) = $2.50/week
Current inventory on hand = 0
The demands or requirements for the next 12 weeks are shown as below:
Week
1
2
3
4
5
6
7
8
9
10
11
12
Demands
60
50
39
17
150
36
90
25
15
25
85
30
Apply L4L for the above production requirements. (4 points)
Apply EOQ (only integer multiples of the EOQ can be ordered, only one setup cost is charged even order multiple EOQs) for the above production requirements. (4 points)
Apply POQ (use the rounded up order interval, i.e., time between order, from EOQ) for the above production requirements. (4 points)
Apply PPB (Part Period Balancing) for the above production requirements. (4 points)
Compute and compare the costs resulting from these four procedures. Assume orders will be received at the beginning of the week and the inventory holding cost is incurred at the end of the week. (4 points)
Inventory carrying cost
Setup cost
Total cost
After reading the first 12 chapters of the book “The Goal: A process of ongoing improvement” by Goldratt and Cox, answer the following questions. (2 points each)
What is the situation the plant manager, Mr. Rogo, faces?
If NXC10 (robotic machine) has produced 36% more parts but not used for ontime assembly, what does it imply to the goal and inventory?
Define dependent events and statistical fluctuations in manufacturing plants.
Name the following persons associated with Mr. Rogo’s plant:
Uniware division head:
Plant controller:
Inventory control:
Production manager:
Strategy 
Hiring cost 
Firing cost 
Regular time cost 
Overtime cost 
Inventory cost 
Total cost 





















Dec 03 2019 View more View Less
The following graph shows aggregate demand and shortrun aggregate supply.1. Use the line drawing tool to show the effect of an unexpected decrease in the price of oilan...
Jun 06 2021Suppose that the Bank of Canada prints $1000 and purchases bonds on the open market from a bank. The bank puts the $1000 in their reserves. a.If the desired reserve ratio...
Jul 09 2021JRC Trading Corp (JRC) bought computer software and hardware from Progressive Data Systems (PDS) for $167,935, which it paid in full, to track movement of its trucks with...
Aug 04 2021Given the history we’ve studied so far, in its entirety, how would you respond to the claim that the United States was a melting pot of cultures and races between 1790 up...
Feb 14 2020Kneeland Corporation has two divisions: Grocery Division and Convenience Division. The following report is for the most recent operating period:Total CompanyGrocery Divis...
Aug 13 2021Identify the economic benefits of globalization (4)What are the issues and concerns associated with Globalization? Do some countries benefit more than others? Why?(Provid...
May 07 2020A Formal Model of Consumption and Saving (Appendix 4.A)1) David consumes 200 in the current period and 330 in the future period. The real interest rate is 10% per period....
Jan 11 2020Open systems can accomplish their tasks and meet their objectives through different courses of action. Open systems do not need a single ‘best’ method to achieve their ob...
Dec 21 2017List and briefly describe the advantages and disadvantages of decentralization for an organization.187.What are the differences between cost centers, profit centers, and ...
Jan 24 2020Minimum CostA cargo container (in the shape of a rectangular solid) must have a volume of 480 cubic feet. The bottom will cost $5 per square foot to construct, and the si...
Jul 30 2021