What document is used to determine the actual amount of direct materials used in production, to be recorded on a job cost sheet?

Problems Prepare the problems below using Excel. Upload the workbook using the link. 1. (10 points) Alake Company is a manufacturing firm that uses job-order costing.The company applies overhead to jobs using a predetermined overhead rate based on direct labor hours. At the beginning of the year, the company estimated manufacturing overhead cost of $218,700 and estimated direct labor hours of 13,500. The following transactions were recorded for the year:  a. Raw materials were requisitioned for use in production, $477,215 ($462,615 direct and $14,600 indirect). b. Depreciation for the year was $112,500, of which $106,100 is related to factory operations, $3,700 is related to sales equipment, and $2,700 is related to administative office equipment. c. Advertising, $112,200. d. The following employee costs were incurred: direct labor, $265,440; indirect labor, $16,300; sales salaries, $48,200; sales commissions, $16,000; and administrative salaries, $52,100. e. Raw materials were purchased, $515,500. f. Factory utility costs, $77,100. g. Manufacturing overhead was applied to jobs using the appropriate allocation base established above for applying overhead. Machine-hours worked for the year were 39,600. The average hourly rate for direct labor was $21.00 per hour. h. The cost of goods manufactured for the year was $972,500. i. Sales for the year totaled $1,244,900 and the costs on the job cost sheets of the goods that were sold totaled $865,100. j. The balance in the Manufacturing Overhead account was closed out to Cost of Goods Sold. Required:  Use the horizontal model spreadsheet to record each of the transactions above (a. through j.). Assume that all transactions with employees, customers, and suppliers were conducted in cash. 2. (8 points) EMD Corporation manufactures two products, Product S and Product W. Product W is of fairly recent origin, having been developed as an attempt to enter a market closely related to that of Product S. Product W is the more complex of the two products, requiring an hour and a quarter of direct labor time per unit to manufacture compared to three quarters of an hour of direct labor time for Product S. Product W is produced on an automated production line. The company estimated it would incur $502,085 in manufacturing overhead costs and produce 9,400 units of Product W and 63,900 units of Product S during the current year. Cost data for materials and direct labor are: Product S Product W Direct materials cost per unit  $              11.00  $              23.10 Direct labor cost per hour  $              11.60  $              14.10 The company’s overhead costs can be attributed to four major activities. These activities and the amount of overhead cost attributable to each for the current year are given below: Activity Cost Pools Estimated Overhead Cost Expected Activity for Product S Expected Activity for Product W Machine setups required  $        197,715                     800                  1,300 Purchase orders issued  $          35,375                     400                     100 Machine-hours required  $        106,140                  3,000                  9,200 Maintenance requests issued  $        162,855                     860                  1,240 Required:  Using the data above and an activity-based costing approach, determine the unit product cost of each product for the current year. Carry unit costs to four decimal places. 3. (8 points) Entin Corporation reported the following data for the month of January: Inventories  Beginning   Ending  Work in process  $          11,100  $            18,300 Raw materials              31,500                35,500 Finished goods              47,900                49,700 Additional information:  Direct labor cost   $            95,900  Manufacturing overhead cost incurred                 67,100  Manufacturing overhead applied to Work in Process                 56,200  Raw materials purchases                 66,500 Required:  a. Prepare a Schedule of Cost of Goods Manufactured in good form with proper labels.  b. Prepare a Schedule of Cost of Goods Sold in good form with proper labels.

Problems Prepare the problems below using Excel. Upload the workbook using the link. 1. (10 points) Alake Company is a manufacturing firm that uses job-order costing.The company applies overhead to jobs using a predetermined overhead rate based on direct labor hours. At the beginning of the year, the company estimated manufacturing overhead cost of $226,800 and estimated direct labor hours of 14,000. The following transactions were recorded for the year:  a. Advertising, $118,800. b. Raw materials were requisitioned for use in production, $542,110 ($525,810 direct and $16,300 indirect). c. Depreciation for the year was $120,500, of which $113,300 is related to factory operations, $4,100 is related to sales equipment, and $3,100 is related to administative office equipment. d. Factory utility costs, $90,400. e. The following employee costs were incurred: direct labor, $267,225; indirect labor, $15,500; sales salaries, $49,800; sales commissions, $14,100; and administrative salaries, $49,600. f. Raw materials were purchased, $441,800. g. Manufacturing overhead was applied to jobs using the appropriate allocation base established above for applying overhead. Machine-hours worked for the year were 36,700. The average hourly rate for direct labor was $21.00 per hour. h. The cost of goods manufactured for the year was $948,200. i. Sales for the year totaled $1,131,700 and the costs on the job cost sheets of the goods that were sold totaled $824,600. j. The balance in the Manufacturing Overhead account was closed out to Cost of Goods Sold. Required:  Use the horizontal model spreadsheet to record each of the transactions above (a. through j.). Assume that all transactions with employees, customers, and suppliers were conducted in cash. 2. (8 points) EMD Corporation manufactures two products, Product S and Product W. Product W is of fairly recent origin, having been developed as an attempt to enter a market closely related to that of Product S. Product W is the more complex of the two products, requiring one and three quarters hours of direct labor time per unit to manufacture compared to three quarters of an hour of direct labor time for Product S. Product W is produced on an automated production line. The company estimated it would incur $499,480 in manufacturing overhead costs and produce 10,900 units of Product W and 59,400 units of Product S during the current year. Cost data for materials and direct labor are: Product S Product W Direct materials cost per unit  $              10.90  $              25.90 Direct labor cost per hour  $              12.80  $              17.10 The company’s overhead costs can be attributed to four major activities. These activities and the amount of overhead cost attributable to each for the current year are given below: Activity Cost Pools Estimated Overhead Cost Expected Activity for Product S Expected Activity for Product W Machine setups required  $        180,405                     800                  1,100 Purchase orders issued  $          54,145                     400                     300 Machine-hours required  $        102,810                  3,000                10,800 Maintenance requests issued  $        162,120                     860                  1,240 Required:  Using the data above and an activity-based costing approach, determine the unit product cost of each product for the current year. Carry unit costs to four decimal places. 3. (8 points) Entin Corporation reported the following data for the month of January: Inventories  Beginning   Ending  Finished goods  $          45,600  $            45,300 Work in process              10,600                17,100 Raw materials              34,800                36,200 Additional information:  Direct labor cost   $            88,400  Raw materials purchases                 65,900  Manufacturing overhead applied to Work in Process                 57,100  Manufacturing overhead cost incurred                 67,900 Required:  a. Prepare a Schedule of Cost of Goods Manufactured in good form with proper labels.  b. Prepare a Schedule of Cost of Goods Sold in good form with proper labels.

Advertisers use the image transfer process in radio advertising in order to

A _____ appeal is used when the advertiser makes either a direct or an indirect comparison to another brand and usually claims superiority on one or more attributes.

Problems Prepare the problems below using Excel. Upload the workbook using the link. 1. (10 points) Alake Company is a manufacturing firm that uses job-order costing.The company applies overhead to jobs using a predetermined overhead rate based on direct labor hours. At the beginning of the year, the company estimated manufacturing overhead cost of $202,500 and estimated direct labor hours of 12,500. The following transactions were recorded for the year:  a. Factory utility costs, $82,600. b. Depreciation for the year was $113,000, of which $105,600 is related to factory operations, $4,400 is related to sales equipment, and $3,000 is related to administative office equipment. c. Raw materials were purchased, $456,400. d. Raw materials were requisitioned for use in production, $512,945 ($496,745 direct and $16,200 indirect). e. The following employee costs were incurred: direct labor, $243,390; indirect labor, $14,500; sales salaries, $51,800; sales commissions, $15,000; and administrative salaries, $59,200. f. Advertising, $128,400. g. Manufacturing overhead was applied to jobs using the appropriate allocation base established above for applying overhead. Machine-hours worked for the year were 40,000. The average hourly rate for direct labor was $21.00 per hour. h. The cost of goods manufactured for the year was $969,200. i. Sales for the year totaled $1,198,900 and the costs on the job cost sheets of the goods that were sold totaled $967,500. j. The balance in the Manufacturing Overhead account was closed out to Cost of Goods Sold. Required:  Use the horizontal model spreadsheet to record each of the transactions above (a. through j.). Assume that all transactions with employees, customers, and suppliers were conducted in cash. 2. (8 points) EMD Corporation manufactures two products, Product S and Product W. Product W is of fairly recent origin, having been developed as an attempt to enter a market closely related to that of Product S. Product W is the more complex of the two products, requiring one and a half hours of direct labor time per unit to manufacture compared to one hour of direct labor time for Product S. Product W is produced on an automated production line. The company estimated it would incur $472,965 in manufacturing overhead costs and produce 9,900 units of Product W and 55,000 units of Product S during the current year. Cost data for materials and direct labor are: Product S Product W Direct materials cost per unit  $              10.50  $              24.10 Direct labor cost per hour  $              11.40  $              16.40 The company’s overhead costs can be attributed to four major activities. These activities and the amount of overhead cost attributable to each for the current year are given below: Activity Cost Pools Estimated Overhead Cost Expected Activity for Product S Expected Activity for Product W Machine setups required  $        189,905                     800                  1,100 Purchase orders issued  $          37,275                     400                     100 Machine-hours required  $        110,505                  3,000                10,900 Maintenance requests issued  $        135,280                     860                  1,040 Required:  Using the data above and an activity-based costing approach, determine the unit product cost of each product for the current year. Carry unit costs to four decimal places. 3. (8 points) Entin Corporation reported the following data for the month of January: Inventories  Beginning   Ending  Work in process  $          10,200  $            18,500 Finished goods              49,400                43,400 Raw materials              32,500                41,000 Additional information:  Direct labor cost   $            85,300  Manufacturing overhead cost incurred                 62,800  Raw materials purchases                 66,700  Manufacturing overhead applied to Work in Process                 55,300 Required:  a. Prepare a Schedule of Cost of Goods Manufactured in good form with proper labels.  b. Prepare a Schedule of Cost of Goods Sold in good form with proper labels.

The residence time of litter on the forest floor increases

Which of the following statements explains why marketers use emotional appeals?

Name the process by which trees conserve nutrients from leaves before they are lost to the ecosystem via litterfall

Which of the following is an advertising execution approach designed to illustrate key advantages of a product by showing it in actual use?