Explain how to structure worksheet including titles

Assignment Help Basic Computer Science

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

Reference no: EM1358245

Questions Cloud

How much power is dissipated in the cord : when 105 mL of water at 22 C is mixed with 68mL of water at 95 C, what is the final temperature? suppose no heat is lost to the surroundings and density of water is 1 g/mL.

Alternative trade: legacies for the future : explain how Alternative Trade: Legacies for the Future supports or challenges your conceptualizations of trade and development. Are there themes that some of you agree upon? Do you disagree on others? Describe your conversation.

Reasons why there is optimism for continued union success : Show the reasons why there is optimism for continued union success and why do employers resist the formation of unions in their companies? Provide at least four reasons.

Capriati corp-equity securities entries : Journal entries for equity securities for Capriati Corp in 2012, their first year of business, including unrealized gains or losses in 2012:

Explain how to structure worksheet including titles : 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.

Business environment and concepts : Universal Company has made changes in its inventory handling policies that are expected to increase turnover from 7 to 8 times per year.

Functions of a manager from an hr perspective : What are considered to be the functions of the manager from an HR perspective and how good do you think you are at performing these functions?

Diagnostic aspects of the person behavior : Examine the Antisocial Personality Disorder (APD) and indicate 3 diagnostic aspects of this person's behavior.

Idea to award employees merit raises : Merit pay or merit raises is any salary increase awarded to an employee based on his or her individual performance. Merit pay has both advocates and detractors. Which are you?

User Account

All Pages