a) Set up a new spreadsheet to calculate the profit made (or lost) on the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a) Set up a new spreadsheet to calculate the profit made (or lost) on the following inventory: gold floor lamps, blue armchairs, wood side tables, and glass coffee tables. Use the data below as a starting point. Hint: Profit= total revenue - total cost. What columns do you need to add to your spreadsheet to calculate the total cost and total revenue (and therefore profit) for each item? Item Gold Floor Lamp Blue Armchair Wood Side Table Glass Coffee Table Cost per Item $20.00 $55.00 $8.00 $85.00 Quantity at Beginning of March 25 16 44 35 Price in March Number Sold in March $35.00 $105.00 $25.00 $95.00 14 7 40 4 CLOSE a) Set up a new spreadsheet to calculate the profit made (or lost) on the following inventory: gold floor lamps, blue armchairs, wood side tables, and glass coffee tables. Use the data below as a starting point. Hint: Profit= total revenue - total cost. What columns do you need to add to your spreadsheet to calculate the total cost and total revenue (and therefore profit) for each item? Item Gold Floor Lamp Blue Armchair Wood Side Table Glass Coffee Table Cost per Item $20.00 $55.00 $8.00 $85.00 Quantity at Beginning of March 25 16 44 35 Price in March Number Sold in March $35.00 $105.00 $25.00 $95.00 14 7 40 4 CLOSE
Expert Answer:
Answer rating: 100% (QA)
To set up a spreadsheet to calculate the profit made or lost on the inventory you will need to add t... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Payroll Assignment - (50 Marks) The following employees are working in the ABC Clinic, they are paid biweekly. Calculate the gross income, net income, and the total remittance that ABC is to report...
-
What major competencies should Genexis maintain and develop to grow in its current market? What strategic alliances, if any, should Genexis create to establish its VAN or service supply network?
-
Data on x = representative age and y = 6-minute walk time for boys were given in Exercise 5.29. Compute the values of se and r2 for these data. What do these values tell you about the fit of the...
-
Citizens Medical Centre, a hospital in Victoria, Texas, recently instituted a new hiring policy that bans job applicants from employment for being overweight. The new policy states that the hospital...
-
Jarvene Corporation uses the FIFO method in its process costing system. The following data are for the most recent month of operations in one of the company's processing departments: The cost of...
-
A firm produces output according to the production function Q = K1/2 1/2. The demand schedule for the output is P= 20 - Q. If K is fixed at 4 units, what is this firm's short-run demand curve for...
-
Pet Emporium had a robbery on the weekend in which a large amount of inventory was taken. The loss is covered completely by insurance. A physical inventory count determined that the cost of the...
-
Research the types of cloud virtualization vendors and list their pros and cons. Choose which vendor you would use if you were over a cloud network and why.
-
Identify how the discount charged for discounting notes is reported on the income statement. Deducted from income from opertaions. in the other income and expenses section. as a nonoperating expense....
-
Why is knowing the market is very important when investigating a business one show interest in buying?
-
COOLDOWN Company has an initial fund of $8 million. The company has identified good investment opportunities to invest $5 million now at an average rate of return of 50 per cent. The expected market...
-
Briefly outline the process you established for reporting payroll according to statutory requirements incorporated in the organisational policies and procedures for this task.
-
What is the total weight of the slab in problem 7 in lb and the weight in psf (lb/ft2), if reinforced concrete has a unit weight of 150 pcf (lb/ft3)
-
A block of mass m slides upward along a frictionless incline of length D and angle of inclination 0. While on the incline the block encounters a force of air resistance given by F. = kw The block...
-
Repeat the previous problem, but close the positions on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify...
-
Refer PB1-1. Accounts Payable.. $ 33,130 Accounts Receivable.. 9,500 Cash. 13,900 Common Stock 10,000 Dividends.. 1,100 Equipment... 86,000 Notes Payable.. 51,220 Operating Expenses. 60,000 Other...
-
Explain why stockholders equity is increased by revenues and decreased by expenses.
-
Robin Harrington established Time Definite Delivery on January 1. The following transactions occurred during the companys most recent quarter. a. Issued common stock for $ 80,000. b. Provided...
-
What other deductions might be made from gross pay by an employer?
-
Write down what you think would be good definitions for the term 'wage' and the term 'salary'.
-
Why do you think this development occurred?
Study smarter with the SolutionInn App