Is a vending machine a good investment?

User Generated

terlrlrqivkra

Other

Overview

You work for Winnie Widget, the president of Acme Widget Company. Acme is a small but growing company that has 26 current employees. The company is housed in an old factory building with several other small- and medium-sized companies. The area around Acme is very industrial and there are not many places to eat nearby. A number of employees have asked Ms. Widget to install vending machines in the office. Ms. Widget wants to keep employees happy but also wants to keep costs low. She needs your help. She has asked you to analyze the situation using a spreadsheet and to write up a memo in which you present the options and make a recommendation.

Directions

Begin by consulting the relevant documents in the Project resources, including the employee survey and the brochures from two vending companies. Define the problem as precisely as you can and formulate the question you want to answer. Then, brainstorm possible solutions to the problem.

• the number of employees who want each machine.
• the average purchases per day for those who responded “Yes.”
• the monthly costs to Acme for each option.
• the monthly cost for employees for each option.
• the total monthly cost (Acme cost + employee cost) for each option.

Use the spreadsheet to perform the required calculations. Do not perform calculations yourself (on paper, with a calculator, etc.). Make sure to use the following formulas and functions at least once:

• SUM
• AVERAGE
• PRODUCT or multiplication
• QUOTIENT or division
• COUNTIF or COUNTA
• IF

After you have finished the spreadsheet, answer the following questions, which are included at the bottom of the spreadsheet:

• Why is it useful to use formulas in this scenario?
• Which formula did you find most useful or hardest to use, and why?

This spreadsheet will be submitted as one of two deliverables for this Project.

Part 2: Memo

Flesh out the details of your top three solutions that you think you will present in your memo. Note the advantages and drawbacks associated with each solution. Remember there are nonmonetary considerations as well. You can certainly use your own real-world knowledge in coming up with solutions, but be sure to work within the framework of the information provided.

Analyze your top three solutions, and decide which one is best and the key reasons why. Then, write a business memo to Winnie Widget. Your memo should:

• briefly explain the situation.
• explain three feasible solutions.
• identify the best solution and explain why it is best.
• be written in standard format (see the Business Memo Purpose and Format resource in the Project resources).http://cfaresources.s3.amazonaws.com/AA%20General%...
• use appropriate language for its purpose (see Audience and Purpose resource in the Project resource).
• be free of spelling and grammar mistakes.
http://cfaresources.s3.amazonaws.com/AA%20General%..

Unformatted Attachment Preview

ACME WIDGET EMPLOYEE SURVEY Soda Employee machine Barry Bonds no Celia Cruz yes Felix Frankfurter no Izzy Isaacs yes Lisa Ling no Mary Martin yes Nick Nolte no Robin Roberts no Tom Thompson yes Ursula Upton yes Winnie Widget no Zinnia Zinn no Amy Adams yes Doris Day no Emilio Estavez yes George Garcia no Henry Higgins yes Janet Jackson no Kevin Kline no Ophelia O'Brian yes Paula Poundstone yes Quenella Quincy yes Sylvester Strange yes Vince Vaughan yes Xavier Xerxes yes Yolanda Young yes Average sodas per week for "yes" answers: Total number of sodas per week Total number of employees who want soda machine: Constants Number of work weeks per month Average number of sodas per "yes" employee per month Average number of snacks per "yes" employee per month 4 Sodas per week Snack machine no yes no no yes no no no no no no no yes yes yes yes yes no yes yes yes yes yes yes yes yes 5 10 1 5 4 10 5 2 3 3 10 2 6 1 8 Total number of employees who want snack machine: Total number of snacks per month Total number of sodas per month Vendor Queen Sodas Snacks Costs for Acme Installment Cost per drink (for Acme) Installment Cost per snack (for Acme) Total cost per month Total cost per month Costs for "yes" employees Cost per drink Cost per snack Average cost per employee per month Total cost to employees per month Average cost per employee per month Total cost to employees per month Superior Sodas and More (less than 50) Sodas Cost for Acme Installment Cost per drink (for Acme) Total cost per month Snacks Installment Cost per snacks (for Acme) Costs of snack per month Income per snack Total monthly income from snack sales Total cost per month for Acme (installment - total monthly income from snack sales) Costs for "yes" employees Cost per drink Cost per snack Average cost per employee per month Total cost to employees per month Average cost per employee per month Total cost to employees per month Superior Sodas and More (more than 50) Sodas Cost for Acme Installment Cost per drink (for Acme) Installment Cost per snack (for Acme) Total cost per month Total cost per month Snacks Costs for "yes" employees Cost per drink Cost per snack Average cost per employee per month Average cost per employee per month Total cost per month Total cost per month 1. Why is it useful to use formulas in this situation? 2. Which formula did you find hardest to use and why? Which was most useful and why? © Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. Snacks per week Comments 1 3 bring my lunch refrigerator coffeemaker refrigerator 4 5 refrigerator 2 3 4 3 2 5 6 7 5 coffeemaker 5 5 Average snacks per week for "yes" answers: Total number of snacks per week Snacks Costs for Acme Costs for "yes" employees Snacks Cost for Acme Costs for "yes" employees Snacks Cost for Acme Costs per "yes" employees eserved. 0 0 0 0 0 0 0 0 0 0 0 0
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

please find the attached files. i look forward to working with you again. good bye

1

Vending Machines
Institution
Course
Tutor
Date

VENDING MACHINES

2

To: Winnie Widget, the president of Acme Widget Company
From: Financial analyst
Subject: Vending machines
Date: 27th March 2019
This memo is to bring to your attention that indeed buying vending machines is beneficial
for the company. There are fifteen employees willing to take soda and snack machines. On
weekly basis, this translates to seventy five sodas sold and sixty snacks. At t...

Review

Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4