The demand information is given below.
able[[Month,Jan,Feb,Mar,Apr,May,Jun],[Demand,1,900,2,900,4,800,5,800,5,800,1,950]]
A worker can produce 25 units per month. Assume that the beginning inventory in January is 800 units, and the firm desires to have 150 units of inventory at the end of June.
a. Use a chase production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter " 0 ".
able[[Month,Jan,Feb,Mar,Apr,May,Jun],[Demand,1,900,2,900,4,800,5,800,5,800,1,950],[Production,,2900,,5800,,],[Ending inventory,,,,,,],[Workforce,,,,,,]]
b. Use a level production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter " 0 ".
able[[Month,,Jan,Feb,Mar,Apr,May,Jun],[Demand,,1,900,2,900,4,800,5,800,5,800,1,950],[Production,,,3742,3742,3742,3742,],[Ending inventory,800,,3,484,2,426,,,],[Workforce,,,150,,,,]
Please slove for the one that is incorrect (red) the rest of the green are correct
The demand information is given below.
Month Demand
Jan 1,900
Feb 2,900
Mar 4,800
Apr 5,800
May 5,800
Jun 1,950
the end of June
a. Use a chase production strategy to compute the monthly production, ending inventory/(backlog) and workforce levels. Do not round intermediate calculations. Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "o".
Month Demand Production
Jan 1,900
Feb 2,900 2900
Mar 4,800
Apr 5,800
May 5,800
Jun 1,950
1100
4800
5800
5800
2100
Ending inventory
800
0
0
0
0
0 232 Cn
150
Workforce 44 116 192 232 84 b.Use a level production strategy to compute the monthly production, ending inventory/(backlog and workforce levels.Do not round intermediate calculations Round your answers to the nearest whole number. Use a minus sign to enter a negative value, if any. If your answer is zero,enter "o".
Month
Jan 1,900
Feb 2,900
Mar 4,800
Apr 5,800
May 5,800 3742
Jun 1,950
Demand
3742
3742 368 ? -1,690
3742
Production
3742
3742
2,426
150
Ending inventory
800
2642
3,484 150
Workforce
150
150
150
150
150
