ate.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_348855_1&course_id=_1696885_1&content_id=_8165358_1&step=null Question Completion Status: The following questions are based on this problem and accompanying Excel windows. A company is planning production for the next 4 quarters. They want to minimize the cost of production. The production cost is stable but demand and production capacity vary from quarter to quarter. The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand. Quarterly inventory holding cost is 3% of the cost of production. The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month. There are currently 5,000 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter. Unit Production Cost Units Demanded Maximum Production $ 300 2,000 8,000 Quarter 2 3 $ 300 $ 300 9,000 2,000 7,000 8,000 $ 300 11,000 9,000 Let Pi=number of units produced in quarter i, i = 1, Bi= beginning inventory for quarter i MIN Subject to: 300 P1 - 300 P2 - 300 P3 - 300 PA+ 9(B1-B2) 2-9(B2-B3) 2 - 9(B3-B4) 2 - 9(B4-B) 2 4000 SP, S 8000 3500 SP2 S 7000 4000 D. con Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save AA edu/webapps/assessment/take/launch.jsp?course assessment id=_348855_1&course_id = 1696885_1&content_id=_8165358_1&step=null Question Completion Status: 9(B1+B7)2 +9(B2+B3)2+%B3+ B4)2 +B4+BsY2 Subject to: 4000 SP1 S 8000 3500 SP2 S 7000 4000 SP3 s 8000 4500 SP4 S 9000 3000 SB1 +P1 - 2000 12000 3000 B2 + P2 - 9000 S 12000 3000 SB3 + P3 - 12000 12000 3000 SB4+P4 - 11000 12000 B2 =B1+P1 - 2000 B3 =B2 + P2 - 9000 B4 =B3 + P3 - 12000 B5 =B4+P4 - 11000 P. B;20 AB C D E IF Quarter 3 Beginning Inventory 4 Units Produced 5 Units Demanded Ending Inventory 5.000 9,000 2 11,000 7,000 9,000 9,000 5,000 8,000 2.000 11,000 9,000 8,000 12,000 5.000 11.000 3,500 8 Minimum Production svim Denne 4,000 e non 4.000 on 4,500 Onn Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save Al Answers Save ar Question Completion Status C D E Quarter 5.000 9.000 3 levels 4 hits Produced 3 hits Demanded 6 Ending Inventory 3.000 8,000 2.000 11,000 11.000 7,000 9.000 9.000 9.000 8.000 12.000 5,000 11,000 Minimum Production 9 Maximum Production 4.000 8,000 3,500 7,000 4,000 8,000 4,500 9,000 11 Minimum Inventory 12 Maximum Inventory 3.000 3,000 12,000 3,000 12.000 3,000 12,000 12,000 14 Unit Production Cost 15 Unit Carrying Cost $300 $9.00 $300 $9.00 $300 $9.00 S300 $9.00 3.096 1 17 Quarterly Production Cost 18 Quarterly Carrying Cost 19 $2,400,000 $72,000 $2,100,000 $90,000 $2,400,000 S63.000 $2,700,000 $36.000 Total Cost $9.801.000 Refer to Exhibit 3.5. Which cells are changing cells in the accompanying Excel spreadsheet? a. C9 F9 b. F20 C4 F4 d. C12 F12 Click Save and Submit to save and submit. Click Save All Answers to save all answers. ate.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_348855_1&course_id=_1696885_1&content_id=_8165358_1&step=null Question Completion Status: The following questions are based on this problem and accompanying Excel windows. A company is planning production for the next 4 quarters. They want to minimize the cost of production. The production cost is stable but demand and production capacity vary from quarter to quarter. The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand. Quarterly inventory holding cost is 3% of the cost of production. The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month. There are currently 5,000 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter. Unit Production Cost Units Demanded Maximum Production $ 300 2,000 8,000 Quarter 2 3 $ 300 $ 300 9,000 2,000 7,000 8,000 $ 300 11,000 9,000 Let Pi=number of units produced in quarter i, i = 1, Bi= beginning inventory for quarter i MIN Subject to: 300 P1 - 300 P2 - 300 P3 - 300 PA+ 9(B1-B2) 2-9(B2-B3) 2 - 9(B3-B4) 2 - 9(B4-B) 2 4000 SP, S 8000 3500 SP2 S 7000 4000 D. con Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save AA edu/webapps/assessment/take/launch.jsp?course assessment id=_348855_1&course_id = 1696885_1&content_id=_8165358_1&step=null Question Completion Status: 9(B1+B7)2 +9(B2+B3)2+%B3+ B4)2 +B4+BsY2 Subject to: 4000 SP1 S 8000 3500 SP2 S 7000 4000 SP3 s 8000 4500 SP4 S 9000 3000 SB1 +P1 - 2000 12000 3000 B2 + P2 - 9000 S 12000 3000 SB3 + P3 - 12000 12000 3000 SB4+P4 - 11000 12000 B2 =B1+P1 - 2000 B3 =B2 + P2 - 9000 B4 =B3 + P3 - 12000 B5 =B4+P4 - 11000 P. B;20 AB C D E IF Quarter 3 Beginning Inventory 4 Units Produced 5 Units Demanded Ending Inventory 5.000 9,000 2 11,000 7,000 9,000 9,000 5,000 8,000 2.000 11,000 9,000 8,000 12,000 5.000 11.000 3,500 8 Minimum Production svim Denne 4,000 e non 4.000 on 4,500 Onn Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save Al Answers Save ar Question Completion Status C D E Quarter 5.000 9.000 3 levels 4 hits Produced 3 hits Demanded 6 Ending Inventory 3.000 8,000 2.000 11,000 11.000 7,000 9.000 9.000 9.000 8.000 12.000 5,000 11,000 Minimum Production 9 Maximum Production 4.000 8,000 3,500 7,000 4,000 8,000 4,500 9,000 11 Minimum Inventory 12 Maximum Inventory 3.000 3,000 12,000 3,000 12.000 3,000 12,000 12,000 14 Unit Production Cost 15 Unit Carrying Cost $300 $9.00 $300 $9.00 $300 $9.00 S300 $9.00 3.096 1 17 Quarterly Production Cost 18 Quarterly Carrying Cost 19 $2,400,000 $72,000 $2,100,000 $90,000 $2,400,000 S63.000 $2,700,000 $36.000 Total Cost $9.801.000 Refer to Exhibit 3.5. Which cells are changing cells in the accompanying Excel spreadsheet? a. C9 F9 b. F20 C4 F4 d. C12 F12 Click Save and Submit to save and submit. Click Save All Answers to save all answers