Question

In: Operations Management

Q1: What is the Projected Ending Inventory for week 6?

On hand inventory at end of week 5 = 75
Week	6	7	8	9	10	11	12	13
Forecasted demand	200	200	200	300	300	300	250	250
Booked orders	265	210	190	280	260	225	180	120
Projected ending inventory	???
Master production schedule	600			900			750
Available to promise							XXX

Q1: What is the Projected Ending Inventory for week 6?

a. 400 units.

b. 475 units.

c. 335 units.

d. None of these answers are correct.

e. 410 units.

On hand inventory at end of week 5 = 75
Week	6	7	8	9	10	11	12	13
Forecasted demand	200	200	200	300	300	300	250	250
Booked orders	265	210	190	280	260	225	180	120
Projected ending inventory		???
Master production schedule	600			900			750
Available to promise							XXX

Q2: What is the Projected Ending Inventory for week 7?

a. 215 units

b. 0 units.

c. None of these answers is correct.

d. 275 units.

e. 200 units

On hand inventory at end of week 5 = 75
Week	6	7	8	9	10	11	12	13
Forecasted demand	200	200	200	300	300	300	250	250
Booked orders	265	210	190	280	260	225	180	120
Projected ending inventory
Master production schedule	600			900			750
Available to promise	???						XXX

Q3: What is the Available to Promise for week 6?

a. Minus 65 units.

b. None of these answers is correct.

c. 125 units.

d. 0 units.

e. Minus 75 units.

f. 10 units.

g. 200 units.

Expert Solution

Projected ending inventory for current week = Master production scheduleIf any) + projected ending inventory for last week - Max(forecasted demand , booked orders)

therefore

Projected ending inventory for week6 = Master production schedule + projected ending inventory for week5 - Max(200 , 265)

= 600 + 75 - 265

= 410 units

Q1 the Projected Ending Inventory for week 6 is e) 410 units

Projected ending inventory for week7= projected ending inventory for week6 - Max(200 , 210)

= 410 - 210

= 200 units

the Projected Ending Inventory for week 7 is e) 200 units

Available to promise = projected ending inventory for last week + MPS - sum of all booked orders till next MPS

therefore available to promise for week6 = On hand inventory for week5 + MPS for week6 - (sum ofbooked order for week6, 7 and 8)

= 75 + 600 - (265 + 210 + 190)

= 10 units

Available to Promise for week 6 is f) 10 units

keosha answered 2 years ago

Q1 :- Explain the effects of inventory valuation methods on the cost of ending inventory, income...

Q1 :- Explain the effects of inventory valuation methods on the cost of ending inventory, income and income taxes ? Q2 :- Given the following information, determine the cost of ending inventory at November 30 using the Weighted Average perpetual inventory method. November 3: 15 units were purchased at $8 per unit. November 11: 18 units were purchased at $9.50 per unit. November 15: 15 units were sold at $45 per unit November 18: 30 units were purchased at $10.75...

On hand inventory at end of week 5 = 75 Week 6 7 8 9 10...

On hand inventory at end of week 5 = 75 Week 6 7 8 9 10 11 12 13 Forecasted demand 200 200 200 300 300 300 250 250 Booked orders 265 210 190 280 260 225 180 120 Projected ending inventory Master production schedule 600 900 750 Available to promise ??? XXX Q4: What is the Available to Promise for week 9? a. 135 units. b. 145 units. c. 0 units. d. 360 units. e. None of these answers...

There are 10 units in ending inventory compute the value of the ending inventory using the...

There are 10 units in ending inventory compute the value of the ending inventory using the periodic inventory method. Compute the answer using FIFO, LIFO and the average cost methods. (round your answer to the nearest whole number) Price Cost Number Per Per Date Transaction of units unit Purchase Apr. 3 Inventory 2 10 20 8 Purchase 2 15 30 11 Purchase 3 20 60 30 Purchase 2 25 50 May 8 Purchase 3 25 75 10 Purchase 3 30...

Q1 An employee is working 6 days a week from Monday to Saturday. Assume the overtime...

Q1 An employee is working 6 days a week from Monday to Saturday. Assume the overtime for the employee is double after 40 hours. The following table shows his working hours. Complete the table below (Show your work) M T W Th F Sa Total Hours Regular Hours Overtime Hours Regular Rate Overtime Rate 10hr 10hr 10hr 10hr 10hr 2 hr ?? ?? ?? $ 12.50 ?? Find the gross earning of the employee. Hamda is a salesclerk who receives...

6. The Seten Corporation has a desired ending inventory of 30% of the next months estimated...

6. The Seten Corporation has a desired ending inventory of 30% of the next months estimated sales. In turn, their cost of goods sold is 60% and their forecasted sales for the months of March, April, May, June and July are as follows: $750,000 $880,000 $700,000 $800,000 $900,000 Purchases for the Months of February and March were $500,000 and $360,000 and their purchases are paid as follows: 10% during the month of the purchase, 80% in the next month and...

In comparing the ending inventory balances of FIFO andLIFO, the ending inventory value under FIFO...

Fulbright Corp. uses the periodic inventory system. During its first year of operations, Fulbright made the following purchases (listed in chronological order of acquisition): 40 units at $100 per unit 70 units at $80 per unit 170 units at $60 per unit Sales for the year totaled 270 units, leaving 10 units on hand at the end of the year. In comparing the ending inventory balances of FIFO and LIFO, the ending inventory value under FIFO less the ending inventory balance under LIFO results in...

The following data are provided regarding an entities ending inventory year current cost of ending inventory...

The following data are provided regarding an entities ending inventory year current cost of ending inventory cumulative price level 15 250,000 100 16 342,000 120 17 383,500 130 18 375,000 125 19 406,000 140 Calculate ending inventory for each year, 2015 through 2019, inclusive, using the dollar value LIFO method as well as any reported LIFO reserve.

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days

Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...

Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables = 6825 Beginning Payables = 8304 Ending Payables = 8758 Credit Sales = 91199 Cost of Goods Sold = 73243 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days

Estimate the cost of the ending merchandise inventory

Based on the following data , estimate the cost of the ending merchandise inventoryParticularsAmount$Sales92,50,000Estimated Gross profit rate 36%Beginning merchandise inventory1,80,000Purchase (net)59,45,000Merchandise available for sale61,25,000