XYZ Enterprises needs to schedule operations for the next six months. Create a Master Schedule including...

XYZ Enterprises needs to schedule operations for the next six months. Create a Master Schedule including calculating Available-to-Promise (ATP) Inventory for each time period in the scheduling horizon using the following information:
Beginning Inventory of 60 units; Forecasted Demand of 40 units per period; Standard Production Quantity of 50 units, and confirmed Customer Orders of 42 units for Month 1, 35 units for Month 2, 10 units for Month 3, and 5 units for Month 4.

Solutions

Expert Solution

There are two types ATP calculations.

Push Based ATP & Pull based ATP.

Following is the calculation of considering Pull based ATP.

Pull-based ATP = Beginning Inventory + Production - Demand*

*where demand includes only confirmed orders but does not include forecasted demand (as forecast is not considered as committed demand)

ATP of the previous period becomes the Beginning Inventory of the next period.

Using this formula,

	Month 1	Month 2	Month 3	Month 4
Beginning Inventory	60	68	83	123
Production	50	50	50	50
Forecasted Demand	40	40	40	40
Confirmed Orders	42	35	10	5
Available to Promise (ATP)	68	83	123	168

keosha answered 1 year ago

Next > < Previous

Related Solutions

A company is planning its production schedule over the next six months (it is currently the...

A company is planning its production schedule over the next six months (it is currently the end of month 2). The demand (in units) for its product over that timescale is as shown below: Month 3 4 5 6 7 8 Demand 5000 6000 6500 7000 8000 9500 The company currently has in stock: 1000 units which were produced in month 2; 2000 units which were produced in month 1; 500 units which were produced in month 0. The company...

Freewheel is in the process of preparing its master budget for the six months ending December...

Freewheel is in the process of preparing its master budget for the six months ending December 19X2. The balance sheet for the year ended 30 June 19X2 is estimated to be as follows: Cost Deprec prov NBV Fixed assets 140.000 14.000 126.000 Current assets Stock 25.000 Trade debtors 24.600 Bank 3.000 Net current liabilities 52.600 Creditors Amount falling due within one year Trade creditors 25.000 Other creditors 9.000 34.000 Net current assets 18.600 Total assets less current liabilities 144.600 Capital...

There is a futures contract calling for delivery of one share of XYZ six months from...

There is a futures contract calling for delivery of one share of XYZ six months from today. You observe the following data today: • XYZ stock price is $125.00. • Dividend yield over the 6-month period of 4.00% • You can borrow and invest at the same riskless interest rate of 3.00%, over the 6-month period. Investors can short-sell shares of XYZ at a zero cost. a) Based on the data above, calculate the cash and carry value. b) Suppose...

The BCJ Company needs a master budget for the three months beginning April 1, 2020. The...

The BCJ Company needs a master budget for the three months beginning April 1, 2020. The company retails widgets. The 2020 budget should be based on the following information. An ending minimum cash balance of $10,000 each month is required. Sales are forecasted at an average selling price of $8 per widget. Merchandise costs are $4 per widget. Currently, the company maintains an ending inventory balance equal to 20% of the next month’s projected cost of goods sold. Purchases during...

Create a master budget for the first year of operations for a consulting business that offers...

Create a master budget for the first year of operations for a consulting business that offers training services. The master budget should include the operating budgets and the financial budgets. (make use of assumed figures)

Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June....

Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation. Sales: February $514,000; March $489,000; April $550,000; May $586,000; June $663,000; July $668,000Purchases: Purchases are calculated as 57% of the next month's sales, 11% of purchases are made in cash, 46% of purchases are paid for 1 month after purchase, and the remaining 43% of purchases are paid for 2 months after...

ABC is expected to pay a dividend of $1.25 every six months for the next four...

ABC is expected to pay a dividend of $1.25 every six months for the next four years. The current share price is $25.76 and the relevant discount rate is 14% (compounded semi-annually). What do you expect the share price at the end of year 4 to be? a. $28.82 b. $26.74 c. $31.44 d. $25.12 Please don't use the PVA formula.

ABC is expected to pay a dividend of $1.25 every six months for the next four...

ABC is expected to pay a dividend of $1.25 every six months for the next four years. the current share price is $25.76 and the relevant discount rate is 14% compounded semiannually. what do you expect the share price at the end of year 4 be?

suppose ABC's stock price is $25. In the next six months it will either fal to...

suppose ABC's stock price is $25. In the next six months it will either fal to $15 or it will rise $40. What is the current value of a six month call option with an exercise price of $20? The six month risk free interest rate is 5% (periodic rate). us the risk neutral valuation method A: $13.10 B: $20 C: $8.57 D: $21.33 E: $9.52

Shown below are the budgeted sales for ABC Company for the next six months: Sales for...

Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $18,000 $ 95,000 February $15,000 $130,000 March $24,000 $ 70,000 April $26,000 $120,000 May $19,000 $ 90,000 June $14,000 $100,000 On average, 45% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 15% are collected in the second month following sale, and the remaining 10% is collected three...

Subjects