Linkoln company inventory BUS 511 CASE 2 CPA BEC S3 A production supervisor for Linkoln Company is comparing his budget to actuals for inventory components in May. He has asked you to prepare two documents which will be sent to the division finance officer. The first is a cost of goods manufactured statement which will require you to derive the individual components of total manufacturing costs. The second is a one-page analysis document which will highlight specific sensitivities and relative comparison points. Using the information included within the exhibit, complete the table below for the month ended May, Year 6.
• For Part I, calculate the required costs identified in column A, and enter your associated response rounded to whole numbers in column B. If a response is zero, enter a zero (0).
• For Part II, use the option list provided and enter your response in column B for each situation. AB 1 2 3 PART I Cost Item Amount Raw materials used 1 Direct labor Overhead applied 4 5 1 2 3 4 5 6 7 AB AB PART II Situation Answer Relative to raw materials used, raw materials purchased are: Relative to cost of goods sold, cost of goods manufactured is: If labor hours budgeted were 21,000 hours, cost of goods sold would be: If actual labor hours were 20,200, manufacturing costs would be: If ending finished goods inventory totaled 68,450, the impact on cost of goods manufactured would be:
Allocation of Cost of service departments using Direct method. | |||||
From | Maintenance | Personnel | Printing | Developing | |
Service Department costs | $ 3,000.00 | $ 13,000.00 | $ 14,100.00 | $ 11,200.00 | |
Maintenance allocation | $ (3,000.00) | $ 750.00 | $ 2,250.00 | ||
Personnel allocation | $ (13,000.00) | $ 1,625.00 | $ 11,375.00 | ||
Totals | $ - | $ - | $ 16,475.00 | $ 24,825.00 | |
Workings : | |||||
Maintenance allocation | |||||
Printing : $3000 * 1700 /(1700+5100) | $ 750.00 | ||||
Developing : $3000 * 5100 /(1700+5100) | $ 2,250.00 | ||||
Personnel allocation | |||||
Printing : $13000*500/(500+3500) | $ 1,625.00 | ||||
Developing : $13000*3500/(500+3500) | $ 11,375.00 |
Linkoln company inventory BUS 511 CASE 2 CPA BEC S3 A production supervisor for Linkoln Company...
Babb Company is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year: Beginning Balance Ending Balance Raw materials $ 11,100 $ 15,700 Work in process $ 32,200 $ 14,100 Finished goods $ 101,000 $ 120,000 The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 17,700 machine-hours and incur...
Babb Company is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year: Beginning Balance Ending Balance Raw materials $ 11,000 $ 15,400 Work in process $ 32,300 $ 14,000 Finished goods $ 102,000 $ 125,000 The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 17,100 machine-hours and incur...
Bakerston Company is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year Raw materials Work in process Finished goods $ 11,700 32,000 $107,000 $ 15,200 $ 14,300 The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 17,300 machine-hours and incur $276,800 in manufacturing overhead cost. The following transactions were...
Raw materials inventory, beginning of year $21,000 Raw materials inventory, end of year 23,000 Work in process inventory, beginning of year 55,000 Work in process inventory, end of year 52,000 Finished goods inventory, beginning of year 42,000 Finished goods inventory, end of year 48,000 Raw materials purchased 110,000 Indirect Materials used 6,000 Indirect Labor used 33,000 Direct Labor used 210,000 Depreciation on Factory Machines 22,000 Amount spent on other manufacturing overhead 90,000 Direct labor hours used 15,000 Predetermined overhead rate ...
The following information is available for Tomlin Company. Raw materials inventory Work in process inventory April 1 $10,400 5,290 April 30 $13,800 3,340 Materials purchased in April Direct labor in April Manufacturing overhead in April $98,200 79,700 160,000 Prepare the cost of goods manufactured schedule for the month of April. TOMLIN COMPANY Cost of Goods Manufactured Schedule For the Month Ended April 30 Work in process, April 1 5,290 Direct Materials Raw Materials, April 1 10,400 Raw Materials Purchases 98,200...
StoSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $28,100 21.900 79,900 Ending Inventory $25,600 46,800 68,500 Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling general, and administrative expenses Sales revenue 40,500 1,900 62,900 35.200 23,200 236,500 Required: 1. Based on the above information, prepare a cost of...
Bakerston Company is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year: Raw materials Work in process Finished goods Beginning Balance $ 11,600 $ 32,600 $102,000 Ending Balance $ 15,900 $ 14,300 $125,000 The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 17,400 machine-hours and incur $261,000 in manufacturing...
An analysis of the accounts of Coronado Company reveals the following manufacturing cost data for the month ended September 30, 2020.InventoriesBeginningEndingRaw materials$ 14,000$ 13,300Work in process9,5007,000Finished goods12,00014,000Costs incurred: raw materials purchases $ 64,500, direct labor $ 53,000, manufacturing overhead $ 37,650. The specific overhead costs were: indirect labor $ 8,500, factory insurance $ 7,000, machinery depreciation $ 8,000, machinery repairs $ 4,800, factory utilities $ 5,600, miscellaneous factory costs $ 3,750. Assume that all raw materials used were direct materials.(a)Prepare the cost of goods manufactured schedule for the month ended September 30, 2020.Coronado Co.Cost of Goods Manufacturing Schedulechoose...
The following cost and inventory data are taken from the accounting records of Mason Company for the year just completed: Costs incurred: Direct labor cost $ 80,000 Purchases of raw materials $ 137,000 Manufacturing overhead $ 204,000 Advertising expense $ 49,000 Sales salaries $ 104,000 Depreciation, office equipment $ 225,000 Beginning of the Year End of the Year Inventories: Raw materials $ 8,200 $ 10,300 Work in process $...
The following cost data relate to the manufacturing activities of Black Company during the just completed year: Manufacturing overhead costs incurred: Property taxes, factory $ 3,000 Utilities, factory 4,900 Indirect labor 9,900 Depreciation, factory 24,000 Insurance, factory 5,900 Total actual manufacturing overhead costs $47,700 Other costs incurred: Purchases of raw materials $32,100 Direct labor cost $39,200 Inventories: Raw materials, beginning $ 8,400 Raw materials, ending $ 6,500 Work in process, beginning $ 5,500 Work in process, ending $ 7,000 The...