Is a vending machine a good investment?
Subject
Other
Question Description
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
Part 1: Spreadsheet
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.
Next, complete the Spreadsheet in the Project resources to guide your analysis of the problem and possible solutions. Your spreadsheet should include:
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.