You run a business selling Personal Computers. You ran a sales promotion that lasted from week 4
Question:
You run a business selling Personal Computers. You ran a sales promotion that lasted from week 4 to week 11 of this year. Your Finance Department provided you 16 weeks of data covering the 3 weeks prior to the promotion, the 8 weeks of the promotion, and the 5 weeks following the promotion.
The sales promotion had two important elements; 1) A price discount that resulted in the Gross Margin declining from 33% to 28%, and, (2) the addition of $25K/Week of Sales labor overtime to aggressively work on the promotion campaign. This increased the SGA expense (Sales & General/Administrative) during the 8-week promotion.
You owe your boss a one-page report on a PowerPoint slide to review the promotions success.
Create three graphs using financial data from tthe spreadsheet posted on Blackboard. Select the Graph formats that most effectively convey your analysis. These include a Sales Graph, an Earnings Graph and Earning Impact Graph (refer to the posted template for more info on the Earnings Impact Graph).
Provide Sales Promotion commentary in the area noted on the slide. Was the promotion a success? What observation do you have with any residual benefit from the promotion? What recommendation(s) do you have regarding future promotions,Your boss has a particular interest in the SGA expense area; did the promotions increase in sales increase or reduce the SGA % rate? Include a bullet comment.
Hey, any help with this assignment especially with the graphs would be great and truly appreciated. I will be leaving a thumbs up because all help is considered.
Thank you in advance!
D16 X fix A B C D E F G H I J K L M N P 1 2 Month January January January January February February February February March March March March April April April April 3 Week Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 4 Sales $ 1,381,273 $ 1,400,250 $ 1,420,450 $ 1,715,432 $ 1,745,012$ 1,795,243$ 1,807,754$ 1,860,778 $ 1,897,025 $ 1,752,106 $ 1,700,812 $ 1,402,376 $ 1,384,001 $ 1,408,532 $ 1,390,076 $ 1,408,556 5 GM% 33% 33.00% 33% 28% 28% 28% 28% 28% 28% 28% 28% 33% 33% 33% 33% 33% 6 GM $ 455,820 $ 462,083 $ 468,749 $ 480,321 $ 479,878 $ 502,668$ 506,171$ 521,018$ 531,167 $ 490,590$ 476,227 $ 462,784 $ 456,720 $ 464,816 $ 458,725 $ 464,823 7 SGA 27% 27% 26% 23% 23% 22% 22% 21% 21% 23% 24% 27% 27% 27% 27% 27% 8 SGA Expense $ 375,000 $ 375,000 $ 375,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 375,000 $ 375,000 $ 375,000 $ 375,000 $ 375,000 9 Earnings Before Tax $ 80,820 $ 87,083 $ 93,749 $ 80,321 $ 79,878 $ 102,668 $ 106,171 $ 121,018 $ 131,167 $ 90,590 $ 76,227 $ 87,784 $ 81,720$ 89,816 $ 83,725$ 89,823 10 11 Sales discount offered plus Sales Staff Overtime added to support Promotion from week 4 to week 11 12 13 Earnings Impact: 14 Calculate and show on a graph: Average Average Weekly Average Weekly Weekly Earnings Before Earnings During Earnings After 15 Promo Promo Promo 16 Value ? Value ? Value ? 17 18 19 January February February February February March March March 20 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Totals 21 Earnings $ 80,321 $ 79,878 $ 102,668$ 106,171 $ 121,018$ 131,167 $ 90,590 $ 76,227 $ 788,040 22 SGA $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $3,200,000 23 SGA $ increase $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 200,000 24 SGA Rate 23% 23% 22% 22% 21% 21% 23% 24% 25 26 27 D16 X fix A B C D E F G H I J K L M N P 1 2 Month January January January January February February February February March March March March April April April April 3 Week Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 4 Sales $ 1,381,273 $ 1,400,250 $ 1,420,450 $ 1,715,432 $ 1,745,012$ 1,795,243$ 1,807,754$ 1,860,778 $ 1,897,025 $ 1,752,106 $ 1,700,812 $ 1,402,376 $ 1,384,001 $ 1,408,532 $ 1,390,076 $ 1,408,556 5 GM% 33% 33.00% 33% 28% 28% 28% 28% 28% 28% 28% 28% 33% 33% 33% 33% 33% 6 GM $ 455,820 $ 462,083 $ 468,749 $ 480,321 $ 479,878 $ 502,668$ 506,171$ 521,018$ 531,167 $ 490,590$ 476,227 $ 462,784 $ 456,720 $ 464,816 $ 458,725 $ 464,823 7 SGA 27% 27% 26% 23% 23% 22% 22% 21% 21% 23% 24% 27% 27% 27% 27% 27% 8 SGA Expense $ 375,000 $ 375,000 $ 375,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 375,000 $ 375,000 $ 375,000 $ 375,000 $ 375,000 9 Earnings Before Tax $ 80,820 $ 87,083 $ 93,749 $ 80,321 $ 79,878 $ 102,668 $ 106,171 $ 121,018 $ 131,167 $ 90,590 $ 76,227 $ 87,784 $ 81,720$ 89,816 $ 83,725$ 89,823 10 11 Sales discount offered plus Sales Staff Overtime added to support Promotion from week 4 to week 11 12 13 Earnings Impact: 14 Calculate and show on a graph: Average Average Weekly Average Weekly Weekly Earnings Before Earnings During Earnings After 15 Promo Promo Promo 16 Value ? Value ? Value ? 17 18 19 January February February February February March March March 20 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Totals 21 Earnings $ 80,321 $ 79,878 $ 102,668$ 106,171 $ 121,018$ 131,167 $ 90,590 $ 76,227 $ 788,040 22 SGA $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $3,200,000 23 SGA $ increase $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 200,000 24 SGA Rate 23% 23% 22% 22% 21% 21% 23% 24% 25 26 27College Algebra
ISBN: 978-0134697024
12th edition
Authors: Margaret L. Lial, John Hornsby, David I. Schneider, Callie Daniels