Brenda Jonstone owns a small product distribution company that currently employs a sales force of four...

Transcribed Image Text:

Brenda Jonstone owns a small product distribution company that currently employs a sales force of four people. The business is growing fast and Jonstone must begin to make decisions more strategically. Sales and cost data is available for each region and salesperson for the last 5 years. Jonstone does not understand the value of the data or how to parse it in a way that might be useful for decision making. 2022 South Lucy Ornaments 99 77 2022 East Carlos Flowers 50 31 2022 North Mary Flowers 66 40 2022 East Victor Ribbons 61 13 2022 South Lucy Ribbons 77 17 The data is provided below. 2022 West Lucy Ribbons 110 24 2023 North Carlos Baskets 142 77 Year Region Manager Product Sales revenue Cost of goods sold 2023 North Lucy Baskets 118 64 2019 North Carlos Baskets 120 65 2023 North Carlos Baskets 36 20 2019 North Lucy Baskets 100 55 2023 East Carlos Ornaments 59 46 2019 North Carlos Baskets 30 17 2023 East Lucy Ornaments 15 12 2019 East Carlos Ornaments 50 39 2023 West Mary Flowers 106 65 2019 East Lucy Ornaments 12 10 2023 West Mary Flowers 67 41 2019 West Mary Flowers 89 54 2023 South Victor Ribbons 172 37 2019 West Mary Flowers 56 34 2023 South Victor Ribbons 41 9 2019 South Victor Ribbons 145 31 2023 South Victor Ribbons 95 20 2019 South Victor Ribbons 34 8 2019 South Victor Ribbons 80 17 2020 South Carlos Baskets 30 17 2020 South Mary Baskets 75 41 2020 South Mary Baskets 50 28 2020 West Carlos Baskets 25 14 2020 North Victor Ornaments 20 16 2020 South Lucy Ornaments 90 70 2020 East Carlos Flowers 45 28 2020 North Mary Flowers 60 37 2020 East Victor Ribbons 55 12 2020 South Lucy Ribbons 70 15 2020 West Lucy Ribbons 100 21 2021 North Carlos Baskets 132 72 2021 North Lucy Baskets 110 60 2021 North Carlos Baskets 33 18 2021 East Carlos Ornaments 55 43 2021 East Lucy Ornaments 14 11 2021 West Mary Flowers 98 60 2021 West Mary Flowers 62 38 2021 South Victor Ribbons 160 34 2021 South Victor Ribbons 38 8 2021 South Victor Ribbons 88 19 2022 South Carlos Baskets 33 18 2022 South Mary Baskets 83 45 2022 South Mary Baskets 55 30 2022 West Carlos Baskets 28 16 2022 North Victor Ornaments 22 17 Brenda Jonstone owns a small product distribution company that currently employs a sales force of four people. The business is growing fast and Jonstone must begin to make decisions more strategically. Sales and cost data is available for each region and salesperson for the last 5 years. Jonstone does not understand the value of the data or how to parse it in a way that might be useful for decision making. 2022 South Lucy Ornaments 99 77 2022 East Carlos Flowers 50 31 2022 North Mary Flowers 66 40 2022 East Victor Ribbons 61 13 2022 South Lucy Ribbons 77 17 The data is provided below. 2022 West Lucy Ribbons 110 24 2023 North Carlos Baskets 142 77 Year Region Manager Product Sales revenue Cost of goods sold 2023 North Lucy Baskets 118 64 2019 North Carlos Baskets 120 65 2023 North Carlos Baskets 36 20 2019 North Lucy Baskets 100 55 2023 East Carlos Ornaments 59 46 2019 North Carlos Baskets 30 17 2023 East Lucy Ornaments 15 12 2019 East Carlos Ornaments 50 39 2023 West Mary Flowers 106 65 2019 East Lucy Ornaments 12 10 2023 West Mary Flowers 67 41 2019 West Mary Flowers 89 54 2023 South Victor Ribbons 172 37 2019 West Mary Flowers 56 34 2023 South Victor Ribbons 41 9 2019 South Victor Ribbons 145 31 2023 South Victor Ribbons 95 20 2019 South Victor Ribbons 34 8 2019 South Victor Ribbons 80 17 2020 South Carlos Baskets 30 17 2020 South Mary Baskets 75 41 2020 South Mary Baskets 50 28 2020 West Carlos Baskets 25 14 2020 North Victor Ornaments 20 16 2020 South Lucy Ornaments 90 70 2020 East Carlos Flowers 45 28 2020 North Mary Flowers 60 37 2020 East Victor Ribbons 55 12 2020 South Lucy Ribbons 70 15 2020 West Lucy Ribbons 100 21 2021 North Carlos Baskets 132 72 2021 North Lucy Baskets 110 60 2021 North Carlos Baskets 33 18 2021 East Carlos Ornaments 55 43 2021 East Lucy Ornaments 14 11 2021 West Mary Flowers 98 60 2021 West Mary Flowers 62 38 2021 South Victor Ribbons 160 34 2021 South Victor Ribbons 38 8 2021 South Victor Ribbons 88 19 2022 South Carlos Baskets 33 18 2022 South Mary Baskets 83 45 2022 South Mary Baskets 55 30 2022 West Carlos Baskets 28 16 2022 North Victor Ornaments 22 17

Answer rating: 100% (QA)

Answer To make strategic decisions based on the sales and cost data Brenda Jonstone can start by ana... View the full answer