Fus Home Ingen Page Layout Formulas Review View Tell me what you want to do PROTECTED VIEW Be care from the Internet can contain viruses. Unless you need to add sales to stay in Protected View Enable Editing P29 f - B D H 1 2 Assignment 6.26 3 4 Complete the following business mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. 5 5 05 SEASON 03 04 APR MAN OL FER 8 02 MAR Os JUN JUL TOTAL $6.150.00 $5.350.00 55.00.00 6.090.00 $ 850.00 $ 1 100.00 $ 1.250.00 $ 1.010.00 $ 1,200.00 Arap Sales $1,100.00 5 1,600.00 $ 1.295.00$ 1.800.00 $ 1.200.00 9 Beginning of Season (BOS) Beginning of Month (BOM) Stock at Retail 10 11 Sales 12 13 Receipts for 14 15 Markdown 15 17 End of Month End of Season EOS Stock 13 19 Mart Up on Retail 550000 S 500.00 500.00 $ 40000 60000 Turnover 5. 5.500 5535000 350000 55 5430N 53.90 54. SON 55 TON 54. SON 21 Cost Complement 22 23 Beginning season (BOS/Beginning of Month OOMStock at Cost 24 25 25 27 End of Month OM End of Season Stock It Cont Average ratest 29 30 3 14 35 37 23 10 Sheett Sheet2 11 PM 11/2009 Type here to search o 0 File Home Insent Page Layout Formulas Data Review View Tell me what you want to do PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing P29 A B D E F G H 1 2 Assignment 62:6 3 4 Complete the following business mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. S 5 01 FES 02 MAR SEASON 03 04 APR Os JUN 06 JUL TOTAL 56.150.00 $5.350.00 $ 5.000.00 6090.00 $ 850.00 $ 1 100.00 $ 1.250.00 $ 1,010,00 1,300.00 Average Sales $1,100.00 1.600.00 $ 1.295.00 $ 1.800.00 $ 1.200.00 Average Stock 9 Beginning of Season (BOS) Beginning of Month (BOM) Stock at Retail 10 11 Sales 12 13 Receipts for 14 15 Markdowns 16 17 End of Month (EOM/End of Season (EOS) Stock at Retail 13 19 Mark Up on Retail 5500.00 500.00 50.00 540000 60000 Turnover 5.5.000 55.350.00 500.00 55 54 SON 53. SON 54 SON 55.70 54 SON 21 Cost Complement 22 23 Beginning of Season (BOS/Beginning of Month Om Stock Cow 24 Average into a Cast 25 27 End of Month OMVEnd of Seasons Shock at Cost 29 11 33 34 35 39 Sheet1 Sheet2 11 PM Ad 6/17/2020 @ e D Type here to search