A company has the following information concerning demand and supply of a particular product: Period 1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company has the following information concerning demand and supply of a particular product: Period 1 2 5 10 Demand forecast 120 40 40 55 45 50 50 50 Orders on hand 120 40 10 55 5 0 0 0 Planned supply 145 45 50 50 50 50 50 50 50 50 Note: The demand forecast includes orders on hand plus an estimate of future customer orders yet to be received. The above figures are NOT cumulative over time. 3 50 50 + 6 7 50 0 (a) (4 points) Calculate cumulative available-to-promise quantities for each period. (b) (4 points) A new customer inquiry is received requesting delivery of 30 units in period 3, 40 units in each of periods 4, 5 and 6, and 50 units in period 7. Calculate the best delivery quote the company can offer. (c) (2 points) Assuming the quote is accepted, calculate updated cumulative available-to-promise quantities for each period. (d) (5 points) Suppose the lead time for producing the product is 3 periods and the yield is 85%. The product supply in period 1 includes 100 units already in finished goods inventory plus 45 units projected output from work-in-process. The remaining work-in-process is projected to supply 45 units in period 2 and another 50 units in period 3. Perform requirements planning calculations to compute required production start quantities in each period satisfying the demand forecasts. Assume demand forecasts do not change as a result of the new customer inquiry. You can report fractional amounts to the nearest tenth of a unit. (e) (5 points) Perform requirements planning calculations to compute required production start quantities in each period satisfying only the orders on hand, excluding the new customer inquiry. You can report fractional amounts to the nearest tenth of a unit. A company has the following information concerning demand and supply of a particular product: Period 1 2 5 10 Demand forecast 120 40 40 55 45 50 50 50 Orders on hand 120 40 10 55 5 0 0 0 Planned supply 145 45 50 50 50 50 50 50 50 50 Note: The demand forecast includes orders on hand plus an estimate of future customer orders yet to be received. The above figures are NOT cumulative over time. 3 50 50 + 6 7 50 0 (a) (4 points) Calculate cumulative available-to-promise quantities for each period. (b) (4 points) A new customer inquiry is received requesting delivery of 30 units in period 3, 40 units in each of periods 4, 5 and 6, and 50 units in period 7. Calculate the best delivery quote the company can offer. (c) (2 points) Assuming the quote is accepted, calculate updated cumulative available-to-promise quantities for each period. (d) (5 points) Suppose the lead time for producing the product is 3 periods and the yield is 85%. The product supply in period 1 includes 100 units already in finished goods inventory plus 45 units projected output from work-in-process. The remaining work-in-process is projected to supply 45 units in period 2 and another 50 units in period 3. Perform requirements planning calculations to compute required production start quantities in each period satisfying the demand forecasts. Assume demand forecasts do not change as a result of the new customer inquiry. You can report fractional amounts to the nearest tenth of a unit. (e) (5 points) Perform requirements planning calculations to compute required production start quantities in each period satisfying only the orders on hand, excluding the new customer inquiry. You can report fractional amounts to the nearest tenth of a unit.
Expert Answer:
Answer rating: 100% (QA)
a To calculate the cumulative availabletopromise quantities for each period we need to track the planned supply and deduct the demand forecast in each ... View the full answer
Related Book For
Managing Business Ethics Making Ethical Decisions
ISBN: 9781506388595
1st Edition
Authors: Alfred A. Marcus, Timothy J. Hargrave
Posted Date:
Students also viewed these accounting questions
-
Use the fact that (a) 1 (1-x) =nxn-1 to find the sum of each series. n = 1 =(7) - n = 1 x 8 (b) (9) n=1 = X
-
What is the percentage sales mix in units and the percentage sales mix in pesos respectively? (Sales Mix): An entity manufactures and sells three products: MFD, RUD, and SLW. Annual fixed costs are...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Reflect on the key elements of an effective professional development program. List the top three elements that must be included in an effective professional development program. Does your school's...
-
On June 30, 2014 Equipment Leasing International (ELI) leased equipment to Cheapskate Mfg Corp (CMC). The lease agreement qualifies as a direct financing lease and calls for CMC to make semiannual...
-
During December of this year, G. Elden established Ginnys Gym. The following asset, liability, and owners equity accounts are included in the chart of accounts: Cash Exercise Equipment Store...
-
True or False. The system mass matrix is always singular unless the boundary conditions are incorporated.
-
Swan's Supplies is a wholesaler of sporting goods equipment for retailers in a local metropolitan area. The company buys sporting goods equipment direct from manufacturers and then resells them to...
-
Hardeep Shah has recently been appointed as the new Company Secretary of Teroja Finance Berhad, a company that provides financial advisory services, which has its shares listed on the Bursa Malaysia....
-
Open the Orders Solution.sln file contained in the VB2017\Chap03\Orders Solution folder. The interface provides a button for adding the number ordered to the total ordered, and a button for...
-
Rodriguez Corporation issues 14,000 shares of its common stock for $237,500 cash on February 20. Prepare journal entries to record this event under each of the following separate situations. 1. The...
-
If two different departments in the same organization each develop strategies that bring them into competition for the same customer, that organization is suffering from a problem with what?
-
When calculating productivity measures, do higher or lower results indicate improvement?
-
Is a core competency believed to be a source of competitive advantage or corporate vision?
-
In theory, if the total combined value of every output of a system could be compared to the total combined value of every input to that same system, the resulting ratio would be called what?
-
If a customer considers a feature a necessity but is not impressed by it, is this feature an order qualifier or an order winner?
-
Xavier Company provided the following bank reconciliation on January 31 of the current year: Bank balance Add Deposit in transit Total Deduct Outstanding checks: No. 114 115 116 Adjusted bank balance...
-
What does non-recourse financing mean?
-
CEO Marina Delatorre was in trouble with the Board of Directors for her reluctance to move quickly in reengineering Phantom Savings and Loan. The companys stock was selling far below its true value,...
-
You work for Brighten Enterprises, a Fortune 500 company with annual sales of more than $23 billion. Your company has been on the cutting edge in new product innovation. It has grown rapidly and has...
-
Its hard to be a start-up. To get funding from major venture capitalists with deep pockets requires having a good story. NOTHAM Foodss story had two parts that the companys charismatic founder Daniel...
-
A W14 \(\times 30\) structural A992 steel column is pin connected at is ends and has a length \(L=12 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the column does...
-
A W16 \(\times 45\) structural A992 steel column is fixed at the base and free at the top and has a length \(L=8 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the...
-
Determine the \(\operatorname{load} P\) required to cause the steel \(\mathrm{W} 12 \times 50\) structural A-36 steel column to fail either by buckling or by yielding. The column is fixed at its...
Study smarter with the SolutionInn App