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?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd