Question
Write an excel formula to calculate the following: The Qty ordered (cell E7) is 0 if Ending Inventory exceeds Reorder Point (ROP - cell D1),
Write an excel formula to calculate the following:
The Qty ordered (cell E7) is 0 if Ending Inventory exceeds Reorder Point (ROP - cell D1), or is Quantity (Q - cell D2) if Ending Inventory drops at or below ROP
| A | B | C | D | E | |
| 1 | ROP | 140 | |||
| 2 | Q | 140 | |||
| 3 | |||||
| 4 | Day | Starting Inventory | Sales | Ending Inventory | Qty Ordered |
| 5 | 1 | 100 | 80 | 20 | < EXCEL FORMULA > |
| 6 |
Step by Step Solution
3.41 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
Assuming the Order Qu...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Integrated Accounting
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
8th edition
1285462726, 1285462721, 978-1285462721
