Reference no: EM1358245
Your brother owns his own company that builds and sells iron tomato cages. He has asked you to create a spreadsheet that will help him calculate the expense associated with selling his tomato cages. Your brother currently has two employees and is considering increasing the hours they both work.
The time it takes to make the three different sizes of a tomato cage is 10 min for a small, 15 min for a medium, and 20 min for a large. Currently his two employees make 50 of each size cage on their 5 hour shift. Your brother would like to increase that number to 100. He needs to know how many more hours he would have to have his two employees work to accomplish this. Respond fully to the following questions regarding this task:
A -Explain how you will structure the worksheet, including the titles, column headings, and formulas to calculate the time it takes to make each size of cage.
B -Employees currently work 5 hours a day. During those 5 hours each employee is given two 10 min coffee breaks and a 30 min lunch break. Describe how you will set up the worksheet to reflect the number of hours available to work on each tomato cage.
C -You want to set up the worksheet to automatically highlight the number of hours needed to build each size of cage to meet the goal. Green for small, blue for medium, and orange for large