for the correspondin each alternative tax scheme ory (F23:N23) for all 10 tax y
ID: 2396382 • Letter: F
Question
for the correspondin each alternative tax scheme ory (F23:N23) for all 10 tax y 23, calculate the total values for each category(F23. 6. In row 7. As part of the flat-rate tax tax, one possible scheme would include a state allow and low cost of living. The amount of the ls 7:B9. If the list does not contain the appropriate st to balance the high low by state in cel message #N/A should the state allowanc the column, and then copy it to cells 013:021 state, the should be displayed. In cell 012, write a for allowance for this taxpayer Write the formula so that it can be displayed. In cell 012, write a formula g. Highlight in pink the colu mn of the tax scheme that is most favorable to income taxpayers (Actual, Alternative 1, or Alternative 2) 9. Format the worksheet to make it easy to read and understand. 10. Save and close the Freedom Tax Analysis.xlsx workbook. Level 2 -Calculating Travel Costs at America Travels As a new sales associate at America Travels travel agency, you assist travel agents in finding As a high-volume travel agency, America Traves the best fares for corporate customers. has negotiated several premium discounts with airlines, which you pass along to vour customers who do a large amount of business with you. Compared to standard busines fares, these discounts can amount to a substantial savings and do not have minimum stay requirements Convertto, Inc. is a significant customer with a travel department that prices its own fares online and then contacts America Travels to see if it can provide a better rate. Convertto sends an Excel workbook containing a list of proposed trips to America Travels each day by 10 a.m. via email, and requests price quotes for these trips by noon. Convertto has corporate offices in New York, San Francisco, and London, which is where mostExplanation / Answer
Discounted fare price represents base fare less discount The formula which we can use for discounted fare is Base fare -(base fare*% discount) we can get % discount by using the H lookup formula Base Fare Weekday Fare category Discount Discounted fare 272 6 1 X 204 H9-(HLOOKUP(K9,$I$15:$L$16,2,0)*H9) 2277 2 3 Y 1138.5 H10-(HLOOKUP(K10,$I$15:$L$16,2,0)*H10) 665 5 2 Y 332.5 H11-(HLOOKUP(K11,$I$15:$L$16,2,0)*H11) 939 5 3 AA 939 H12-(HLOOKUP(K12,$I$15:$L$16,2,0)*H12) Flights discounts Discount category AA X Y Z % discount 0% 25% 50% 65% Discount Category Fare category Weekday 1 2 3 1 AA AA X 2 Y Y Y 3 Y Y Z 4 Y Z Z 5 Z Y AA 6 X X X 7 Y Y Z
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.