Reference no: EM132553370 , Length: word count:2500
Assignment
The part of the assignment is the theoretical part and you should refer to the textbook by Monk and Wagnerand the lecture notes/slides to answer the following questions in addition to materials from various sources. In order to avoid the concern of plagiarism, you should do a proper referencing based on the Harvard-UniSA referencing system.
Part 1. The following exercise will test your understanding of Fitter's current credit-check system. In each situation, you are given background data and information about documents in the system.
a. Given the information currently in the system, will credit be granted or denied for KLM Corporation's current order?
b. If the system processed data in a more timely way, would credit be granted or denied?
Part 2. Using the Fitter sales forecast for January through December given in the table below, develop a spreadsheet for sales and operations planning for the whole year. Use the format of the spreadsheet similar to the one shown in Figure 4-5. The highest level of capacity utilization is 95 percent in any month. In case the demand is higher, inventory has to be built up in the previous months to deal with the increased demand in certain month.
S&OP
|
Dec.
|
Jan.
|
Feb.
|
March
|
April
|
May
|
June
|
July
|
Aug.
|
Sep.
|
Oct.
|
Nov.
|
Dec.
|
1) Sales forecast
|
|
5906
|
5998
|
6061
|
6318
|
6476
|
7128
|
7097
|
6517
|
6401
|
6187
|
6133
|
5987
|
2) Production plan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3) Inventory
|
100
|
|
|
|
|
|
|
|
|
|
|
|
|
4) Working days
|
|
21
|
20
|
23
|
21
|
21
|
22
|
20
|
23
|
21
|
21
|
20
|
21
|
5) Capacity (shipping cases)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6) Utilization
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7) NRG-A (cases) 70%
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8) NRG-B (cases) 30%
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Part 3. Create a swimlane document flowchart for the following Fitter Snacker sales process. Use the swimlanes of Customer, Sales, Manufacturing, and Procurement.
Here is a description of what happens when a customer wants to buy cases of Fitter Snacker bars. In this situation, they are not buying through the sales person, they are buying through the inside sales department (handled only by phone):
1) The Customer that wants to buy the bars fills out a multipart paper request and sends it to the sales department.
2) The Sales department sends a copy of the customer's request to the Manufacturing Department and to the Procurement Department. The Sales Department files their copy of the paper form alphabetically by customer name.
3) The order arriving in the Manufacturing Department triggers the creation of a preliminary work order. To create this preliminary work order, the department gets data from (a) the sales order, (b) their current production plan file (a window on the plant manager's PC), (c) their current capacity requirement plan (another paper document), and (d) their history of prior work file which is on the plant manager's PC's hard drive and read off the computer screen. An estimate of time, labor, and overhead is manually prepared and entered into a preliminary work order form, which is a multi-part paper form. One copy of the form is sent to the Procurement Department, one copy sent to the Sales Department which is filed by sales order number in a file cabinet, and the Manufacturing department files one copy of the report by order date in the cabinet. The prior work file is not yet updated since the bars have yet to be manufactured.
4) To simplify matters, let's assume that the Procurement Department does NOT have to buy any raw materials. Since this is the case, assume the Procurement Department simply files the preliminary work order form and also files the Sales Request (order).
5) Since the raw materials are available, the Manufacturing Department can now go ahead and create a complete work order. The preliminary work order is retrieved from the file cabinet. This is used as input to the computer program: Final work order scheduling. There are two outputs to this program: a printed final work order document and an update to the Current Production Plan file. The printed work order document is filed in the "To-do" file by order date.
Part 4. Read the CASE STUDY #1/2017 available at the UN System Staff College, and the paper provided together with this final assignment file before answering the following questions.
i. Summarise the key findings of each paper.
ii. Discuss the difference of the ERP implementation approaches based on the ERP system adopted mentioned in these two case studies.
iii. Discuss the key factors that are common in these two case studies.
iv. Discuss how the process mapping tools can be used to help the change management of the ERP implementation.
Notes:
a) You need to do a proper referencing using Harvard-UniSA referencing system.
b) You need to provide references to support your arguments.
c) You have to paraphrase the reference contents in order to avoid the concern of plagiarism.
The following questions are single choice questions.
1. Which general ledger document tracks the amount of money that a customer owes for the goods received by the customer?
a. Accounts payable c. Balance sheet
b. Income statement d. Accounts receivable
2. Assume that a buyer calls a seller to order $5,000 worth of goods and her credit limit is $12,000. If the sellers accounts receivable for the customer is already $9000, how much of the new order will be accepted?
a. No amount c. The entire amount
b. $12,000 only d. 3000
3. What are the manufacturing costs that include factory utilities, general factory labor such as custodians or security guards, factory managers' salaries, storage, insurance, and other manufacturing-related costs?
a. Overhead costs c. Direct costs
b. Manmade costs d. Plant costs
4. If the cost of manufacturing NRG-A bars is $0.75 per bar, how much does FS need to charge to make a profit of $0.25?
a. $1.00 c. $0.97
b. $1.25 d. $0.99
5. The key pieces of information for cost analysis is the direct material costs and the ____.
a. driver cost c. direct labor cost
b. selling cost d. overhead cost
6. If Fitter Snacker's cost of making a case of bars is $230. There are 25 bars to a box and 12 boxes to a case. How much money does it cost Fitter Snacker to make each individual bar?
a. $8.74 c. $17.49
b. $0.76 d. $1.00
7. The Fitter Snacker company sold 5000 cases of snack bars in June of the previous year. They are expecting sales to increase by 3% this year. In addition, they are launching a promotional campaign in May, which they expect will increase sales in June by an additional 700 cases.What is the sales forecast for June of this year that Fitter Snacker should use?
a. 5750 c. 5150
b. 5850 d. 5755
8. Table below summarizes the per-unit processing time in minutes for each of the four products (A, B, C, D) on the four machines. The last row in Table is a simple estimate of required capacity (load in min).
|
Machine 1
|
Machine 2
|
Machine 3
|
Machine 4
|
MPS
|
Product A
|
5
|
3
|
2
|
5
|
90
|
Product B
|
7
|
1
|
4
|
2
|
110
|
Product C
|
3
|
8
|
2
|
1
|
60
|
Product D
|
4
|
2
|
3
|
3
|
160
|
Load (min)
|
|
|
|
|
|
"Required capacity (load -min) in Machine 1 is"
a. 2400 c. 2040
b. 2050 d. 2450
9. Given the following (incomplete) MRP record:
Oats Lead Time = 2 weeks
|
Week 1
|
Week 2
|
Week 3
|
Week 4
|
Week 5
|
Gross Requirements (lb)
|
18500
|
23700
|
24872
|
18464
|
17938
|
Scheduled Receipts
|
|
|
32000
|
|
|
|
Planned Receipts
|
|
|
|
|
|
|
On Hand
|
23635
|
|
|
|
|
|
Planned Orders
|
|
|
|
|
|
|
"The On Hand number in week 2 is"
a. 37135 c. 8300
b. 13453 d. 13435
10. Given the following incomplete Fitter's production plan for January.
Demand Management
|
Week 1
|
Week 2
|
Week 3
|
Week 4
|
Monthly demand NRG-A
|
4134
|
4480
|
4588
|
4784
|
Monthly demand NRG-B
|
1925
|
2200
|
1998
|
2350
|
Working days in week
|
5
|
5
|
|
|
Working days in month
|
21
|
20
|
|
|
MPS weekly demand NRG-A
|
|
|
|
|
MPS weekly demand NRG-B
|
|
|
|
|
MPS daily demand NRG-A
|
|
|
|
|
MPS daily demand NRG-B
|
|
|
|
|
"MPS week 1 demand for NRG-B is"
a. 92 c. 984
b. 458 d. 197
11. What are the costs associated with inventories:
a. Capital cost and Operating costs and Risk-related cost
b. Capital cost and Risk-related cost
c. Capital cost and Operating costs
d. Maintenance and operating costs
12. Which of the following area of evaluation are more important in Selection of suppliers
Select one:
a. Process capability, Quality assurance and financial capability
b. Financial capability and the number of employees
c. Process capability and company's age and size
d. All of above
13. Purchasing and outsourcing may be preferred:
a. When the lead time of buying is substantially lower than the lead time of manufacturing.
b. When the lead time of buying is substantially higher than the lead time of manufacturing.
c. Purchasing and outsourcing is not related to lead time at all.
d. When the lead time of buying same as the lead time of manufacturing.
14. What are the costs associated with inventories:
a. Capital cost and Operating costs
b. Maintenance and operating costs
c. Capital cost and Operating costs and Risk-related cost
d. Capital cost and Risk-related cost
15. The plant produces three products (A, B, C) which are all processed on the four machines I, II, III and IV. The products' maximum sales quantities (row 6), sales prices (row 7) and material costs (row 8) are also presented in the table. The processing times of each product on each machine are measured in minutes per unit and can be found in columns 2 to 4 of rows 2 to 5.
|
1
|
2
|
3
|
4
|
1
|
|
ProductA
|
Product B
|
Product C
|
2
|
Machine I
|
15
|
15
|
10
|
3
|
Machine II
|
5
|
5
|
10
|
4
|
Machine III
|
14
|
14
|
5
|
5
|
Machine IV
|
10
|
10
|
5
|
6
|
Maximum sales
|
100
|
80
|
50
|
7
|
Sales price (in.$)
|
70
|
60
|
75
|
8
|
Material costs (in.$)
|
20
|
35
|
30
|
9
|
Throughput.(in.$)
|
|
|
|
Please answer the following question.
"Throughput per minute of constraint time of product B in Machine 1 is"
a. 3.33 c. 2.33
b. 1.67 d. 3
16. Giving the information about a company below, please answer the question by selecting the right answer.
|
1
|
2
|
3
|
4
|
1
|
|
Product A
|
Product B
|
Product C
|
2
|
Machine I
|
15
|
15
|
10
|
3
|
Machine II
|
5
|
5
|
10
|
4
|
Machine III
|
14
|
14
|
5
|
5
|
Machine IV
|
10
|
10
|
5
|
6
|
Maximum sales
|
100
|
26.7
|
50
|
7
|
Sales price (in.$)
|
65
|
71
|
90
|
8
|
Material costs (in.$)
|
20
|
35
|
30
|
9
|
Throughput.(in.$)
|
|
|
|
If the operating cost is $2500 then;
The profit (P) earned by firm is
a. $5960 b. $7380
b. $5460 d. $6880
17. Giving the forecasting and actual sales figures of the year, please calculate the safety stock based on the basis of the condition provided.
Month
|
Forecast (F)
|
Actual (A)
|
1
|
100
|
98
|
2
|
100
|
104
|
3
|
100
|
102
|
4
|
100
|
105
|
5
|
100
|
102
|
6
|
100
|
103
|
"If the safety factor at 98% desired customer level is 2.05 then the required safety stock will be"
a. 3.23 c. 2.33
b. 6.59 d. 7.22
18.
Required volume. (Q)
|
The purchase cost per unit, (cp)
|
Cost of manufacturing per unit (cm)
|
5000
|
12
|
8
|
Based on Break-even analysis purchasing is preferred when the initial investment is less than?
a. 5000 c. 20000
b. 10000 d. 25000
19. What are the functionalities of Warehousing?
a. Goods Receipt, Goods Issue, Picking, Packing, Shipping, Inventory
b. Goods Receipt and Goods Issue
c. Picking, Packing and Shipping
d. Picking, Packing, Shipping and Inventory
20. One of the main function of Warehouses is :
a. to absorb demand variations
b. to provide smoother operations of the supply chain
c. to manage the operations, such as receiving inventory, stocking and tracking inventory, and shipping it to stores
d. all of above tasks
Attachment:- Final assignment.rar