need formula for trends and bonus AveryCollinsKinsleyMcDonnoughRossShannon2012 Total Sales by AgentJanuary - JuneJanuaryFebruaryMarchApril$ 3,671 $ 2,973 $ 4,017 $ 5,040 $$ 1,549 $992$$2,267 $ 3,201 $2,996 $ 6,948 $ 4,205 $ 5,523 $2,003 $ 4,190 $ 3,496 $$ 4,038 $ 2,064 $ 7,015 $$ 1,172 $ 866 $2,109 $$Task 5Create Line sparklines in column Hin the Summary sheet to display six-month trends for each agent. Showthe high point in each sparkline.Task 7Create a footer with your fullname on the left side, the filename in the center, and theDate on the right side of eachsheet (Part_1 and Part_2).MayJune4,963 $ 5,4974,008 $ 3,7986,597 $ 5,1471,975 $ 2,936 $ 3,4986,832 $ 5,971 $ 5,4973,385 $ 4,078 $ 3,598TrendsBonus$BonusTask 6Insert an IF function in column I that displaysa $600 bonus if an agent's average sales aregreater than the average of all sales for thesix months. Use two nested AVERAGEfunctions in the logical_test argument of theIF function to make the comparison. Use cellreference for Bonus.600

Find the Given details below: Given details January February March April May June Avery $…

Avery Collins Kinsley McDonnough Ross Shannon 2012 Total Sales by Agent January - June January February $ 3,671 $ 2,973 $ 1,549 $ 992 $ 2,996 $ 6,948 $ 2,003 4,190 $ 4,038 $ 2,064 $ 7,015 $ $ 1,172 $ 866 $2,109 $ Task 5 Create Line sparklines in column H in the Summary sheet to display six- month trends for each agent. Show the high point in each sparkline. April May June 5,040 $ 4,963 $5,497 4,008 $ 3,798 5,523 $ 6,597 $ 5,147 1,975 $ 2,936 $ 3,498 6,832 $ 5,971 $5,497 3,385 $ 4,078 $ 3,598 March $4,017 $ $2,267 $ 3,201 $ $ 4,205 $ $3,496 $ Trends Bonus Bonus Task 6 Insert an IF function in column I that displays a $600 bonus if an agent's average sales are greater than the average of all sales for the six months. Use two nested AVERAGE functions in the logical_test argument of the IF function to make the comparison. Use cell reference for Bonus. 600

Avery Collins Kinsley McDonnough Ross Shannon 2012 Total Sales by Agent January - June January February $ 3,671 $ 2,973 $ 1,549 $ 992 $ 2,996 $ 6,948 $ 2,003 4,190 $ 4,038 $ 2,064 $ 7,015 $ $ 1,172 $ 866 $2,109 $ Task 5 Create Line sparklines in column H in the Summary sheet to display six- month trends for each agent. Show the high point in each sparkline. April May June 5,040 $ 4,963 $5,497 4,008 $ 3,798 5,523 $ 6,597 $ 5,147 1,975 $ 2,936 $ 3,498 6,832 $ 5,971 $5,497 3,385 $ 4,078 $ 3,598 March $4,017 $ $2,267 $ 3,201 $ $ 4,205 $ $3,496 $ Trends Bonus Bonus Task 6 Insert an IF function in column I that displays a $600 bonus if an agent's average sales are greater than the average of all sales for the six months. Use two nested AVERAGE functions in the logical_test argument of the IF function to make the comparison. Use cell reference for Bonus. 600

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Forecasts and actual sales of digital music players at Just Say Music are as follows: Month Forecast Actual Sales March 150 170 April 207 214 May 202 190 June 265 247 July 268 242 August 250 210 September 285 240 October 267 192 What is the forecast for November, using a two-period moving average? Round your answer to two decimal places. What is the forecast for November, using a three-period moving average? Round your answer to two decimal places. Compute MSE for the two- and three-period moving average models and compare your results. Do not round intermediate calculations. Round your answers to two decimal places.
Data collection strategy prior to data entry?
Conduct an ABC analysis on the following twelve items. SKU $ Value/Unit Annual Use (units) B 60 580 D 52 620 36 720 K 20 600 38 300 40 250 25 360 16 280 G 480 10 320 12 240 22 120
Please do not give solution in image formate thanku. The local supermarket buys lettuce each day to ensure really fresh produce. Each morning any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week the supermarket can buy fresh lettuce for $4.00 a box. The lettuce is sold for $10.00 a box and the dealer that sells old lettuce is willing to pay $1.50 a box. Past history says that tomorrow's demand for lettuce averages 250 boxes with a standard deviation of 24 boxes. How many boxes of lettuce should the supermarket purchase tomorrow? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round your answer to the nearest whole number.)
q4
Smart Phone covers sales for the past 12 months is given below. Management forecast's for the months of March, April, May, and June are listed Month Unit Sales Management's Forecast Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 100 95 95 112 126 118 95 85 101 94 89 110 122 114 108 112 a) What is the MAD for the forecast developed by management sales (round your response to two decimal places) What in the MAPE for the forecast developed by management % (round your response to two decimal places). %3D
HELP THIS PLEASE AND THANKS U PLEASE THANKS
Is there a specific spacing and font for an Buiness Annual Report?
96 LL I %24 Question 19 of 20 > Sony charges a higher price for the newest version of "Grand Theft Auto" than older versions. A health club waives the first month's usage fee for new members. DirecTV offers viewing packages with various combinations of channels at different prices. Cincinnati Bell offers Internet, phone, cellular, and cable services for a single price. Wells Fargo charges an advisor's fee of $95 for closing an investment account and peak-load pricing incial services firm Nock-in strategy intertemporal pricing Show all 5:22 PM 78°F EENG 12/9/2021 su prt sc f12 delete end 114 144 15 94 PA num backspace 5 6 home enter H. pause 1 shift.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Please explain the calculation to get get the answers in the column provided?!
Year Season Sales 2018 Winter 40 2018 Spring 29 2018 Summer 31 2018 Fall 40 2019 Winter 102 2019 Spring 87 2019 Summer 96 2019 Fall 132 2020 Winter 105 2020 Spring 93 2020 Summer 105 2020 Fall 117 2021 Winter 141 2021 Spring 39 2021 Summer 114 2021 Fall 123 What is the slope of the trend equation obtained by linear regression? Round to two decimal digits. What is the intercept of the trend equation obtained by linear regression? Round to two decimal digits. What is the seasonal index for Spring? Round to two decimal digits. The quarter number for Winter of 2018 is 1. What is the quarter number for Spring of 2025? What is the trend based forecast for Spring of 2025. Round to a whole number. What is the seasonally adjusted trend based forecast for Spring of 2025? Please do not use excel to find the slope and intercept, thank you so much!