Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2019. Square Feet 500 Direct Expenses $ 15,000 27,000 103,000 13,000 Sales Department Advertising Administrative 700 4,100 4,700 Shoes $124,000 186,000 Clothing The advertising department developed and distributed 190 advertisements during the year. Of these, 38 promoted shoes and 152 promoted clothing. Utilities expense of $74,000 is an indirect expense to all departments. Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $74,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses to the two operating departments on the basis of the number of ads placed that promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on the amount of sales.

Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2019. Square Feet 500 Direct Expenses $ 15,000 27,000 103,000 13,000 Sales Department Advertising Administrative 700 4,100 4,700 Shoes $124,000 186,000 Clothing The advertising department developed and distributed 190 advertisements during the year. Of these, 38 promoted shoes and 152 promoted clothing. Utilities expense of $74,000 is an indirect expense to all departments. Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $74,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses to the two operating departments on the basis of the number of ads placed that promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on the amount of sales.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 30E: A company uses charging rates to allocate service department costs to the using departments. The...

See similar textbooks

Similar questions

A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950
Jansen Company reports the following for its ski department for the year 2019. All of its costs are direct, except as noted. Sales $ 610,000 Cost of goods sold 435,000 Salaries 113,000 ($25,000 is indirect) Utilities 15,600 ($5,700 is indirect) Depreciation 54,400 ($17,400 is indirect) Office expenses 29,600 (all indirect) 1. Prepare a departmental income statement for 2019.2. & 3. Prepare a departmental contribution to overhead report for 2019. Based on these two performance reports, should Jansen eliminate the ski department?
Jansen Company reports the following for its Ski department for the year 2019. All of its costs are direct, except as noted. Sales . $605,000 Cost of goods sold . 425,000 Salaries . 112,000 ($15,000 is indirect) Utilities . $14,000 ($3,000 is indirect) Depreciation 42,000 ($10,000 is indirect) Office expenses . 20,000 (all indirect) Prepare a (1) departmental income statement for 2019 and (2) departmental contribution to overhead report for 2019. (3) Based on these two performance reports, should Jansen eliminate the Ski department?
Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $716,000 in service revenue. Their total cost (fixed and variable) per client was $2,700 and they served 125 clients during the year. If operating expenses for the year were $304,000 what was their net income? Park and West, LLC Income Statement For Year Ending 2019 $fill in the blank 2 fill in the blank 4 $fill in the blank 6 fill in the blank 8 $fill in the blank 10
Edward ltd comprises of 3 production departments and 2 service departments. The following information is provided for Edward Ltd for 2019. Supervisor's Salary $ Machining 300,000 Assembly 200,000 Finishing 250,000 Canteen 120,000 Maintenance 150,000 $ Factory Rent 300,000 Heat & Light 200,000 General Repairs 60,000 Machine Depreciation 80,000 Machine Insurance 90,000 Business Rates 75,000 Machining Assembly Finishing Canteen Maintenance Floor Space occupied (m2) 400 200 200 150 50 Value of machinery ($'000) 300 400 200 50 50 The service department work for other departments as follows Machining Assembly Finishing Canteen Maintenance Service carried out by canteen Canteen 30% 30% 40% Maintenance 25% 50% 25% Using the overhead analysis sheet for 2019, determine the overhead allocated and apportioned to each of the five departments. Calculate the total overheads included in the…
Edward ltd comprises of 3 production departments and 2 service departments. The following information is provided for Edward Ltd for 2019. Supervisor's Salary $ Machining 300,000 Assembly 200,000 Finishing 250,000 Canteen 120,000 Maintenance 150,000 $ Factory Rent 300,000 Heat & Light 200,000 General Repairs 60,000 Machine Depreciation 80,000 Machine Insurance 90,000 Business Rates 75,000 Machining Assembly Finishing Canteen Maintenance Floor Space occupied (m2) 400 200 200 150 50 Value of machinery ($'000) 300 400 200 50 50 The service department work for other departments as follows Machining Assembly Finishing Canteen Maintenance Service carried out by canteen Canteen 30% 30% 40% Maintenance 25% 50% 25% Using the overhead analysis sheet for 2019, determine the overhead allocated and apportioned to each of the five departments.
Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $993,729 in service revenue. Their total cost (fixed and variable) per client was $1,217 and they served 268 clients during the year. If operating expenses for the year were $291,276 what was their operating income?
2. Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $720,000 in service revenue. Their total cost (fixed and variable) per client was $2,500 and they served 115 clients during the year. If operating expenses for the year were $302,000 what was their operating income? Use this information to construct an income statement for the year 2019. Operating Income Cash Retained Earnings Gross Profit Cost of Goods Sold Service Revenue Cost of Services Operating Expenses Sales Revenue PLEASE NOTE: You must enter the account names exactly as written above and all whole dollar amounts will be with "$" and commas as needed (i.e. $12,345). Park and West, LLC Income Statement for Year Ended 2019
Bubba Manufacturing Company provided the following information for the fiscal year toJune 30, 2020:Inventories 01/07/2019 30/06/2020Direct Materials $72,000 $65,000Work-in-Process $107,000 $128,000Finished Goods $149,500 $141,700Other information:Office cleaner’s wages 4,500Sales Revenue 1,031,000Raw materials purchased 235,000Factory wages 239,700Indirect materials 23,500Delivery truck driver’s wages 15,400Indirect labor 9,500Depreciation on factory plant & equipment 32,000Insurance 1 60,000Depreciation on delivery truck 7,250Utilities 2 118,750Administrative salaries 41,250Special Design Costs 5,000Selling expenses 9,000Sales Commission 2% of gross profit 1 Of the total insurance, 66⅔% relates to the factory facilities & 33⅓% relates to general& administrative costs.2 Of the total utilities, 80% relates to the manufacturing facilities & 20% relates to theoffice area. Requirements:…
Bubba Manufacturing Company provided the following information for the fiscal year toJune 30, 2020:Inventories 01/07/2019 30/06/2020Direct MaterialsWork-in-ProcessFinished Goods$72,000107,000149,500$65,000128,000141,700Other information:Office cleaner’s wages 4,500Sales Revenue 1,031,000Raw materials purchased 235,000Factory wages 239,700Indirect materials 23,500Delivery truck driver’s wages 15,400Indirect labor 9,500Depreciation on factory plant & equipment 32,000Insurance 1 60,000Depreciation on delivery truck 7,250Utilities 2 118,750Administrative salaries 41,250Special Design Costs 5,000Selling expenses 9,000Sales Commission 2% of gross profit1 Of the total insurance, 66⅔% relates to the factory facilities & 33⅓% relates to general& administrative costs.2 Of the total utilities, 80% relates to the manufacturing facilities & 20% relates to theoffice area.Requirements:a) What was the amount of direct materials used in production?b) What was the amount of manufacturing…
Simply Sweets has provided the following relating to the most recent month (August 31, 2020) of operations, for their main product, cookies. Baker's salary 3,000 Finished goods inventory, beginning 1,000 Finished goods inventory, ending 3,000 General & administrative expenses 3,500 Indirect materials 500 Production Supervisor, Salary 4,000 Purchases of raw materials 11,000 Raw materials inventory, ending 2,000 Raw materials inventory, beginning 1,000 Rent on production factory 2,000 Rent, retail store 1,000 Sales 40,000 Utilities on production factory 500 Utilities, retail store 500 Wages, retail staff 3,000 WIP inventory, beginning 2,500 WIP inventory, ending 4,500 Required: Prepare a schedule of cost of goods manufactured in good format Calculate the cost of goods sold Do not give answer in image
Magio Company manufactures kitchen equipment used in hospitals. They distribute their products directly to the customer and, for the year ending 2019, they reported the following revenues and expenses. Sales Revenue $983,000 Cost of Goods Sold 489,000 Operating Expenses 243,000 Use this information to construct an income statement for the year 2019. Magio Company Income Statement For Year Ending 2019