Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Oackestove sels a number of dferent products Thery aiso sell roduct tundes The table on the Product Sales worksheol details the total sales revesse by
Oackestove sels a number of dferent products Thery aiso sell roduct tundes The table on the Product Sales worksheol details the total sales revesse by mordh foe each of the p North Fuel Supply wth Stove a Accessory K Adystole Fru Grate S570 S180 S475 $112 20 $230$ 530 $1212472 24 564 $ Blue Bag Bol Plate 31 $54 Cenac Kede Sharperer Cty Deals 9-Pack Shppng $128 $25 Cordurs D-Ring Bag 58 $219 $304 $110 $122 122$50$50 $3 $110 ST4 $73 $108S88 $900408 5155 $25 Cup Charger 20 Dekise Combe Kt Ostance Pedometer S4E $416 $294 $293,S205 $110 erded G Plate ire StrtrH S1T 534$1 208 $737 Frebox Bunde Fretes Mater Cono 16 $3 44 ivingSocial Voucher Shppng Mader Comnbo Ka S4 Nsgere Catene ie ar cmp pace Saver Op 3030 8225 $10$16 Repte 5520 $2.340 $1.545 soe 543 S111 $5 824 $104 $2 46 3 $441 1 379 $1,247 5351 Red Caning P Red Scaich Brte Pad $13 520 S137 S179 8124 112 at and Pepper Shkar 24$ 3$123 $13 $124 $1126 526 5145 5318 S40 0 sed product bundles The table on the "Product Saes" workshest details the total sales reversae by month for each of the products and bundles that 5190 $300 $570 $105 545 $312$208 $238$165 8 $20 $12$12 S4 $16 $253 2e 1 375 $25 $95 $219 34 $110 $122 $50$0 $125$499 $324 537 $110 $74 $73$108 $450 $093$469 $485 $416 $294 $290 $17 5702 544015$494563 $4905 $417 $3.389 sc $3879 $6.079 9440t$3,051 334 $4 563 3009049$49 962 $344$412 $15$100 $10 $140 500 $14 8 34 32 $15 $15 sa 540 S88 S32 $110 $156 $126 seo 5114$20 0 10 5246 525 s35 2 $142 004 $1,00 5838 $1e, $1,766 02 $184 s111 $14 3e8 51319 41247 137$179 $138 $124$112 5219 $1330 Ihe tabie on the "Product Sales" worksheet details the total sales revenue by month for each of the products and bundles that Quickstove sold in 2012. Create a ine chart to examine trends in sales for certain products and bundles. Task # Points Task Description Construct a line chart to examine the "Total Sales" growth (row 89 of the worksheet) 4across each month in 2012, Format the chart 12 with the title "Quickstove Product Sales" and a legend to the right of the chart. Use the months in row 6 of the worksheet as ie labels for the horizontal axis Add a linear trendline 2 15 Construct a line chart to compare the sales trends for the following products and kits: Firebox Deluxe Combo Kit, Firebox Master Combo Kit, Folding Firebox Campfire Stove, and Quickstove Fuel Disk. Format the chartT with the title "Sales For Selected Products" and a legend to the right of the chart. Use the months in row 6 of the worksheet as the labels for the horizontal axis. 12/6/2018 file://:/Users/Public. MasterDownABCDE/Downloads/assignment.html 3 Oackestove sels a number of dferent products Thery aiso sell roduct tundes The table on the Product Sales worksheol details the total sales revesse by mordh foe each of the p North Fuel Supply wth Stove a Accessory K Adystole Fru Grate S570 S180 S475 $112 20 $230$ 530 $1212472 24 564 $ Blue Bag Bol Plate 31 $54 Cenac Kede Sharperer Cty Deals 9-Pack Shppng $128 $25 Cordurs D-Ring Bag 58 $219 $304 $110 $122 122$50$50 $3 $110 ST4 $73 $108S88 $900408 5155 $25 Cup Charger 20 Dekise Combe Kt Ostance Pedometer S4E $416 $294 $293,S205 $110 erded G Plate ire StrtrH S1T 534$1 208 $737 Frebox Bunde Fretes Mater Cono 16 $3 44 ivingSocial Voucher Shppng Mader Comnbo Ka S4 Nsgere Catene ie ar cmp pace Saver Op 3030 8225 $10$16 Repte 5520 $2.340 $1.545 soe 543 S111 $5 824 $104 $2 46 3 $441 1 379 $1,247 5351 Red Caning P Red Scaich Brte Pad $13 520 S137 S179 8124 112 at and Pepper Shkar 24$ 3$123 $13 $124 $1126 526 5145 5318 S40 0 sed product bundles The table on the "Product Saes" workshest details the total sales reversae by month for each of the products and bundles that 5190 $300 $570 $105 545 $312$208 $238$165 8 $20 $12$12 S4 $16 $253 2e 1 375 $25 $95 $219 34 $110 $122 $50$0 $125$499 $324 537 $110 $74 $73$108 $450 $093$469 $485 $416 $294 $290 $17 5702 544015$494563 $4905 $417 $3.389 sc $3879 $6.079 9440t$3,051 334 $4 563 3009049$49 962 $344$412 $15$100 $10 $140 500 $14 8 34 32 $15 $15 sa 540 S88 S32 $110 $156 $126 seo 5114$20 0 10 5246 525 s35 2 $142 004 $1,00 5838 $1e, $1,766 02 $184 s111 $14 3e8 51319 41247 137$179 $138 $124$112 5219 $1330 Ihe tabie on the "Product Sales" worksheet details the total sales revenue by month for each of the products and bundles that Quickstove sold in 2012. Create a ine chart to examine trends in sales for certain products and bundles. Task # Points Task Description Construct a line chart to examine the "Total Sales" growth (row 89 of the worksheet) 4across each month in 2012, Format the chart 12 with the title "Quickstove Product Sales" and a legend to the right of the chart. Use the months in row 6 of the worksheet as ie labels for the horizontal axis Add a linear trendline 2 15 Construct a line chart to compare the sales trends for the following products and kits: Firebox Deluxe Combo Kit, Firebox Master Combo Kit, Folding Firebox Campfire Stove, and Quickstove Fuel Disk. Format the chartT with the title "Sales For Selected Products" and a legend to the right of the chart. Use the months in row 6 of the worksheet as the labels for the horizontal axis. 12/6/2018 file://:/Users/Public. MasterDownABCDE/Downloads/assignment.html 3
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