This assignment has been created to show you how many of the topics in Chapter 3 are inter-related and how a business would use many of these concepts to help them make better decisions. Furthermore, this assignment introduces you to data analytics. Companies have so much data available to them. Accountants can analyze this data, create visuals and interpret it to assist management in their decision making. I have created a tutorial video to help you with the data analytics piece in case you are new to Excel and creating pivot tables and charts. This can be found on Moodle in the assignments section. Questinne Calculations All calculations must be completed in Excel using formulas in the answer boxes provided. Do not calculate on a 36 calculator and input the final answer in Excel. 37 Worksheets There are five (5) tabs in this workbook including this cover page. Please only modify the response tabs (do not. change the data tabsi). Ensure you answer all questions and scroll to the bottom of each worksheet. You cannot write anything into the cover page other than your namel Poppity Popl is a growing manufacturer that produces three types of popcorn makers: home (stovetop), office (free-standing unit with a smaller capacity than movie theater maker), and movie theater (free-standing unit, largest popcorn capacity). The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission. Mart Cornish, the company's controller, has just prepared the company's budgeted income statement for next vear as follows: As Matt handed the statement to Mya Ferguson, the company's president, he commented, I went ahead and used the agents' current commission rate (as shown in cell BS) in complating these statements. However, we've just learned that they refuse to sell our products nekt year unless we increase the commission rate as shown below in cell B29. "That's the last straw," Mya replied angrily. "Those agents have been demanding more and more, and this time theyve gone too fat, How can they possibly defend that new rate?" They claim after paying for advertising, travel, and the other costs of promotion, there's nothing left over for profit", replied Matt. "I say it's just plain robbery," retorted Mya, "And I also say it's ome we dumped those guys and got our own sales force. Can vou get your people to work some cost figures for us to look at?" "We've already worked them up," said Matt. "Several companies we know pay a commission (see industry standard in cell B34) supplemented by a small salary. Of course, we would have to handle all promoton costs, too. We hgure our fixed oxpenses would increase, but that would be more than offset by the commission that we would avoid on agents commissions. The increase in fixed costs is detailed below. Increase in fixed costs if the company uses its own sales staff rather than agents: "Super" replied Mya, "And I nosiced that the totalincroased in fixed costs (cell B41) is fairly comparable to how. mich we're paying the asents in commissions last year (as shown in the income statement in cell B18)." "its even better than that, explained Matt. "We can actually save more esch year because we're paying our wodienss to check out the apents' reports. So our overall adminiatrative exponses would be fons". "Pull all of these numbers togethar and wo'll show them to the executive committee tomerrow" said Mya. With the spptovel of the committee, wa can move on the matter immediatelyc" This assignment has been created to show you how many of the topics in Chapter 3 are inter-related and how a business would use many of these concepts to help them make better decisions. Furthermore, this assignment introduces you to data analytics. Companies have so much data available to them. Accountants can analyze this data, create visuals and interpret it to assist management in their decision making. I have created a tutorial video to help you with the data analytics piece in case you are new to Excel and creating pivot tables and charts. This can be found on Moodle in the assignments section. Questinne Calculations All calculations must be completed in Excel using formulas in the answer boxes provided. Do not calculate on a 36 calculator and input the final answer in Excel. 37 Worksheets There are five (5) tabs in this workbook including this cover page. Please only modify the response tabs (do not. change the data tabsi). Ensure you answer all questions and scroll to the bottom of each worksheet. You cannot write anything into the cover page other than your namel Poppity Popl is a growing manufacturer that produces three types of popcorn makers: home (stovetop), office (free-standing unit with a smaller capacity than movie theater maker), and movie theater (free-standing unit, largest popcorn capacity). The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission. Mart Cornish, the company's controller, has just prepared the company's budgeted income statement for next vear as follows: As Matt handed the statement to Mya Ferguson, the company's president, he commented, I went ahead and used the agents' current commission rate (as shown in cell BS) in complating these statements. However, we've just learned that they refuse to sell our products nekt year unless we increase the commission rate as shown below in cell B29. "That's the last straw," Mya replied angrily. "Those agents have been demanding more and more, and this time theyve gone too fat, How can they possibly defend that new rate?" They claim after paying for advertising, travel, and the other costs of promotion, there's nothing left over for profit", replied Matt. "I say it's just plain robbery," retorted Mya, "And I also say it's ome we dumped those guys and got our own sales force. Can vou get your people to work some cost figures for us to look at?" "We've already worked them up," said Matt. "Several companies we know pay a commission (see industry standard in cell B34) supplemented by a small salary. Of course, we would have to handle all promoton costs, too. We hgure our fixed oxpenses would increase, but that would be more than offset by the commission that we would avoid on agents commissions. The increase in fixed costs is detailed below. Increase in fixed costs if the company uses its own sales staff rather than agents: "Super" replied Mya, "And I nosiced that the totalincroased in fixed costs (cell B41) is fairly comparable to how. mich we're paying the asents in commissions last year (as shown in the income statement in cell B18)." "its even better than that, explained Matt. "We can actually save more esch year because we're paying our wodienss to check out the apents' reports. So our overall adminiatrative exponses would be fons". "Pull all of these numbers togethar and wo'll show them to the executive committee tomerrow" said Mya. With the spptovel of the committee, wa can move on the matter immediatelyc