Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance The Markets And Financial Management Of Multinational Business

Authors: Maurice D. Levi

3rd Edition

0070376875, 978-0070376878

More Books

Students also viewed these Finance questions