Question: 8. Answer the following questions: ( 2 points for each question) 1-Merge and center City Electronics Company across D to F. 2-Merge and Center Sales

8. Answer the following questions: ( 2 points for each question) 1-Merge and center "City Electronics Company" across D to F. 2-Merge and Center "Sales Report for the month of June" across columns D to F. 3-Determine the sales revenue for ("Quantity * Sales Price) for each item starting with iPhone in cell DS and down. 4-Determine the COGS for each item item ("Quantity * Unit Cost) starting with iphone in cell F8 and down. 5-Determine the gross profit for each item item (-Sales Revenue - COGS) starting with iphone in cell Gs and down. 6-Find the total Sales Revenue using the SUM function in cell D1S. 7.Find the total COGS using the SUM function in cell F15. B-Determine the Gross Profit in cell G15 (-5ales Revenue-COGS) 9-Enter the total expenses of $16,000 in H15. 10-Determine the net income in cell 115 (=Gross Profit - Total Expenses) 11-Find the product that gives the highest Gross Profit using an Excel function, 12 Find the product that gives the lowest Gross Profit using an Excel function. 13-Find the average Gross Profit for all products using an Excel function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Answer the following questions: ( 2 points for each question) 1-Merge and center "City Electronics Company" across D to F. 2-Merge and Center "Sales Report for the month of June" across columns D to...

Following is the sales's report for City Electornics Company City Electronics Company Sales Report for the month of June 8 Answer the following questions: (2 points for each question) 9 1-Merge and...

Flexible Budget l'erformance Report Project Kelscy's Frozen Confectionarica buys and distributes singlo-scrve ice cream treats, popsicles, etc., such as those sold at convenience stores, sporting...

BUS 616 Summer, 2015 Final Exam Answer the following questions based on the 2014 annual report of the Walt Disney Company (Disney). A link to the annual report is provided with the posting of this...

ead the Harvard case study on Procter and Gamble. Then, answer the following questions. 1. What is business analytics? Why is it important to make real-time decisions at P&G? What are the benefits of...

1)Financial Reporting - The Procter & Gamble The financial statements of P&G are presented in Appendix B. The companys complete annual report, including the notes to the financial statements, can be...

Refer to the 2013 annual report of JB Hi-Fi Limited on its website, ww.jbhifi.com.au, and answer the following questions: 1. List the subsidiary companies in the JB Hi-Fi Group. 2. What is the value...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

I noticed there are existing papers available, however could I get a new paper? Appendix A: The Home Depot, Inc. Annual Report in Fundamentals of Financial Accounting Write a 1,050- to 1,750-word...

Please answer the following questions after reading Lectures 3,4 and 5: 1. Please list, describe and explain each one of the five major types of taxes as discussed in Lectures 3,4, and 5: What is the...

Solve Using Shooting Method Estimate y at x = 0.1 using the Euler method with the step size of 0.1 where y(0) = 2 and y(0.3) = 3. dy dt t + y = 0

The following information pertains to Concord Video Company. 1. Cash balance per bank, July 31, $8,143. 2. July bank service charge not recorded by the depositor $34. 3. Cash balance per books, July...

Give a geometric description of the set of points whose coordinates satisfy the given conditions. x = 2 , z = 6 A . The line through the point ( 2 , 6 , 0 ) and parallel to the z - axis B . All...

Summary of Haier Group: Reinventing the Industrial Corporation ( Case 1 4 OF Textbook; pp 4 9 0 )

Every time a credit card company sends our bill late with barely enough time for us to make our payment without incurring late charges and we dont threaten to cut up our card if the practice...

Every time were served restaurant food that is too salty, overcooked, too tough, or whatever, and we dont say anything, the restaurant has no way of knowing its food is substandard or that the new...

Every time we receive shoddy luggage service at a hotel and the bellhop sticks a hand out for a tip and we give the bellhop money, were telling the bellhop that tips arent connected to the service...