Mid-Life Motorcycles (MLM) is a small shop that builds customized motorcycles, mostly for middle-aged men with significant discretionary income who are hoping to fulfill a high-school dream. Since it works with high-end clients, all of its work is custom and it makes many of the bike parts used, including frames, in-house. Other parts, such as the engine, are purchased from outside suppliers and then modified in-house. Although most of the bikes are built to order for a specific individual, the shop occasionally builds a bike with no prearranged buyer. These bikes are sometimes intended to be entered in custom-bike contest and then sold afterwards. The shop has been in existence for 10 years, but for the sake of simplicity, assume it has no beginning inventories for 2019. Five motorcycle restoration projects were worked on during 2019. By the end of the year, four of these projects were complete and three of them had been sold. The following selected data are from MLM's 2019 budget. Advertising Direct materials Direct labor Rent on office space Rent factory space Indirect materials Maintenance costs for factory equipment Utilities costs for office space Utilities costs for factory space Depreciation on factory equipment Machine hours expected to be worked Direct labor hours expected to be worked $ 11,050 201,000 181, 100 9,800 29,400 14,900 5, 100 1,900 4,000 12,000 4,000 6,500 The following information relates to production events during 2019. Raw materials were purchased for $207,500. Materials used in production totaled $200,400, $15,200 of these were considered indirect materials costs. The remaining $185,200 of direct materials costs related to individual motorcycle jobs as follows. Job Number 115 116 117 118 119 Direct Materials Cost $42,400 34,700 41,100 38,800 28, 200 Labor costs incurred for production totaled $176,700. The workers are highly skilled craftsmen who require little supervision. Therefore, all of these costs were considered direct labor costs and related to individual jobs as follows. Job Number 115 116 117 118 119 Direct Labor Cost $39,200 41,100 47,300 29,600 19,500 Paid factory rent of $29,000. Recorded depreciation on factory equipment of $12,500. Made $5,500 of payments to outside vendors for maintenance of factory equipment. Paid factory utilities costs of $4,100. Applied manufacturing overhead using a predetermined rate of $16.35 per machine hour. The 3,720 machine hours that were used relate to each job as follows. Job Number 115 116 117 118 119 Machine Hours Worked 770 820 890 860 380 Completed all jobs except Job 119 and transferred those projects to finished goods. Sold three jobs for the following amounts: Job Number 115 116 117 Sales Price $125,500 117,800 110,600 Closed the Manufacturing Overhead account to transfer any overapplied or underapplied overhead to the Cost of Goods Sold account. Required a. Assume MLM had used direct labor hours (versus machine hours) as its cost driver. Compute its predetermined overhead rate. (Round your answer to 2 decimal places.) b. Determine the ending balance in Raw Materials Inventory. c. Determine the ending balance in Finished Goods Inventory. d. Determine the ending balance in Work in Process Inventory. e. Determine the costs of goods manufactured. f. Determine the amount of Cost of Goods Sold. g. Determine the amount of gross margin that was earned on Jobs 115, 116, and 117. h. Determine the amount of overapplied or underapplied overhead that existed at the end of the year. (For all requirements, round your intermediate calculations to 2 decimal places.) a. Predetermined overhead rate per hour b. Ending balance in Raw materials c. Ending balance in Finished goods inventory d. Ending balance in Work in process inventory e. Cost of goods manufactured f. Cost of goods sold g. Gross margin for job 115 Gross margin for job 116 Gross margin for job 117 h. Over or underapplied overhead
