Question: 1,000 case units. Forecast Demand Ending Inventory Target Planning Data Initial number of employees Employees per line Standard production rate (each line) Employee pay rate

1,000 case units. Forecast Demand Ending Inventory Target Planning Data Initial number of employees Employees per line Standard production rate (each line) Employee pay rate Overtime pay rate Standard hours per shift Paid hours per shift Maximum overtime per day Inventory carry cost Stockout cost Employee hiring and training cost Employee layoff cost Working days per quarter 1st (1-13) 2,000 338 Numbers 60 6 450 $20.00 $30.00 7.5 8.0 2.0 $1.00 $2.40 $5,000.00 $3,000.00 65 Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 2,200 2,500 385 408 Units of measure employees employees Cases per hour per hour per hour hours hours hours $ per case (per qtr) $ per case $ per employee $ per employee days 4th (40-52) 1st (Next Year) Notes 2,650 2,200 Each number is a 13 week forecast. 338 This is calculated based on 6 weeks of future forecast demand. Foreca st Dema nd by Qua rt er (1 ,000 Ca se Unit s) 3,000 2,500 2,000 1,500 Profit margin loss 1,000 500 0 1st (1-13) Aggregate Plan Lines run Overtime hours per day 1st (1-13) 8 0 Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 10 9 1 2 4th (40-52) 11 0 200 1,755 2,000 -45 Beginning Inventory Production Expected Demand Ending Inventory Deviation from Inventory Target Employees Cost of Plan Labor Regular Time Labor Overtime Hiring and Training Layoff Inventory Carry Cost Stockout Cost Quarter Budget 2 nd (14-2 6) -45 2,486 2,200 241 241 2,501 2,500 242 -144 60 -166 54 $624,000 $117,000 $60,000 $0 $0 $0 $801,000 $561,600 $210,600 $0 $18,000 $0 $0 $790,200 $686,400 $0 $60,000 $0 $0 $0 $746,400 Total Cost of Plan $2,980,800 1st (Next Yea r) Added paid hours paid per shift (8) -333 66 $499,200 $0 $0 $36,000 $0 $108,000 $643,200 4th (40-52 ) Notes 242 2,413 2,650 5 -383 48 3rd (2 7-39) Employees are paid for 8 hrs work per day. 60 employees are employeed currently. Carrying cost per year,divided by 4, multiplied by 1,000. Basic on negative deviation from target. Annual Totals $0 $0 $0 $198,000 $0 $0 $2,980,800 Qtr Wk 1st 2nd 3rd 4th 5th 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 Lines Scheduled Overtime Scheduled (hours) Beginning Inventory Scheduled Production Forecast Demand 8 8 8 8 8 8 8 8 8 8 8 8 8 10 10 10 10 10 10 10 10 10 10 10 10 10 9 9 9 9 9 9 9 9 9 9 9 9 9 11 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 200.0 181.2 162.3 143.5 124.6 105.8 86.9 68.1 49.2 30.4 11.5 -7.3 -26.2 -45.0 -23.0 -1.0 21.1 43.1 65.1 87.1 109.1 131.2 153.2 175.2 197.2 219.2 241.3 241.3 241.4 241.5 241.5 241.6 241.7 241.7 241.8 241.9 241.9 242.0 242.1 242.1 223.9 205.7 187.5 169.2 151.0 132.8 114.6 96.4 78.1 59.9 41.7 23.5 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 Expected Ending Inventory Expected Weeks-ofSupply Actual Production Rate (cases/hour) Actual Demand (1,000 Cases) Actual Production Actual Ending Inventory Inventory Target Inventory Deviation from Target Stockouts per Week 181.2 162.3 143.5 124.6 105.8 86.9 68.1 49.2 30.4 11.5 -7.3 -26.2 -45.0 -23.0 -1.0 21.1 43.1 65.1 87.1 109.1 131.2 153.2 175.2 197.2 219.2 241.3 241.3 241.4 241.5 241.5 241.6 241.7 241.7 241.8 241.9 241.9 242.0 242.1 242.1 223.9 205.7 187.5 169.2 151.0 132.8 114.6 96.4 78.1 59.9 41.7 23.5 5.3 1.2 1.1 0.9 0.8 0.7 0.6 0.4 0.3 0.2 0.1 0.0 -0.2 -0.3 -0.1 0.0 0.1 0.3 0.4 0.5 0.6 0.8 0.9 1.0 1.1 1.2 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.3 1.2 1.2 1.2 1.2 1.2 1.2 1.1 1.0 0.9 0.8 0.7 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0.0 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 153.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 135.0 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 185.6 181.2 162.3 143.5 124.6 105.8 86.9 68.1 49.2 30.4 11.5 -7.3 -26.2 -45.0 -23.0 -1.0 21.1 43.1 65.1 87.1 109.1 131.2 153.2 175.2 197.2 219.2 241.3 241.3 241.4 241.5 241.5 241.6 241.7 241.7 241.8 241.9 241.9 242.0 242.1 242.1 223.9 205.7 187.5 169.2 151.0 132.8 114.6 96.4 78.1 59.9 41.7 23.5 5.3 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 385.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 408.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 338.0 -156.85 -175.69 -194.54 -213.38 -232.23 -251.08 -269.92 -288.77 -307.62 -326.46 -345.31 -364.15 -383.00 -407.98 -385.96 -363.94 -341.92 -319.90 -297.88 -275.87 -253.85 -231.83 -209.81 -187.79 -165.77 -143.75 -166.68 -166.62 -166.55 -166.48 -166.41 -166.35 -166.28 -166.21 -166.14 -166.08 -166.01 -165.94 -165.88 -114.10 -132.32 -150.54 -168.76 -186.98 -205.20 -223.42 -241.64 -259.87 -278.09 -296.31 -314.53 -332.75 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 7.3 18.8 18.8 -22.0 -22.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -3,509.0 Regular Qtr Wk Production Cost 1 38,400 2 38,400 3 38,400 4 38,400 5 38,400 6 38,400 7 38,400 1st 8 38,400 9 38,400 10 38,400 11 38,400 12 38,400 13 38,400 14 48,000 15 48,000 16 48,000 17 48,000 18 48,000 19 48,000 48,000 2nd 20 21 48,000 22 48,000 23 48,000 24 48,000 25 48,000 26 48,000 27 43,200 28 43,200 29 43,200 30 43,200 31 43,200 32 43,200 43,200 3rd 33 34 43,200 35 43,200 36 43,200 37 43,200 38 43,200 39 43,200 40 52,800 41 52,800 42 52,800 43 52,800 44 52,800 45 52,800 46 52,800 4th 47 52,800 48 52,800 49 52,800 50 52,800 51 52,800 52 52,800 Totals $2,371,200 Overtime Production Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 16,200 0 0 0 0 0 0 0 0 0 0 0 0 0 Inventory Carrying Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $327,600 $0 0 0 0 0 0 0 0 0 0 0 17,538 45,231 45,231 -52,846 -52,846 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Hiring and Training Cost 0 0 0 0 0 0 0 0 0 0 0 0 0 60,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60,000 0 0 0 0 0 0 0 0 0 0 0 0 $2,308 $120,000 Stockout Cost Layoff Cost Total For Week Cumulative 36,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74,400 38,400 38,400 38,400 38,400 38,400 38,400 38,400 38,400 38,400 55,938 83,631 83,631 64,154 4,154 57,000 57,000 57,000 57,000 57,000 57,000 57,000 57,000 57,000 57,000 57,000 77,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 59,400 112,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 52,800 74,400 112,800 151,200 189,600 228,000 266,400 304,800 343,200 381,600 420,000 475,938 559,569 643,200 707,354 711,508 768,508 825,508 882,508 939,508 996,508 1,053,508 1,110,508 1,167,508 1,224,508 1,281,508 1,338,508 1,415,908 1,475,308 1,534,708 1,594,108 1,653,508 1,712,908 1,772,308 1,831,708 1,891,108 1,950,508 2,009,908 2,069,308 2,128,708 2,241,508 2,294,308 2,347,108 2,399,908 2,452,708 2,505,508 2,558,308 2,611,108 2,663,908 2,716,708 2,769,508 2,822,308 2,875,108 $54,000 $2,875,108

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1 , 0 0 0 case units. Forecast Demand Ending Inventory Target Planning Data Initial number of employees Emplyees per line Standard production rate ( each line ) Employee pay rate Overtime pay rate...

Simulation Worksheet Qtr Wk Lines Scheduled Overtime Scheduled Expected Beginning Scheduled Forecast (hours) Inventory Production Demand Ending Inventory 1 10 1 200.0 191.3 153.8 237.4 Expected...

caculate cost of plan. th(00-) ) NO 27600 2.300 Bachumbaris a week This is bend on forecast and 1,000 units Forecast Demand Ending Inventory Target Planning Data Initial number of employees Emples...

1,000 case unith. Forecast Demand Ending Inventory Target Planning Data initial number of employees Emplyees per Ine Standard production rate (each line) Employee pay rase Overtme pay rate Standard...

1,000case unita. Forecast Demand Ending Inventory Target Planning Data Inltial number of employees Emplyees per Ine Standard production rate (each llne) Employee pay rate Overtlme pay rate Standard...

Manufacturing - Planning Plant Production se units. orecast Demand ing Inventory Target Data iber of employees per line production rate ( each line ) pay rate pay rate hours per shift l overtime per...

How get the calculation for labor regular time cost of $624,000? DU Arial -110 26 Wrap Text Currency Xcut Da Copy - Paste Format Painter Clipboard - A A DA. Bad BIU- Good Noutal Merge & Center - S 8....

Calibri 11 A A Aa Po Paste B I U ab A Undo Clipboard Page 3 of 3 58F Clear 1061 words E Font Questions T Paragraph Emphasis Heading 1 Normal OPMA 3306 Operations Management Ops Analytics Case 6:...

You are the operations manager for a manufacturing plant that produces pudding food products. One of your important responsibilities is to prepare an aggregate plan for the plant. This plan is an...

(a) Define the terms assets, liabilities, and stockholders equity. (b) What items affect stockholders equity?

A petroleum company wants to lay a pipe from one of its tanks to a station across the river. The river is 2 km across, and the station is 9 km downstream. The pipe is laid in two sections; across the...

Question content area Part 1 The market regulator of a country is reviewing the application from a corporation to set up a stock exchange. Finex, the corporation which plans to commence equity...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Teamwork.With a partner read alternate sentences from the following paragraph aloud to each other. (Objective 2) ehT qaimtimg also qroved that, sa well sa being a great humter, Cro-Wagmom Nam saw a...

Global.Contact an international center at a university (visit, call, or send e-mail).Ask about a study abroad or work abroad program. Develop and present your findings to your class. (Objectives 4...

Technology. Global. India is a well-known location for offshore sites and outsourcing operations for large corporations. Using an encyclopedia, website URLs in this chapter, or other resources,...