Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 402 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Accounting Posted 06 Aug 2017 My Price 13.00

Beasley Company

Spreadsheet Assignment Mastering Excel

Beasley Company makes three types of exercise machines. Data have been accumulated for four possible overhead drivers. Data for these four possible drivers are shown in rows 3 to 7 of the following spreadsheet.

Required

Construct a spreadsheet that will allocate overhead and calculate unit cost for each of these alternative drivers. A screen capture of the spreadsheet and data follows.

Spreadsheet Tips

  1. This spreadsheet uses a function called vertical lookup. This function can pull the appropriate values from a table. The form of this function is 5VLOOKUP (value, table, column#). In this example, the table is in cells B4 to K7. Three examples of the use of VLOOKUP follow.

  2. Cell C15 is 5VLOOKUP (B15, B4:K7, 2). This function operates by using the one (1) in cell B15 to look up a value in the table. Notice that the table is defined as B4:K7 and that the function is looking up the value in the second column, which is Units.

  3. Cell E15 is 5VLOOKUP (B15, B4:K7, 10). In this case, the function is looking up the value in the tenth column, which is 45,000. Be sure to count empty columns.

  4. Cell E20 is 5VLOOKUP (B15, B4:K7, 4)*G15. In this case, the function is looking up the value in the fourth column, which is $10,000. Be sure to count empty columns.

  5. Cells I15, G20, and I20 also use the VLOOKUP function.

  6. After completing the spreadsheet, you can change the value in cell B15 (1-4) to see the effect of choosing a different driver for overhead.

Answers

Maurice Tutor
(5)
Status NEW Posted 06 Aug 2017 09:08 PM My Price 13.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)