Don't just give me a number please.

Jay Corporation has provided data from a two-year period to aid in planning The Controller has asked you to prepare a cor Cell Reference Allows you to refer to data from another cell in the worksheet From the Excel Simulation below, fw Basic Math functions: below itin ablak cel-819 20 was emered the toria would ad te valeshom tose cels and opt tee Alows you to use tie basc math symtots to perform, mathemaica functions ou can use SUM function: Alows you to refer to multiple cells and adds all the values You can add individual cel references or ertu Snlanyitnatark cel-SMC 18 ofading those three separate cells, or 47,300 ntis eanple n this example igh-Low Method Contribution Fomat Income Seatement HOME ISRT PAGI LAYOUT FORMULAS DATAREMEW 1 Formating TableSs- Styles -/ "ITO aid in planning, Jay Budgeted information for Quarter 1 of years Sales in 17/000 Sales price pr un fter analyzing experses, the company has determined the following cost paterns Cot ofgoods sold Sales commissions 9.50% pe Administratnive 5,000.00 per quarter 45,000.00 p quarter 27D00.00 per quate 5 36.000.00 per quarter sManagement has concluded that shipping expense is a mixed cot. Units shipped and the related shipping cost over the last eight quarters are Quarter 94 000.00 5800.00 2.6/00.00 20 Quarter 2Quarter4 a year2 ,,I ..nar 1 3,800