Download Assignment esc4300 Algonquin and more Study notes Material Engineering in PDF only on Docsity!
Student number: 040874071
Course: ESC 4300_
Assignment 1
a. Dollar Percentage of sale Sales $20 100% Direct Material $6.4 32% Direct Labor $6.6 33% Overhead $6 30% Total Cost of goods sold $ Profit $1 5% New profit = 1,000,000 + 75%*1,000,000= 1,750,000 (1.75 million) Profit = sale(x) – (Cogs) Profit= x – (0.32x-0.33x-6) 7.75 = 0.35x X= 22. Therefore, firm should increase annual sales by 22.14 – 20 = 2.14 million. b. to increase profit by 0.75 million, Firm should decrease material cost by: 0.75 million c. to increase profit by 0.75 million, Firm should decrease labor cost by: 0.75 million
Student number: 040874071
Course: ESC 4300_
Period 1 2 3 4 5 6 Total Forecast demand
Planned Production
Planned Inventory (550)
Period Production = 6000-550+200 / 6 = 941.6 round up = 942 End inventory = Open Inventory + Planned Production – Forecast Demand
8 unit/day, Month 1 2 3 4 5 6 Total Working day 20 24 12 22 20 19 117 Forecast Demand
Planned Production
Planned Inventory (1000)
Total Production: 18,100 – 1000 + 500 = 17, Daily production: 17,600 / 117 = 150. Number of worker require : 150.43/ 8 = 18.88 round up to 19 workers Actual Daily production : 19*8 = 152 Planned production (Week 1) : 152 * 20 = 3040 It is not possible to reach exact ending inventory target because of the extra fraction of worker needed.
Student number: 040874071
Course: ESC 4300_
21 units are ordered in week 3 would be greater than ATP at end of week 2 so it would have satisfied by ATP at the end of week 2 Week 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 80 80 80 70 7 0
Demand 83 78 86 61 4 9
PAB | 110 27 99 13 93 2
MPS 150 150 150 150 150 150
ATP 13 0 40 65 122 143 150
37 units are ordered in week 5 would have to be satisfied by on hand inventory, ATP at end of week 4 = 0 From week 4 alone (because week 4 have 40 ATP) can satisfied week 5 Week 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 80 80 80 70 70 70 70 70 70 70 70 70 Demand 83 78 65 61 49 (+37) 51 34 17 11 7 0 0 PAB | 110
MPS 15
ATP 27 7 40 65 12
120 units are ordered in week 3 could be fulfill using on hand inventory Week 1 2 3 4 5 6 7 8 9 10 1 1
Forecast 8 0
Demand 8 3
Student number: 040874071
Course: ESC 4300_
PAB | 110 2
MPS 150 150 150 15
ATP 1
27+7+40+65=139 maybe able to satisfied part of 120,
Low-Level Code Week 1 2 3 4 5 Part A Lead time: 1 week Lot size: Lot- for-lot Gross requirements Schedule receipts Projected Available | Net requirements Planned Order receipts Planned Order Release
Part B Lead time: 1 week Lot size: Lot- for-lot Gross requirements Schedule receipts Projected Available Net requirements Planned Order receipts Planned Order Release
Part C Lead time: 1 week Lot size: Lot- for-lot Gross requirements Schedule receipts Projected Available Net requirements Planned Order receipts (^70)
Student number: 040874071
Course: ESC 4300_
MRP record at the end of week 1 Week 1 2 3 4 5 6 Gross Requirements 70 40 110 50 40 60 Schedule Receipts 70 Project Available |50 50 10 0 50 10 50 Net requirements 100 50 Planned Order Receipt 100 100 Planned Order Release
