Question
The Discount amounts in cells D4, D5, D6 and D7 are computed using the IF function. The discount amoun in colum D should equal the
The Discount amounts in cells D4, D5, D6 and D7 are computed using the IF function. The discount amoun in colum D should equal the Discount % from the assumptions area multiplied by the Sales figure from the column B if the corresponding Sales in column B is greated than or equal to $300,000. If the corresponding Sales in column B is less than $300,000, then the Discount amount is calculated us 5% as the discount percentage. The IF function in cell D4, D5, D6, and D7 are incorrect. Edit and correct the IF function and show formulas.
| WheelsAboutTown.com Annual Projected Net Income | |||||
| Contract | Sales | Transportation Costs | Discounts | Maint. Costs | Net Income |
| Media Outlets | $350,124.50 | $32,211.45 | $42,014.94 | $29,760.58 | $246,137.52 |
| Publishers | 267,543.95 | $24,614.04 | 13,377.20 | #REF! | #REF! |
| Financial Consortium | 642,245.50 | $59,086.59 | 77,069.46 | - | 506,089.45 |
| Downtown Hotel Core | 456,955.25 | $42,039.88 | 54,834.63 | #VALUE! | #VALUE! |
| Total | $1,716,869.20 | $157,951.97 | $187,296.23 | #REF! | #REF! |
| Assumptions | |||||
| Transportation % | 9.20% | ||||
| Discount % | 12.00% | ||||
| Maint. Costs % | 8.50% | ||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Accounting The Ultimate Guide To Accounting For Beginners
Authors: Greg Shields
1st Edition
1546332820, 978-1546332824
