Attached is the Example assignment than the 7 questions, I am having trouble setting up any of these "tables they have on the example? So far I have done this maybe you could add some tables and information to my answer I just can't really think of anything more ( not looking for 7+ pages just maybe 1-2 with some tables to help me complete this. I never learned excel so I am having trouble in word to set up any "Account' Table usually i use "connect" which has tool for it.

Thank you will Rate helpful right away!

S6-3 Researching Cost of Operating Vending Machines, Performing Cost-Volume-Profit Analysis, Multiproduct CVP 4 LO 6-1, 1 6-6 Suppose you have decided to start a small business selling snacks from vending machines. You have secured a location for one candy vending machine in a local bookstore. Rental for the space will cost $200 per month. Vending machines can be purchased at wholesale clubs such as Sam's Club and Costco. You can also purchase the snacks to stock the machines in bulk there. Required: 1. Either visit a local warehouse club or review its website to determine the initial cost to purchase a snack vending machine. 2. Assume you are initially going to have only one type of snack bar in your machine. What type of snack bar will you choose? If you purchase the bars in bulk, what is your cost per bar? 3. How much will you charge for each bar sold? 4. What is your contribution margin per bar? How many bars must you sell to cover the cost of the vending machine? 5. When you have covered the initial investment, what will the monthly break-even point be in number of bars and in sales dollars? 6. Repeat requirements 2 through 5 assuming you decided to have a drink vending machine instead of a snack machine. Remember to find the price for a beverage vending machine. You may assume rental for the vending machine space is $200 per month regardless of its type. 7. Assume your machine can accommodate more than one product, for example, a snack machine that can dispense both chips Page 300 and candy bars or a drink machine that offers both soda and water. Repeat requirements 2 through 5 assuming you have decided to offer two products. The products should have different prices, variable costs, and contribution margins. Perform the Page 301 analyses for three levels of sales mix: 50/50, 30/70, and 70/30.