Format spreadsheets effectively, and use the spreadsheets to analyze data. Be sure to hand in any spreadsheets, graphs, and calculations along with your responses to your teacher.
1. Read the following data regarding payroll deductions, and answer the questions that follow:
Lydia: $9.50/hour, worked 20 hours this pay period
Thomas: $12.50/hour, worked 40 hours this pay period
Bruce: $8.50/hour, worked 30 hours this pay period
a) Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings. (2 points)
b) Add a "Tax (%)" column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who make $9.00 or less an hour, the rate is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the rate is 7%. (3 points)
c) Describe how you generated this column. (1 point)
2. Read the following data from Maria's personal monthly bank statement and answer the questions that follow:
Rent: $850
Groceries: $276.89
Public transportation: $45
Utilities: $135.24
Entertainment: $150.26
a) Enter Maria's data into a spreadsheet using a spreadsheet program. Be sure to include proper headings (2 points).
b) Maria would like an efficient way to analyze how she spent her money this month. Using the spreadsheet program, create a bar graph representation of her monthly expenses. Briefly describe how you create the bar graph (3 points).
c) Based on the bar graph representation, what is one thing you would recommend to Maria in the future? (1 point)
3. Read the following data from Wesley Publishing and answer the questions that follow:
Author: Henry Stratford; Author ID: 8945; Book sales: $2,862.26
Author: Carrie Berkshaw; Author ID: 4903; Book sales: $56,234.48
Author: Russel Owens; Author ID: 8321; Book sales: $9,245.67
Author: Finius Menken; Author ID: 7564; Book sales: $27,356.11
a) Enter Wesley Publishing's author revenue data into a profit-and-loss spreadsheet. Be sure to include proper headings. (1 point)
b) Now sort the authors by their ID number in descending order. (1 point)
c) Wesley Publishing earns 10% of each author's book sales. In order to efficiently calculate the company's profit, add a "Percentage" column and lock the cells so that it's standard for each entry. Briefly describe how you locked the cells. (2 points)
d) Add three more rows above row 1 and set up a lookup table to find the book sales total by searching the Author ID. Use Author ID 8321. Include the formula. (2 points)
e) Wesley Publishing has an office in England that would like the American office to share their data on profits. What steps should the American office take in order to determine the profits in pounds for the England office? (2 points)
Answers: 1
Other questions on the subject: Business
Business, 22.06.2019 10:00, dtaylor7755
How has internet access changed and affected globalization from 2003 to 2013? a ten percent increase in internet access has had little effect on globalization. a twenty percent decrease in internet access has had little effect on globalization. a thirty percent increase in internet access has sped up globalization. a fifty percent decrease in internet access has slowed down globalization.
Answers: 1
Business, 22.06.2019 12:50, lily539711
Required information problem 15-1a production costs computed and recorded; reports prepared lo c2, p1, p2, p3, p4 [the following information applies to the questions displayed below. marcelino co.'s march 31 inventory of raw materials is $84,000. raw materials purchases in april are $540,000, and factory payroll cost in april is $364,000. overhead costs incurred in april are: indirect materials, $59,000; indirect labor, $26,000; factory rent, $38,000; factory utilities, $19,000; and factory equipment depreciation, $58,000. the predetermined overhead rate is 50% of direct labor cost. job 306 is sold for $670,000 cash in april. costs of the three jobs worked on in april follow. job 306 job 307 job 308 balances on march 31 direct materials $30,000 $36,000 direct labor 25,000 14,000 applied overhead 12,500 7,000 costs during april direct materials 133,000 210,000 $100,000 direct labor 105,000 150,000 101,000 applied overhead ? ? ? status on april 30 finished (sold) finished in process (unsold) required: 1. determine the total of each production cost incurred for april (direct labor, direct materials, and applied overhead), and the total cost assigned to each job (including the balances from march 31). a-materials purchases (on credit). b-direct materials used in production. c-direct labor paid and assigned to work in process inventory. d-indirect labor paid and assigned to factory overhead. e-overhead costs applied to work in process inventory. f-actual overhead costs incurred, including indirect materials. (factory rent and utilities are paid in cash.) g-transfer of jobs 306 and 307 to finished goods inventory. h-cost of goods sold for job 306. i-revenue from the sale of job 306. j-assignment of any underapplied or overapplied overhead to the cost of goods sold account. (the amount is not material.) 2. prepare journal entries for the month of april to record the above transactions. 3. prepare a schedule of cost of goods manufactured. 4.1 compute gross profit for april. 4.2 show how to present the inventories on the april 30 balance sheet.
Answers: 3
Business, 22.06.2019 21:20, danielahumajova6
In a market economy, supply and demand are important because theya. (i) play a critical role in the allocation of the economy's scarce resources. b. (ii) determine how much of each good gets produced. c. (iii) can be used to predict the impact on the economy of various events and policies. d. all of (i), (ii), and (iii) are correct.
Answers: 3
Business, 22.06.2019 22:00, Suzispangler2264
Miami incorporated estimates that its retained earnings break point (bpre) is $21 million, and its wacc is 13.40 percent if common equity comes from retained earnings. however, if the company issues new stock to raise new common equity, it estimates that its wacc will rise to 13.88 percent. the company is considering the following investment projects: project size irr a $4 million 14.00% b 5 million 15.10 c 4 million 16.20 d 6 million 14.20 e 1 million 13.42 f 6 million 13.75 what is the firm's optimal capital budget?
Answers: 3
You know the right answer?
Format spreadsheets effectively, and use the spreadsheets to analyze data. Be sure to hand in any sp...
Questions in other subjects:
Chemistry, 30.03.2021 03:00
