Need this preferably done in excel, both assignments, let me know if you have any questions.

Accounting 2 Handouts \\ Assignment 7.1 Handout 1. Job costing and process costing track costs differently. Requirement Would the following companies use job order costing or process costing? 2. For a manufacturer that uses job order costing, there is a correct order that the costs flow through the accounts. Requirement Order the following from 1-4. Item 1 has been completed for you. 3. Gear Packs manufactures backpacks. Its plant records include the following materials-related transactions: Requirements R1. What journal entries record these transactions? R2. Post these transactions to the Materials inventory account. R3. If the company had $35,000 of Materials inventory at the beginning of the period, what is the ending balance of Materials inventory? Accounting 2 Assignment Handout 2011 Pearson Education Page 1 of1 6 4/4/2016 Accounting 2 Handouts \\ 4. Boston Enterprises produces LCD touch screen products. The company reports the following information at December 31, 2010: Boston began operations on January 30, 2010. Requirements R1. What is the cost of direct materials used? The cost of indirect materials used? R2. What is the cost of direct labor? The cost of indirect labor? 5. Evergreen Furniture manufactures wood patio furniture. The company reports the following costs for June 2011: Requirement What is the balance in the Manufacturing overhead account? 6. Job 303 includes a direct materials cost of $470 and direct labor costs of $350. Requirement If the manufacturing overhead allocation rate is 60% of direct labor cost, what is the total cost assigned to Job 303? Accounting 2 Assignment Handout 2011 Pearson Education Page 2 of2 6 4/4/2016 Accounting 2 Handouts \\ 7. Refer to the data in exercise 4. Requirements R1. What is the actual manufacturing overhead of Boston Enterprises? R2. What is the allocated manufacturing overhead? R3. Is manufacturing overhead underallocated or overallocated? By how much? 8. The T-account showing the manufacturing overhead activity for Edith, Corp., for 2011 is as follows: Requirements R1. What is the actual manufacturing overhead? R2. What is the allocated manufacturing overhead? R3. What is the predetermined manufacturing overhead rate as a percentage of direct labor cost, if actual direct labor costs were $170,000? R4. Is manufacturing overhead underallocated or overallocated? By how much? R5. Is Cost of goods sold too high or too low? 9. Refer to the data in exercise 8. Requirement R1. Journalize the entry to close out the company's Manufacturing overhead account. 10. Blake Advertising pays Amanda Hilton $108,000 per year. Hilton works 2,000 hours per year. Requirements R1. What is the hourly cost to Blake Advertising of employing Hilton? R2. What direct labor cost would be traced to client 507 if Hilton works 18 hours to prepare client 507's magazine ad? 11. Consider the following incomplete statements. Accounting 2 Assignment Handout 2011 Pearson Education Page 3 of3 6 4/4/2016 Accounting 2 Handouts \\ Requirement Complete each of the statements with the term job order costing or the term process costing. 12. Great Quality Trailers' job cost records yielded the following information: Requirement Using the dates above to identify the status of each job, compute Great Quality 's cost of (a) Work in process inventory at May 31, (b) Finished goods inventory at May 31, and (c) Cost of goods sold for May. 13. Consider the following transactions for Sleek's Furniture: Requirement Journalize the transactions in Sleek's general journal. Accounting 2 Assignment Handout 2011 Pearson Education Page 4 of4 6 4/4/2016 Accounting 2 Handouts \\ Accounting 2 Assignment Handout 2011 Pearson Education Page 5 of5 6 4/4/2016 Accounting 2 Handouts \\ 14. Simms Realtors, a real estate consulting firm, specializes in advising companies on potential new plant sites. The company uses a job order costing system with a predetermined indirect cost allocation rate, computed as a percentage of direct labor costs. At the beginning of 2011, managing partner Debra Simms prepared the following budget for the year: Maynard Manufacturing, Inc., is inviting several consultants to bid for work. Debra Simms estimates that this job will require about 260 direct labor hours. Requirements R1. Compute Simms Realtors' (a) hourly direct labor cost rate and (b) indirect cost allocation rate. R2. Compute the predicted cost of the Maynard Manufacturing job. R3. If Simms wants to earn a profit that equals 55% of the job's cost, how much should she bid for the Maynard Manufacturing job? Accounting 2 Assignment Handout 2011 Pearson Education Page 6 of6 6 4/4/2016 Accounting 2 Handouts Assignment 7.2 Handout 1. Sherborn Construction, Inc., is a home builder in New Mexico. Sherborn uses a job order costing system in which each house is a job. Because it constructs houses, the company uses accounts titled Construction wages and Construction overhead. The following events occurred during August: Requirements R1. Record the events in the general journal. R2. Open T-accounts for Work in process inventory and Finished goods inventory. Post the appropriate entries to these accounts, identifying each entry by letter. Determine the ending account balances, assuming that the beginning balances were zero. R3. Add the costs of the unfinished houses, and show that this total amount equals the ending balance in the Work in process inventory account. R4. Add the cost of the completed house that has not yet been sold, and show that this equals the ending balance in Finished goods inventory. R5. Compute gross profit on the house that was sold. What costs must gross profit cover for Sherborn Construction? Accounting 2 Assignment Handout 2011 Pearson Education Page 1 of1 5 4/4/2016 Accounting 2 Handouts 2. Classic Technology, Co., manufactures CDs and DVDs for computer software and entertainment companies. Classic uses job order costing and has a perpetual inventory system. On November 2, Classic began production of 5,100 DVDs, Job 423, for Cheetah Pictures for $1.30 each. Classic promised to deliver the DVDs to Cheetah by November 5. Classic incurred the following costs: Classic Technology allocates manufacturing overhead to jobs based on the relation between estimated overhead ($520,000) and estimated direct labor costs ($450,000). Job 423 was completed and shipped on November 3. Requirements R1. Prepare a job cost record similar to the following example for Job 423. Calculate the predetermined overhead rate; then apply manufacturing overhead to the job. R2. Journalize in summary form the requisition of direct materials and the assignment of direct labor and manufacturing overhead to Job 423. R3. Journalize completion of the job and the sale of the 5,100 DVDs. Accounting 2 Assignment Handout 2011 Pearson Education Page 2 of2 5 4/4/2016 Accounting 2 Handouts Accounting 2 Assignment Handout 2011 Pearson Education Page 3 of3 5 4/4/2016 Accounting 2 Handouts 3. Robin Design, Inc., is a Web site design and consulting firm. The firm uses a job order costing system, in which each client is a different job. Robin Design traces direct labor, licensing costs, and travel costs directly to each job. It allocates indirect costs to jobs based on a predetermined indirect cost allocation rate, computed as a percentage of direct labor costs. At the beginning of 2011, managing partner Judi Jacquin prepared the following budget: In November 2011, Robin Design served several clients. Records for two clients appear here: Requirements R1. Compute Robin Design's predetermined indirect cost allocation rate for 2011. R2. Compute the total cost of each job. R3. If Jacquin wants to earn profits equal to 20% of service revenue, how much (what fee) should she charge each of these two clients? R4. Why does Robin Design assign costs to jobs? Accounting 2 Assignment Handout 2011 Pearson Education Page 4 of4 5 4/4/2016 Accounting 2 Handouts Decision Case Nature's Own manufactures organic fruit preserves sold primarily through health food stores and on the Web. The company closes for two weeks each December to enable employees to spend time with their families over the holiday season. Nature's Own's manufacturing overhead is mostly straight-line depreciation on its plant and air-conditioning costs for keeping the berries cool during the summer months. The company uses direct labor hours as the manufacturing overhead allocation base. President Cynthia Ortega has just approved new accounting software and is telling Controller Jack Strong about her decision. \"I think this new software will be great,\" Ortega says. \"It will save you time in preparing all those reports.\" \"Yes, and having so much more information just a click away will help us make better decisions and help control costs,\" replies Strong. \"We need to consider how we can use the new system to improve our business practices.\" \"And I know just where to start,\" says Ortega. \"You complain each year about having to predict the weather months in advance for estimating air-conditioning costs and direct labor hours for the denominator of the predetermined manufacturing overhead rate, when professional meteorologists can't even get tomorrow's forecast right! I think we should calculate the predetermined overhead rate on a monthly basis.\" Controller Strong is not so sure this is a good idea. Requirements R1. What are the advantages and disadvantages of Ortega's proposal? R2. Should Nature's Own compute its predetermined manufacturing overhead rate on an annual basis or monthly basis? Explain. Accounting 2 Assignment Handout 2011 Pearson Education Page 5 of5 5 4/4/2016