Assignment 4 Do P17-368 Due Date: June 21 (Monday) Bonus Points: Up to 10 You are required to use spreadsheet to do the assignment, save it as A Your Name, and submit it by the due date. Assignment solutions will be provided right after the due date. Turn in assignment on time to earn bonus points. Handwritten assignment and late assignment will earn no points P17-30A is similar and its solution is in the workbook Chapter 17 Job Order Costing which can be downloaded by clicking Chapter 17 Summary in the Course Content folder. P17-36B Accounting for transactions, construction company Meadow Construction, Inc. is a home builder in Arizona, Meadow uscs a job order costing system in which each house is a job. Because it constructs houses, the com- pany wies an account titled Construction Overhead. The company applies overhead based on estimated direct labor costs. For the year, it estimated construction over head of $1,150,000 and total direct labor costs of $5,750. The following events recurred during Augs Purchased material on account, $450,000 1. Requisitioned direct materials and used direct labor in construction. Recorded the materials requisitioned . Direct Materials Direct Labor House 402 $ 52,000 $ 47,000 House 403 67.000 36,000 House 404 63.000 54.000 House 405 88.000 52,000 c. The company locurred totales of $240,000: Use the data from em bo on the got yet paid d. Depreciation of costruction equipament. $4.300 e. Other overhead costs incurred. Equipment rentals pudin cush, S1000, Worker lability insurance expired, 55.000 Allocated on the toys HOU Opened: 402 404 h. House sold on account. 464 for $250,000 Requirements 1. Calculate Meadow predetermined overcadalocation rate for the year 2. Prepare journal carries to record the events in the general journal 3. Open accounts for Work in Process lovestory and Finished Goods Inventory Nou the appropriate entries to the accounts, identifying each entry by lent Determine the coding account balance, suming that the beginning blince WER 4. Add the cms of the unfinished home and show that this to mount was the ending balance in the Work in Process Inventory count Add the cost of the completed house that has not yet been sold and show that this quals the ending bace in Pined Goods live 6 Compte gros profit on the house that was old. What costs must grouproti CON Meadow Costruction CHAPTER 1 JOS ONDER COSTINO Home Draw Page Layout Formas Data Vw Acrobat hiline CB -A A . de 0 MW MO www OA WE E 6% -5 CS 3 VEL WY 30 IN HOS ww WOOD H www 1 TE 10 11 WERE TI We 21 Over " !!,!,!! w ro Home Insert Draw CHAPTER 17 JOB Page Layout Formulas Data Review View Acrobat Tell me o Calibr (Body) 11 X out Da Copy Forma == Paste 33 Wrap Text General BIU AA = = = Merge Center $ %) R17 all-23 for Conditional Formatting as A c D 2 MOH LP17A 1 1 CH Allocation Rate 1 COGS 1.24 264504 21046 29 21500 50000 45000 9250 11000 29646 4 The anal maturing overhead roles Managed to make deithroughout the period Accountant predetermined overhead to toe maraductormation when there today 12 13 14 16 18 - 19 20 21 22 23 20 25 26 22 20 30 31 32 25 35 36 27 40 41 4