Chapter 6, Problem 64P

B2 A 1 DATE VALUE X✓ fx 2 1 3 9 4 548 56 3835 40468 VALUE B C D E F G H MEASURE Current Date (TODAY) VALUE FORMULA MEASURE VALUE FORMULA Current Time (NOW) #N/A #N/A Use E6 "Problem Date" for green cells in col. E & I Cumulative full days this year #N/A Year to date fraction (YEARFRAC) #N/A Use E6 "Problem Date" for green cells in col. E & I Month to date fraction of year #N/A 10/8/2019 Day of the week #N/A 6 Problem Date 7 Year (YEAR) 8 Date Value Fractional Date Month (MONTH) 9 40468.25 Day (DAY) 10 40468.375 11 40468.625 12 13 14 15 DATE DATA CLEANUP and MANIPULATION End of month Start of month Start of next month First day of the year #N/A #N/A #N/A #N/A #N/A #N/A #N/A TIP: Use custom date format to display as the name of the day (dddd) Name of month Workdays in current month #N/A #N/A 30 workdays (excluding weekends) from today Days between today and 30 workdays from now #N/A #N/A 16 Target $2,000 17 18 DATE REVENUE MONTH DAY OF WEEK Hit Target? MONTH DAY OF WEEK FORMULAS for…

Job 528 was one of the many jobs started and completed during the year. The job required $11,200 in direct materials and 40 hours of direct labor time at a total direct labor cost of $12,600. If the job contained five units and the company billed at 65% above the unit product cost on the job cost sheet, what price per unit would have been charged to the customer?

C2 X✓ fx Σ N A B 1 Product ☑ Order Quantity C D E F G H K L Product ID ✓ Unit Price Gross Sales Formulas for Columns C, D, & E Product Product ID Unit Price 2 Carry-on Suitcase 3 Carry-on Suitcase 4 Bluetooth Headphones 5 Carry-on Suitcase 6 Travel Pillow 7 Travel Umbrella 8 Battery Pack 9 Travel Pillow 10 Travel Pillow 11 Battery Pack 23 #N/A #N/A #N/A Travel Umbrella B07NQKQ19S $12.51 #N/A #N/A #N/A Bluetooth Headphones B01NAJGGA2 $35.39 12 Battery Pack 13 Travel Pillow 14 Bluetooth Headphones 15 Battery Pack 16 Bluetooth Headphones 17 Travel Umbrella 18 Carry-on Suitcase 19 Bluetooth Headphones 20 Travel Umbrella 21 Bluetooth Headphones 22 Travel Umbrella 23 Battery Pack 24 Bluetooth Headphones 25 Carry-on Suitcase 26 Travel Pillow 27 Battery Pack 28 Carry-on Suitcase 29 Carry-on Suitcase 30 Battery Pack 31 Carry-on Suitcase 32 Travel Pillow 33 Bluetooth Headphones 34 Bluetooth Headphones 22226-22 22272122227222432-29 10 9 23 27 27 23 #N/A #N/A #N/A Battery Pack B00Z9QVE4Q $34.98…

General accounting

I need help solving this general accounting question with the proper methodology.

C2 X✓ fx Σ N A B 1 Product ☑ Order Quantity C D E F G H K L Product ID ✓ Unit Price Gross Sales Formulas for Columns C, D, & E Product Product ID Unit Price 2 Carry-on Suitcase 3 Carry-on Suitcase 4 Bluetooth Headphones 5 Carry-on Suitcase 6 Travel Pillow 7 Travel Umbrella 8 Battery Pack 9 Travel Pillow 10 Travel Pillow 11 Battery Pack 23 #N/A #N/A #N/A Travel Umbrella B07NQKQ19S $12.51 #N/A #N/A #N/A Bluetooth Headphones B01NAJGGA2 $35.39 12 Battery Pack 13 Travel Pillow 14 Bluetooth Headphones 15 Battery Pack 16 Bluetooth Headphones 17 Travel Umbrella 18 Carry-on Suitcase 19 Bluetooth Headphones 20 Travel Umbrella 21 Bluetooth Headphones 22 Travel Umbrella 23 Battery Pack 24 Bluetooth Headphones 25 Carry-on Suitcase 26 Travel Pillow 27 Battery Pack 28 Carry-on Suitcase 29 Carry-on Suitcase 30 Battery Pack 31 Carry-on Suitcase 32 Travel Pillow 33 Bluetooth Headphones 34 Bluetooth Headphones 22226-22 22272122227222432-29 10 9 23 27 27 23 #N/A #N/A #N/A Battery Pack B00Z9QVE4Q $34.98…

Can you explain the process for solving this financial accounting question accurately?

Please give me answer with accounting question

EXERCISE 3-5 Treasury Stock Held by Subsidiary LO 8 Pool Company purchased 90% of the outstanding common stock of Spruce Company on December 31, 2019, for cash. At that time the balance sheet of Spruce Company was as follows: Required: Current assets Plant and equipment Land Total assets Liabilities Common stock, $20 par value Other contributed capital Retained earnings Total Less treasury stock at cost, 5,000 shares Total equities $1,050,000 990,000 170,000 $2,210,000 $ 820,000 900,000 440,000 150,000 2,310,000 100,000 $2,210,000 Prepare the elimination entry required for the preparation of a consolidated balance sheet workpa- per on December 31, 2019, assuming: (1) The purchase price of the stock was $1,400,000. Assume that any difference between the book value of net assets and the value implied by the purchase price relates to subsidiary land. (2) The purchase price of the stock was $1,160,000. Assume that the subsidiary land has a fair value of $180,000, and the other assets and…