Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please disregard the excel question B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local
please disregard the excel question
B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local travel agency. Your manager has asked you to track your sales of next winter's holiday packages. For each package, customers can schoose whether or not to include a flight in the package. For each sale, an initial down payment of 20% of the total package cost is required. 6 Customers can pay the remainder of their balance owing using a monthly payment plan for one year with a standard annual interest rate applied 7 Make sure you spot-check your work to be sure your formulas and functions are working correctly as you copy them! 9. Always use appropriate relative and/or absolute cell references for every function you build in the first row of each column, copy it down for all customers. 10 a) Assign the name Packages to range A40:044. 11 ) Use a date function to display the current date in cell B25. 12 a For the first customer in row 29, insert an appropriate function to display or calculate the following Cell E29 - the package cost, based on the package chosen. Cell F29 the flight cost, based on the package chosen Cell G29 - the total cost of the package (hint: the flight cost is only included in the total package cost IE the customer needs a flight), Cell H29 - the amount of the down payment required. Cell 129 - the balance owing, which is the difference between the total package cost and the down payment paid. Cell 129 - the client's monthly payment (hint read the question carefully the information you need is in the question) 19 d) After copying your functions down each column for all customers, use a function to calculate the totals on row 37 for columns E through 20 e) Apply accounting format with 2 decimals to all monetary values in rows 29 to 37. Apply the Top and Double Bottom Border style to the range 37:137 2. Complete the Summary Statistics section (cells 640.644) using appropriate functions Format the monetary values to be currency format with O decimals. 13 14 15 16 17 18 Stacy's Travel - Winter Holiday Specials Monthly Payment Yes 24 25 Date Prepared: 26 Interest Rate: 3.75% 27 Down Payment: 20W Flight Total Package Down 28 Customer ID Number Last Name Package Needed Package Cost Flight Cost Cost Payment Balance 29 10034 Cordum Hawaii Dream Trip No 30 3421 Desai Rio Getaway Yes 31 12123 Saxer Japanese Hideaway Yes 32 23901 Tran Japanese Hideaway 33 12012 Salinas Hawaii Dream Trip Yes 34 20301 Smith Japanese Hideaway No 35 20310 Shannon New York City Weekend 38 12314 Nelson South American Cruise Yes 37 Total: 38 39 Package Package Cost Flight Cost Summary Statistics 40 Hawaii Dream Trip S $ 350.00 Number of Packages Sold 41 Japanese Hideaway S $ 500.00 Lowest Total Package Cost 42 New York City Weekend $ S 375.00 Average Total Package Cost 43 Rio Getaway 5 $ 400.00 Highest Total Package Cost 44 South American Cruise $ s 450.00 Median Total Packare Cost 45 your PACKAGE COSTS (cells B40:844) are $0.00 - this means you failed to enter your student properly on the Instructions tab and can't start the exam yet 46 Yes ANSWER THIS QUESTION: Which customer booked the least expensive vacation package for next winter? 48 * answer MUST be cell-referenced The accounts receivable turnover ratio is calculated by dividing: O total sales by ending gross accounts receivable. O total sales by average gross accounts receivable. net credit sales by average net accounts receivable. Onet credit sales by average gross accounts receivable. Presented here is selected financial information (in millions of dollars) from the 2017 financial statements of Canadian National Railway Company and Canadian Pacific Railway Limited: Sales Allowance for doubtful accounts, beginning of year Allowance for doubtful accounts, end of year Accounts receivable balance (net), beginning of year Accounts receivable balance (net), end of year CN Railway $13,041 28 16 875 984 CP Railway $6,554 32 25 591 687 X Your answer is incorrect. Calculate the receivables turnover and average collection period for both companies. (Round times to 1 decimal place, g. 52.7 and all other answers to o decimal places, s. 52.) CN Railway CP Railway 107 times Receivables turnover 144 times 340 25.4 days Average collection period days 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