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 page 188 there is an example of how a hybrid costing system might be designed for a large-scale bicycle manufacturer. Select another industry and explain how a hybrid costing system could be...
-
Repeat Problem 6-109 for heating water at 21oC. Problem 6-109 Compare the Nusselt number results for heating air in a smooth tube at 300 K and Reynolds numbers of 50,000 and 100,000, as calculated...
-
Alpine Ski Shops Prepaid Rent balance is $4,500 on June 1. This prepaid rent rep resents six months rent. Journalize and post the adjusting entry on June 30 to record one months rent. Compute the...
-
Seeing Double Corporation purchase land for $510,000. Later in the year, the company sold land with a book value of $217,500 for $165,000. How are the effects of these transactions reported on the...
-
! Required information [The following information applies to the questions displayed below] Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 each. Each frame requires 4...
-
We want to design a tension spring with a spring outer diameter of 32 mm. The range of tensile load is 110 160 N, and the deformation range is 140~ 170 mm. We are going to use SWO-B as the material....
-
Do you think that Freuds ideas are slightly sexist?
-
How is the double-entry accounting system used to record financial transactions, and what are the basic principles behind it?
-
Make sense of the reason and parts of the accounting report. 8. What are the vital components of a pay proclamation, and how do organizations ascertain net gain? 9. Talk about the job of income...
-
In preparing its December 31, Year 4, financial statements, Irene Corp. must determine the proper accounting treatment of a $180,000 loss carryforward available to offset future taxable income. There...
-
Can you provide some additional examples of variable and fixed cost as well as why they are categorized ?
-
What is the Value of Employee Benefits? Discuss the Key Issues in Benefit Planning, Designing, and Administration.
-
Using the following Income Tax data, and given that your annual income is $ 85,000: a) Calculate the total tax (in $); b) The average tax rate (%); c) The marginal tax rate (%); and d) What is the...
-
What is beacon marketing? What are digital wallets?
-
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...
-
The fly balls of spring loaded governor of Hartnell type running at 600 rpm have a radius of rotation of 80 mm with sleeve in mid-position and ball arms vertical. The ball arms and sleeve arms are of...
-
The height of Watt's governor is proportional to (a) speed (N) (b) \(\mathrm{N}^{2}\) (c) \(1 / \mathrm{N}\) (d) \(1 / \mathrm{N}^{2}\).
-
What is the main function of a governor? How does it differ from that of a flywheel?
Study smarter with the SolutionInn App